Data Analyst (Hybrid - 2 days in office/week)
Location: Toronto, Ontario, Canada
Salary: CA$45.00 - CA$50.00 per hour
Posted 2 weeks ago. Be among the first 25 applicants.
Experience
8-10 years in finance and data analysis roles.
Responsibilities
- Document data dictionaries, metadata, requirements, and mappings for banking domain.
- Apply data quality and data governance principles, including metadata lineage and security standards across cloud and on‑prem platforms.
- Translate business needs into detailed functional and technical specifications for Informatica PowerCenter mappings, workflows, and transformations.
- Validate ETL loads, troubleshoot data discrepancies, and collaborate with technical teams to resolve issues.
- Support development, testing, and implementation of Informatica PowerCenter jobs, ensuring alignment with business rules and data governance standards.
- Perform end‑to‑end data analysis, including source‑to‑target mapping, data profiling, and gap identification using Informatica and SQL.
- Understand how data is structured, connected, governed, and used across data products.
- Leverage data models, product lifecycle knowledge, and stakeholder management experience.
- Ingest and transform large datasets using Databricks (PySpark, SQL) and Informatica PowerCenter workflows.
- Create comprehensive Incoming Data Collections (IDCs) for cloud ingestion, outlining data sources, ingestion frequency, file formats, orchestration, and Azure target layers.
Qualifications
- Strong documentation skills (data dictionaries, metadata, requirements, mappings).
- Experience with data quality, data governance, lineage, and security standards.
- Proficiency in Informatica PowerCenter and SQL for mappings, workflows, and transformations.
- Knowledge of cloud (Azure) and on‑prem data platforms.
- Experience with Databricks (PySpark, SQL) for large data ingestion.
- Excellent problem‑solving skills and ability to work cross‑functionally.
Seniority & Employment
- Seniority level: Mid‑Senior level
- Employment type: Full‑time
- Job function: Information Technology
- Industry: IT Services and IT Consulting
Referrals increase your chances of interviewing at Astra‑North Infoteck Inc.
#J-18808-Ljbffr
Data Analyst employer: Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!
Astra-North Infoteck Inc. is an exceptional employer located in the vibrant city of Toronto, offering a dynamic work culture that fosters innovation and collaboration. Employees benefit from comprehensive growth opportunities, including mentorship programs and access to cutting-edge technology, all while working in a supportive environment that values diversity and creativity. Join us to be part of a forward-thinking team that is shaping the future of cloud-based solutions and AI.
Contact Details:
Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision! Recruitment Team
