64 Adf Developer jobs in Canada

Skills Required: • IBM Infosphere DataStage• Unix Shell Scripting and text processing tools• MySQLJob Description: Key Responsibilities • Develop and implement ETL solutions• Design and build DataStage jobs to extract, transform, and load data from various sources into target data warehouses or data marts.Data Warehousing and Data Integration• Focus on data warehousing and data integration projects, ensuring data consistency and availability for business intelligence and analytics.Performance Tuning• Optimize the performance of ETL processes to meet business requirements and ensure efficient data processing.SDLC and Agile Methodologies• Participate in the software development lifecycle (SDLC) and potentially work within agile frameworks.Collaboration• Work with business analysts, data architects, and other developers to understand requirements and deliver high-quality solutions.Production Support• May be involved in providing support for existing DataStage jobs in production, including troubleshooting and resolving issues.Skills and Experience • IBM InfoSphere DataStage• Strong proficiency in using DataStage for ETL development.• SQL and Databases• Solid understanding of SQL and experience with relational databases like Oracle.• ETL Concepts• Deep understanding of ETL concepts, data warehousing principles, and data integration best practices.• Unix Linux• Experience with Unix Linux operating systems, including scripting (e.g., Unix Shell Scripting).• Data Modelling• Familiarity with data modelling concepts and techniques.• Agile and DevOps• Experience working in agile environments and potentially with DevOps practices

Job Description

Job Description

Specific Duties

• -Reviewing, designing, developing ETL jobs to ingest data into Data Lake, load data to data marts;
• -extract data to integrate with various business applications.
• -Parse unstructured data, semi structured data such XML etc.
• -Design and develop efficient Mapping and workflows to load data to Data Marts
• -Map XML DTD schema in Python (customized table definitions)
• -Write efficient queries and reports in Hive or Impala to extract data on ad hoc basis for data analysis.
• -Identify the performance bottlenecks in ETL Jobs and tune their performance by enhancing or redesigning them.
• -Responsible for performance tuning of ETL mappings and queries.
• -import tables and all necessary lookup tables to facilitate the ETL process required to process daily XML files in addition to processing the very large (multi-terabytes) historical XML data files

•  Skills Required: • Digital: Mongo DB• IBM Infosphere DataStage• Unix Administration•  Job Description:• Key Responsibilities:o Develop and implement ETL solutionso Design and build DataStage jobs to extract, transform, and load data from various sources into target data warehouses or data marts.o Data Warehousing and Data Integration: Focus on data warehousing and data integration projects, ensuring data consistency and availability for business intelligence and analytics.o Performance Tuning: Optimize the performance of ETL processes to meet business requirements and ensure efficient data processing.o SDLC and Agile Methodologies: Participate in the software development lifecycle (SDLC) and potentially work within agile frameworks.o Collaboration: Work with business analysts, data architects, and other developers to understand requirements and deliver high-quality solutions.o Production Support: May be involved in providing support for existing DataStage jobs in production, including troubleshooting and resolving issues.• Skills and Experience:o IBM Infosphere DataStage: Strong proficiency in using DataStage for ETL development.o SQL and Databases: Solid understanding of SQL and experience with relational databases like Oracle.o ETL Concepts: Deep understanding of ETL concepts, data warehousing principles, and data integration best practices.o UNIX Linux: Experience with UNIX Linux operating systems, including scripting (e.g., Unix Shell Scripting).o Data Modelling: Familiarity with data modelling concepts and techniques.o Agile and DevOps: Experience working in agile environments and potentially with DevOps practices.•  Additional Technical Skills:• 8+ years of strong design, development experience using C#, .NET Core, Web API, Angular/React, ASP.NET, MVC• 3+ years of strong development experience using SQL Server/Oracle/Sybase, complex procedures and SSIS• Resourcing experience in financial domain• Experience working with DevOps, source code management tools like Git, Sun, Jira, CUD, Jenkins• Experience working with Agile/Scrum/RAD development methodology• Nice to have container-based technologies like Docker, Kubernetes, OpenShift, cloud platform and familiar with big-data and cloud-based technologies• Nice to have experience in setting application in Linux/Windows, IIS/Nginx• Nice to have working experience with APAC Regulatory Reporting• Strong technical analytical skills to solve complex problems• Strategic thinker with excellent interpersonal skills to work across functions and businesses•  Exp Required: 8 -10

