Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Somanath Kondeti

Summary

ETL Testing Professional with 3.4 years of experience in data warehousing and ETL processes. Proficient in using tools like WMQ, HVR, Informatica, and SQL to ensure data accuracy, consistency, and quality. Strong background in analyzing complex data sets, validating business rules, and supporting data integration projects. AWS Associate certified, with hands-on experience in cloud-based solutions and automation.

Overview

4
4
years of professional experience
2009
2009
years of post-secondary education
1
1
Certification
1
1
Language

Work History

ETL Tester

Wissen Infotech Private Limited
05.2021 - Current
  • Designed and executed end-to-end ETL testing processes for various client projects
  • Validated complex data transformations and ensured data integrity using SQL and Informatica
  • Developed and executed test cases to validate business and functional requirements
  • Collaborated with cross-functional teams to troubleshoot and resolve data quality issues
  • Key Projects
  • Project 1: PRAHS (PRA Health Sciences)
  • Client: PRA Health Science is a global provider of Clinical research, Clinical trial Management Data, and outsourced development and commercialization services to the pharmaceutical, biotechnology and medical device industries
  • Description: Performed ETL testing on healthcare data to ensure accurate reporting and compliance with regulatory standards
  • Validated clinical trial data flows from multiple sources to centralized data warehouses
  • Automated testing processes to enhance data quality and reduce manual intervention
  • Worked closely with stakeholders to deliver accurate and timely insights for healthcare studies
  • Project 2: AMPS BDW
  • Client: GE Aviation, a subsidiary of General Electric, is headquartered in Evendale, Ohio, outside Cincinnati
  • GE Aviation is among the top aircraft engine suppliers, and offers engines for the majority of commercial aircraft
  • Description: Focused on building and testing a business data warehouse to streamline data analytics and reporting
  • Tested complex data pipelines, ensuring data consistency between source systems and data marts
  • Collaborated with developers and data architects to enhance ETL workflows and optimize performance
  • Identified and resolved critical data discrepancies impacting financial reporting
  • Project 3: OPS (On Premises Simplified) – GE Healthcare
  • Client: GE Healthcare, a leading provider of medical imaging and diagnostics solutions
  • Description: Simplified and tested on-premises data solutions for better data management and reporting
  • Verified data ingestion, transformation, and storage processes, ensuring seamless integration
  • Implemented robust test plans to validate data pipelines and troubleshoot issues in real-time
  • Supported the transition of legacy systems to modern data platforms, improving operational efficiency

Education

Bachelor of Technology (B.Tech) -

JNTU University

Skills

ETL Tools: Informatica

ETL Tools: HVR

Database & Querying: SQL

Database & Querying: Oracle

Database & Querying: MySQL

Middleware: WMQ

Cloud Platforms: AWS

Scripting: Python

Testing: Functional Testing

Testing: Regression Testing

Testing: Data Validation Testing

Certification

AWS Certified Solutions Architect – Associate

Timeline

ETL Tester

Wissen Infotech Private Limited
05.2021 - Current
AWS Certified Solutions Architect – Associate

Bachelor of Technology (B.Tech) -

JNTU University
Somanath Kondeti