ETL Tester

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).