Technology & Transformation | EAID | Engineering | IPC lead | Senior Consultant

Job description

Job requisition ID :: 108457 Date: Jul 9, 2026 Location: Bhubaneswar CEC Designation: Senior Consultant Entity: Deloitte Touche Tohmatsu India LLP Key Responsibilities • Analyse existing Informatica PowerCenter mappings, workflows, sessions, and reusable components. • Design, develop, and migrate ETL jobs from PowerCenter to Informatica IDMC (Cloud Data Integration). • Convert and optimize PowerCenter mappings into IDMC mappings, taskflows, and reusable assets. • Develop and modify SQL scripts, Stored Procedures, and database objects as part of migration activities. • Create and maintain Unix Shell Scripts for job orchestration, file handling, and automation. • Perform unit testing, system integration testing, and reconciliation to ensure data accuracy after migration. • Troubleshoot ETL failures, identify root causes, and implement appropriate fixes. • Optimize ETL jobs for performance, scalability, and maintainability. • Collaborate with Solution Architects, Business Analysts, QA teams, and business stakeholders. • Prepare technical design documents, migration documents, deployment guides, and operational runbooks. • Support deployment across Development, QA/UAT, and Production environments. • Participate in code reviews and ensure compliance with development standards and best practices. Mandatory Skills • 6–10 years of experience in Informatica PowerCenter development. • Hands-on experience with Informatica Intelligent Data Management Cloud (IDMC) – Cloud Data Integration (CDI). • Experience in ETL migration projects, preferably PowerCenter to IDMC. • Strong SQL programming skills. • Experience in writing and optimizing Stored Procedures. • Hands-on experience with Unix/Linux Shell Scripting. • Strong understanding of ETL concepts, data warehousing, and dimensional modeling. • Experience in debugging, performance tuning, and optimization of ETL jobs. • Knowledge of batch scheduling and workflow orchestration. • Experience with Git or other version control systems. • Excellent analytical and problem-solving skills. • Strong verbal and written communication skills. Preferred Skills • Experience with databases such as Teradata, Oracle, SQL Server, Snowflake, or Microsoft Fabric. • Knowledge of CI/CD pipelines and DevOps practices. • Experience working in Agile/Scrum projects. • Exposure to Python or scripting for automation. • Experience with REST APIs and cloud integrations.