Data Warehouse Testing

About the Role

As a Data Warehouse Testing professional at Infosys, you will be responsible for leading end-to-end data warehouse testing initiatives across multiple projects, ensuring high data quality and integrity. This involves designing, planning, and executing test strategies and test plans for data warehouse and ETL components based on business and technical requirements.

Key Responsibilities

• Design and execute test strategies and test plans for data warehouse and ETL components based on business and technical requirements.
• Validate data mapping, data transformations, aggregations, and data movement from source to staging, DWH, and downstream systems.
• Develop and maintain comprehensive test cases, test scenarios, and test data sets for DWT and ETL testing.
• Perform functional, regression, system integration, and user acceptance support testing for data warehouse solutions.
• Analyze complex SQL queries and datasets to identify data discrepancies, defects, and root causes.
• Collaborate with ETL developers, data modelers, and business analysts to clarify requirements and resolve defects efficiently.
• Establish and enforce quality standards, best practices, and processes for data testing within the team.

Skills & Qualifications

• Test Data Management
• Cloud Testing
• Bigdata
• PL/SQL
• Data Warehouse Testing
• IBM Optim
• Python
• ETL
• Package testing
• AWS Testing
• Delphix
• MDM
• Bachelor's degree in Computer Science, Information Technology, or a related field
• Knowledge of data warehousing concepts and ETL processes
• Experience with Python programming language
• Familiarity with AWS and cloud testing

What You'll Learn

In this role, you will have the opportunity to learn about data warehousing concepts, ETL processes, and cloud testing. You will also gain experience with Python programming language and develop skills in test data management, data quality analysis, and data transformation.

Resume Tip

When applying for this role, make sure to highlight your experience with Python programming language, data warehousing concepts, and ETL processes. Also, include any relevant certifications or training programs you have completed in data testing, data quality analysis, or cloud testing.