Job Title - ETL Test Lead
Location - Hybrid @ Toronto
Core Skills (Must Have)
- Strong Data Warehousing & EDW concepts
- Fact & Dimension modeling
- Star / Snowflake schemas
- Data marts and reporting layers
- Hands-on EDW testing experience
- Source → Staging → Integration → Presentation layer validation
- Full load vs Incremental / Delta load testing
- SCD validation expertise
- SCD Type 1, Type 2 (history, effective dates, current flag)
- Late Arriving Dimensions, Out-of-sequence data
- Advanced SQL skills
- Complex joins, subqueries, window functions
- Data reconciliation & cross-layer balancing
- Duplicate, null, referential integrity checks
Testing Capabilities
- Data Validation & Reconciliation
- Business rule & transformation logic validation
- Row count, aggregation, threshold & variance checks
- CDC / incremental data testing
- Regression & UAT support
- Defect analysis, triage, and RCA
Salary and Other Compensation:
The annual salary for this position is between $100-115Kdepending on experience and other qualifications of the successful candidate.
This position is also eligible for Cognizant’s discretionary annual incentive program, based on performance and subject to the terms of Cognizant’s applicable plans.
Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:
· Medical/Dental/Vision/Life Insurance
· Paid holidays plus Paid Time Off
· 401(k) plan and contributions
· Long-term/Short-term Disability
· Paid Parental Leave
· Employee Stock Purchase Plan
Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable la
About us
Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, building the bridge between AI investment and enterprise value by building full-stack AI solutions for our clients. Our deep industry, process and engineering expertise enables us to build an organization’s unique context into technology systems that amplify human potential, realize tangible returns and keep global enterprises ahead in a fast-changing world. See how at www.cognizant.com or @cognizant.
Additional employment information
Compensation information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, state or local laws.
If you have a disability that requires reasonable accommodation to search for a job opening or submit an application, please email [email protected] with your request and contact information.
