Description

- Develop complex SQL queries, PL/SQL packages, stored procedures, functions, and triggers using Oracle databases.
- Build, enhance, and maintain ETL workflows using Informatica PowerCenter to extract, transform, and load data from multiple source systems.
- Implement source code management and version control best practices using Jenkins, GitHub and GitOps.
- Create automation scripts using Python and Unix shell scripting to streamline data processing, monitoring, and operational activities.
- Manage and schedule batch processing jobs using enterprise scheduling tools such as Control-M and AutoSys.
- Support reporting and analytics initiatives by providing optimized data structures and datasets for OBIEE/OAS and other BI tools.
- Collaborate with business stakeholders, data architects, and application teams to gather requirements and deliver data solutions aligned with business objectives.
- Create and maintain technical documentation, including data flow diagrams, ETL mappings, deployment procedures, and operational support documents.
- Ensure data quality, integrity, consistency, and security throughout the data lifecycle.
- Monitor, troubleshoot, and resolve ETL failures, database issues, and data-related production incidents.
- Participate in code reviews, design discussions, and continuous improvement initiatives to enhance data engineering practices.
- Work closely with cross-functional teams to support data migration, modernization, and cloud transformation projects.
- Ensure compliance with data governance, security standards, and organizational policies.

Basic Qualifications:
• 5+ years of Expert-level knowledge of writing complex SQL queries using Oracle. 
• 5+ years of Expert-level knowledge of Oracle PL/SQL (Stored Procedures, Functions, packages, triggers) 
• 5+ years of working experience in scripting and automation using Unix, Python in a Data Engineering environment.
• 6+ years of extensive experience with Relational Databases like Oracle including being able to implement performance tuning techniques
• 5+ years of working experience using GitHUB for Source Code Management (SCM) in a Data Engineering Practice.

Preferred Qualifications:

• Strong working experience in ETL tools like Informatica (Power Center)

• Strong working knowledge of Data warehousing patterns and Dimensional Modelling techniques using Oracle.
• Experience building scalable patterns for data integration in a 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

Key Skills

Education

Bachelor's degree