Business Technology Solutions Associate at ZS Associates India Pvt Ltd. (2025-02 – Present)
Working as an IICS developer on the AbbVie AA MDM Platform Migration project in the PHARMA domain, primarily on IICS and Snowflake. Successfully migrated the Oracle database to Snowflake and modernized ETL workflows from Informatica to IICS by building mappings, mapping tasks, taskflows, and loading data into Snowflake tables.
- Implemented Snowflake streams for near real-time data ingestion and built complex Stored procedures to process data through multiple layers, enforce business rules, perform data quality validations, standardize data, and manage historical data.
- Developed complex IICS IDL load mappings using parameters stored in a paramfile to support IDL loads from multiple Oracle source systems into Snowflake tables.
- Implemented business rules and data quality workflows in IICS and Snowflake, ensuring standardized, accurate, and high-quality data delivery.
- Implemented historical data storage mechanisms and executed delta detection processes in the Pre-MDM layer.
- Implemented list file creation to reliably identify and read correct input files, and automated archival by building a Python script to move files to WinSCP, executed through an IICS Taskflow command task after loading data into Snowflake.
- Prepared detailed Confluence documents outlining complete data flow and processing steps for each source system in the Pre-MDM layer.
- Built Snowflake views from legacy systen with differing structures, performing calculations and storing results for downstream processing.
- Managed end-to-end resolution of client-raised incidents, collaborating with cross-functional teams and delivering accurate, error-free outputs while maintaining clear communication and following best practices.
Programmer Analyst at Cognizant Technology Solutions (2022-06 – 2025-02)
Worked as Informatica developer in Life Science project in the domain AIA, primarily on Informatica PowerCenter. Successfully delivered solutions to clients within specified timelines along with proper quality.
- Leveraging Informatica PowerCenter for ETL solutions, facilitating seamless data integration across various systems. Responsibilities encompassed requirements analysis, ETL design, development, and implementation.
- Utilizing Informatica PowerCenter's features like mapping designer, workflow manager, and repository manager to implement various Transformations, the team constructed efficient data pipelines to extract, transform, and load data.
