Data Warehouse Testing

Relevant Experience

5-8 / 8-10 / 10+

Detailed JD

Must have skills - 2 skills which are non-negotiable

ETL, SQL, Python, Spark

Desirable skills - 1 skill which is nice to have

Big Data Tech Stacks

Desired experience range

5-8 years

Responsibilities and JD in brief along with additional criteria to be considered (if any):

Hands-on experience in ETL Testing, Data Warehouse Testing, and Data Migration Testing.

Robust expertise in SparkSQL and database validation across Oracle, SQL Server, PostgreSQL, Snowflake, AWS Redshift, or BigQuery.

Validate source-to-target mappings, transformation rules, data lineage, and business logic as per mapping documents.

Experience in Python-based ETL test automation.

Perform data reconciliation, completeness checks, referential integrity, duplicate detection, and data quality validations.

Experience in ETL tools such as Informatica, Ab Initio, ODI, SSIS, DataStage, Azure Data Factory, or Databricks.

Strong understanding of Data Warehousing concepts including Facts, Dimensions, Star Schema,



and SCD validations.

Experience designing and implementing Spark-based Data Validation frameworks to validate large-scale financial data across batch and ETL pipelines, ensuring data quality, completeness, accuracy, and consistency throughout the project lifecycle.

Experience developing automated data quality controls and validation test suites using Apache Spark, including reconciliation, schema validation, data profiling, and exception handling for high-volume financial datasets

Experience validating cloud-based data platforms on AWS, Azure, Databricks, Snowflake, or GCP.

Hands-on experience with batch job validation, workflow monitoring, and scheduling tools such as Autosys, Control-M, or Airflow.

Develop automation solutions using Python/Shell scripting for ETL and data validation activities.

Implement test strategies, prepare and execute test cases, analyze results, and coordinate defect resolution to

📌 Data Warehouse Testing (Bengaluru)
🏢 Dananda Talents
📍 Bengaluru