ETL Lead Developer

Position: ETL Lead Developer
Location: Toronto, ON (Onsite)
Employment Type: Full-Time

Experience Range: 8 -10 Years

Job Description:

We are seeking an experienced Data Warehouse Lead with strong expertise in Data Warehousing, ETL Development, IBM Netezza, and AWS technologies. The ideal candidate will lead data integration initiatives, support data warehouse modernization programs, and collaborate with stakeholders in the Banking and Financial Services domain.

Key Responsibilities

• Lead the design, development, and support of enterprise data warehouse solutions.
• Develop and maintain ETL processes using SSIS and related technologies.
• Manage data integration, transformation, and migration activities across multiple platforms.
• Collaborate with business and technical teams to gather requirements and deliver scalable data solutions.
• Provide technical guidance and mentorship to development teams.
• Support data warehouse migration and modernization initiatives involving Netezza and AWS platforms.
• Ensure data quality, performance, governance, and operational stability.
• Participate in solution design, testing, deployment, and production support activities.

Mandatory Skills

• Data Warehousing & ETL Development
• Microsoft SSIS / SSRS
• IBM Netezza
• AWS Redshift
• AWS Glue
• Banking & Financial Services Domain Experience
• SQL Development
• Team Leadership & Stakeholder Management

Preferred Skills

• AWS Cloud Services (EMR, Spark, Redshift)
• Kafka Message Processing
• Lending Systems Knowledge
• Master Data Management (MDM)
• Retail & Commercial Banking Systems
• Core Banking Domain Experience