PRAKHAR SRIVASTAVA
Mirzapur
Summary
Data Engineer with over 2 years of expertise in pipeline development, data migration, and integration. Proficient in SnapLogic, DataStage, SQL, Power BI, and AWS services, with a strong focus on data warehousing and predictive analytics. Recognized for delivering high-quality solutions through automation and visualization while employing critical thinking and problem-solving skills to drive actionable insights. Aiming to leverage technical skills to enhance data-driven decision-making in future projects.
Overview
2
2
years of professional experience
1
1
Certification
Work History
ETL Developer
EXL Service Pvt. Ltd.
Bangalore
01.2023 - 12.2024
- Designed and implemented pipelines to streamline data movement from sources to targets.
- Executed precise data mapping and conducted comprehensive unit testing to ensure data consistency and accuracy between source and target systems, leveraging advanced techniques such as joins, filters, lookups, SQL queries, and conditional logic to optimize pipeline transformations.
- Experienced with SnapLogic Expression Libraries for code reuse, consistency, and version control.
- Implemented child pipelines and parent pipeline invocation; proficient in Tidal automation for job scheduling.
- Tech Stack Used: DataStage, Snap Logic, SQL, Excel, MQ Client, python, Tidal Schedule
Junior SQL Developer
EXL Service Pvt. Ltd.
08.2022 - 10.2023
- Assessed code during the testing phase to identify and resolve potential glitches and bugs, performed advanced query tuning to enhance system performance, and monitored database systems to ensure optimal performance levels.
- Led the migration of databases to new platforms or versions with minimal downtime and data loss, while optimizing SQL queries and stored procedures to significantly reduce execution time, and enhance performance.
- Developed interactive reports, pie charts, and bar charts to visualize business data, utilizing Power BI for insightful data representation.
- Applied DAX functions to enhance data analysis and reporting accuracy, enabling stakeholders to make effective, data-driven decisions.
Education
Some College (No Degree) - Electrical Engineering
SRM Institute of Engineering
Chennai05-2022
Higher Secondary School -
SN Public School
Mirzapur04-2018
Skills
- SnapLogic
- Advance SQL
- Excel
- Exploratory Data Analysis
- Azure Data Factory
- IBM Data analysis
- Data Migration
- Logic Building
- Python programming
- Data migration
- ETL modeling
- Data warehousing management
- Data cleansing
- Data mapping
- Data transformation
- Data modeling
Certification
- Snap Logic Integrator Certification(Snaplogic official site)
- AWS Redshift Essential(LinkedIn learning)
- SQL Beginner to Advance (Udemy)
LANGUAGE
Hindi
First Language
English
Advanced (C1)
C1
Accomplishments
- Streamlined Data Integration:
Designed and implemented efficient ETL pipelines, reducing data integration time by 30% and improving system performance. - Optimized Data Workflows:
Enhanced ETL workflows, minimizing processing errors by 25% and ensuring accurate and timely data delivery. - Seamless Data Migration:
Led a successful migration of large datasets across platforms with 100% data accuracy and minimal downtime, ensuring business continuity. - Cost Savings:
Automated ETL processes using SnapLogic and DataStage, saving the organization 20% in data processing costs annually. - Compliance and Accuracy:
Ensured compliance with data governance standards by implementing robust validation and error-handling mechanisms.
Timeline
ETL Developer
EXL Service Pvt. Ltd.
01.2023 - 12.2024
Junior SQL Developer
EXL Service Pvt. Ltd.
08.2022 - 10.2023
Some College (No Degree) - Electrical Engineering
SRM Institute of Engineering
Higher Secondary School -
SN Public School
Similar Profiles
Lokesh PathakLokesh Pathak
Executive in Finance and Accounting at Exl Service Pvt. Ltd.Executive in Finance and Accounting at Exl Service Pvt. Ltd.
KRITIKA BHANKRITIKA BHAN
Consultant - Finance Transformation at EXL Service Pvt. LtdConsultant - Finance Transformation at EXL Service Pvt. Ltd
Yogita KaushikYogita Kaushik
Assistant Manager Accounts Payable at EXL Service Pvt Ltd.Assistant Manager Accounts Payable at EXL Service Pvt Ltd.