Senior Talend ETL Lead / Manager

Job Title: Senior Associate/Manager – Talend ETL Lead Location: Mississauga, ON (Canada) / Marlborough, MA (USA) Shift: Day Shift (9:00 AM – 6:00 PM EST) Position Summary We are seeking an experienced Talend ETL Lead / Manager with 12+ years of experience in Data Integration, Data Warehouse, and ETL development. The ideal candidate will possess strong expertise in Talend ETL, SQL/Snowflake, and data warehousing technologies, along with proven experience leading offshore teams and collaborating with business and technology stakeholders in a fast-paced retail environment. This role requires strong technical leadership, hands-on development capabilities, excellent analytical skills, and the ability to drive end-to-end delivery of enterprise-scale data integration solutions using Agile methodologies. Required Experience & Qualifications 12+ years of IT experience with strong expertise in: Talend ETL Development and ArchitectureData Warehousing and Data Integration SolutionsShell Scripting (Intermediate Level)Strong hands-on experience with: SQL ProgrammingSnowflakeOracle and other RDBMS platformsExperience working in Agile/Scrum delivery methodologies.Bachelor's degree in Computer Science, Information Technology, Engineering, or related field. Key Responsibilities Technical Leadership Lead the design, development, enhancement, and support of enterprise-scale ETL and Data Warehouse solutions using Talend.Provide technical leadership and guidance to onsite and offshore development teams.Drive solution architecture reviews, code reviews, and technical best practices.Ensure adherence to enterprise development standards, governance, and security policies.Data Integration & ETL Development Design and implement high-volume, high-performance data integration solutions using Talend.Develop and optimize ETL workflows, data pipelines, and batch processing solutions.Conduct source system analysis, data profiling, and impact assessments.Create and maintain Source-to-Target mappings and technical design documents.Perform performance tuning and optimization for ETL jobs, SQL queries, and data loads.Database & Data Warehouse Management Develop complex SQL queries, stored procedures, and scripts across Snowflake, Oracle, and other relational databases.Support data quality initiatives through validation, reconciliation, and exception handling processes.Collaborate with Data Architects and Business Analysts on data modeling and warehouse design activities.Project Delivery & Stakeholder Management Partner with business users, product owners, architects, and project teams to gather and refine requirements.Participate in Agile ceremonies including sprint planning, backlog grooming, daily standups, reviews, and retrospectives.Drive issue resolution, risk mitigation, and production support activities.Manage stakeholder communication and provide regular project status updates. Required Technical Skills Must Have Talend Data Integration (DI) and ETL DevelopmentSQL and Advanced Query OptimizationSnowflake Data PlatformOracle DatabaseData Warehousing ConceptsData Quality and Data ValidationSource-to-Target MappingETL Performance TuningShell Scripting (Unix/Linux)SDLC and Agile MethodologiesJob Scheduling Tools (Ctrl-M preferred)Git or other Source Code Management toolsGood to Have Unix/Linux AdministrationRetail and Supply Chain Domain KnowledgeJira and ConfluenceMicrosoft Office 365 SuiteBasic Data Modeling ExperienceCloud Data Platforms and Modern Data Architecture concepts Leadership & Soft Skills Proven experience leading offshore and distributed delivery teams.Strong stakeholder management and client-facing communication skills.Excellent written, verbal, and presentation skills.Strong analytical and problem-solving capabilities.Ability to work independently and manage multiple priorities in a dynamic environment.High attention to detail, accountability, and ownership mindset.Flexible to support critical production releases, deployment activities, and business deadlines as required. Preferred Industry Experience Retail, Merchandising, Supply Chain, Inventory Management, or Logistics domain experience.Experience working in large-scale enterprise data transformation and modernization programs.