Harshit Garg
New Delhi
Summary
• A focused and result-oriented professional with nearly 2 years 6 months of experience in Project Execution, ETL, Data Modeling, Data Warehousing and Database Management.
• Competent in end-to-end development of applications from Project Planning includes requirement analysis to system study, designing (low level - technical), coding, testing, documentation and
implementation.
Overview
2
2
years of professional experience
Work History
Data Engineering Analyst
Accenture Solutions Private Limited
05.2022 - Current
- Used Informatica Power Centre 10.4 for extraction, transformation and load (ETL) of data in data warehouse.
- Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
- Used SQL to test various reports and ETL Jobs load in development, testing and production
- Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
- Parameterized mappings and increased re-usability.
- Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with logic embedded in mappings.
- Created procedures to truncate data in target before session run.
- Extensively used Informatica debugger to figure out problems in mapping. Also involved in troubleshooting existing ETL bugs.
Associate Software Engineer
Accenture Solutions Private Limited
02.2021 - 05.2022
- Analyzed business requirements and functional specifications.
- Extracted data from oracle database and spreadsheets and staged into Data Hub Layer and applied
- Created list of inconsistencies in data load on client side so as to review and correct issues on their side.
- Created ETL exception reports and validation reports after data is loaded into warehouse
- Created Test cases for mappings developed and then created integration Testing Document.
- Followed Informatica recommendations, methodologies and best practices.
Education
B.Tech. - Computer Science Engineering
Maharaja Agrasen Institute Of Technology, GGSIPU
New Delhi, Delhi12.2020
12th (CBSE) -
Rainbow English Sr. Sec. School
Janakpuri, New Delhi03.2015
10th (CBSE) -
Rainbow English Sr. Sec. School
Janakpuri, New Delhi03.2013
Skills
- Informatica Powercenter
- IICS
- ETL (Extract, Transform, Load)
- SQL
- PL/SQL
- Data Integration
- Oracle Database
- Cloud warehousing & Data warehousing
- Unix
- Tableau
Languages
English
Advanced (C1)
Hindi
Advanced (C1)
Timeline
Data Engineering Analyst
Accenture Solutions Private Limited
05.2022 - Current
Associate Software Engineer
Accenture Solutions Private Limited
02.2021 - 05.2022
B.Tech. - Computer Science Engineering
Maharaja Agrasen Institute Of Technology, GGSIPU
12th (CBSE) -
Rainbow English Sr. Sec. School
10th (CBSE) -
Rainbow English Sr. Sec. School
Similar Profiles
Nitin MathewNitin Mathew
Bid Manager - Team Lead at Accenture Solutions Private LimitedBid Manager - Team Lead at Accenture Solutions Private Limited
Kiran Kumar NKiran Kumar N
Order to Cash Application Analyst / Cash Application Specialist at Accenture Solutions Private LimitedOrder to Cash Application Analyst / Cash Application Specialist at Accenture Solutions Private Limited
SANTHOSH SOMAPPASANTHOSH SOMAPPA
Data Engineering Associate Manager at ACCENTURE SOLUTIONS PRIVATE LIMITEDData Engineering Associate Manager at ACCENTURE SOLUTIONS PRIVATE LIMITED
Laxmi Prasanna GajawadaLaxmi Prasanna Gajawada
Software Test Engineer at Accenture Solutions Private LimitedSoftware Test Engineer at Accenture Solutions Private Limited
Nitin DhamijaNitin Dhamija
Chief Finance Officer (CFO) at Expo Stand Services Pvt. Ltd.Chief Finance Officer (CFO) at Expo Stand Services Pvt. Ltd.