Apurba Mondal

– Client Details: Genuine Parts Company, a Fortune 500 enterprise, is a global distributor of automotive replacement parts and industrial materials. – Collaborated with business stakeholders to identify key requirements and ensure alignment with enterprise – Automated over 200 Informatica PowerCenter workflows using IICS, improving system scalability and efficiency. – Designed and implemented dynamic taskflow orchestration to eliminate redundant manual processes. – Developed advanced Sterling pipelines for secure file integrations into Google Cloud Storage, improving data accessibility by 50%. – Implemented automated data quality checks and version controls, ensuring consistent deployment to production environments. – Consistently proposed and delivered solutions to optimize job scheduling and ETL performance. – Actively used database and data storage connection with transformations like sorter, expression, aggregator, router, filter, mapplet with mapping task, mapping and taskflow. – As per business requirement, migrated the existing Informatica Power Center mapping, session and workflow to IICS code and made sure no data loss or no functionality change happened. – Created Test automation tool which will generate test script based on source and target table including CHECKSUM value. – This reduced human workload, error and manual activity. – Created automated mapping task comparison tool to compare and highlight the differences between mapping tasks of different versions which made sure only the required changes go through the migration to the upper environment. – Worked exclusively on performing the ETL to Level 1 as is staging, Level 2 staging, DW load – Extensively worked on multiple sources to import data from database as well as delimited and flat files. – Used multiple pipelines in Informatica mappings and target load orders to maintain the target loading sequence. – Used complex sql queries to derive file names dynamically as per the business requirement.

– Conducted in-depth analysis sessions with business stakeholders to identify gaps in existing workflows and provided automated solutions. – Transitioned over 150 workflows from legacy Oracle systems to Azure and Informatica SSMS, ensuring data integrity and alignment with compliance requirements. – Designed automation scripts for daily ETL jobs using Autosys and shell scripting, cutting manual intervention by 40%. – Integrated advanced analytics using Azure Data Factory and Power BI for real-time insights. – Optimized pipeline execution times by 25% by re-engineering key transformations. – Used SSMS to connect and execute Stored Procedures from Informatica to perform daily complex operations. – Extensively using the mailing and Cyber Fusion capability to transmit files, logs and notifications to remote server and business users when required. – Extensively using Informatica B2B Data Exchange to create Application, Profile, Partner, Workflow and End Points to keep track of all the end-to-end jobs. – Using PIDAC database to schedule any jobs on daily-weekly-monthly-quarterly or yearly manner. – Using PIDAC, created dependency on single and multiple jobs. – Using PIDAC database to create trigger file name matching with profile names to get auto executed from scheduler. – Built and deployed automated testing frameworks to validate workflow migrations, enhancing accuracy and reliability. – Used shell scripting and Autosys to automate the jobs. – Used SSMS to create trigger and sequences which are vastly used across ETL mappings. – Identifying the root causes for the Failure of Informatica Job and solving the complex problems and reran the processing in order to avoid customer related issues. – Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems. – Worked with complex mapping using transformations such as Expression, Router, Lookup, Filter, Joiner, SQ, Stored Procedures and Aggregator.

– Developed scalable ETL frameworks to automate over 90% of compliance-related reporting workflows. – Optimized existing mappings to cut ETL processing times by 30%, leveraging Informatica's latest dynamic caching capabilities. – Conducted deep dives into system logs and debugging tools to proactively resolve data anomalies and ensure consistent output. – Designed parameterized workflows to enable flexible, environment-specific executions, reducing development overhead by 20%. – Engaged with leadership and external regulators to present automated solutions tailored to regulatory standards. – Extensively used Transformation Language functions in the mappings to produce the desired results. – Used session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts. – Extensively worked on Informatica 10.2 version and much usage of Monitor, Designer, Repository and Manager. – Analyzed requirements from the users and created, reviewed the specifications for the ETL. – Designed Incremental strategy, Created Reusable Transformations, Mapplets, Mappings/Sessions/Workflows etc. – Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values. – Extensively worked on Informatica PowerCenter mapping with Source qualifier, joiner, sorter, router, Java Transformation, normalizer and update strategy to achieve the required target. – Created Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy – Extensively worked on writing complex SQL Queries and creating Complex Mappings and designing the workflows as per the requirement. – Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.