Misbhauddin Mohammed

Lead Developer

Comtec Information Systems

Jan 2025 - Current (1 year 10 months)

• Experienced in building and architecting multiple Data pipelines, end to end ETL and ELT process for Data Ingestion and transformation in Azure.
• Worked with Azure BLOB and Data Lake storage and loaded data into Azure SQL Synapse analytics (DW).
• Worked on migration of data from GCP to Azure data platform by using different data ingestion pipelines.
• Simulated the Ingestion & ETL to identify the blockers beforehand eliminating job failures by integrating Data Quality (DQ) checks on metadata and source using PySpark & SQL.
• Analyzed source data coming from different sources like SQL Server tables, XML files and Flat files then transformed according to business rules using Informatica and loaded the data in to target

Informatica Lead Developer

Bank of the West

Jan 2023 - Jan 2025 (2 years 1 month)

• Led business and data analysis for CCAR regulatory reporting, translating functional requirements into ETL solutions that improved reporting accuracy across 4+ loan product lines (Auto, Home Equity, Credit Cards, Small Business)
• Designed and implemented data ingestion pipelines into AWS from diverse sources (SQL Server, Oracle, flat files, and APIs) using Informatica, Python, ensuring efficient and secure data movement.
• Automated ETL processes using Python and Shell, reducing manual intervention by 40% and ensuring consistent and reliable ETL workflows for big data needs.
• Conducted exploratory data analysis (EDA) on large datasets, leading to early identification of data quality issues and improving decision-making sp

B

Sr. Informatica Developer

Blue Cross Blue Shield LA

Jun 2021 - Dec 2022 (1 year 7 months)

• Documented, tested, and supported Informatica ETL and Oracle applications, ensuring 99.8% uptime and smooth operations across claims and membership data systems.
• Developed complex Informatica mappings with transformations (Aggregator, Lookup, Router, etc.) to integrate data from hospital, claims, and pharmacy systems into Oracle DW.
• Standardized ETL code by creating common reusable objects and documentation, improving team productivity by 20% and reducing code defects.
• Partnered with business users and project managers to align ETL deliverables with requirements, enabling timely delivery of 100% of project milestones.
• Conducted business and data analysis on healthcare datasets using Informatica & SQL, improving

Sr. Informatica Developer

Bank of the West

Apr 2019 - Mar 2021 (2 years)

• Executed full life cycle data migration (ETL) from multiple banking systems into Oracle DW, migrating 15M+ financial records with zero reconciliation issues.
• Partnered with business stakeholders to define data mapping and cleansing rules, improving CCAR regulatory reporting accuracy by 25%.
• Collaborated with Data Governance team to enforce quality/compliance standards, ensuring 100% adherence to CCAR and SOX audits.
• Developed and documented data migration strategy including dependency mapping and sequencing, enabling smooth migration of 10+ critical banking systems.
• Oversaw work of 4 ETL developers, reviewing code quality and resolving errors, which reduced production defects by 15%.
• Partnered with busin

Informatica Lead Developer

Wells Fargo

Oct 2016 - Aug 2018 (1 year 11 months)

• Served as onshore Informatica Lead Developer, leading design and delivery of enterprise-wide Wealth Management Data Mart (WDM).
• Directed a team of 6 offshore ETL developers, ensuring timely delivery of 100% of data integration milestones.
• Analyzed business/functional specs to design ETL workflows supporting trust, private banking, and wealth compliance reporting.
• Authored and presented System Architecture & Functional Design Documents, accelerating stakeholder sign-off by 20%.
• Designed new data marts and data models in Erwin to support Wealth Management reporting, enhancing data availability for 500+ business users.
• Built and maintained ETL processes with Informatica PowerCenter, synchronizing data from

ETL Developer

Bank of the West

Apr 2016 - Oct 2016 (7 months)

• Developed and optimized Informatica ETL mappings and workflows to support CCAR regulatory reporting.
• Conducted business/data analysis and authored technical specifications, ensuring accurate migration of banking data to Oracle DW.
• Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development
• Created Informatica mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy and Joiner transformations
• Implemented ETL code migrations across environments with DBAs, maintaining smooth production deployments.
• Involved in Creating, Validating, Testing and running the sequential and concurre

Informatica Developer

Wells Fargo

Aug 2012 - Mar 2016 (3 years 8 months)

• Collaborated with business users to deliver reporting solutions that supported strategic decision making across Wealth Management.
• Transforming high-level design spec to simple ETL coding. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development
• Designed and developed ETL mappings (Source Qualifier, Lookup, Aggregator, etc.) to integrate trust, private banking, and compliance data.
• Built Informatica workflows to load data from Oracle, DB2, Teradata, and SQL Server into Wealth Management Data Mart.
• Created Informatica mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy a

Misbhauddin Mohammed

About

Detail

Timeline

Résumé

Misbhauddin Mohammed

About

Detail

Behavioral traits