• Performed end-to-end data mapping and profiling from multiple source systems into the Enterprise Data Warehouse (EDW), ensuring accurate lineage and consistency with business requirements.
• Identified and documented data gaps, developing remediation plans and integrating missing data elements into the EDW for complete and reliable reporting.
• Designed and optimized data models (relational and dimensional) aligned with client and regulatory requirements, prioritizing runtime efficiency and scalability.
• Developed and maintained SQL stored procedures, ETL workflows, and Informatica transformations, ensuring compliance with HLB’s data governance and industry standards.
• Collaborated with integration teams to deliver outbound data feeds to external clients, implementing robust validation and reconciliation checks for accuracy.