Data Architect II

UST; Chennai District; On-site; INR 1,600,000 - 2,200,000; Full time

Job summary

EY-GDS Data & Analytics is seeking a Senior professional to design and implement data extraction using PowerCenter and ETL processes with IDMC. You will lead ETL workflows, mentor a team of data engineers and analysts, and work with business analysts and DBAs to ensure high-performance data migration.

The role emphasizes adherence to best practices in ETL development, documentation, and DevOps awareness, including CI/CD and GitLab, in a fast-paced, banking-focused data ecosystem.

Qualifications

• Experience in handling structured and semi-structured data.
• Strong knowledge of Oracle, SQL Server, DB2 and IDMS (mainframe).
• Proficiency in SQL, PL/SQL, stored procedures, and performance tuning.
• Expertise with Informatica Cloud (IICS) and cloud data migration.

Responsibilities

• Design and develop data extraction using PowerCenter.
• Design and develop data transformation, and loading (ETL) processes using IDMC.
• Lead a team of ETL developers, data engineers, and analysts.
• Monitor and tune Informatica workflows for high performance.
• Troubleshoot ETL job failures and data discrepancies.

Skills

Data Modeling

Data Engineering

ETL

Agile

Job description

Role 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. Key responsibilities: 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. Skills and Experience: Experience in handling structured and semi-structured data Strong knowledge of Oracle, SQL Server, DB2 and IDMS (mainframe) Proficiency in SQL, PL/SQL, stored procedures, and performance tuning. Expertise with Informatica Cloud (IICS) and cloud data migration. Familiarity with DevOps practices and tools (e.g., CI/CD, Gitlab) Deep understanding of architectural principles, frameworks, and best practices Knowledge of database design and data modelling Nice to Have: 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 Ideally, you’ll also have Client management skills What we look for People with technical experience and enthusiasm to learn new things in this fast-moving environment What working at EY offers At EY, we’re dedicated to helping our clients, from start-ups to Fortune 500 companies — and the work we do with them is as varied as they are. You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees, and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, we are part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer: Support, coaching and feedback from some of the most engaging colleagues around Opportunities to develop new skills and progress your career The freedom and flexibility to handle your role in a way that’s right for you About EY As a global leader in assurance, tax, transaction, and consulting services, we’re using the finance products, expertise, and systems we’ve developed to build a better working world. That starts with a culture that believes in giving you the training, opportunities, and creative freedom to make things better. Whenever you join, however long you stay, the exceptional EY experience lasts a lifetime. And with a commitment to hiring and developing the most passionate people.

Skills

• Data Modeling
• Data Engineering
• ETL
• Agile