Muheeb Syed

Experience

1. Senior Informatica Developer

   BNY

   Mar 2022 — Present · CA, US

   Developed Informatica mappings and sessions to extract, transform, and load data from diverse source systems.• Utilized Informatica IICS mass ingestion feature to efficiently load data into Snowflake.• Built transformations and steps in Pentaho Data Integration based on specific business requirements.• Authored UNIX shell scripts for executing and scheduling batch processes.• Frequently employed SQL features like joins, triggers, stored procedures, and functions for backend data interaction.• Tuned and optimized SQL queries to enhance performance during migration from SQL to Snowflake, ensuring faster batch processing and user response times.• Followed Informatica best practices, including creating reusable shared objects and adopting consistent naming conventions; designed complex transformations, mapplets, reusable sessions, worklets, and workflows in PowerCenter.• Interpreted high-level documentation to fully understand business rules, applying data transformation techniques suited to the source systems during bi-weekly agile sprints.• Implemented master data management solutions using Informatica MDM to improve data quality, consistency, and governance.• Built and maintained Slowly Changing Dimensions (SCD) for accurate historical data tracking and enhanced reporting.• Wrote complex PL/SQL procedures and functions to support sophisticated data transformation logic.• Participated in PL/SQL development and enhanced query performance through optimization techniques.• Automated key ETL tasks with Python scripts for data transformation and validation, streamlining overall workflow efficiency.• Designed reusable mapplets for complex mappings within Informatica, using ESP for job scheduling.• Developed mappings to populate staging areas and then transform data into dimensional and fact tables for Snowflake-based data models.

Education

• American College of Commerce and Technology

  Master's degree

  2015 — 2017

• Osmania University

  Bachelor's degree

  2009 — 2013