Oracle Advanced Engineering-ODI- AWS-Senior

Delhi - India

Monthly Salary: Not Disclosed

Posted on: 8 hours ago

Vacancies: 1 Vacancy

Job Summary

At EY youll have the chance to build a career as unique as you are with the global scale support inclusive culture and technology to become the best version of you. And were counting on your unique voice and perspective to help EY become even better too. Join us and build an exceptional experience for yourself and a better working world for all.

Senior ETL(OracleAWS) Developer

Experience: 47 years

Employment Type: Full-time

About the Role

We are seeking a Senior ETL Developer with strong expertise in Oracle AWS Glue and Redshift. The role involves designing and optimizing ETL workflows (written using spark/Python) while integrating between Oracle and AWS services (Redshift). Also maintaining repositories thereby ensuring smooth orchestration CI/CD of developed components.

Key Responsibilities

Optimize the currently implemented spark(python/pyspark) based ETL workflows(Glue) for enterprise data integration.
Develop new workflows catering to enhancements.
AWS Redshift performance tuning and workload management to facilitate optimized storage and quick retrieval.
Able to suggest on creation of optimized keys(Sort) for Redshift tables.
Manage data ingestion from Oracle to AWS Redshift and S3 ensuring data quality and integrity.
Orchestrate ETL workflows using AWS Step functions and Apache Managed AirFlow.
Implement data governance security and compliance across Oracle and AWS environments.

Must-Have Qualifications

47 years of experience in ETL development with strong focus on ETL tools (AWS Glue/ ODI/Informatica).
Expertise in Oracle database concepts performance tuning for ETL processes.
Strong Hands-on experience integrating ETL workflows with AWS services (Glue Redshift S3).
AWS Glue: ability to build and optimize ETL pipelines using PySpark/Python.
Intermediate Spark and Python skills for data transformation and automation.
Strong SQL skills and understanding of data warehousing concepts.
Redshift performance tuning/optimization
Experience with workflow orchestration (AWS Step Functions AirFlow) and CI/CD practices.

Good to Have

Experience with any ETL Tool(ODI Informatica)
Knowledge of data governance tools like Lake Formation and cost optimization strategies on AWS.
Knowledge of PL/SQL Programming
Familiarity with hybrid cloud data architecture and migration strategies.
Education
Bachelors degree in Computer Science Engineering or related field (or equivalent experience).

EY Building a better working world

EY exists to build a better working world helping to create long-term value for clients people and society and build trust in the capital markets.

Enabled by data and technology diverse EY teams in over 150 countries provide trust through assurance and help clients grow transform and operate.

Working across assurance consulting law strategy tax and transactions EY teams ask better questions to find new answers for the complex issues facing our world today.

Required Experience: