RAGHU RAJ DAVESAR
DATA ENGINEER
LUDHIANA
Summary
- 11.6 years of total IT experience that includes AWS cloud ( 3Y) , Snowflake DWH ( 3 Y ) , Snaplogic / Informatica Development (ETL), Data Warehousing , Oracle, Autosys. Exposure to APACHE KAFKA
- Strong data engineering & analytics engineer with around 11+ years of cross functional and technical experience in designing and implementing solutions for Investment banking , CapitaL, and Management consulting sectors to drive strategic and tactical decisions
- Proficient in technology leadership, architecture and client management.
- Worked closely with Business users to clarify business requirements and translate the requirements into technical specifications.
- Solid hands-on experience in building ingestion and transformation pipelines, re-usable frameworks, ETL pipelines, Orchestration
- Ability to meet deadlines and handle multiple tasks, decisive with leadership qualities, flexible in work schedules and possess good communication skills.
- Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
- Worked in Agile methodology .
Overview
11
11
years of professional experience
6
6
years of post-secondary education
1
1
Certification
Work History
AWS Cloud Engineer
TATA CONSULTANCY SERVICES
GURGAON
06.2019 - 10.2022
- Client - Mckinsey & Company , Project - FIRM DATA WAREHOUSE
- 3.4 years of hands on experience in AWS cloud including GLUE, AIRFLOW , LAMBDA , S3 , IAM , DMS,VPC ,STEP FUNCTIONS, EMR).
- 3 years of experience in Snowflake Data Warehouse.
- 2 Years of experience in Python programming.
- Worked as team member within team of cloud engineers on migration of on-prem Data Warehouse to Snowflake using AWS as cloud platform.
- Demonstrated understanding of AWS data migration tools and technologies including Storage gateway and Database Migration.
- Build ETL pipelines in AWS GLUE using Pyspark scripting for ingestion of data from various sources like API's, Oracle and loading data to staging and facts & dimensions tables.
- Scheduling of AWS jobs using Airflow DAG's.
- Creating and managing S3 buckets to build data lake.
- Creation of POCs and architecture for upcoming engagements.
Senior Consultant
eTeam, Inc.
BENGALURU
09.2017 - 06.2019
- CLIENT - UBS - Investment banking company , PROJECT - REFERENCE DATA REPORTING
- Majorly worked on developing Warehouse SCD1 & SCD2 mapping and Data Reporting. Created mappings to load transactional data to warehouse and created end to end Reports as per the business requirements.
- Hands on experience in developing SCD1 & SCD2 mappings, tasks, worklets, workflows, mapplets & designer transformations.
- Developed Informatica Mapping, Sessions, Workflows& various transformations like Expression, Aggregator, Source Qualifier, Union, Joiner Look Up, Filter, Router and Sorter & Update Strategy transformation.
- Extensively worked on Data Extraction, Transformation and loading data from various sources like Oracle, Sybase, Flat files,Json files.
- Performed Unit testing and generated reports for SIT & UAT.
- Extensively worked on Warehouse data loads & developed mappings using SCD2 and warehouse refresh.
- Worked with L2 team on fixing major Warehouse data load issues.
- Fixed existing bugs/issues in existing warehouse load mappings.
- Worked on Autosys for scheduling of jobs.
- Developed custom solutions based upon clients' strict requirements.
Consultant Engineer
Genpact India PVT LTD
GURGAON
08.2011 - 07.2017
- Client - General Electorincs ( GE Capital ) , Project - Smart Stream
- Understanding business requirements and translate the requirements into technical specifications documents like LLD & BRD documents.
- Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
- Extensively used transformation like Expression, Aggregator, Source Qualifier Union, Joiner, Look Up, Filter, Router and Sorter.
- Developed complex mappings in Informatica to load the data from various sources to Warehouse tables using SCD mappings.
- Prepared SQL Queries to validate the data in both source and target databases.
- Identifying bugs in existing mappings by analysing data flow, evaluating transformations and fixing invalid mappings.
- Prepared UNIX scripts to automate the Informatica jobs, splitting of output files & sftp the files to target Unix server.
- Involved in ITG process for code migration to Production from DEV environment.
- Involved in Daily and Weekly Business meetings.
- Providing support to newly introduced production informatica jobs.
- Provided KT and mentored new resources joined in project.
Education
Bachelor of Technology - Computer Science
Punjab Technical University
JALANDHAR 08.2007 - 05.2011
10+2 ( Higher Secondary School ) - Non-Medical
CBSE Board
Ludhiana 03.2005 - 03.2006
10th ( High School ) - Mathematics
PSEB Board
Ludhiana 03.2003 - 03.2004
Certification
CERTFIED AWS CLOUD PRACTITIONAR
Timeline
CERTFIED AWS CLOUD PRACTITIONAR
12-2021
AWS Cloud Engineer
TATA CONSULTANCY SERVICES
06.2019 - 10.2022
Senior Consultant
eTeam, Inc.
09.2017 - 06.2019
Consultant Engineer
Genpact India PVT LTD
08.2011 - 07.2017
Bachelor of Technology - Computer Science
Punjab Technical University
08.2007 - 05.2011
10+2 ( Higher Secondary School ) - Non-Medical
CBSE Board
03.2005 - 03.2006
10th ( High School ) - Mathematics
PSEB Board
03.2003 - 03.2004