Senior AWS Databricks Consultant
EY
Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.
Job summary
EY is seeking a Senior for EY-GDS Data and Analytics to design, develop, and lead ETL processes using PowerCenter and IDMC. You will mentor a team of ETL developers and collaborate with data architects and analysts to deliver high-performance data migrations.
Key responsibilities include overseeing ETL jobs, ensuring data quality, and maintaining migration documentation. Expertise in Oracle, SQL Server, DB2 and cloud data migration is highly valued.
Qualifications
- Experience with ETL design, development, and deployment
- Experience with Informatica PowerCenter and IDMC
- Knowledge of data migration in banking or financial domains preferred
- Familiarity with DevOps practices and CI/CD pipelines
Responsibilities
- Design and develop data extraction using PowerCenter.
- Design and develop data transformation and loading (ETL) using IDMC.
- Lead ETL development and mentor team members.
- Oversee ETL jobs, workflows, and mappings in IDMC.
- Monitor and optimize Informatica workflows for performance.
Skills
Tools
Job description
EY- GDS - Data and Analytics Informatica PowerCenter and IDMC - Senior
As part of our EY-GDS D&A (Data and Analytics) team, we help our clients solve complex business challenges with the help of data and technology. We dive deep into data to extract the greatest value and discover opportunities in key business and functions like Banking, Insurance, Manufacturing, Healthcare, Retail, Manufacturing and Auto, Supply Chain, and Finance.
- Design and develop data extraction using PowerCenter.
- Design and develop data transformation, and loading (ETL) processes using IDMC
- Is aware of setting up of PowerCenter, PowerCenter navigator.
- Lead and contribute in design, coding, testing, and deployment of the migration engine.
- Oversee the development of ETL jobs, workflows, and mappings in IDMC.
- Lead a team of ETL developers, data engineers, and analysts.
- Work closely with business analysts, data architects, and database administrators.
- Provide technical mentorship and enforce best practices in ETL development.
- Monitor and tune Informatica workflows for high performance.
- Troubleshoot ETL job failures and data discrepancies.
- Maintain technical documentation for all migration processes.
- Structured and semi-structured data
- Oracle
- SQL Server
- DB2
- IDMS (mainframe)
- SQL
- PL/SQL
- Informatica Cloud (IICS) and cloud data migration
- DevOps practices and tools (CI/CD, Gitlab)
- Banking domain knowledge (Core Banking).
- Familiarity with Data migration process in a banking implementation project.
- Experience with data masking, encryption, and security compliance.
- Knowledge of virtualization technologies and storage architectures.
- Familiarity with Agile methodology
- Client management skills
- People with technical experience and enthusiasm to learn new things in this fast-moving environment
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
