Job Summary
More than 10 years experience in designing, developing, and supporting enterprise data integration and ETL workflows using Oracle PL/SQL, Informatica, and Control-M, with strong Unix expertise. The role involves working closely with business, application, and data teams to ensure high-quality, performant, and reliable data pipelines. Key Responsibilities Design, develop, and maintain ETL workflows using Informatica PowerCenter / IICS Develop and optimize Oracle PL/SQL procedures, packages, triggers, and complex queries Perform data extraction, transformation, and migration activities across systems Schedule, monitor, and manage batch jobs using Control-M or equivalent tools Develop and maintain Unix shell scripts for automation and batch processing Ensure data integrity, performance tuning, and optimization of ETL and database processes Troubleshoot and resolve production issues, incidents, and data discrepancies Collaborate with business analysts, architects, and QA teams for requirement analysis and delivery Participate in code reviews, deployments, and continuous improvement initiatives Mandatory Skills Strong hands-on experience in: Oracle SQL & PL/SQL (advanced level) Informatica (PowerCenter / IICS) Control-M job scheduling Unix/Linux & Shell scripting Good-to-Have Skills Exposure to: Banking / Financial services domain Data warehousing concepts and architecture Agile / DevOps delivery models
Key Responsibilities
2. To support as an SME
3. To ensure knowledge up-gradation and work with new technologies so that the solution is current and meets quality standards and the client requirements
4. To train and develop team so as to ensure that there is an adequate supply of trained manpower in the said technology and deliver risks are mitigated
5. To gather specifications and deliver solutions to the client organization based on understanding of a domain or technology
6. To review project deliverables.
7. To recommend client value creation initiatives and implement industry best practices (on specific technology/product)