13 Nov
|
EdgeVerve Systems
|
India
13 Nov
EdgeVerve Systems
India
Job Description
Role Overview We are looking for an experienced ETL Testing Engineer with 4–6 years of hands-on experience in validating Data Warehouse and ETL solutions. The ideal candidate should possess strong expertise in ETL testing, SQL, data validation, and data quality assurance across large-scale enterprise data platforms.
Key Responsibilities
• Analyze business requirements, source-to-target mapping documents, and technical specifications.
• Design, develop, and execute comprehensive ETL test cases, test plans, and test scenarios.
• Validate data extraction, transformation, and loading processes across multiple source systems.
• Perform data reconciliation and data quality checks between source and target systems.
• Write complex SQL queries for database testing and data validation.
• Verify data integrity, completeness, consistency, and accuracy throughout the ETL lifecycle.
• Validate data warehouse and data mart implementations.
• Identify, log, track, and retest defects using defect management tools.
• Collaborate with ETL developers, business analysts, data engineers, and stakeholders to resolve data issues.
• Participate in release validation, regression testing, and production support activities.
• Prepare test reports and communicate testing status to project stakeholders. Required Skills
• 4–6 years of experience in ETL/Data Warehouse testing.
• Strong knowledge of ETL concepts and Data Warehousing methodologies.
• Proficiency in SQL with experience writing complex joins, subqueries, aggregations, and performance validation queries.
• Experience testing ETL tools such as:
• Informatica PowerCenter
• Talend
• Azure Data Factory (ADF)
• SSIS
• Datastage
• Solid knowledge of database platforms:
• SQL Server
• Oracle
• PostgreSQL
• Snowflake
• Azure SQL
• Experience validating large datasets and performing data reconciliation.
• Expertise in data quality, data profiling, and data transformation validation.
• Familiarity with Agile/Scrum methodologies. Experience with defect tracking tools such as JIRA or Azure DevOps.
📌 Test Analyst (India)
🏢 EdgeVerve Systems
📍 India