Software Tester - ETL/Datawarehouse Testing

<p><p><b>Experience : </b>5+ years in ETL Testing, Database Testing, and Manual Testing.<br/><br/><b>Technical Skills : </b><br/><br/>- Strong understanding of ETL concepts and data warehouse testing methodologies monitoring scripts and running them.<br/><br/>- Proficient in RDBMS : MySQL, Oracle SQL.<br/><br/>- Hands-on experience with SSIS (SQL Server Integration Services).<br/><br/>- Skilled in UNIX commands (grep, awk, find) for log analysis and job monitoring.<br/><br/>- Advanced SQL skills : joins, group functions, analytical functions, subqueries.<br/><br/>- AWS services : CloudWatch, EventBridge, QuickSight, Batch Jobs, Lambda, S3, Redshift, Glue.<br/><br/>- Proficiency in writing test automation scripts for data pipelines.<br/><br/><b>Testing Expertise : </b><br/><br/>- Strong background in Data Migration Testing : <br/><br/>a.

Source-to-target validation.<br/><br/>b.

Record count verification.<br/><br/>c.

Data integrity and validation.<br/><br/>d.

Transformation logic and job run verification.<br/><br/>- Experience in system integration and functional testing across sprints/iterations.<br/><br/>- Able to create, review, and execute detailed test cases based on business and technical requirements.<br/><br/><b>Additional Skills : </b><br/><br/>- Requirement analysis and work effort estimation.<br/><br/>- Quality management : defect identification, root cause analysis, corrective measures.<br/><br/>- Strong analytical, problem-solving, and communication skills to collaborate effectively.<br/><br/><b>Nice to Have :</b><br/><br/>- Experience automating data testing using AI/ML tools.<br/><br/>- CI/CD pipeline integration for test automation.<br/><br/><b>Benefits :</b><br/><br/>- Health Insurance : 30 Lakh for employee, spouse, two dependent children, and two parents/in-laws.<br/><br/>- Accident & Disability : 50 Lakh for employee.<br/><br/>- Free doctor consultations.<br/><br/>- 12% of basic salary contributed to PF.<br/><br/>- 11 National Holidays and 15 PTO days.</p><br/></p> (ref:hirist.tech)