**As an AVP, SQL & ETL Developer, you will play a critical role in the design, development, optimization, and maintenance of robust and scalable data solutions. This position requires deep expertise in SQL, database systems, and Extract, Transform, Load (ETL) processes, coupled with an understanding of data warehousing principles.** **Crucially, you must possess strong domain knowledge in banking, specifically related to liquidity management, stress modeling, and markets data, to effectively translate complex business requirements into data solutions.** **Based in Canada, this role will contribute to key data initiatives, ensuring data quality, availability, and integrity to support critical business operations and analytical needs. You will be expected to lead specific projects, mentor junior developers, and engage with stakeholders to deliver high-quality data solutions within the financial domain.**
**Key Responsibilities**
**SQL Development & Optimization:**
**Design, develop, and optimize complex SQL queries, stored procedures, functions, and views for data extraction, transformation, and loading.**
**Analyze and tune database performance (e.g., query optimization, indexing strategies) to ensure efficient data processing and retrieval.**
**Implement data integrity checks and validation rules within SQL scripts.**
**Develop and maintain database schemas and data models in collaboration with data architects.**
**ETL Solution Design & Development:**
**Lead the design, development, and implementation of robust, scalable, and automated ETL processes using various ETL tools (e.g., Informatica PowerCenter, SSIS, DataStage, Talend, or cloud-native ETL services).**
**Develop and maintain data pipelines for ingesting data from diverse sources (e.g., relational databases, flat files, APIs, cloud storage) into target data warehouses or data marts.**
**Implement error handling, logging, and monitoring mechanisms within ETL workflows.**
**Ensure data quality and consistency throughout the ETL process.**
**Data Warehousing & Data Management:**
**Apply strong understanding of data warehousing concepts (e.g., Kimball, Inmon methodologies), dimensional modeling, and OLAP principles.**
**Work closely with data architects and business analysts to translate business requirements into technical data solutions.**
**Manage and maintain data dictionaries and data lineage documentation.**
**Project Leadership & Mentorship:**
**Lead small to medium-sized data development projects from inception to completion, including planning, execution, and deployment.**
**Provide technical guidance and mentorship to junior developers on SQL, ETL best practices, and troubleshooting.**
**Participate in code reviews to ensure adherence to development standards and quality.**
**Troubleshooting & Support:**
**Diagnose and resolve complex data-related issues, including data discrepancies, performance bottlenecks, and ETL job failures.**
**Provide production support for data solutions, ensuring high availability and reliability.**
**Collaboration & Stakeholder Engagement:**
**Collaborate effectively with cross-functional teams including business users, data analysts, data scientists, architects, and IT operations.**
**Translate business requirements into technical specifications for data solutions.**
**Communicate project status, challenges, and solutions clearly to technical and non-technical stakeholders**
**Education:**
**Bachelor's degree/University degree or equivalent experience**
**This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.**
**5+ years of progressive experience** **in SQL development and ETL design/implementation.**
**Must have significant experience in the banking or financial services domain.**
**Demonstrated strong domain knowledge in one or more of the following areas: Liquidity Management, Stress Modeling, and Markets Data (e.g., trading data, market risk data).**
**Proven experience in leading data projects and/or mentoring junior team members.**
**Experience working with large datasets and complex enterprise data architectures.**
**Technical Proficiency:**
**Expert-level proficiency in SQL** **(e.g., T-SQL, PL/SQL, PostgreSQL, MySQL) with strong experience in query optimization, stored procedures, functions, and triggers.**
**Extensive experience with at least one major ETL tool** **such as Informatica PowerCenter, Microsoft SSIS, IBM DataStage, Talend, or equivalent cloud-native ETL services (e.g., AWS Glue, Azure Data Factory, GCP Dataflow/Cloud Data Fusion).**
**Strong understanding of** **data warehousing concepts** **and** **dimensional modeling** **.**
**Experience with BigData technologies is good to have**
**Experience with database management systems (e.g., SQL Server, Oracle, DB2, PostgreSQL).**
**Familiarity with scripting languages (e.g., Python, PowerShell) for automation is a strong plus.**
**Knowledge of version control systems (e.g., Git) and SDLC methodologies (Agile/Scrum).**
**Experience with job scheduling tools (e.g., Autosys, Control-M) is an asset.**
**Familiarity with cloud platforms (AWS, Azure, GCP) and their data services is a plus.**
**Skills & Competencies:**
**Strong analytical and problem-solving skills, with meticulous attention to detail.**
**Excellent communication and interpersonal skills, capable of interacting effectively with both technical and non-technical stakeholders.**
**Ability to translate complex banking domain requirements into effective data solutions.**
**Ability to work independently, prioritize tasks, and manage multiple projects concurrently in a fast-paced environment.**
**Proactive attitude with a strong commitment to quality and continuous improvement.**
---
**Job Family Group:**
Technology
---
**Job Family:**
Applications Development
---
**Time Type:**
Full time
---
**Primary Location Full Time Salary Range:**
$94,300.00 - $141,500.00
---
**Most Relevant Skills**
Please see the requirements listed above.
---
**Other Relevant Skills**
For complementary skills, please see above and/or contact the recruiter.
---
_Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law._
_If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review_ _Accessibility at Citi ( _._
_View Citi's_ _EEO Policy Statement ( _and the_ _Know Your Rights ( _poster._
Citi is an equal opportunity and affirmative action employer.
Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.

Job Description

Job Description

Durée du contrat prévue de 3 à 5 ans.
Date d'entrée en fonction prévue entre Q1 et Q3 2025.
Rôle hybride.

Les heures de travail sont normalement comprises entre 8 h et 17 h, du lundi au vendredi (35h par semaine), mais peuvent être étendues lors de certains projets.

1. Optimiser les traitements d’extraction existants et futurs,

2. Extraire les données nécessaires pour répondre aux nouveaux besoins d’affaires,

3. Migrer les données à travers les différentes couches en respectant les meilleures pratiques actuelles,

4. Documenter les extractions effectuées.

Exigences

• Minimum de 5 ans d’expérience professionnelle dans les technologies de l’information, dont 4 ans dans un rôle avec des responsabilités similaires.
• Détenir un diplôme universitaire de premier cycle (BAC) en technologie de l’information ou en administration des affaires ou son équivalent.
• Connaissance de la base de données MS-SQL et Oracle, de Power BI et Power Apps, Automate et Apps Portail
• Français (écrit et parlé) de niveau professionnel.
• Capacité de passer une évaluation des antécédents judiciaires.
• Capacité de se déplacer dans la région de la ville de Québec.

Job Description

Job Description

RQ09632 - Sr. Software Developer - ETL
Downtown, Toronto

Hybrid - 3 days a week in office

Contract (6 months)

Security Level: CRJMC + Credit Check (must get before starting date)

Must-haves:

• 5+ years of proven working experience in an ETL role; strong understanding of ETL principles, including data extraction, transformation, and loading processes.
• Strong SQL skills and experience working with Azure SQL Databases and Dataverse .
• Knowledge of Microsoft Dynamics 365 Customer Engagement (CE).

Nice-to-Have:

• Azure cloud certifications (e.g. Azure fundamentals, Azure Data Engineer associate, Azure Database Administrator associate)
• Public Sector experience

Job Description

Job Description

RQ09525 - Sr. Software Developer - ETL

Downtown, Toronto

Hybrid - 3 days onsite and 2 days remote. Starting October 20, resources are expected to come into the office 4 days per week. Starting January 5, resources are expected to come into the office 5 days per week. This is subject to change based on manager's discretion.

Contract (7+ months, possible extension)

Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.

Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.

Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.

Must-Have's:

• Design, build, automate and optimize complex data ETL/ELT processes using PL/SQL and equivalent
• Cloud technologies (Azure, Google, AWS)
• Advanced skills and hands-on experience with Azure SQL Server and Azure Data Factory
• PL/SQL for data extraction, transformation, and loading, initial setup and other ETL experience management and support, such as troubleshooting, performance tuning, failover and recovery
• Working knowledge of issue tracking system JIRA, Azure DevOps
• Public sector experience