Job Title or Location

QA Lead - Informatica MDM & Data Warehouse Testing

J&M Group, Inc - 212 Jobs
Mississauga, ON
Posted today
Job Details:
Full-time
Experienced

We are seeking an experienced Data Warehouse BI Test Analyst with over 10 years of experience in Software Quality Assurance for enterprise-level applications, focusing on ETL, data warehouse, and MDM (Informatica) testing. The ideal candidate will be highly skilled in SQL, data validation, test automation, and working with large datasets across cloud and traditional environments. Key Responsibilities:
  • Perform end-to-end testing of data warehouses and MDM platforms using Informatica PowerCenter & BDM.

  • Write and execute complex SQL/PLSQL queries for data validation and transformation testing.

  • Conduct ETL testing, data profiling, auditing, balancing, and reconciliation.

  • Develop and manage test plans, test cases, RTMs, and defect life cycles.

  • Utilize QA automation tools (preferably Python) for test scripting and execution.

  • Work with tools like JIRA, ALM, and Snowflake, and manage data on AWS (S3), PostgreSQL, Hadoop, and MongoDB.

  • Understand data governance principles, data modeling, and entity-relationship diagrams.

  • Collaborate with cross-functional teams and manage project deliverables in dynamic environments.

Essential Skills:
  • Strong expertise in Data Warehouse and MDM Testing (Informatica)

  • Proficiency in SQL, ETL Testing, and data analysis

  • Experience with Snowflake, AWS (S3), PostgreSQL, Hadoop Data Lake, and MongoDB

  • Hands-on with Python for test automation

  • Familiarity with test planning, defect tracking, and agile environments

  • Strong analytical, problem-solving, and communication skills

Share This Job: