Description

You will validate data flows and testing strategies for ETL, data warehousing, and Business Intelligence systems.

Responsibilities

• Test data warehouse components including stored procedures, SSIS packages, slowly changing dimension tables, and Change Data Capture.
• Validate DataMart, ODS, data models, and SSRS reports for Business Intelligence testing.
• Write advanced SQL queries to verify data integrity across ETL and BI workflows.
• Identify automation candidates and develop test automation strategies.

Required Skills

• 3+ years of experience in ETL testing and data warehousing.
• Proficiency in writing advanced SQL queries for Oracle, SQL Server, NoSQL, RDBMS, or Big Data environments.
• Hands-on experience with Star Schema, ODS, multi-dimensional models, and slowly changing dimensions.
• Knowledge of ETL frameworks, Change Data Capture, DataMart, and data models.
• Familiarity with SQL-on-Hadoop technologies such as Hive, Impala, Spark SQL, or Presto.
• Experience working within Agile frameworks like Scrum or Kanban.
• Working knowledge of test management tools including JIRA and qTest or ALM.
• Bachelor's degree.

Key Skills

Education

Bachelor's degree