Data Analyst

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Toronto; On-site; CAD 85,000 - 115,000; Full time

Job summary

A technology firm in Toronto seeks a data specialist with over 8 years of experience in data governance and quality principles. Responsibilities include supporting the development of ETL processes using Informatica PowerCenter, validating data loads, and performing comprehensive data analysis. Candidates should possess strong documentation skills and be proficient in SQL and Databricks. An understanding of business data structures and stakeholder management is essential. This role is pivotal in ensuring data integrity across platforms.

Responsibilities

• Support development and testing of Informatica PowerCenter jobs.
• Validate ETL loads and troubleshoot discrepancies.
• Perform end-to-end data analysis using Informatica and SQL.

Skills

Data governance principles

Strong documentation skills

Informatica PowerCenter

Data profiling

SQL

Databricks (PySpark)

Stakeholder management

Tools

Informatica

Azure

Job description

Location: Toronto
Experience: 8-10 years

Responsibilities

• 8 years of banking domain, strong documentation skill set data dictionaries, meta data, requirements, mappings.
• 8 years of data quality and data governance principles, meta data, lineage, and security standards across cloud and on prem data platforms.
• 8 years of translate business needs into detailed functional and technical specifications for informatica PowerCenter mapping, workflows and transformations.
• Validate ETL loads, troubleshoot data discrepancies and work with technical teams to resolve issues.
• Support the 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.
• 8 years of business value and understand how data is structured, connected, governed and used across data products.
• 8 years of good understanding of data models, data product life cycle, stakeholder management experience.
• 8 years of support ingestion and transformation of large datasets using Databricks (PySpark, SQL) and Informatica PowerCenter workflows.
• Create comprehensive IDCs (Incoming Data Collection) for cloud ingestion, outline data sources, ingestion frequency, file formats, orchestration and Azure target layers.