Abhijeet Kumar

Migrated enterprise data from Denodo to Snowflake using Informatica IDMC and implemented Medallion Architecture (Bronze, Silver, Gold layers) to build scalable ETL pipelines and organize raw, transformed, and curated datasets for analytics. Improved ETL performance by 65% by replacing full-table reloads with incremental ingestion using max-date watermark logic in the Bronze layer.

Implemented Slowly Changing Dimension

Type 2 (SCD2) in the Silver layer for historical tracking and SCD Type 1 (SCD1) in the Gold layer for curated analytical datasets, with parameterization for connections and key expressions to enable reusable and environment-independent pipelines.

Data Engineer / ETL Developer at Cognizant (2025-09 – Present)

• Migrated enterprise data from Denodo to Snowflake using Informatica IDMC and implemented Medallion Architecture (Bronze, Silver, Gold layers) to build scalable ETL pipelines and organize raw, transformed, and curated datasets for analytics.
• Improved ETL performance by 65% by replacing full-table reloads with incremental ingestion using max-date watermark logic in the Bronze layer.
• Implemented Slowly Changing Dimension Type 2 (SCD2) in the Silver layer for historical tracking and SCD Type 1 (SCD1) in the Gold layer for curated analytical datasets, with parameterization for connections and key expressions to enable reusable and environment-independent pipelines.
• Enabled SQL ELT Optimization in Informatica IDMC for high-volume tables in the Silver layer, pushing transformations to Snowflake and reducing pipeline processing time by 45%.

Data Analyst at Cognizant (2024-05 – 2025-09)

• Migrated complex dashboards from Qlik Sense to Power BI, ensuring 100% visual and functional parity while improving dashboard performance, interactivity, and client satisfaction.
• Built scalable Power BI dashboards by transforming data from SharePoint and Azure Databricks with optimized SQL queries increased data processing efficiency by 30% and reduced dashboard load times for Stakeholders
• Created robust data models and optimized backend transformations with Power Query and DAX, boosting team efficiency by 40% and accelerating project delivery timelines.
• Spearheaded end-to-end development of multiple interactive Power BI dashboards, translating complex datasets into actionable insights and improving stakeholder understanding of key performance indicators.

Database Tech Intern at Cognizant (2023-12 – 2024-05)

• Utilized SQL to validate and analyze reporting datasets, improving reliability and supporting data-driven decision-making
• Utilized Amazon Web Services (AWS)— including RDS, Redshift, and S3 — for cloud-based data storage, processing, and analytics, enabling scalable and secure data management.
• Leveraged PySpark to perform extensive data cleansing, preprocessing ensuring high-quality datasets for model training and improving the accuracy of analytical outcomes
• Explored integration of Generative AI with cloud data platforms to drive automation, improve data-driven decision-making, and implement Natural language processing (NLP) use cases.

Bachelor of Technology in Technology – Harcourt Butler Technical University (2019 – 2023)