IQE DWT BLR 290826 - Data Warehouse Testing - (WALK-IN, BLR)

IQE_DWT_BLR_290826 - Data Warehouse Testing (WALK-IN, BLR)

This contract opportunity is for experienced Data Warehouse Testers to join a hybrid team in Bengaluru, Karnataka, India. The role requires hands-on expertise in ETL and Data Warehouse testing, with a focus on automation, data quality, and validation across multiple platforms and technologies. Candidates will participate in a face-to-face walk-in interview on 29th August 2026 (Saturday) in Bangalore. The position offers the chance to work with cutting-edge data technologies and collaborate with cross-functional teams to ensure data integrity and compliance.

Key Responsibilities

• Perform ETL Testing, Data Warehouse Testing, and Data Migration Testing.
• Validate source-to-target mappings, transformation rules, data lineage, and business logic as per mapping documents.
• Conduct data reconciliation, completeness checks, referential integrity, duplicate detection, and data quality validations.
• Develop and implement Spark-based Data Validation frameworks for large-scale financial data across batch and ETL pipelines.
• Design and execute automated data quality controls and validation test suites using Apache Spark, including reconciliation, schema validation, data profiling, and exception handling.
• Validate cloud-based data platforms on AWS, Azure, Databricks, Snowflake, or GCP.
• Perform batch job validation, workflow monitoring, and scheduling using 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 ensure data quality.
• Collaborate with business, development, and data engineering teams to ensure accurate and reliable data delivery.
• Maintain detailed documentation of test scenarios, SQL validations, automation assets, and testing processes.

Requirements

• Must-Have Skills: ETL Testing, SQL, Python, Spark
• Desirable Skills: Big Data Tech Stacks (Hadoop, Hive, Kafka), BI Reporting validation (Power BI, Tableau, Qlik, MicroStrategy), AI-enabled Data Quality and Data Governance solutions
• Strong expertise in SparkSQL and database validation across Oracle, SQL Server, PostgreSQL, Snowflake, AWS Redshift, or BigQuery
• Experience in ETL tools such as Informatica, Ab Initio, ODI, SSIS, DataStage, Azure Data Factory, or Databricks
• Understanding of Data Warehousing concepts including Facts, Dimensions, Star Schema, and SCD validations
• Experience developing automated data quality controls and validation test suites using Apache Spark
• Experience validating cloud-based data platforms
• Hands-on experience with batch job validation and workflow monitoring tools
• Proficiency in Python/Shell scripting for automation
• Bachelor's degree (BTech or foreign equivalent) from an accredited institution
• At least 4 years of experience in Data/ETL Testing
• Experience working in Agile delivery environments
• Excellent communication and collaboration skills
• Strong analytical and problem-solving skills
• Ability to understand complex business transformations and convert them into comprehensive test scenarios
• Passion for ensuring data accuracy, integrity, and compliance
• Proactive approach to identifying data defects and root cause analysis
• Ability to collaborate effectively with Data Engineers, Architects, Business Analysts, and Product Owners
• Domain experience in Banking, Capital Markets, Wealth Management, or Mortgage is a plus

Work Arrangements

• Location: Bengaluru, Karnataka, India
• Type: Contract
• Interview: Face-to-face walk-in on 29th August 2026 (Saturday) in Bangalore
• Work Model: Hybrid (onsite presence required for interview and as per company policy)
• Experience Levels: 5-8 years, 8-10 years, 10+ years