ETL Tester

Coforge; Hyderabad; On-site; INR 700,000 - 1,100,000; Full time

Job summary

Coforge is seeking a Quality Assurance Analyst to lead data and ETL testing across AWS and Snowflake environments. You will design tests, validate data pipelines, and ensure reporting accuracy in Power BI, collaborating with developers and analysts.

Ideal candidates have 4–8 years in QA, strong SQL, and experience with DW testing, automation, and agile or CD delivery. The role requires rigorous testing and clear communication to stakeholders.

Qualifications

• Bachelor's degree in CS or related field.
• 4–8 years in QA/testing with ETL and data warehousing.
• Strong SQL skills and data verification capabilities.
• Experience with DW testing and QA processes across SDLC.

Responsibilities

• Conduct end-to-end testing to validate business and technical requirements.
• Design and execute test scripts, including automated tests when applicable.
• Develop and maintain automation for QA processes.
• Test data management, ETL/ELT workflows, and Snowflake pipelines.
• Validate Power BI reports integrated with data fabric and AWS.
• Identify defects, participate in triage, and track QA metrics.
• Collaborate with cross-functional teams to improve quality.

Skills

Analytical thinking

Communication skills

Independent work

Team collaboration

Education

Bachelor's Degree in Computer Science

Tools

Jira

Selenium

JUnit

TestNG

Python

Snowflake

Power BI

AWS

Job description

Quality Assurance Analyst (Data & ETL Testing)

Job Title: Quality Assurance Analyst

Experience: (4 to 8 Years)

Job Responsibilities

• Conduct end-to-end testing on applications and technology, to ensure that business, technical, functional requirements are being met throughout the SDLC.
• Design and execute test scripts based upon test strategy/plans to identify defects prior to production. Tests may be manual or automated or both.
• Construct test scenarios, cases and scripts, ensuring that requirement coverage is adequate and as per business requirements, functional specifications and designs are linked to test artifacts.
• Develop and maintain quality automation code and work towards automating non-test related QA functions.
• Working experience of Data and functionality testing of application hosted on AWS Cloud.
• Working experience of data pipelines and transformations within Microsoft Fabric environments. Also, perform data accuracy, performance and end-to-end testing of Power BI reports integrated with Fabric.
• Validate ETL/ELT workflows, data ingestion mechanisms, and transformation logic within Snowflake data warehouse solutions.
• Evaluate and create test data against expected positive and negative scenarios, identifying deficiencies.
• Create defect for identified issues and participate in the defects triage meeting. Tracks quality assurance metrics such as defect densities and open defect counts.
• Troubleshoot system failures and narrow down root causes independently or with the help of developers or operation engineers.
• Participate in the development and implementation of structured testing concepts, methodologies, and automated testing and support tools.
• Contribute ideas and effort toward continuous improvement and Quality enablement.
• Communicate overall status of testing activities to Leadership and project team members.

Required Qualification

• Bachelor's Degree in Computer Science or related field or equivalent experience.
• Proven experience in software testing and quality assurance with a distinguished track record in testing complex software systems.
• Minimum 3+ years of combined experience in ETL using Informatica, Database and Reports Testing, with extensive working experience in writing and executing complex SQL queries.
• Proficient in all types of testing (Sanity, Functional, Regression, Integration, Load, Stress and Performance) in Data Warehouse environments.
• Strong knowledge and understanding of relational database concepts, data warehousing, ETL process, requirements gathering and/or decision support tools.
• Proven experience with multiple database platforms, including Oracle and SQL, and writing complex SQLs.
• Ability to collaborate with cross-functional teams of Business Owners, Developers, Business Analysts and Quality Assurance professionals.
• Knowledge of quality management tools such as Jira.
• Knowledge of the QA process/SDLC in Waterfall, Continuous Delivery and Agile environments.
• Strong organizational skills: ability to complete multiple tasks under tight and competing schedules and priorities.
• Strong analytical skills including analyzing complex data.
• Excellent written and verbal communication skills (ability to communicate effectively with technical staff, Business Analysts, management, and business team members).
• Work independently (full SDLC) with minimal supervision in a team environment.

Preferred Qualification

• Experience working in an Agile or Continuous Delivery environment.
• Knowledge of Automation Frameworks such as JUnit, TestNG, and Selenium.
• Experience creating automation frameworks using Selenium, Python, etc.
• Good to have experience with IICS (Informatica Intelligent Cloud Service) and IDQ (Informatica Data Quality).