Informatica BDM Developer

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) Architect and implement data solutions leveraging Python, lambda, EMR • Build and maintain scalable data workflows and orchestration using Apache Airflow.