ETL Developer (IBM Netezza)

Apptoza Inc.; Toronto; On-site; CAD 110,000 - 140,000; Full time

Job summary

Apptoza Inc. seeks a senior data warehouse specialist with a strong banking/financial domain background. The role requires leading a team of developers, designing ETL processes, and overseeing the full data warehouse lifecycle.

Candidates should have 10+ years in data warehousing, expertise in MS SSIS/SSRS, and hands-on experience with AWS Redshift and Glue to implement scalable data solutions in a financial context.

Qualifications

• Must have 10+ years of data warehouse experience in the banking/financial domain.
• Proven ETL design, development and DW architecture leadership.
• Experience leading developers and mentoring as needed.
• Experience with AWS Redshift and AWS Glue.

Responsibilities

• Lead a team of developers and mentor as needed.
• Understand requirements and manage complete data warehouse systems.

Skills

Data warehouse

ETL development

Team leadership

Tools

MS SSIS/SSRS

AWS Redshift

AWS Glue

ETL data warehouse

Job description

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

MUST HAVE:

• ETL data warehouse
• MS SSIS/SSRS
• AWS Redshift, AWS Glue

NICE TO HAVE:

• 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)