Technical Specialist

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