To Apply for this Job Click Here NOTE: This is a 100% Remote Position. Candidates will be working on PST Hours One of our clients in San Deigo, California is looking for an Oracle PL/SQL Developer with the following skills and experience: Interview Process: First Round: CoderByte technical assessment (~2 hours) Second Round: 1-hour panel interview with the team Must-Have Skills: PL/SQL, Informatica, SQL, ETL, Performance Tuning Required Skills: Technical Skills: PL/SQL Development: 5+ years of experience, specifically with Oracle. Proficient in developing complex database objects such as Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL. Informatica: Expertise in data integration and ETL processes using Informatica PowerCenter, Data Transformation, and Informatica B2B Data Exchange products. Strong understanding of Informatica design concepts and best practices. SQL & Performance Tuning: Experience in SQL and PL/SQL Performance Tuning, query rewriting, and the use of Explain Plan and Hints. Proficient in Collections, Exception Handling, Partitioning techniques, BULK features, Analytics functions, and External tables. ETL & Data Modeling: Strong ETL and data modeling experience, including creating mappings and workflows, and implementing ETL concepts. Unix/Linux: Comfortable with UNIX/Linux platforms and commands. Experience in Unix Shell, Perl, or Python programming languages. Additional Technical Skills: Proficiency in the latest version of Oracle RDBMS. PostgreSQL knowledge is a plus. Experience with Standard Oracle Packages (e.g., UTL_FILE), Dynamic SQL, Records, Arrays, PL/SQL tables, and File handling. Familiarity with Agile methodologies, Scrum, and SDLC best practices. Experience with Atlassian products (JIRA, Confluence, BitBucket). Knowledge of DevOps tools such as UC4, Maven, Jenkins, and CI/CD pipelines. Understanding of object-oriented analysis and design principles. Experience in modern programming languages and frameworks (e.g., Java, Angular or React, JPA, Spring Boot, XML, JSON). Knowledge of API gateways (e.g., Gravitee) is a plus. Comprehensive knowledge of software methodologies, distributed networking, databases, communications, and multiprocessing applications. Nice-to-Have Skills: Experience with Java, Angular or React, JPA, Spring Boot, XML, and JSON. Interested candidates may submit their resumes online or call at for further information regarding the position.
NS-ODM-NS_1718715187 To Apply for this Job Click Here
PostgreSQL Informatica Agile API JSON Perl Performance optimization XML JPA React Maven SDLC CI/CD Spring Boot Python Confluence PL/SQL DevOps Jira SQL Java ETL Scrum Angular Jenkins Bitbucket