Data Analyst
Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!
Job Description
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