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
Similar Profiles
Shailja BhatejaShailja Bhateja
Associate Director-Client & Industry at PricewaterhouseCoopers India LLP ( PwC, India)Associate Director-Client & Industry at PricewaterhouseCoopers India LLP ( PwC, India)
Hariharan N Hariharan N null
Accountant at Hiregenics India LLP (Oracle India PVT LTD)Accountant at Hiregenics India LLP (Oracle India PVT LTD)
Shivani WankhedeShivani Wankhede
Software Developer (Experienced) at Amdocs Development Centre India, LLP, Pune, IndiaSoftware Developer (Experienced) at Amdocs Development Centre India, LLP, Pune, India
Arindam SinghArindam Singh
AI Agent Architecture Intern at IBM at IBM India Pvt. Ltd.AI Agent Architecture Intern at IBM at IBM India Pvt. Ltd.
Sumit Singh BishtSumit Singh Bisht
Software Support Engineer at Nippon Data System Ltd.Software Support Engineer at Nippon Data System Ltd.