ETL Tester

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

Responsibilities

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

Required Skills

• 5+ years of Software Quality Assurance experience on enterprise-level 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 Mongo DB.
• Ability to work independently with minimal supervision.

Preferred Skills

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