About
Result-oriented and highly analytical ETL Tester with 5 years of specialized experience in skills like Oracle SQL, UNIX, IICS and ETL Concepts, Well-versed with all stages of software Development life cycle (SDLC), Software Testing Life Cycle (STLC) & Bug life Cycle, Experience in various types of testing like Functional, Regression, Retesting, Smoke & Sanity testing. Created test cases, executed and note down the results and have done peer to peer validation. Involved in end to end testing. Created complex SQL for business requirement and executed in oracle database, Expertise in writing SQL Queries by using joins, Function, CTEs and Subquery. Good knowledge in Agile Methodology and waterfall Good Knowledge in star, snow flake schema, fact & dimension tables. Strong working experience in windows and UNIX Clear understanding of business requirements, validate mapping sheet and ability to work as a team
Skills & Expertise (22)
Work Experience
ETL Test Engineer
Profuse Transtech Solutions Pvt Ltd
May 2021 - Present
Formulate and execute comprehensive ETL test strategies, test plans, and extensive SQL validation scripts based on complex Source-to-Target mapping documents. Validate high-volume data extractions, complex transformations, and accurate loads across heterogeneous environments. Perform deep-dive data profiling, data quality assessments, and integrity checks to catch source inconsistencies, truncation errors, and null constraints. Utilize advanced SQL operations including analytical functions, multi-table joins, subqueries, and set operations to manually reconcile target databases against source systems. Implement Python and Unix shell scripts to automate repetitive data validation checks, reducing regression testing cycles by 30%. Track, document, and manage defects using Jira; collaborate closely with ETL developers and data engineers to drive root-cause analysis and fast resolution. Participate in daily Agile Scrum meetings, sprint planning, and look-ahead sessions to align testing roadmaps with evolving project delivery requirements.
Education
Bachelor of Technology (B.Tech) in Information Technology - Dhanalakshmi College of Engineering
- 2013 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Need Sponsorship
Relocation
Depends on Offer
Skills (22)
Click a skill to find developers with the same skill
