Experienced professional with over 6+ years of experience in IT Industry with history of meeting company goals utilizing consistent and organized practices. Skilled in working under pressure and adapting to new situations and challenges to best enhance the organizational brand.
Overview
6
6
years of professional experience
4
4
years of post-secondary education
2
2
Languages
Work History
Azure Data Engineer
Logility
Bangalore, Karnataka
10.2019 - Current
Collaborated with Rituals(Client) team on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
Analyzed source data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
Employed data cleansing methods such as duplicate checks ,null value checks, significantly enhancing data quality, producing accurate results.
Experience in creating mount points to connect to Azure Data lake storage Gen2 from Databricks.
Processed structured and semi structured data using PySpark Dataframes.
HandsOn experience on performance tuning of the data procesing.
Associate Consultant
Capgemini
Bangalore, Karnataka
08.2018 - 09.2019
Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
Interacting with onsite coordinator to discuss the status of project, clarify any queries regarding the requirements.
Creating workflows and respective design pattern based on technical design document.
Extracted the data from the Oracle & Flat files.
Configured the Informatica jobs using the Tidal scheduler.
BI Consultant
KPI Partners
Bangalore, Karnataka
08.2015 - 08.2018
Developed ETL programs using Informatica to implement the business requirements.
Data manipulations using various Informatica Transformations like Filter, Expression,Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router,Sorter and Union.
Implemented the SCD Type1, Type2 logic to keep track of historical data along with current data in dimensions and scheduled those jobs based upon dependency.
Extracted data from ‘SalesForce’ system to Staging Area and loaded the data to the target database by ETL process using Informatica Power Center.
Identified problems in existing production data and developed adhoc scripts to correct them.
Responsible for fixing the bugs raised by the QA team.
Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
Performed unit testing at various levels of the ETL and actively involved in team code reviews.
Education
Bachelor of Technology - Computer Science
JNTU Kakinada
Kakinada
08.2011 - 05.2015
Skills
PySpark using Databricks
undefined
Accomplishments
Achieved Employee of the Quarter – Q3 2016 from KPI Partners India Pvt. Ltd.
Software
MS Office
Quote
The way to get started is to quit talking and begin doing.
Walt Disney
Timeline
Azure Data Engineer
Logility
10.2019 - Current
Associate Consultant
Capgemini
08.2018 - 09.2019
BI Consultant
KPI Partners
08.2015 - 08.2018
Bachelor of Technology - Computer Science
JNTU Kakinada
08.2011 - 05.2015
Similar Profiles
Rajkumar R Rajkumar R null
Senior Project Engineer at Logility, VFCorpSenior Project Engineer at Logility, VFCorp
Duty Manager - Fast Food at Cinescape Kuwait National Cinemas Co-operation (KNCC)Duty Manager - Fast Food at Cinescape Kuwait National Cinemas Co-operation (KNCC)