Headline

Data Engineer at Cognizant | Passionate About Data Science, Machine Learning, and Transforming Data into Insights | Lifelong Learner Committed to Innovation

About

As a Data Engineer with more than 4 years of experience in ETL development, I worked on Big Data technologies, and Cloud Data Warehousing. I have worked extensively on Snowflake migration and modernization projects in the Insurance domain at Cognizant, with a focus on scalable data pipelines, data quality, and performance optimization. My expertise includes PySpark, Snowflake, Informatica, SQL/PLSQL, and Python, with hands-on experience in building batch and incremental (SCD Type 2) data pipelines, migrating on-premise pipelines to the cloud, and handling large-scale datasets (100M+ records) efficiently. I have strong exposure to Cloud platforms (GCP, AWS, Snowflake), CI/CD deployments, and job scheduling using Jenkins, Autosys, and UDeploy. I am recognized for delivering ahead of deadlines, adapting to Agile methodologies, and collaborating effectively with cross-functional teams. Beyond my core responsibilities, I actively contribute to innovation—participating in Cognizant’s Hackathon, where I built an Insurance Claim Fraud Detection Dashboard using Streamlit, Python, and ML models. I have also completed the Google Associate Cloud Engineer certification, further enhancing my skills in cloud technology. In addition to my technical pursuits, I have actively engaged in extracurricular activities, hosting inter-school sports, arts competitions as a member of the NSS team at GIT. I have a keen interest in philosophy. Drawn to subjects that emphasize logical reasoning. Outside of academics, I enjoy playing sports like table tennis, cricket, and chess, which keep my competitive spirit alive. I am always eager to connect with like-minded professionals and explore opportunities that leverage my skills in data engineering and analytics. Let’s connect!

Location

Karnataka

AI stack

antigravity

claude code

cursor

gemini

github copilot

ChatGPT

Work experience

Associate at Cognizant, Jul 2025 - Present · 1 yr 4 mos, Bengaluru, Karnataka, India

Data Engineer at Cognizant, Jul 2022 - Present · 4 yrs 4 mos, Migrated Oracle data warehouse tables and Informatica ETL pipelines to Snowflake by developing metadata-driven PySpark pipelines on AWS EMR and Amazon S3 as part of Hartford’s enterprise cloud modernization initiative. Owned the end-to-end development of the CLAIM FINANCIAL data product by collaborating with Business Analysts to translate complex business rules and pseudo logic into scalable Snowflake data pipelines. Implemented transformation logic for 31 financial amount columns using Snowflake Streams, Tasks, Stored Procedures, and metadata-driven frameworks to support one-time historical loads and automated incremental processing. Optimized incremental pipeline execution from 90 minutes to 30 minutes (67% improvement), reducing Snowflake compute cost while enabling timely financial reporting and downstream analytics. Designed and implemented metadata-driven SCD Type 2 pipelines for 40+ enterprise tables handling over 100M records, ensuring historical data integrity, auditability, and reliable incremental processing. Built automated Persistent Stage and Data Mart ingestion pipelines using Informatica IDMC, Snowpipe, Snowflake Stored Procedures, Streams, and Tasks to support enterprise reporting and analytics. Developed reusable metadata-driven ETL components and SQL transformations, improving pipeline maintainability, reducing manual effort, and accelerating onboarding of new data assets. Deployed and supported over 300+ database objects, including tables, views, stored procedures, ETL pipelines, and Snowflake Tasks across QA and Production environments using Jenkins, Autosys, and UDeploy while ensuring production stability and data quality.

Cloud Consultant at Cognizant, Mar 2022 - Present · 4 yrs 8 mos, Bengaluru, Karnataka, India

Education

BE - Bachelor of Engineering, Computer Science, Gogte Institute of Technology, Belgaum

Gogte Institute of Technology, Science, Tungal Independent PU Science college

Public links

github: https://github.com/abhishekloni01

leetcode: https://leetcode.com/abhishekloni01