Job Title:  Consultant | IPC lead | Bhubaneswar CEC | Engineering | Data Modernization & Migration

The  Team 

Deloitte’s Technology & Transformation practice can help you uncover and unlock the value buried deep inside vast amounts of data. Our global network provides strategic guidance and implementation services to help companies manage data from disparate sources and convert it into accurate, actionable information that can support fact-driven decision-making and generate an insight-driven advantage. Our practice addresses the continuum of opportunities in business intelligence & visualization, data management, performance management and next-generation analytics and technologies, including big data, cloud, cognitive and machine learning. 

Your work profile

The Program / Account Manager is responsible for managing client relationships and overseeing the successful delivery of programs or accounts.

This role serves as the primary point of contact between the organization and its clients, ensuring alignment of goals, timelines, budgets, and expected outcomes while driving client satisfaction and business growth.

Key skills required: 

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. 

Education Qualification

 B. E , B. Tech , M.E , MTech 

Location and Way of Working: 

Base location: Any Location