Dama Revanth
Tirupati
Summary
Motivated ETL Developer with knowledge of Informatica PowerCenter, SQL, and data warehousing concepts. Experience in creating mappings, workflows, and transformations such as Lookup, Joiner, Aggregator, and Expression. Strong analytical skills with the ability to develop efficient ETL solutions for data integration and reporting.
Overview
3
3
years of professional experience
Work History
Associate Consultant B1
Capgemini
Bangalore
08.2025 - Current
- I'm maintain the application using Informatica ETL tools and PL/SQL database
- Analyse, design and deliver client-requested changes and enhancements to existing systems
- Handle RITM (Request Item) tickets and resolve production incidents in a timely manner
- Optimize PL/SQL procedures, packages, and database objects.
- The CMT product provides to track the spare part of the engine in different metrics.
Sr. Analyst
Capgemini
Bangalore
10.2022 - 08.2025
- Involved in development of mappings. Sophisticated transformation rules are implemented using Informatica features like Aggregator, Filter, Expression, Sequence Generator, Rank and Source Qualifier.
- Involved in Understanding the Requirements and Preparing Design Documents
- Extracting source data from oracle and Flat Files and moving into Staging area and then transferring to Oracle target database using Informatica
- Involved in Coding, Testing, Documentation, Maintenance.
- Monitored sessions using Informatica Workflow Manager and workflow monitor.
- Performing the unit testing and reviewing the test cases.
- Interacted with business users and owners to know their business views.
- Performed data validation by comparing visualized result in spotfire with source system queries
- The WIP Analytics product provides visibility to the cost of an overhaul shop visit as the engine progresses through the overhaul. This capability allows shops to identify real time cost variances against fleet model-based targets and to escalate and implement interventions.
Education
B-TECH - CIVIL
Annamacharya Institute of Technology and Sciences
Tirupati01-2019
INTERMEDIATE -
Sri Chaitanya Bharathi junior college
Tirupati01-2015
SSC -
Sri Kesava Reddy Concept School
Tirupati01-2013
Skills
- Informatica power center
- MySQL
- Oracle PL/SQL
- UNIX
- Windows
Residence
H.No 15-2-100/B GS Mada Street, Tirupati, Andhra Pradesh, 517501
Passport Details
T3242984
Corporate Mail
REVANTH.B.D@CAPGEMINI.COM
Personal Information
- Date of Birth: 05/31/98
- Gender: Male
- Nationality: Indian
- Marital Status: Single
Designation
Associate Consultant B1
Accomplishments
Shining Star Award for Q3 2025: Best Performance.
Timeline
Associate Consultant B1
Capgemini
08.2025 - Current
Sr. Analyst
Capgemini
10.2022 - 08.2025
B-TECH - CIVIL
Annamacharya Institute of Technology and Sciences
INTERMEDIATE -
Sri Chaitanya Bharathi junior college
SSC -
Sri Kesava Reddy Concept School