RAJASEKHAR Reddy KONDA
IT
Bangalore
Summary
Dynamic Senior Data Engineering and ETL Testing professional with over 7 years of experience delivering robust data solutions across diverse sectors, including banking, insurance, pharmaceuticals, clinical research, and retail. Expertise in ETL testing, data validation, and data warehousing concepts, complemented by proficiency in Informatica PowerCenter, Informatica Intelligent Cloud Services (IICS), and advanced SQL. Skilled in validating complex, large-scale data pipelines and executing source-to-target reconciliation, incremental load, and CDC testing to ensure exceptional data quality and integrity across enterprise systems. Adept at navigating cloud-based data platforms and supporting end-to-end data lifecycle processes within Agile environments while effectively collaborating with cross-functional teams to drive business-aligned data solutions.
Overview
8
8
years of professional experience
Work History
Quality Engineering Specialist
Accenture
02.2024 - Current
- Performed end-to-end ETL testing for large-scale data pipelines using IICS across Oracle, SQL Server, and GCP environments
- Validated source-to-target mappings, transformation logic, and business rules using complex SQL queries
- Conducted reconciliation testing to ensure data completeness between staging and target tables
- Executed sanity, smoke, system, regression, and re-testing cycles
- Monitored ETL workflows and batch jobs using Control-M, analyzed failures, and supported reruns
- Raised and tracked defects in HP ALM, providing SQL evidence and detailed analysis
- Prepared daily and weekly test status reports, metrics, and quality dashboards for stakeholders
- Collaborated closely with developers, BAs, and onsite teams in Agile delivery model
- Managed budgets and timelines for large-scale engineering projects, ensuring all resources were allocated effectively to meet objectives.
- Operated successfully in QA environment focused on maximizing performance
Senior Data Engineering Analyst
Capgemini
12.2021 - 01.2024
- Designed and executed ETL test strategies, test plans, and test cases for Insurance and Financial Services projects
- Validated incremental and full data loads, ensuring no data loss or duplication
- Performed exception handling and reconciliation testing between staging and target layers
- Analyzed Informatica session and workflow failures and coordinated fixes
- Created and executed SQL scripts for backend data validation and defect analysis
- Managed defect lifecycle using Jira and HP QC
- Generated weekly status reports and quality metrics for leadership review
- Enhanced productivity by streamlining workflow processes based on findings from data analysis.
- Developed comprehensive reports detailing analytical findings, providing valuable insights for decisionmakers.
Software Engineer
ATOS
04.2020 - 12.2021
- Worked on Pharma domain projects using Informatica PowerCenter 10.1 and Oracle databases
- Developed and tested Informatica mappings using transformations such as Aggregator, Joiner, Lookup, Router, Rank, and Update Strategy
- Monitored Informatica sessions, tuned performance, and analyzed logs for failures
- Validated data from heterogeneous sources including flat files and relational databases
- Participated in technical design walkthroughs and requirement analysis sessions
- Integrated new technologies into existing systems, increasing capabilities and improving overall performance.
Senior Associate
Wipro
12.2017 - 04.2020
- Executed ETL and database testing for Banking and Financial Services clients
- Validated source-to-target mappings and transformation rules
- Created SQL queries for backend data verification and reconciliation
- Raised and tracked defects using HP QC and maintained test metrics
- Supported regression and UAT testing cycles
- Collaborated with cross-functional teams to drive successful completion of complex projects within deadlines.
Education
Bachelor of Technology (B.Tech) - Computer Science Engineering
Jawaharlal Nehru Technological University (JNTU)
Kakinada06-2016
Skills
ETL testing and validation
Data integration skills using ETL tools
Database management: Oracle, SQL Server, Snowflake, Databricks
Advanced SQL development AND UNIX /shellscript
Data warehousing expertise AND SCD
Timeline
Quality Engineering Specialist
Accenture
02.2024 - Current
Senior Data Engineering Analyst
Capgemini
12.2021 - 01.2024
Software Engineer
ATOS
04.2020 - 12.2021
Senior Associate
Wipro
12.2017 - 04.2020
Bachelor of Technology (B.Tech) - Computer Science Engineering
Jawaharlal Nehru Technological University (JNTU)