HamburgerMenu
hirist

Software Tester - ETL/Datawarehouse Testing

Insight Global
Multiple Locations
5 - 10 Years

Posted on: 19/09/2025

Job Description

Experience : 5+ years in ETL Testing, Database Testing, and Manual Testing.

Technical Skills :

- Strong understanding of ETL concepts and data warehouse testing methodologies monitoring scripts and running them.

- Proficient in RDBMS : MySQL, Oracle SQL.

- Hands-on experience with SSIS (SQL Server Integration Services).

- Skilled in UNIX commands (grep, awk, find) for log analysis and job monitoring.

- Advanced SQL skills : joins, group functions, analytical functions, subqueries.

- AWS services : CloudWatch, EventBridge, QuickSight, Batch Jobs, Lambda, S3, Redshift, Glue.

- Proficiency in writing test automation scripts for data pipelines.

Testing Expertise :

- Strong background in Data Migration Testing :

a. Source-to-target validation.

b. Record count verification.

c. Data integrity and validation.

d. Transformation logic and job run verification.

- Experience in system integration and functional testing across sprints/iterations.

- Able to create, review, and execute detailed test cases based on business and technical requirements.

Additional Skills :

- Requirement analysis and work effort estimation.

- Quality management : defect identification, root cause analysis, corrective measures.

- Strong analytical, problem-solving, and communication skills to collaborate effectively.

Nice to Have :

- Experience automating data testing using AI/ML tools.

- CI/CD pipeline integration for test automation.

Benefits :

- Health Insurance : 30 Lakh for employee, spouse, two dependent children, and two parents/in-laws.

- Accident & Disability : 50 Lakh for employee.

- Free doctor consultations.

- 12% of basic salary contributed to PF.

- 11 National Holidays and 15 PTO days.


info-icon

Did you find something suspicious?