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 SDLC Agile API CI/CD Spring Boot JSON Confluence PL/SQL DevOps Jira Performance optimization SQL XML JPA Java ETL React Scrum Maven Angular Jenkins Bitbucket