Etl Test Engineer

Infosys; Pune District, Bengaluru, Hyderabad; On-site; INR 6,000,000 - 8,000,000; Full time

Job summary

Infosys is seeking an experienced ETL Testing Engineer with strong expertise in ETL testing. The role involves collaborating with business analysts and data engineers to understand requirements and developing comprehensive test strategies.

Candidates should possess strong knowledge of ETL tools, proficiency in SQL, and familiarity with data warehousing concepts. Responsibilities include executing test cases, validating data quality, and maintaining clear communication with stakeholders.

Qualifications

• Strong knowledge of ETL tools and processes.
• Proficiency in SQL for creating test queries and validating data.
• Familiarity with data warehousing concepts and architecture.
• Experience with data quality management and testing methodologies.

Responsibilities

• Collaborate with analysts to understand ETL requirements.
• Develop comprehensive ETL test plans.
• Create detailed test scenarios and test cases.
• Validate data extraction and transformation.
• Execute test cases for ETL functionality.
• Evaluate system error handling.
• Perform regression testing.
• Document defects and communicate with stakeholders.
• Possibility of automation testing.

Skills

ETL tools knowledge

SQL proficiency

Data warehousing concepts

Data quality management

Job description

We are looking for an experienced ETL Testing Engineer with strong expertise in ETL testing.

Roles & Responsibilities

1. Requirement Analysis: Collaborate with business analysts and data engineers to understand ETL requirements, data sources, transformation rules, and business rules.
2. Test Planning: Develop comprehensive ETL test plans that outline the testing strategy, scope, objectives, and resources needed for effective testing.
3. Test Case Development: Create detailed test scenarios and test cases that cover various aspects of the ETL process, including data extraction, transformation rules, data loading, error handling, and data quality checks.
4. Data Validation: Validate that data is correctly extracted from various sources, transformed according to business rules, and loaded into data warehouses or databases. This includes performing regular data quality inspections.
5. Execution of Tests: Execute test cases to validate the functionality and accuracy of the ETL processes. This involves running test scripts, monitoring data flows, and verifying that data transformations align with business requirements.
6. Error Handling: Evaluate the ETL system's ability to handle errors and exceptions gracefully. Test how the system responds to unexpected data and transformation failures.
7. Regression Testing: Perform regression testing to ensure that changes or updates to the ETL processes do not introduce new issues or adversely impact existing functionality.
8. Documentation and Reporting: Document defects, report on testing progress, and collaborate with development teams to resolve issues. Maintain clear communication with stakeholders regarding testing outcomes and data quality.
9. Automation Testing: In some roles, ETL Test Engineers may also be responsible for developing and executing automated tests to improve efficiency and coverage.

Skills Required

• Strong knowledge of ETL tools and processes.
• Proficiency in SQL for creating test queries and validating data.
• Familiarity with data warehousing concepts and architecture.
• Experience with data quality management and testing methodologies.

By fulfilling these responsibilities, ETL Test Engineers play a crucial role in maintaining data quality and integrity, which is essential for effective business intelligence and analytics.