Ramprasad Racha
Hanamkonda
Summary
Dynamic ETL Developer with extensive experience at Schneider Electric, specializing in Informatica Cloud and SQL Server. Proven track record of enhancing data quality, achieving a 40% reduction in errors. Adept at transforming complex data into actionable insights while collaborating effectively with cross-functional teams. Proficient in Informatica PowerCenter and skilled in problem-solving. Experienced ETL developer proficient in Informatica PowerCenter, IICS, and SQL Server. Known for delivering efficient data integration solutions and optimizing ETL mappings to enhance data quality.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Consultant
Capgemini Technology ltd
04.2025 - 09.2025
- Consulted on business services leveraging IICS tool and SQL Server to optimize data integration.
- Developed mappings using almost all transformations in IICS like Source, Target, Aggregator, joiner, Normalizer, Sequence, Lookup, Hierarchy Builder, Hierarchy Parser etc.
- Experience in Creating different connectors like Oracle, SQL Server
- Developed and integrated add-on connectors within IICS Administrator to enhance system functionality.
- Supported Citibank client initiative by delivering tailored data solutions and ensuring project alignment with client needs.
- Served as ETL developer and team member
- Worked within a team of five
- Technologies/Tools: Informatica IICS, SQL server
- Location: Offshore
Specialist Data Engineer
LTIMindtree
07.2024 - 01.2025
- Interpreted function design document to create Informatica mappings, facilitating seamless data transfer to downstream systems.
- Worked on different transformations like Router, Filter, Expression, Lookup, Transaction control transformation, Update strategy etc.
- Developed mappings to extract data from tables and loaded data in target as per the business logic provided by client.
- Engineered ETL mappings with Informatica Power Center to integrate data from flat files and Oracle into staging, data warehouse, and data marts.
- Developed ETL mappings using transformations such as Aggregator, Lookup, and Joiner to efficiently load data into staging and dimension tables.
- Implemented Incremental loading to from source to Stage.
- Contributed to client project for Wells Fargo
- Served as ETL developer and team member
- Worked in a team of three
- Technologies/Tools: Informatica IICS, SQL server
- Operated in an offshore location
- Engaged in financial domain
Data Analyst
Trainity
01.2024 - 03.2024
- Internship Training and certification for a period of 3 months from the institute in various real-time projects.
Sr. ETL Developer
Schneider Electric
Bengaluru
11.2020 - 07.2023
- Directed the implementation of Informatica cloud for data quality checks, resulting in a 40% reduction in data errors and ensuring accurate reports and dashboards were published through Tableau
- Worked on Data Integration and Monitor services in IICS to monitor daily jobs and also monitored SQL Server jobs and increasing productivity
- To get the Functional Requirement Specifications from the customer, analyze and deploying the same to daily jobs
- Resolved the issues if there are delays or failures in jobs by delivering 100% accurate data
- Contributed as Informatica developer using the IICS tool with SQL Server on multiple requirements on a daily, weekly, and monthly basis
- Involved in the design of ETL development as per the Business Requirement document and got approval from business within SLA
- Making and develop the ETL code or mappings as per the project ETA timeline and increased revenue by 60%.
- Payroll: ACL Digital
Software Engineer
Tech Mahindra
Hyderabad
06.2012 - 06.2015
- Developed the script for a given application based upon the format given by business units and execute the scripts on the given servers and achieved a growth rate of 50%
- Involved in the development of mappings using ETL Informatica.
- Development of scripts for various applications in all platforms
- Preparation of reports for all scripts with the formatted outputs and test case documents
- Used Desktop and Server Management tool which is a part of IT Asset Management where servers are managed by different businesses on a daily basis.
Education
Bachelor's Degree - Electronics and Communication Engineering
Balaji Institute of Technology & Science
WarangalHigher Secondary - MPC
SR Junior College
SSC -
Bishop Beretta High School
Skills
- Informatica PowerCenter 10x
- Informatica Cloud (IICS)
- SQL Server
- Oracle
- SQL
- Windows
- UNIX
- AWS S3
Certification
- ITIL V3 Foundation from Axelos
- Data Analyst certification from Trainity
- IDMC Foundation series certification
- IDMC Partner Associate certification
- CDGC Foundation series
- Data Analyst certification
Timeline
Consultant
Capgemini Technology ltd
04.2025 - 09.2025
Specialist Data Engineer
LTIMindtree
07.2024 - 01.2025
Data Analyst
Trainity
01.2024 - 03.2024
Sr. ETL Developer
Schneider Electric
11.2020 - 07.2023
Software Engineer
Tech Mahindra
06.2012 - 06.2015
Bachelor's Degree - Electronics and Communication Engineering
Balaji Institute of Technology & Science
Higher Secondary - MPC
SR Junior College
SSC -
Bishop Beretta High School