Fahad Islam

Experience

• 

  Capgemini

  Mar 2020 - May 2023

  Accomplished the migration of power center object to the Informatica Cloud with RPA utility.➢ Successfully migrated mappings, session tasks, and task flows from PwC assets to Informatica IDMC, ensuring seamless data integration and process continuity.➢ Created and configured connections and set up accurate parameters to ensure smooth data flow and system interoperability within the new IDMC environment.➢ Conducted comprehensive validation of mappings and executed System Integration Testing (SIT) for data accuracy and integrity, ensuring all migrated components functioned as expected.➢ Managed the migration of code to higher environments using import and export options, ensuring stability and consistency across development, testing, and production environments➢ Addressed and resolved UAT queries, facilitated stakeholder engagement, and ensured all user requirements and feedback were effectively incorporated into the final solution.➢ Documented all migration steps, process changes, and design adjustments for the new platform. Provided production run support, ensuring all activities were completed within the delivery date and with minimal guidance.Maintain Sprint planning, Unit testing, Issue tracker and UAT issues documents. Show less Mentoring associates for upskilling in Informatica power center and IICS.➢ Working on cloud data integration and cloud application integration services.➢ Developing Informatica solutions to optimize the performance of ETL jobs using different accelerators.➢ Experienced in conversion of Informatica power center assets using RPA utility using different modules.➢ Experienced in IICS, Informatica power center administrations activity like handling user creation node maintenance server startups.➢ Worked on ETL Doctor a ML based recommendation tool to optimize the informatica jobs run time using python.➢ Exposure of IICS rest API’s and CI/CD modules.Understanding the business requirement and develop an ETL process to load data from source to target.➢ Creation of mappings and sessions in informatica which includes various transformation for implementation of business logic➢ Developing mappings to capture data changes from the staging and loading them into target table in Sql server.➢ Analyzing the requirement and applying DDL and DML queries in Sql server.➢ Experienced in writing Shell scripts.➢ Also, trained in power BI to generate reports from target table and visualize them with graphs and dashboards. Show less Perform continuous integration and deployments using tools such as Jenkins, github as a data-oops engineerAnalyzed Informatica power center mappings, workflows and export assets into xml’s by resolving all dependencies.➢ Creation of new folders in staging area according to change suggested by leadership.➢ Mapping of each database folder name in staging area with its corresponding schema using shell scripts.➢ Create GitHub branching strategy for maintaining the code versions that helps developer to easily segment their work.➢ Designed CI/CD pipeline from scratch for deployments of various component like Informatica objects and database objects to different environments.➢ Perform unit testing and integration testing of assets after deployment using new pipeline.➢ Increase efficiency of CI/CD pipeline by integrating various Informatica accelerators.➢ Maintaining and Support for new CI/CD pipeline for few sprint.➢ Maintained some trailing document related to:o Detail Design Specification (DDS)o Test cases and results.o SOP’s➢ Creating Jenkins CI/CD pipeline and run different script within.➢ Analyze data-ops tools like Data Kitchen to create pipeline for smooth data flow.➢ Worked on python scripts for accessing GitHub Api and send GitHub metadata about GitHub actions into Database.➢ Analyze Jenkins and git metadata and visualize using data visualization tools (Tableau, Kibana) Show less Undergo training on business intelligence.➢ Understand B.I Tools like Informatica, Tableau and Teradata.➢ Process .csv/excel file using ETL tools like Informatica power centre and later visualize the data using data visualization tools i.e. Tableau.➢ Worked on different mapping using SCD wizards.➢ Create SCD while loading data into RDBMS for creating data warehouse.➢ Adding different transformation while processing the data and sending them into target location.➢ Visualize the processed data in tableau by creating graphs and charts. Show less

  • Associate Consultant

    Jul 2022 - May 2023

  • Senior Software Engineer

    Nov 2021 - Oct 2022

  • Software Engineer

    Sept 2020 - Oct 2021

  • Analyst Trainee

    Mar 2020 - Aug 2020
• 

  Accenture

  May 2023 - now

  Custom Software Engineering Analyst

  As a part of migration team, we migrated more than 6 applications from on-prem to IDMC.➢ It includes validating each asset of IDMC with respect to underlying frameworks migration to new servers.➢ Strong understanding of IICS Architecture, advanced transformations (Hierarchy Builder, JSON/XML parser and schemas, Mapplet, web services) with parameterization, REST API integration, exception, and error handling methods.➢ Debugged and troubleshooted performance issues, data discrepancies, and errors in complex ETL mappings to ensure smooth operations.➢ Reduced data processing time by 20%, Improved data accuracy and consistency.➢ Town Hall Q1 recognition for significant project contributions and outstanding performance.➢ Worked closely with informatica team by raising GCS ticket on different issues faced during the migration process, also shared different use cases for new IDMC cloud it is not working as like PWC. Show less