Job Description

Title: - Data Warehouse Testing - (WALK-IN, BLR)

Relevant Experience: 5-8 / 8-10 / 10+

Detailed JD: Must have skills - 2 skills which are non-negotiable

Location: KRNK | BANGALORE (Hybrid)

Vendor Rate: 7000.00 – 8000.00 /Day

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.
- Strong 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.
- Robust 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 valida

📌 Data Warehouse Testing _ Infosys (Bengaluru)
🏢 Tailored Management
📍 Bengaluru