Datastage / ETL / DWH / Data Tester - Tester
We are looking for an experienced Datastage / ETL / DWH / Data Tester to join our data and analytics team. The ideal candidate will be responsible for validating end‑to‑end data pipelines, ensuring data accuracy, completeness, and consistency across enterprise data warehouses and reporting systems.Key ResponsibilitiesDesign, develop, and execute ETL and Data Warehouse test strategies for complex data integration projectsValidate IBM Datastage ETL jobs, including source-to-target data mapping, transformations, aggregations, and business rulesPerform data quality, data reconciliation, and data integrity testing across source systems, staging, and target DWH layersCreate and execute SQL queries to validate large data volumes across relational databasesValidate data loaded into Data Warehouses, Data Marts, and downstream BI/reporting systemsPerform system, integration, regression, and UAT support testing for data-driven applicationsAnalyze data discrepancies, identify root causes, and work closely with ETL developers, data engineers, and business analysts to resolve issuesDevelop and maintain test plans, test cases, test data, and defect reportsParticipate in requirement reviews and provide testing estimates and risk assessmentsEnsure adherence to data governance, control, and compliance standardsRequired Skills & QualificationsStrong experience in ETL / DWH / Data TestingHands-on experience with IBM DatastageStrong SQL skills (Oracle, SQL Server, DB2, Teradata, Snowflake, etc.)Solid understanding of Data Warehouse concepts (facts, dimensions, star/snowflake schemas)Experience with source-to-target mapping validationKnowledge of data validation techniques (reconciliation, balancing, duplicate checks, null checks)Familiarity with batch processing, data loads, and schedulingExperience working in Agile or Waterfall environmentsStrong analytical, problem-solving, and communication skillsNice to HaveExperience with BI tools (Tableau, Power BI, Cognos, Business Objects, etc.)Exposure to big data or cloud platforms (Azure, AWS, GCP)Knowledge of automation tools used in data testingExperience in banking, financial services, healthcare, or retail domainsa.