PL/SQL Developer Introduction:

We are seeking a PL/SQL Developer who has the ability to be an independent contributor with strong communication skills. The ideal candidate will have expert-level knowledge of writing complex SQL queries using Oracle and will be proficient in Oracle PL/SQL. They should also have experience with ETL tools like Informatica, scripting and automation using Unix and Python, as well as working knowledge of data warehousing patterns and dimensional modeling techniques using Oracle.

Responsibilities:

Write complex SQL queries using Oracle Develop and maintain Stored Procedures, Functions, packages, and triggers using Oracle PL/SQL Utilize ETL tools like Informatica (Power Center) for data integration Create scripts and automate processes using Unix and Python in a Data Engineering environment Implement performance tuning techniques for Relational Databases like Oracle Apply Datawarehousing patterns and Dimensional Modelling techniques using Oracle Build scalable patterns for data integration in cloud-based and on-prem environments Utilize Batch scheduling tools like Control-M, Autosys Work with business intelligence and analytics tools such as

OBIEE/OAS

Use GitHUB for Source Code Management (SCM) in a

Data Engineering Practice Requirements:

Required Skills:

Expert-level knowledge of writing complex SQL queries using Oracle Expert-level knowledge of Oracle PL/SQL (Stored Procedures, Functions, packages, triggers) Strong working experience in ETL tools like Informatica (Power Center) Working experience in scripting and automation using Unix, Python in a Data Engineering environment Extensive experience with Relational Databases like Oracle including performance tuning techniques Strong working knowledge of Datawarehousing patterns and Dimensional Modelling techniques using Oracle Experience building scalable patterns for data integration in cloud-based as well as on-prem environments Working knowledge of Batch scheduling tools like Control-M, Autosys Experience with business intelligence and analytics tools such as

OBIEE/OAS

Working experience using GitHUB for Source Code Management (SCM) in a Data Engineering Practice