100% Remote-Oracle PL/SQL Developer at Beacon Hill #vacancy #remote

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

Leave a Reply