ETL Practice Lead - Jobs in Toronto

Job Description

Hours 37.5Workplace Model HybridPay DetailsWe #39;re committed to providing fair and equitable compensation to all our colleagues. As a candidate, we encourage you to have an open dialogue with your recruiter and ask compensation related questions, including pay details for this role.Department OverviewBuilding a World-Class Technology Team at TDWe can #39;t afford to be boring. Neither can you. The scale and scope of what TD does may surprise you. The rapid pace of change makes it a business imperative for us to be smart and open-minded in the way we think about technology. TD #39;s technology and business teams become more intertwined as new opportunities present themselves. This new era in banking does not equal boring. Not at TD, anyway.TD Data and Information Management covers building, developing, designing, and implementing involved with tech data management solutions. Where do we begin These experts analyze, design, develop and support TD #39;s info management system; lead and support bank data curation; develop data road map and info management strategies; focus on complex data integration, and drive use of our data reference model. This area doesn #39;t work in isolation. We love data and we feel the same about integration and our assignments prove it.There #39;s room to grow in all of it.Job DetailsETL practice lead will manage and lead a team of ambitious ETL (Extract Transform Load) developers specializing in industry standard ETL tools such as Ab Initio, IBM DataStage, MS SSIS, Informatica as they deliver a wide range of application or system solutions. You will be responsible to establish the roadmap for the ETL practice for DaaS and may provide technical guidance and leadership beyond your immediate team. Here #39;s some of what you may be asked to perform:•Manages a community of practice consisting of ETL developer responsible for data movement and transformation across various data assets in DaaS (Data-as-a-service) using multiple ETL tools including Ab Initio, IBM DataStage, MS SSIS, Informatica. •A specialist who ensures a holistic design approach is followed by the ETL practice across projects, breaking silos •Responsible to establish coding standards, ETL framework and standard data flow using the approved ETL tools across DaaS •Develops, documents, and rolls out policies and procedures. Communicates policies and procedures to the group and other project teams and enforces adherence to processes and procedures. •Provides leadership with an on-going focus on reusability, scalability and innovation within the community of practice •Provides guidance on the work of practitioners as related to the quality of product(s)/work being produced, deliveredamp; speed of delivery / to market •Create and maintain strategic capability by enhancing depth and integrity of system knowledge •Enhance Development Capability assessment with a continuous learning approach to grow team expertise leveraging a curated training curriculum •Assist the practice in moving from big-design-up-front (Waterfall) to emergent design (Agile) •Look for opportunities to leverage learnings across projects and collaborates with delivery partners •Identify and recommend opportunities to enhance productivity, effectiveness and operational efficiency of the business unit and/or team •Adopt and ensure full compliance with well-defined TD technology practices and standards and adopt industry best practices where applicable •Actively participate in demand management and resourcing of delivery pods •Set targets and objectives for the team, and deliver results •Drives change through positive reinforcement of milestones and successes •Provides people management leadership by hiring the best talent, setting goals, developing staff, managing employee performance and compensation decisions, promoting teamwork and handling any/all disciplinary actions, as required •Grows team expertise to align with business/enterprise demand and direction; assess team skills and capabilities and continually look for ways to provide and enhance the value delivered •Conducts formal performance reviews and provide on-going feedback; coach and develop employees and ensure performance management and development planning activities are undertaken and completed •Foster an environment / culture that encourages productivity, innovation, process improvement, teamwork and a high level of professionalism •Support a positive work environment that promotes service to the business, quality, innovation and teamwork and ensure timely communication of issues/ points of interestJob RequirementsWhat can you bring to TD Share your credentials, but your relevant experience and knowledge can be just as likely to get our attention. It helps if you have:•Undergraduate Degree or Technical Certificate. •10+ Years of related experience. •Strong technical understanding of ETL concepts and hand-on experience on more than one ETL tool. •In-depth knowledge of the Ab Initio development environment and concepts [EME, Co-op, MFSs, parallelism, psets, log analysis, GDE components, etc]; IBM DataStage job stages and types. •In-depth knowledge of MS SSIS components including control flow, data flow, event handler, package explorer and parameters with package creation using designer. •Proficient in integrating, performance tuning techniques, error handling and troubleshooting mechanisms of Ab Initio graphs, IBM DataStage jobs, stages and MS SSIS package, tasks, containers etc. •Expertise in Ab Initio, IBM DataStage and SSIS design and being able to review and identify/correct design issues from other developers •In-depth knowledge of Informatica PowerCenter, IICS with ability to define coding standards and perform code reviews. •Very good understanding of Linux/Unix. Working experience with process automation using CA7, Autosys, Linux shell scripting etc. •Mainframe experience a plus. •Previous development experience required with domain knowledge in banking, data warehousing, data models and data integration. •Provides guidance to the Infrastructure team for ETL application server architecture requirements and disk capacity/performance needs •Expert knowledge of the business, technology standards, managing people and projects. •Advanced understanding of businesses and/or organizational practices/ disciplines. •Strong knowledge of external competition, and/or market trends. •Previous management experience leading large team ( gt;25) of employees, contractors at onsite and offshore. •Readiness and motivation to manage a sizeable group or team of IT professionals responsible for development/solutions design and/or system enhancements, new releases or project deliverables with increasing complexity of moderate to broad scope. •Proven success in problem solving and coming up with strategies and plans for operational improvement. •Analytical thinker with excellent communications and decision making skills. •Progressively responsible experience in large scale corporate systems analysis. •Six Sigma certifications and experience preferred •Experience with Agile concepts preferred •Azure DataBricks, Azure Synapse/SQL Server, Azure Data Factory (ADF) and Orchestration experience a plusAdditional InformationJoin in on what others in TD Technology Solutions are doing:•Inspire a positive work environment and help champion quality, innovation, teamwork and service to the business. •Learn voraciously, stretch your thinking,Company Overview Our ValuesAt TD we #39;re guided by our purpose is to enrich the lives of our customers, communities and colleagues, and share a set of values that shape our culture and guide our behavior. In exchange for how our colleagues show up to help TD succeed, we are committed to delivering a colleague experience grounded in Impact, Growth and a Culture of Care. No matter where you work across TD, we empower you to make an impact at work and in your community, explore and grow your career and be part of our caring and inclusive culture.Making Your Well-being a PriorityA supportive culture that promotes colleague well-being is core to who we are. At TD, we focus on total well-being with extensive programs to help colleagues assess, manage, and improve their well-being across four core pillars - physical, financial, social and mental/emotional. In addition, we champion a safe and inclusive work environment so colleagues feel a sense of belonging and feel supported in their personal and professional growth. Through our focus on well-being, we know that we can help our colleagues thrive, contribute to our culture of care, and support better business outcomes, because when colleagues feel their best, they #39;re more likely to do their best.Our Total Rewards PackageOur Total Rewards package reflects the investment we make in our colleagues to help them, and their families achieve their well-being goals. Total Rewards at TD includes a base salary, variable compensation, and several other key plans such as health and well-being benefits including medical, dental, visionamp; mental health coverage, savings and retirement programs, paid time off, banking benefits and discounts, career development, and reward and recognition programs.How We WorkAt TD, we believe in-person connections fuel collaboration and collective creativity. Our workplace experience empowers colleagues to do great work side-by-side at TD locations, while offering flexibility to work remotely where it makes sense for the work and team. Our teams work in one of three workplace models: Hybrid, Onsite and Primarily Remote. Wherever our colleagues are working, they #39;ll always have access to the TD community and experience our culture of care.Who We AreTD is one of the world #39;s leading global financial institutions and is the fifth largest bank in North America by branches. Every day, we deliver legendary customer experiences to over 27 million households and businesses in Canada, the United States and around the world. More than 95,000 TD colleagues bring their skills, talent, and creativity to the Bank, those we serve, and the economies we support. We are guided by our vision to Be the Better Bank and our purpose to enrich the lives of our customers, communities and colleagues.TD is deeply committed to being a leader in customer experience, that is why we believe that all colleagues, no matter where they work, are customer facing. As we build our business and deliver on our strategy, we are innovating to enhance the customer experience and build capabilities to shape the future of banking. Whether you #39;ve got years of banking experience or are just starting your career in financial services, we can help you realize your potential. Through regular leadership and development conversations to mentorship and training programs, we #39;re here to support you towards your goals. As an organization, we keep growing - and so will you.Inclusiveness Our Commitment to Diversity, Equity, and Inclusion At TD, we #39;re committed to fostering an environment where all colleagues are encouraged to bring their authentic selves to work, experience equitable opportunities, and feel respected and supported. We #39;re dedicated to building an inclusive workforce that reflects the diversity of the customers and the communities in which we live and serve.Accommodation Your accessibility is important to us. Please let us know if you #39;d like accommodations (including accessible meeting rooms, captioning for virtual interviews, etc.) to help us remove barriers so that you can participate throughout the interview process.How We #39;re Helping Make an Impact in Communities TD has a long-standing commitment to help drive progress towards a more inclusive and sustainable future. That #39;s why we launched the TD Ready Commitment in 2018, now a multi-year North American initiative. Under the TD Ready Commitment, we are targeting a total of $1 billion by 2030 in community giving four key, interconnected drivers of change: Financial Security, Vibrant Planet, Connected Communities, and Better Health. It #39;s our goal to help support change, nurture progress, and contribute to making the world a better, more inclusive place for our customers, colleagues, and communities.We look forward to hearing from you!