BMO Financial Group Developer - (ETL / SQL/ Scripting / Linux) in Toronto, Ontario
YSC - 2 Sheppard Avenue East
Job Family Group:
The intermediate developer contributes to the completion of project deliverables and is accountable for the analysis, design, development, unit testing, implementation, and support of applications to ensure and/or maintain alignment with the Lines of Business (LOBs) strategies. Understands data in terms of its business and technical lifecycle (Create, Read, Update, and Delete), technical underpinnings of database theories (e.g. structured, unstructured), and various data modelling concepts in both the logical and physical domains. Assists in creation, implementation/installation, configuration, change, and support of data models, databases, data marts, data warehouses. Administers and documents data backup and recovery plans, capacity plans and security plans. Assists in planning and participates in tests for new products and data technology releases to ensure features and functions are acceptable and integrated across systems software and platforms. Proactively investigates/troubleshoots database, technical and systems problems and directs/assures corrective action. Identifies and recommends process or system changes to avoid issues/problems. 24/7 duty may be required. Mandate
• Participate in the development, testing, and implementation of initiatives to meet the functional and non-functional requirements of the application. • Provides input into planning, estimating, developing, and testing activities in order to support bug fixes, identify anomalies and misunderstandings, and provide clarity surrounding the interpretation of the requirements. • Writes code according to accepted standards based on user requirements, which are included in the delivery of the application solution, to meet the business need. • Build frameworks and automation scripts to accelerate development of common coding patterns. • Decomposes business requirements and translates them into detailed design specifications and code. • Create and maintain appropriate artefacts / documentation. • Reviews the work of other team members as required.• Support implementation activities in order to promote the application into the production environment in preparation for the user community. • 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. • Leads and implements initiatives as required to deliver business objectives. • Acquires end-to-end knowledge of assigned applications from existing documentation, application code, subject matter experts, and/or other application artifacts in order to identify and recommend technical improvement opportunities to senior management (i.e., Senior Manager, Platform Development, Technology Relationship Manager, Development Manager, and Technology Head). • Contribute to software development process improvement activities. • 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. • Broader work or accountabilities may be assigned as needed. Qualifications: • Typically, between 4 - 6 years of relevant experience and/or certification in IT or an equivalent combination of education and experience. • 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. • Must have 4+ years of ETL development. • Must have 4+ years of SQL. • Experience with unix/linux scripting. • Experience with ETL/ELT. • Experience with SSIS, Spark. • Experience in Data warehousing. • Exposure to AWS, Hadoop, Netezza. • 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. • Strong prioritization skills • Strong customer service and relationship management skills Strong multi-tasking skills covering a wide range of challenges which are independent and distinct
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 https://jobs.bmo.com/ca/en.
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.
BMO Financial Group Serving customers for 200 years and counting, BMO is a highly diversified financial services provider – the 8th largest bank, by assets, in North America. With total assets of $728 billion as of October 31, 2018, and a team of diverse and highly engaged employees, BMO provides a broad range of personal and commercial banking, wealth management and investment banking products and services to more than 12 million customers and conducts business through three operating groups: Personal and Commercial Banking, BMO Wealth Management and BMO Capital Markets.We serve Canadian clients through BMO Bank of Montreal®, our personal and commercial banking business, BMO Nesbitt Burns®*, one of Canada's leading wealth management firms, and BMO Capital Markets™, our North American investment and corporate banking division.In the United States, clients are served through BMO Harris Bank, a major U.S. Midwest personal and commercial bank, and BMO Private Bank, with wealth management offices across the United States, as well as BMO Capital Markets™, our North American investment and corporate banking division.We help our customers make money make sense by delivering the broadest range of financial services through a single point of contact. Our financial service professionals provide access to any services our customers require across the entire enterprise.