Yadvendra Sharma
Sr. Software Engineer
Jaipur
Summary
To obtain a meaningful and challenging position with a frontline organization that enables me to grow in my career. Professional Summary: Having 5 years of experience in ETL Informatica, and Data warehouse ETL designing. Currently working with WIPRO, Pune. Extensive hands-on expertise using Informatica. Having good exposure to Banking, Financial, Insurance domain, OLTP and Data warehouse applications. In all phases of Software development life cycle. In-depth experience in Data Warehousing includes Star Schema Fact & Dimension tables, Sources, Mappings, Targets and resolving any data inconsistencies across loads. Worked on different data sources ranging from flat files, Oracle and legacy system etc. Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling Fast & Self learner of the given environment and challenges presented
Overview
5
5
years of professional experience
Work History
Sr. Software Engineer
Wipro Limited
12.2022 - Current
- Unix
- Team Size 4
Sr. Software Engineer
HCL Technologies
06.2022 - 12.2022
- Platform HFM, Oracle Financial Reporting Studio
- Team Size 2
Informatica Developer
Inventcolabs Infotech Pvt. Ltd
04.2020 - 06.2022
- Project Insurance
- Platform Informatica 9
- Team Size 6
- Synopsis:
- It is one of the General Insurance projects
- We get insurance /organization related data from various source system and process it through ETL
- Roles & Responsibilities
- Participated in understanding the data flow with an existing system and provided business solution/suggestion
- Responsible for analyzing, designing and developing ETL strategies and processes
- Developing and debugging the informatica mappings to resolve bugs, and identify the causes of failures
- Preparation of TD (Technical Design) documents
- User interaction to identify the issues with the data loaded through the application
- Developed different Mappings using different transformations
- Worked on Informatica scheduler for running various jobs
- Creating test plans
- Unit Testing, fixes assigned SIT & UAT defects and provides status for tracking
- Used JIRA tool for tracking the project used for bug tracking, issue tracking, and project management
Informatica Developer
RAYZ INFOTECH
09.2018 - 03.2020
- Project Banking
- Platform Oracle 12c, Informatica
- Team Size 5
- Synopsis
- It is one of the leading banking firm in US
- It is a data warehousing project used for processing data through various layer (Staging→Delta→EDW), EDWs are central repositories of integrated data from various sources
- Roles & Responsibilities
- Responsible for analyzing, designing and developing ETL strategies and processes
- Developing and debugging the informatica mappings to resolve bugs, and identify the causes of failures
- Preparation of TD (Technical Design) documents
- User interaction to identify the issues with the data loaded through the application
- Developed different Mappings using different transformations
- Worked on Informatica scheduler for running various jobs
- Creating test plans and developing Test Scripts: Unit Testing, fixes assigned SIT & UAT defects and provides status for tracking
Education
B Tech - Electrical Engineering
BMIT, Rajasthan Technical University
12th - undefined
Rawat Sr. Sec. School
Jaipur, Rajasthan10th - undefined
Pratap public School
Jaipur, RajasthanSkills
Data warehouse Tools Informatica, Oracle 10g, 11g, 12Cundefined
Timeline
Sr. Software Engineer
Wipro Limited
12.2022 - Current
Sr. Software Engineer
HCL Technologies
06.2022 - 12.2022
Informatica Developer
Inventcolabs Infotech Pvt. Ltd
04.2020 - 06.2022
Informatica Developer
RAYZ INFOTECH
09.2018 - 03.2020
B Tech - Electrical Engineering
BMIT, Rajasthan Technical University
12th - undefined
Rawat Sr. Sec. School
10th - undefined
Pratap public School
Similar Profiles
John MondalJohn Mondal
Senior Analyst at Wipro LimitedSenior Analyst at Wipro Limited
Hari PrasadHari Prasad
Assistant Manager at Wipro LimitedAssistant Manager at Wipro Limited
Trishant AgrawalTrishant Agrawal
Business Finance Manager at WIPRO LIMITEDBusiness Finance Manager at WIPRO LIMITED