ETL Developer
- Toronto, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Experience
- Resource have knowledge in Bank and financial domain (Minimum 10+ years of experience).
- Posting language
- English
- Posted
Original job description
ETL Lead Developer
Toronto, ON
Role: ETL Lead Developer
Role and ResponsibilitiesResource have strong data warehouse technical knowledge.
Resource have knowledge in Bank and financial domain (Minimum 10+ years of experience).
Resource also required knowledge in ETL process and develop the SSIS packages.
Ability to lead the team of developers and mentor as needed.
Ability to understand the requirements and experience in managing complete data warehouse systems.
Please list 5 mandatory “MUST HAVE” skills and experience for this requirement.
Please include skills related to technical as well as domain and non-technical skills and experience as applicable to the position.
ETL data warehouseMS SSIS/SSRSIBM NetezzaMS SQL server/Sybase databaseAWS Redshift, AWS Glue
Please list 5 “NICE TO HAVE” but not mandatory skills and experience for this requirement
AWS Cloud services (Spark, Redshift and EMR)Knowledge in lending systems and functional knowledge on the same
Knowledge in MDM systems for customer demographics process
Knowledge in retail and commercial deposit system process (Core banking with Canadian banking domain)
Strong solution Knowledge in AWS Cloud and hands on experience with ETL process (like Kafka message processing, batch interface data injection and other business layer process)
More about this job
Responsibilities
Lead ETL development and guide a team of developers, including mentoring as needed. Understand requirements and manage data warehouse systems, including developing SSIS packages and supporting ETL processes.
Requirements
Requires strong data warehousing and ETL expertise, including hands-on SSIS package development, and at least 10 years of experience in the banking and financial domain. Candidates should be able to lead and mentor developers, understand requirements, and manage complete data warehouse systems; listed technologies include SSRS, Netezza, SQL Server, Sybase, Redshift, and Glue.
Skills
- ETL
- Data Warehousing
- Microsoft SSIS
- Microsoft SSRS
- IBM Netezza
- Microsoft SQL Server
- Sybase
- AWS Redshift
- AWS Glue
- AWS Cloud Services
- Spark
- EMR
- Kafka
- Banking and Financial Services
- Team Leadership
- Requirements Analysis
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
- Management & Leadership
- Finance & Accounting
Keywords
- ETL
- Data Warehousing
- SSIS
- SSRS
- IBM Netezza
- Microsoft SQL Server
- Sybase
- AWS Redshift
- AWS Glue
- AWS Cloud Services
- Spark
- EMR
- Kafka
- Batch Interfaces
- Data Injection
- Business Layer Processing
- Banking
- Financial Services
- Lending Systems
- Master Data Management
- Customer Demographics
- Retail Deposits
- Commercial Deposits
- Core Banking
- Canadian Banking
- Team Leadership
- Developer Mentoring
- Requirements Analysis
- Data Warehouse Systems