You're using an older version of Internet Explorer that is no longer supported. Please update your browser.

AB-Initio ETL Technical Specialist Business Intelligence- (100% remote-virtual)

Full Time
6 days ago
VIRTUAL52 - HomeRes - BC - BMO

Job Family Group:


We are seeking an experienced ETL application Technical Specialist focused on Business Intelligence with proven experience building and maintaining strong relationships with stakeholders. You would act as an application spoc/SME who would represent the application in the intake forum to ensure that systems functionally meet requirements and assess any impact to identify design changes require to align the application to new requirement. The role provides opportunity to gather deep knowledge in banking finance systems and how data maps , transforms and flows between systems.

You will be part of the Finance Technology Application team which is responsible for maintaining & supporting an ETL data warehousing application which consume, transform, process & loads various finance source systems instruments & General Ledger data (investments, loan, Mortgages etc. ) into the core finance PeopleSoft EPM module that generates funds transfer pricing, allocations and other financial results useful for Finance Management reporting and feeding financial downstream systems.

To be successful , you MUST have a min of 2+ years with Ab Initio, and 5+ years on ETL, Data warehouse knowledge, ETL processing, SQL querying, DB2 , and scripting knowledge in Unix/Linux.

***This is a 100% virtual role***

Day-to-day activities include :
  • Maintains and keep current-state existing design logic documents up to date.
  • Understands and can explain to others the technical specs, core processes , design logic, source data mapping and transformation logic involved in ETL processes.
  • Assess project intake items, upstream systems change impact to application, provide L0,L2,OOM sizing.
  • Track deliveries and coordinate project releases.
  • Gather upstream system /source / business requirements and convert these findings into functional specification documents

Key Responsibilities :
  • Understand and explain current-state existing design ETL logic to development team like core processes , design logic, source data mapping and transformation logic involved in ETL processes.
  • Create and maintains functional specification documents ( TSD/SES/design documents).
  • Assess project intake items, upstream systems change impact to application, provide L0,L2,OOM sizing and communicating with project team and business contact while representing application team in any meeting.
  • Gather requirements and documents these requirements for use in various projects and communicates effectively with project PM, business counterparts and other impacted systems stakeholders.
  • Track deliveries and coordinate project releases.

