Oracle PL/SQL Developer

Beacon Hill Staffing Group - Topeka, KS

Full-time

Topeka, KS

Administrative and Support Services

About the position

The Oracle PL/SQL Developer position at Beacon Hill Staffing Group, LLC involves working with a variety of technical skills and tools to develop and maintain database applications. The ideal candidate will have a strong background in SQL and Oracle PL/SQL, along with experience in Unix Shell scripting or programming languages such as Perl or Python. The role requires extensive proficiency in modern RDBMS products, particularly Oracle's latest version, with PostgreSQL knowledge considered a plus. In this role, the developer will be responsible for utilizing the Informatica Platform, applying best practices for Informatica PowerCenter, Data Transformation, and Informatica B2B Data Exchange products. A strong understanding of Informatica design concepts is essential, as well as experience in ETL processes and data modeling. The developer will create mappings, workflows, and implement ETL concepts effectively. The position also requires the development of complex database objects, including Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL. Candidates should have experience with Standard Oracle Packages, Dynamic SQL, and performance tuning techniques, including query rewriting and the use of Explain Plan and Hints. Additionally, expertise in Collections, Exception Handling, and Partitioning techniques is necessary. Familiarity with UNIX/Linux platforms and Agile methodologies, particularly Scrum and SDLC, is important. Experience with tools such as Atlassian products (JIRA, Confluence, BitBucket), DevOps practices, UC4, Maven, Jenkins, and CI/CD processes will be beneficial. Knowledge of object-oriented analysis and design principles, as well as programming languages and frameworks like Java, Angular, React, JPA, Spring Boot, XML, and JSON, is also required. Experience with API gateways, such as Gravitee, is a plus. Beacon Hill Staffing Group is committed to diversity and encourages individuals with disabilities and protected veterans to apply. The company values the strength that diversity brings to the workplace and is an Equal Opportunity Employer.

Responsibilities

• Develop and maintain complex database objects including Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
• Utilize the Informatica Platform and apply best practices for Informatica PowerCenter, Data Transformation, and Informatica B2B Data Exchange products.
• Create mappings, workflows, and implement ETL concepts effectively.
• Perform SQL and PL/SQL performance tuning, including query rewriting and the use of Explain Plan and Hints.
• Work with Standard Oracle Packages, Dynamic SQL, and file handling techniques.
• Implement Agile methodologies, particularly Scrum and SDLC best practices.
• Collaborate with teams using Atlassian products such as JIRA, Confluence, and BitBucket.
• Engage in DevOps practices and utilize tools like UC4, Maven, Jenkins, and CI/CD processes.
• Apply object-oriented analysis and design principles in development tasks.
• Develop knowledge in programming languages and frameworks such as Java, Angular, React, JPA, Spring Boot, XML, and JSON.

Requirements

• Excellent working knowledge and experience of SQL, Oracle PL/SQL, Unix Shell (or Perl or Python) programming languages.
• Extensive proficiency in modern RDBMS products, particularly Oracle (latest version).
• Experience with Informatica Platform and knowledge of Informatica best practices for Informatica PowerCenter, Data Transformation, and Informatica B2B Data Exchange products.
• Strong ETL and data modeling experience, proficient in creating mappings and workflows.
• Experience in developing complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
• Experience with SQL and PL/SQL performance tuning, query rewriting, and use of Explain Plan and Hints.
• Solid experience with UNIX/Linux platforms and Agile working experience with Scrum and SDLC methodologies.
• Experience with DevOps, UC4, Maven, Jenkins, and CI/CD.
• Good knowledge of programming languages and frameworks such as Java, Angular, React, JPA, Spring Boot, XML, and JSON.

Nice-to-haves

• Knowledge and experience with API gateway (such as Gravitee) is a plus.
• Familiarity with PostgreSQL is a plus.