ETL & Power BI Test Automation

Job Description:
  • Experience of testing in an agile lifecycle (Must have).
  • At least 8+ years of experience in ETL, QA, and related domains.
  • Experience of non-functional testing (Good to have).
  • Experience in writing complex SQL queries, ability to determine the types of testing that must be conducted (i.e, data validation, regression, etc.), including evaluating the testability of requirements.
  • Experience in database skills required in data migration testing and test data creation, e.g., SQL Server Management Studio & Oracle Developer.
  • Must have experience in using ETL Tool /Concepts e.g., AWS, Redshift.
  • Must have experience in Microsoft SQL Server 2012, Oracle 9i/10g, AWS Athena, and Redshift.
  • End-to-End Understanding: Ability to understand end-to-end functionality of the application (Must have).
  • SQL Proficiency: Strong proficiency in querying databases and validating the data (Must have).
  • Data Visualization Testing: Experience in testing data visualizations on dashboards, including AWS QuickSight (Must have).
  • Formula Evaluation: Ability to understand and evaluate formulas used in the application, validating the results (Must have).
  • Cloud Knowledge: Familiarity with cloud-based tools and technology stacks, including AWS – Redshift, Athena, and S3 (Must have).
  • Test Automation: Ability to write and automate test cases, and perform data quality (DQ) checks (Good to have).
  • Performance Testing: Experience with performance load testing, stress testing, or scalability testing of analytics systems (Good to have).
Education:

BE OR B.Tech or MCA or M.Tech only

Interview Rounds:

2 Technical rounds

Experience Level:

7 to 10 Years