ETL Automation QA Professional @ Infobeans

• We are seeking a meticulous ETL QA Tester with strong Advanced SQL skills and experience in ETL testing to ensure data integrity, accuracy, and completeness throughout our data transformation processes.
• This role demands flexibility in working hours to facilitate effective communication with developers and project teams across various time zones.
• Key Responsibilities:
• Design, develop, and execute ETL test cases to validate data extraction, transformation, and loading processes.
• Write and execute complex SQL queries to perform data validation and back-end testing. Identify, report, and track defects systematically.
• Participate in project meetings and be available for discussions in US EST working hours as needed
• Clarify requirements when necessary and ensure comprehensive coverage of all requirements in the testing process.

Required Skills & Qualifications:

• Experience: 6+ years
• Must-have: Strong SQL skills with hands-on experience in writing and optimizing complex queries. Experience in ETL Testing: Understanding of data extraction, transformation, and loading (ETL) processes.

Python & Pytest

UI Automation (Playwright) + API Automation (Rest Assured)

• Knowledge of Agile Methodologies and Defect Tracking Tools: Familiarity with Agile development processes and proficiency in using defect tracking tools like JIRA.
• Data Validation & Reconciliation: Ability to compare large datasets between sources and targets.
• Experience with SQL DBMS Tools: Knowledge of database management systems such as Oracle, Denodo, Azure Databricks, SQL Server.
• Familiarity with data warehouses and data lake is required.
• Strong analytical and problem-solving skills with attention to detail.
• Excellent communication skills with the ability to work in a collaborative and fast-paced environment.
• Flexible working hours to support discussions with cross-functional teams in different time zones.