Job Description

- Hands-on experience in ETL, Data Warehouse, and Data Migration Testing with robust 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.

📌 Data Warehouse Test Engineer (Bengaluru)
🏢 TRIGENT SOFTWARE PRIVATE
📍 Bengaluru