Data Analyst

Job Description

Location : Toronto

Experience : 8-10 years

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 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.