Informatica PowerCenter Developer

Greetings from Tata Consultancy Services (TCS)!

Job Title: Informatica PowerCenter Developer

Desired Experience Range: 5-12 Years

Location of Requirement: Mumbai, Chennai, Hyderabad, Bangalore

Must-Have:

• Good hands-on experience with Informatica PowerCenter (Designer, Workflow Manager, Repository Manager, Workflow Monitor)
• Strong proficiency in SQL and PL/SQL
• Experience working with relational databases such as Oracle, SQL Server, Teradata
• Strong understanding of Data Warehousing concepts, ETL methodologies, and Dimensional Modeling (Star/Snowflake Schema)
• Experience in performance tuning of Informatica mappings, sessions, and workflows
• Knowledge of Unix/Linux Shell Scripting
• Experience with job scheduling tools such as Autosys

Good to Have:

• Familiarity with Git, Jenkins, and CI/CD practices
• Exposure to cloud data integration platforms
• Strong analytical and troubleshooting skills
• Experience in Agile development environments

Role:

• Design, develop, and maintain ETL solutions using Informatica PowerCenter
• Build and optimize data integration workflows and mappings
• Perform data extraction, transformation, and loading from multiple source systems
• Troubleshoot and resolve performance issues related to ETL processes
• Collaborate with business and technical teams to understand data requirements
• Ensure data quality, reliability, and adherence to development standards
• Support production deployments and ongoing maintenance activities