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

Location:
Chennai | Bengaluru | Hyderabad | Mumbai | Indore | Ahmedabad

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 robust 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
• Agile/Scrum Methodology
• 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
• Experience working in enterprise-scale data integration projects
• Proactive mindset with a focus on continuous improvement Experience 5-9 Years

📌 Informatica Developer (Mumbai)
🏢 Tata Consultancy Services
📍 Mumbai