IRFAN MOHAMMED
Dallas
Summary
Results-driven Informatica Administrator / Production Support Engineer with over 10 years of experience in data management, ETL development, and platform administration. Proven expertise in job monitoring, content transfers, migrations, and performance tuning and Informatica PowerCenter with a solid foundation in ETL workflows and automation scripts. Skilled in root cause analysis, incident triage, and system recovery across large-scale production environments. Successfully led the MDM 10.5.3 HF3 upgrade and executed platform migrations and weekly patching across 16+ environments and enhancing ETL job performance, resulting in a 30% increase in data processing speed.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Informatica Consultant/Scrum Master
Charles Schwab
Dallas, TX
06.2021 - Current
- Experienced in Administration tasks like installation, up-gradation, deployments, user adding, Batch Monitoring & recovery, Outages, and monitoring the applications.
- Configured and maintained Repository Service, Integration Service, and Web Services Hub with high availability and failover capabilities.
- Managed grid configuration to distribute workflow workloads and optimize resource utilization across nodes.
- Performed repository performance tuning including cache optimization, metadata cleanup, and database maintenance coordination.
- Managed domain encryption keys, secure communication channels, and service authentication mechanisms.
- Configured connection objects, reusable components, and parameter files for environment-specific deployments.
- Supported multi-repository architecture including repository consolidation and repository split strategies and configured Informatica (Power Center) and MDM HUB components: Informatica MDM Hub console, Hub Store, Hub Server, Cleanse match server, Cleanse Adapter, IDD MDM Hub Configurations: Data mapping, Data validation, Match and Merge rules, Hierarchy Manager Configured.
- Informatica Data Quality services like Model Repository service, Data Integration Service, Analyst service, and Content Management.
- Service Day-to-day monitoring/administration of Control-M, Informatica, and MDM and its components, production batch schedules, and ensure continuity of business services Strong Experience in the Deployment of Informatica IDQ objects and MDM code changes from lower to Production environment Regularly coordinating with the on-site and offshore team and then client to understand the requirement, develop a specification Experienced in infrastructure maintenance and Disaster recovery, monthly/quarterly activities.
- Daily support in resolving issues and Change request implementation Experienced in MDM upgrades like MDM 10.4 HF3 to 10.5 HF3 and 10.5 HF3 to 10.5.3 HF3 on linux server/IBM Websphere. Experienced with Monthly Address Doctor reference file upgrades in all environments Played a key role in TDA migration project, completing after-market Hourly/weekend deployments, testing, and meeting deadlines Prepared test plan documents, test cases, test scripts for deployment & Migration project and tested accordingly.
- SQL, UNIX, Shell Scripting, Data Relationships, Data Extract Validation Debugging, troubleshooting, monitoring, and performance tuning of SQL Queries Creating cases to Informatica Inc. related to any MDM/Informatica product usability and install issues Run books in Confluence for the scheduled jobs to support Sprint Planning, Daily Scrums, Reviews, and Retrospectives to ensure the timely delivery of high-value financial products. Facilitated Agile adoption across multiple squads, coaching Product Owners, Developers, and stakeholders on Scrum Principles and Best Practices Collaborated with Product Owners to refine backlogs, prioritize features, and establish clear acceptance criteria that align with regulatory and business objectives.
Informatica Consultant
Ardent Mills
Denver, CO
11.2018 - 05.2021
- Engage in design and analysis sessions alongside business analysts, source-system technical teams, and end users.
- Responsible for the development and maintenance of ETL jobs, including implementation, enhancements, testing, quality assurance, troubleshooting issues, and performance tuning of ETL queries.
- Develop, maintain, and support Data Warehouse or OLTP processes through Extract, Transform, and Load (ETL) software using Informatica.
- Enhance the current ETL framework to provide improved functionality and broaden sourcing options.
- Translate business requirements into ETL and reporting specifications.
- Conduct error handling using session logs on PowerCenter tools such as Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
- Perform code reviews for Informatica MDM/ETL processes and SQL scripts.
- Upgrade Informatica MDM from version 10.1 HF1 to 10.2 HF1 on a Linux server.
- Provide support for Informatica, including EBF installations and revalidation of job performance issues.
- Assist with data migration activities and offer post-production support.
- Prepare necessary business documentation and low-level design (LLD) for the offshore team.
Developer
VITACOST/TCS
Boca Raton, FL
05.2018 - 11.2018
- Extensively utilized Informatica tools, including Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer, and Mapping Designer.
- Employed the Informatica Admin Console and Informatica Hub Console for all administrative tasks. Leveraged Informatica PowerCenter to implement modifications to existing ETL processes.
- Created ETL mappings featuring complex business logic for high-volume data loads, utilizing transformations such as Aggregator, Sorter, Filter, Normalizer, SQL Transformation, Lookup, Joiner, Router, Update Strategy, Union, and Sequence Generator.
- Developed mapplets, reusable transformations, source and target definitions, and mappings using Informatica. Worked on constructing workflows, worklets, sessions, and command tasks.
Informatica Consultant
Ameriprise Financial
Minneapolis, MN
09.2016 - 10.2018
- Extensively utilized Informatica tools, including Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer, and Mapping Designer.
- Employed the Informatica Admin Console and Informatica Hub Console for all administrative tasks.
- Leveraged Informatica PowerCenter to implement modifications to existing ETL processes.
- Created ETL mappings featuring complex business logic for high-volume data loads, utilizing transformations such as Aggregator, Sorter, Filter, Normalizer, SQL Transformation, Lookup, Joiner, Router, Update Strategy, Union, and Sequence Generator.
- Developed mapplets, reusable transformations, source and target definitions, and mappings using Informatica.
- Worked on constructing workflows, worklets, sessions, and command tasks.
ETL Admin/Developer
Tesoro
San Antonio, TX
01.2016 - 08.2016
- Developed Informatica mappings for Type-I, Type-II, and Type-III Slowly Changing Dimensions (SCD).
- Collaborated with business analysts, data architects, and application developers to design a strong data model.
- Contributed to the warehouse design utilizing a Star Schema approach.
- Merged relational tables from different databases using Joiner Transformation.
- Employed Router Transformation to load user-defined groups for various business units based on specific filtering conditions.
- Involved in performance tuning for sources, targets, mappings, and sessions to improve efficiency.
- Performed unit testing to verify the accuracy of mappings and ensure successful data population in the database.
- Documented technical specifications, business requirements, and functional specifications for the development of Informatica Extraction, Transformation, and Loading (ETL) mappings to facilitate data loading into multiple tables.
Jr. ETL Developer/Database engineer
National Gypsum Company
Charlotte, NC
07.2015 - 12.2015
- Data Extraction and ETL Development Using Informatica.
- Extracted data from a variety of sources utilizing Informatica.
- Extensively employed Informatica client tools, such as Source Analyzer, Warehouse Designer, Mapping Designer, and Mapplets Designer.
- Gathered data from multiple database sources.
- Established a staging area for data cleansing and validation.
- Designed and developed intricate transformation rules, including Aggregate, Expression, Filter, Join, Router, Lookup, and Update Transformations.
- Created schedules to automate update processes, encompassing Informatica sessions and batches.
- Analyzed, designed, constructed, and implemented ETL jobs with Informatica.
- Developed mappings, transformations, and mapplets using the Mapping Designer, Transformation Developer, and Mapplets Designer within Informatica PowerCenter.
Education
Master's - Computer Science
Texas A&M University
USA06.2015
Bachelors - Electronics & Communication
Jawaharlal Nehru Technological University
Hyderabad, India06.2013
Skills
- Problem-solving
- Attention to detail
- Team leadership & development
- Client relationships
- Issue resolution
Certification
Certified scrum master
Timeline
Informatica Consultant/Scrum Master
Charles Schwab
06.2021 - Current
Informatica Consultant
Ardent Mills
11.2018 - 05.2021
Developer
VITACOST/TCS
05.2018 - 11.2018
Informatica Consultant
Ameriprise Financial
09.2016 - 10.2018
ETL Admin/Developer
Tesoro
01.2016 - 08.2016
Jr. ETL Developer/Database engineer
National Gypsum Company
07.2015 - 12.2015
Bachelors - Electronics & Communication
Jawaharlal Nehru Technological University
Master's - Computer Science
Texas A&M University