Default profile banner
AY

Ankur Yadav

@ankuryadav

Programmer Analyst Trainee at Cognizant

City, State

CognizantK.V – Pathankot (CBSE)

Ankur Yadav is a data professional with experience in developing and maintaining scalable ETL/ELT data pipelines. He has utilized technologies such as Python, Spark, and AWS services (S3, Athena, EMR) to process and transform data. His background includes data analysis, quality assurance, and developing data science projects using APIs.

Experience

Programmer Analyst Trainee

Cognizant

Sep 2021 - Present

Designed and implemented a real-time data pipeline to process structured data by integrating records from informatica data sources using hive. Maintained data pipeline while ingesting streaming and transactional data across different primary data sources using Spark, Redshift, S3, and SQL. Developed, maintained, and oversaw automated and scalable ETL/ELT data pipelines. Sourced, processed, validated, transformed, aggregated, and distributed data from different sources. Collaborated with team in developing shell scripts. Supported process flow analyses and ETL process redesigns, contributing implemented plans.

Programmer Analyst Trainee Intern

Cognizant

Feb 2021 - Jul 2021

Developed ETL programs using Informatica to implement the business requirements. Created shell scripts to fine tune the ETL flow of the Informatica workflows. Fixed the invalid mappings and troubleshoot the technical problems of the database. Used relational SQL wherever possible to minimize the data transfer over the network.

Data analyst

Verificient technology

Apr 2020 - Jun 2020

Quality analysis of the data produced by the ML tool. Detected fraudulent and suspicious behaviour in the data.

Education

Galgotias University

B.Tech

Computer Science

Jan 2017 - Jan 2021Grade: 7.75

K.V – Pathankot (CBSE)

Class 12th

Jan 2016Grade: 75.5%

K.V – Delhi (CBSE)

Class 10th

Jan 2014Grade: 8.2 (CGPA)

Skills

Python
ETL (Informatica)
SQL
Spark
AWS (Athena, S3, EMR)