Informatica Developer

Tata Consultancy Services Limited; Chennai; On-site; INR 1,200,000 - 2,100,000; Full time

Job summary

Tata Consultancy Services Limited in Chennai seeks an experienced Informatica Developer with 5-9 years of hands-on data warehousing, ETL development, and database expertise. The role emphasizes Informatica PowerCenter, Oracle, PL/SQL, and Unix/Linux shell scripting to deliver scalable data integration solutions.

The candidate will design and maintain ETL processes, optimize performance, and collaborate with Business Analysts across Agile teams to ensure timely project delivery.

Qualifications

• 5-9 years of hands-on experience in Data Warehousing, ETL development, and database technologies.
• Strong expertise in Informatica PowerCenter, Oracle, PL/SQL Development.
• Unix/Linux Shell Scripting and performance tuning experience.
• Experience with multiple source systems including Oracle, SQL Server, Flat Files and Mainframe.
• Production support and incident resolution experience.

Responsibilities

• Collaborate with Business Analysts and stakeholders to gather and understand business requirements.
• Design, develop, and maintain ETL processes using Informatica PowerCenter.
• Create and manage mappings, sessions, workflows, and repositories.
• Develop complex SQL queries, stored procedures, and PL/SQL scripts.
• Extract, transform, and load data from multiple sources such as Flat Files, Oracle, SQL Server, and Mainframe systems.
• Perform Informatica and database performance tuning to optimize ETL processes.
• Identify and resolve performance bottlenecks in data integration workflows.
• Develop Unix/Linux Shell scripts to automate repetitive operational tasks.
• Create unit test cases, execute testing, and document results.
• Schedule and monitor ETL jobs using Autosys or equivalent scheduling tools.
• Participate in Agile ceremonies and ensure timely delivery of projects.

Skills

Informatica Development

SQL Performance Tuning

Unix/Linux Shell Scripting

Data Warehousing

Analytical Skills

Tools

PowerCenter

Autosys

PowerExchange

JIRA

Job description

Note: We are looking for candidates with an official notice period of 60- 90 days

About the Role

We are seeking an experienced Informatica Developer with 5-9 years of hands-on experience in Data Warehousing, ETL development, and database technologies. The ideal candidate should have strong expertise in Informatica PowerCenter, Oracle, PL/SQL, Unix/Linux Shell Scripting, and performance tuning. This role involves working closely with Business Analysts and stakeholders to deliver scalable and efficient data integration solutions.

Key Responsibilities

• Collaborate with Business Analysts and stakeholders to gather and understand business requirements.
• Design, develop, and maintain ETL processes using Informatica PowerCenter.
• Create and manage mappings, sessions, workflows, and repositories.
• Develop complex SQL queries, stored procedures, and PL/SQL scripts.
• Extract, transform, and load data from multiple sources such as Flat Files, Oracle, SQL Server, and Mainframe systems.
• Perform Informatica and database performance tuning to optimize ETL processes.
• Identify and resolve performance bottlenecks in data integration workflows.
• Develop Unix/Linux Shell scripts to automate repetitive operational tasks.
• Create unit test cases, execute testing, and document results.
• Schedule and monitor ETL jobs using Autosys or equivalent scheduling tools.
• Participate in Agile ceremonies and ensure timely delivery of projects.

Required Skills

• 4.55-9 years of experience in Informatica Development
• Strong expertise in Informatica PowerCenter (Designer, Workflow Manager, Repository Manager)
• Experience with Oracle Database and PL/SQL Development
• Strong SQL query writing and performance tuning skills
• Hands-on experience with Unix/Linux Shell Scripting
• Good understanding of Data Warehousing concepts and ETL methodologies
• Experience working with multiple source systems including Oracle, SQL Server, Flat Files, and Mainframe files
• Strong analytical, debugging, and troubleshooting skills
• Experience in production support and incident resolution

Preferred Skills

• Autosys Scheduling
• PowerExchange
• JIRA
• Data Migration Projects
• Data Quality and Data Governance Exposure

Desired Candidate Profile

• Strong problem-solving and analytical skills
• Excellent communication and stakeholder management abilities
• Ability to work independently and within cross-functional teams
• Proactive mindset with a focus on continuous improvement