· Experience developing and supporting ETL mappings, workflows and sessions.
· Strong SQL skills for data analysis, validation and reconciliation.
· Hands-on experience in production support (L2/L3).
· Working knowledge of Unix/Linux.
· Exposure to Informatica Data Quality (IDQ).
· Experience with enterprise schedulers such as Control-M or Autosys.
· Informatica certification preferred.
Roles & Responsibilities
· Develop, enhance and support Informatica ETL jobs.
· Analyze and resolve production job failures and defects.
· Perform data validation and reconciliation.
· Support releases, deployments and post-production activities.
· Maintain technical documentation and operational runbooks.
· Understand business requirements and then convert business requirement into Technical Specifications
· Demonstrate decision making ability and problem-solving skills in these scenarios.
· Ensure that deliverables are recorded, updated and completed in time
Pre-Screening Questionnaire
· How many years of hands-on experience do you have with Informatica PowerCenter in on-prem environments?
· Is your experience primarily development, production support, or a mix of both?
· Have you worked in L2/L3 production support roles? Please explain your responsibilities.