Jitendra Chauhan [Data Engineer]
Ghaziabad
Summary
- 4.8 year experience in ETL Process [Data Engineer].
- Worked on AWS Datapipline to configure data load from S3 to into Redshift using Python Script.
- Using AWS Redshift I done ETL Process from heterogeneous data sources and destination
- Working with Spark SQL API in PYSPARK to extract and load data to perform SQL Queries
- Worked on Redshift and Snowflake Data warehouse
- Knowledge of Creating End to End Data warehouse creation Process Using SFTP,SSIS Packages,SQL,Procedure
- Knowledge in programming tasks-Stored Procedures,Triggers using SQL Server with T-SQL,optimization(Query Execution Plan) ,Joins and Views
- Worked SSAS (Tabular Model) creation , Tranforming and deployement of model and then use it in reports
- Client Interaction
Overview
6
6
years of professional experience
Work History
Senior Consultant (ETL Developer)
PCGI INDIA LLP
08.2022 - Current
- Perform ETL using Python script
- Able to understand Data Modelling
- Worked on AWS Datapipline to configure data load from S3 to into Redshift using Python Programming
- Strong Understanding of AWS Component such as S3 , EC2
- Created Spark Session to work on Data frames with SQL and Python used global views and other stuffs
- Capable to turn large amounts of raw data into actionable information
- Maintain and support data analytics platforms
- Designing maintenance Stored procedures and putting them into operation
- Created Data warehouse Process
- Worked on Cloud Database (Redshift/Snowflake)
- Designing, implementing and Maintenance SSIS solutions
- ETL Experience in design, configuration, data mapping, extraction, transformation, and loading
- Worked intensively on Reporting Tools Power bi for fetching the insight.
MS SQL Developer (Onsite : KPMG)
ACS Solutions Private Limited (Noida)
09.2021 - 07.2022
- Import data from multiple sources and Load them in multiple sources by using Alteryx, SQL
- Work on advanced Excel ,Vlookup , Pivot etc
- Work on Alteryx tool for performing ETL Process
- Work on Alteryx for data cleaning and data Preparation
- Worked on solving client issues using SQL
- Create and Modify the Procedures and Views as per Requirements
- To gather and analyse business requirements, create specifications, and develop to those specifications
- Maintaining client data and information of database
- Strong SQL skills and database programming skills; Join, creating views, stored procedures and triggers, implementing referential integrity, designing.
Engineer (Solution Delivery Group)
Acidaes Solutions Private Limited (Noida)
06.2021 - 08.2021
- Work on real CRM product
- Work on Banking domain
- Work On MuleSoft software
- Having SQL skills and database programming skills; Join, creating views, stored procedures and triggers
- To gather and analyse business requirements, create specifications, and develop to those specifications
- Maintaining client data and information of database
- Having knowledge with database performance tuning and optimization (Query Execution Plan)
- Strong SQL skills and database programming skills; Join, creating views, stored procedures and triggers, implementing referential integrity, designing.
SQL Developer
R4 Solutions Inc
Noida
01.2021 - 05.2021
- To gather and analyse business requirements, create specifications, and develop to those specifications
- Maintaining client data and information of database
- Knowledge with database performance tuning and optimization (Query Execution Plan)
- Creating ETL process for Extract, Transform, and Load
- Strong SQL skills and database programming skills; Join, creating views, stored procedures and triggers, implementing referential integrity, designing.
Data Digitization Production
QA Infotech (CDL) (Noida)
11.2018 - 12.2019
- Evaluating data file submissions and developing/maintaining SSIS packages for ETL processes
- Experience in creating SSIS packages using proper control and data flow elements
- Enhancing and deploying the SSIS Packages from development server to production server
- Interact with business user to understand their need to find out the root cause of issue for further implementation
- Update functions, procedures, packages and triggers based on business requirement requirements.
Education
Btech(IT) -
AKTU University
Ghaziabad08.2019
XII -
CBSE Board
Ghaziabad03.2015
X -
CBSE Board
Ghaziabad03.2014
Skills
- SQL
- Python
- Pyspark
- BIGDATA
- AWS Services
- Redshift
- SSIS
- SSAS
- Power Bi
Languages
Hindi
First Language
English
Upper Intermediate (B2)
B2
Timeline
Senior Consultant (ETL Developer)
PCGI INDIA LLP
08.2022 - Current
MS SQL Developer (Onsite : KPMG)
ACS Solutions Private Limited (Noida)
09.2021 - 07.2022
Engineer (Solution Delivery Group)
Acidaes Solutions Private Limited (Noida)
06.2021 - 08.2021
SQL Developer
R4 Solutions Inc
01.2021 - 05.2021
Data Digitization Production
QA Infotech (CDL) (Noida)
11.2018 - 12.2019
Btech(IT) -
AKTU University
XII -
CBSE Board
X -
CBSE Board