Detailed JD *(Roles and Responsibilities) Mandatory skills* |
• Minimum 5 years of relevant informatica technical experience with Enterprise Data Warehouse(DWH) design and development using Informatica
• Design, develop, and optimize robust ETL/ELT pipelines using Informatica PowerCenter and other data integration tools.
• Manage and maintain IPP application related components – BDM
• Ability to do performance tuning of Informatica BDM jobs
• Write complex SQL queries for data extraction, transformation, and analysis across relational databases.
• Architect and implement data solutions leveraging AWS services such as S3
• Collaborate with business stakeholders to understand data requirements and deliver solutions.
• Monitor and troubleshoot data pipelines to ensure high availability and data quality.
• Implement best practices in data governance, security, and compliance.
• Create, maintain, review design documentations
• Implement and manage Change Requests pertaining to IPP application related components – S3, BDM and MFT Work with other relevant teams (SCP, IOC, Production Control, Infra, Security, Audit) as required
• Work with platform and application teams to manage and close incidents / issues and implement changes, to troubleshoot complex Data issues and resolve them within SLA
• Documenting and updating of Standard Operating Procedures (SOPs) |
