Software Tester

QA/ETL Tester

USA Based ecommerce company

need immediate joiner or 30 days or less

Remote – India

26-30 lahks per annum

6 month contract to hire full time w client

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:
• Source-to-target validation
• Record count verification
• Data integrity and validation
• 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