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
Similar Profiles
Teen Mariya RoyTeen Mariya Roy
Project Coordinator at Wissen Infotech Private LimitedProject Coordinator at Wissen Infotech Private Limited
YASWANTH KUMAR PALAYASWANTH KUMAR PALA
Cloud Platform | DevOps Engineer at Wissen InfotechCloud Platform | DevOps Engineer at Wissen Infotech
Swagatika PattanaikSwagatika Pattanaik
Senior Engineer at Wissen InfotechSenior Engineer at Wissen Infotech