Description

You will validate data extraction, transformation, and load processes across structured and semi-structured data repositories.

Validate daily and initial load functionality across relational and multidimensional data stores. Create comprehensive test plans that evaluate requirement testability and support business solutions. Execute data validation, regression, and end-to-end testing for enterprise-level data warehouse applications. Analyze data modeling and design principles for data marts and data warehouses. Own the testing of data pipelines involving complex extraction and transformation logic.

Responsibilities

• Execute end-to-end testing for enterprise data warehouse applications.
• Validate daily and initial load functionality across relational and multidimensional stores.
• Create test plans evaluating requirement testability and business solutions.
• Analyze data modeling principles for data marts and warehouses.
• Test data pipelines with complex extraction and transformation logic.

Required Skills

• 5+ years of Software Quality Assurance experience on enterprise applications.
• Expertise in writing complex SQL queries for data validation.
• Hands-on experience with Informatica PowerCenter and BDM.
• Proficiency with Snowflake and AWS S3.
• Experience testing PostgreSQL, SQL databases, and Hadoop Data Lakes.
• Strong understanding of ETL concepts and Data Warehouse architectures.
• Experience with Python, Querysurge, and MongoDB.
• Ability to work independently with minimal supervision.

Preferred Skills

• Experience validating Informatica MDM.
• Knowledge of the Insurance domain.

Key Skills

Education

Any Gradute