PL/SQL Developer

Introduction:

We are seeking a Data Engineer 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