BDM Developer

Total Yrs. of Experience* 8 - 10years 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) Desired skills* Architect and implement data solutions leveraging Python, lambda, EMR Build and maintain scalable data workflows and orchestration using Apache Airflow.