Understands that the success of this role is to understand the core business processes of the business unit and business requirements as well as the architecture patterns and technology strategy (e.g., Transformation, SmartCore, DevOps). Conceive and write detailed software implementations/code while ensuring that their code/configurations adhere to the security, logging, error handling, and performance standards and non-functional requirements. Writes, configures, and integrates code to create the software that aligns with architecture patterns and technology strategy. Understands the implications of various components (including technology strategy & architecture) to the overall design of a program, system, or eco-system. Evaluates new technologies for fit with the program/system/eco-system and the associated upstream and downstream impacts on process, data, risk (e.g., security). Works toward the objective of defect free software. Ensures that systems functionally meet requirements, align with architecture and promote the development of common assets. Supports the resolution of production issues and problems. Makes recommendations to improve BMO processes & systems.
  • Assesses impact of design decisions to the computer solution/product/service being developed (i.e. performance, schedule, budget, downstream component/system impact, quality, etc.) and recommends alternate/creative solutions for mitigation/optimization if required.
  • Recommends and implements solutions based on analysis of issues and implications for the business.
  • Identifies emerging issues and trends to inform decision-making.
  • Leads and implements initiatives as required to deliver business objectives.
  • Conducts independent analysis and assessment to resolve strategic issues.
  • Builds effective relationships with internal/external stakeholders and ensures alignment.
  • Monitors and tracks performance, and addresses any issues.
  • Leads/conducts detailed code-reviews and provides feedback in a constructive manner.
  • Decomposes business requirements and translates them into detailed design specifications and code.
  • Interacts with key business & technology stakeholders to define, analyze, and deliver requirements that reflect the needs of both the business and end-customers.
  • Assesses the costs and benefits for different solutions and recommend/decide on appropriate designs.
  • Designs solutions, writes code, performs unit testing, develops appropriate artefacts / documentation, and facilitates final delivery.
  • Supports production issues, includes independently completing root-cause analysis and diagnosis.
  • Devises new algorithms and data structures for target environment and platform attributes in alignment with architectural patterns.
  • Builds solutions that are supportable, scalable and achieve our aspiration of common assets.
  • Recommends or automates approaches to streamline and integrate technological processes and/or systems to improve operational efficiency and effectiveness.
  • Supports the management of specific project deliverables & outcomes.
  • Identifies opportunities to strengthen the development capability, such as: sharing expertise to promote technical development, mentoring employees, building communities of practice and networks.
  • Stays abreast of industry technical and business trends through participation in professional associations, practice communities & individual learning.
  • Focus is primarily on business/group within BMO; may have broader, enterprise-wide focus.
  • Provides specialized consulting, analytical and technical support.
  • Exercises judgment to identify, diagnose, and solve problems within given rules.
  • Works independently and regularly handles non-routine situations.

  • MUST HAVE a minimum of 2+ years of experience in ETL Ab Initio
  • 5+ or more years of experience in ETL but preferably with the Ab Initio tool
  • Strong Data warehouse knowledge and understanding on ETL processing. ETL mapping, design and development of code using ETL Ab Initio tool.
  • Expertise in in creating and maintaining functional specification documents (TSD/SES/design documents).
  • 3-5 years of experience using SQL statements to query data
  • Strong experience working in DB2
  • At least 2 years of experience in scripting knowledge with Linux/Unix
  • Typically between 5 - 7 years of relevant experience and/or certification in related field of study or an equivalent combination of education and experience.
  • Advanced level of knowledge in domain.
  • Knowledge of software development practices, concepts, and technology obtained through formal training and/or work experience.
  • Knowledge of required programming languages and can code with little oversight.
  • Knowledge of technical/business environment and processes.
  • Understand functional aspects and technical behavior of the underlying operating system, development environment, and deployment practices.
  • Have facility with and understanding of the ecosystem that code operates in.
  • Deep knowledge and technical proficiency gained through extensive education and business experience.
  • Verbal & written communication skills - In-depth.
  • Collaboration & team skills - In-depth.
  • Analytical and problem solving skills - In-depth.
  • Influence skills - In-depth.
  • Data driven decision making - In-depth.

We're here to help

At BMO we are driven by a shared Purpose: Boldly Grow the Good in business and life. It calls on us to create lasting, positive change for our customers, our communities and our people. By working together, innovating and pushing boundaries, we transform lives and businesses, and power economic growth around the world.

As a member of the BMO team you are valued, respected and heard, and you have more ways to grow and make an impact. We strive to help you make an impact from day one - for yourself and our customers. We'll support you with the tools and resources you need to reach new milestones, as you help our customers reach theirs. From in-depth training and coaching, to manager support and network-building opportunities, we'll help you gain valuable experience, and broaden your skillset.

To find out more visit us at .

BMO is committed to an inclusive, equitable and accessible workplace. By learning from each other's differences, we gain strength through our people and our perspectives. Accommodations are available on request for candidates taking part in all aspects of the selection process. To request accommodation, please contact your recruiter.

Note to Recruiters: BMO does not accept unsolicited resumes from any source other than directly from a candidate. Any unsolicited resumes sent to BMO, directly or indirectly, will be considered BMO property. BMO will not pay a fee for any placement resulting from the receipt of an unsolicited resume. A recruiting agency must first have a valid, written and fully executed agency agreement contract for service to submit resumes.
Information Technology

The #1 Podcast for Jobseekers

Latest Episode:

#81 - Wealthsimple - Developing an Engineering Career in FinTech

Interested in jobs like this?

Sign up for email alerts
Get job alerts

About BMO

THERE’S NEVER BEEN A BETTER TIME TO BE PART OF BMO. We’ve set our sights on being the bank that defines great customer experience. Our customers’ needs are changing and so are we. Everyone who wo...

Read More
Banking & Finance
10,000+ employees