Kartik Saxena
Senior Data Engineer
New Delhi
Summary
Bringing extensive expertise in designing and implementing scalable, efficient, and secure data architecture. Collaborates with cross-functional teams to prioritize technology initiatives and assess their impact. A strategic thinker and proficient communicator, skilled in developing data-related solution roadmaps. Key qualifications include leadership, ETL processes, data consistency, compliance, and effective data visualization for non-technical stakeholders.
Overview
3
3
years of professional experience
2
2
Certificates
Work History
System Engineer - Sr. DATA ENGINEER
TATA CONSULTANCY SERVICES
05.2023 - Current
- Designed, developed, and maintained robust data pipelines for ingesting various file formats (.csv, .dat, JSON) into the data lake using PySpark and Python.
- Orchestrated data workflows efficiently using Airflow, ensuring smooth execution and monitoring of ETL processes.
- Leveraged AWS cloud services such as S3, EMR, and Glue for scalable and reliable data processing.
- Worked with Hadoop ecosystem components for distributed data processing and storage.
- Implemented version control using Git for code management and collaboration within the team.
- Resolved data pipeline issues promptly, ensuring minimal downtime and maximum reliability.
- Mentored junior team members and provided technical guidance on best practices in data engineering.
Assistant System Engineer - Data Engineer
Tata Consultancy Services
05.2021 - 05.2023
- Led the design and development of complex data lakes and data marts tailored to healthcare client requirements, ensuring compliance with industry standards and regulations.
- Implemented real-time data ingestion pipelines to capture and process streaming healthcare data, enabling timely insights and decision-making.
- Utilized Python libraries such as NumPy and Pandas for data manipulation, analysis, and feature engineering.
- Leveraged SQL for querying and transforming healthcare datasets, optimizing queries for performance and efficiency.
- Collaborated with cross-functional teams to understand healthcare data requirements and translate them into scalable and efficient data solutions.
- Ensured data integrity, security, and privacy compliance throughout the data lifecycle, adhering to HIPAA and other regulatory standards.
- Conducted performance tuning and optimization of data pipelines to meet SLAs and performance requirements in a healthcare environment.
Oracle Bi Developer - Internship
Dainik Jagran
08.2019 - 01.2020
- Assist in the integration of data from various sources into the Oracle BI environment using ETL (Extract, Transform, Load) processes.
- Implement caching and aggregation strategies to improve query response times and enhance overall system performance.
- Design and develop data models, including star schemas and snowflake schemas, to organize and structure data for efficient querying and reporting.
- Utilize Oracle Business Intelligence (OBIEE) tools to create and maintain metadata layers, such as physical, logical, and presentation layers, to facilitate easy access to data for end-users.
Education
Intermediate - ISC - SCIENCE
Sheiling House School
Kanpur , India 04.2001 -
HSC - ICSE
SHEILING HOUSE SCHOOL
Kanpur , India 04.2001 -
Bachelor of Technology - Computer Science And Engineering
Galgotias University
Greater Noida 04.2001 -
Skills
Database Management Systems (DBMS)
ETL (Extract, Transform, Load) Tools and Processes
Big Data Technologies
Cloud Platforms and Service
Python
SQL and NoSQL DBs
Power BI
Certification
AWS Solutions Architect Associate - SAA-CO3
Accomplishments
2 x On Spot Employee Awarded
Timeline
Meta - Databse Engineer
02-2024
System Engineer - Sr. DATA ENGINEER
TATA CONSULTANCY SERVICES
05.2023 - Current
AWS Solutions Architect Associate - SAA-CO3
01-2023
Assistant System Engineer - Data Engineer
Tata Consultancy Services
05.2021 - 05.2023
Oracle Bi Developer - Internship
Dainik Jagran
08.2019 - 01.2020
Intermediate - ISC - SCIENCE
Sheiling House School
04.2001 -
HSC - ICSE
SHEILING HOUSE SCHOOL
04.2001 -
Bachelor of Technology - Computer Science And Engineering
Galgotias University
04.2001 -