Data Analyst

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 of translate business needs into detailed functional and technical specifications for informatica Power Center 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 Power Center 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 Power Center workflows.
• Create comprehensive IDCs (Incoming Data Collection) for cloud ingestion, outline data sources, ingestion frequency, file formats, orchestration and Azure target layers.