Sr ETL Test Engineer

Job Summary

Education : B.E / B.TECH / M.C.A or Equivalent.

Job Location: Gurugram

Experience: 5+ Years

No. of Resources Required: 6

Responsibilities

• Strong experience in ETL Testing, Data Warehouse Testing, Data Validation and Data Quality Assurance.
• Hands-on experience with SQL, complex queries, joins, stored procedures, views, triggers and database testing.
• Experience in validating source-to-target mappings, transformation rules and business logic implementations.
• Strong knowledge of Data Warehouse concepts including Star Schema, Snowflake Schema, Fact Tables and Dimension Tables.
• Experience working with ETL tools such as Informatica, Talend, SSIS, DataStage, Azure Data Factory or equivalent technologies.
• Hands-on experience in validating large-scale data migration projects and enterprise data integration initiatives.
• Experience in Data Reconciliation, Data Verification and Data Consistency Testing across multiple systems.
• Ability to create ETL test plans, test strategies, test cases, test scenarios and test execution reports.
• Experience in validating data extraction, transformation and loading processes for enterprise applications.
• Strong understanding of Data Profiling, Data Cleansing and Data Governance principles.
• Experience in validating batch processing systems, scheduled jobs and automated data pipelines.
• Knowledge of Business Intelligence reporting validation and dashboard data verification.
• Experience in testing data integration between ERP, CRM, Finance, Retail and Enterprise applications.
• Ability to identify data anomalies, transformation issues and root causes of data quality defects.
• Experience with defect management tools such as JIRA, Azure DevOps or equivalent platforms.
• Strong understanding of Software Testing Life Cycle (STLC), Software Development Life Cycle (SDLC) and Agile methodologies.
• Experience in validating data accuracy, completeness, integrity and consistency across multiple environments.
• Hands-on experience with performance testing of ETL jobs and optimization of large-volume data processing.
• Knowledge of cloud-based data platforms such as AWS, Azure, Google Cloud Platform (GCP), Snowflake or Databricks.
• Experience in validating REST APIs, data services and integration interfaces supporting ETL workflows.
• Ability to analyze business requirements, technical specifications and data mapping documents.
• Experience in enterprise reporting validation using Power BI, Tableau, QlikView or similar analytics platforms.
• Strong analytical, troubleshooting and problem-solving skills with attention to detail.
• Excellent communication skills and ability to work closely with Data Engineers, Business Analysts, Architects and Stakeholders.
• Ability to independently manage ETL testing activities and deliver high-quality data validation solutions aligned with ELAARSONs Data Analytics and Quality Engineering services.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.