Abhinav Tyagi
Kumar
Noida
Summary
Experienced Data Engineer and Architect with a strong foundation in ETL, MDM, and data integration, specializing in designing scalable data architectures across cloud and on-premise systems. Proven success in delivering end-to-end data solutions for global pharmaceutical clients, including MDM rollouts in 34+ countries and complex ETL pipelines integrating Oracle, Salesforce (CRM), TM1, and EBS. Skilled in Informatica IICS (CDI/CAI), MDM, Data Quality, Python, SQL, and Snowflake. Adept in stakeholder alignment, business analysis, GDPR/HIPAA compliance, and setting up data governance frameworks. Brings a consulting background with hands-on experience in architecture, data quality, and cross-functional leadership.
Overview
4
4
years of professional experience
Work History
Data Engineer - Business Intelligence
Mcgraw Hill
10.2024 - Current
- Designed and implemented end-to-end ETL architecture for seamless data ingestion from diverse sources such as Oracle OTC, Salesforce (CRM), TM1, and EBS (financial systems).
- Developed and deployed robust data pipelines for data ingestion, transformation, and publishing, ensuring scalability and reliability.
- Led the architecture setup for both data integration and application integration, supporting cross-platform data flows.
- Collaborated closely with business stakeholders, end users, and cross-functional teams to align data solutions with business needs.
- Developed and maintained data models (conceptual, logical, and physical) tailored to evolving business requirements.
- Established and enforced best practices in data governance, data lifecycle management, and integration standards.
- Enabled data quality and consistency across systems through standardization, validation rules, and metadata management.
Associate Consultant
ZS Associates
06.2022 - 10.2024
- Delivered end-to-end Master Data Management (MDM) solutions for multiple pharmaceutical clients, including a global MDM rollout across 34 countries, aligning with both business and regulatory requirements.
- Designed and implemented scalable ETL pipelines and data architectures to support integrations across CRM (Salesforce), ERP (Oracle/EBS), and Payer/PBM systems.
- Spearheaded architecture and execution of global data integration frameworks, supporting commercial, payer, and provider domains with emphasis on performance, scalability, and governance.
- Ensured compliance with data privacy regulations such as GDPR and HIPAA, embedding data compliance into architectural and ETL design.
- Defined and enforced data quality standards and governance practices, leading efforts on data profiling, standardization, and validation for high-trust data systems.
- Played a critical role in client engagement, business analysis, and stakeholder alignment, bridging technical execution with strategic business needs.
- Managed RFP responses, escalation handling, and client retention activities, driving long-term client success and satisfaction.
- Worked in cross-functional environments to plan resources, align roadmaps, and lead architecture discussions, ensuring timely delivery and adoption of enterprise solutions.
Data Analyst
Capgemini
01.2022 - 06.2022
- Led the architecture design and execution strategy for migrating legacy Informatica PowerCenter mappings to Informatica Intelligent Cloud Services (IICS), ensuring minimal disruption to ongoing business operations.
- Acted as a Functional Business Analyst, gathering and validating business and technical requirements from diverse stakeholders across departments and systems.
- Conducted deep-dive data analysis using SQL and PL/SQL to validate transformation logic and data integrity between source and target systems.
- Prepared Source-to-Target Mapping (STTM) documentation and transformation rules to support migration and downstream integration needs.
- Performed unit and integration testing on migrated IICS mappings; identified and raised defects as JIRA stories, and collaborated with Informatica support for resolution.
- Played a key role in cross-functional coordination, ensuring alignment between data engineering, business users, and vendor teams throughout the migration lifecycle.
- Documented architectural changes and provided post-migration support, ensuring scalability, performance, and compliance in the new cloud-based data integration setup.
ETL Developer
Birlasoft
02.2021 - 12.2021
- Implemented Data Vault architecture to ensure scalability, auditability, and historical tracking within the enterprise data warehouse.
- Designed and developed robust ETL mappings using Informatica PowerCenter, handling complex business logic for claims, payments, and invoice processing.
- Created Unix shell scripts for file movement, data archival, job scheduling, and automated notifications.
- Engaged in direct business interactions to gather, clarify, and translate functional requirements into scalable data solutions.
- Developed and enhanced multiple Informatica workflows, integrating key transformations including Expression, Joiner, Lookup, Union, and Aggregator.
- Scheduled, monitored, and maintained ETL jobs ensuring high availability and timely data delivery.
- Managed change requests and enhancements by analyzing impacts, updating logic, and maintaining job efficiency.
- Participated in the development of new interfaces to streamline and scale the claims processing pipeline.
- Utilized JIRA for defect tracking, change management, and sprint progress monitoring.
- Exposure to NoSQL databases like MongoDB and familiar with implementing OAuth-based authentication (Google, Azure AD, Okta), supporting secure data access in modern applications.
Education
Bachelor of Information Technology - Information Technology
Amity University
Noida 04.2001 -
Skills
ETL Tools - Informatica
Timeline
Data Engineer - Business Intelligence
Mcgraw Hill
10.2024 - Current
Associate Consultant
ZS Associates
06.2022 - 10.2024
Data Analyst
Capgemini
01.2022 - 06.2022
ETL Developer
Birlasoft
02.2021 - 12.2021
Bachelor of Information Technology - Information Technology
Amity University
04.2001 -