Data Warehouse Test Engineer

Job Description - Hands-on experience in ETL, Data Warehouse, and Data Migration Testing with strong SparkSQL and database validation skills. - Validate source-to-target mappings, transformations, data lineage, business rules, reconciliation, completeness, and data quality across diverse databases and cloud platforms. - Strong expertise in Python/Shell-based ETL test automation and Spark-based data validation frameworks for large-scale financial datasets. - Experience with ETL technologies including Informatica, Ab Initio, ODI, SSIS, DataStage, Azure Data Factory, and Databricks. - Strong understanding of Data Warehousing concepts including Facts, Dimensions, Star Schema, and SCD validations. - Develop automated validation suites covering schema validation, profiling, duplicates, referential integrity, exception handling, and data reconciliation. - Experience validating batch workflows, scheduling, and monitoring using Autosys, Control-M, or Airflow across AWS, Azure, Databricks, Snowflake, or GCP. - Design test strategies, execute test cases, analyze defects, maintain testing documentation, and collaborate with business, development, and data engineering teams to ensure reliable data delivery.