ETL SQL Developer

Company: M&T Bank
Location: Buffalo
Posted on: February 15, 2020

Job Description:

ETL SQL DeveloperBuffalo, NYM&T Tech, we're a team of makers, doers, and builders, working to create the most advanced technology solutions in banking. We're not your stereotypical suit and tie bankers: we're an innovative team of leading tech experts, pushing boundaries, and taking risks. We're building an agile team of the most skilled and creative workers to solve complex problems, architect solutions, write high-performance software, and chart our new path, all to make the lives of our customers, and the communities that we serve, better. Join us and be part of something new as we build tomorrow's bank, today. Risk, Regulatory Compliance, Finance and Profitability Technology The RRCT division supports the Chief Risk Officer (CRO) and Chief Finance Officer (CFO) of the bank. As the bank grows and becomes more digital, the need to create fast, automated, and dependable data driven analytical systems to understand the risk and return profile of products, customers relationships, channels, sectors, regions, etc. becomes paramount to run the bank efficiently while meeting the regulatory compliance needs of the bank. Specifically, this requires estimating and managing credit, operational, market & interest rate risk, regulatory and economic capital, liquidity risk, profitability, defenses against money laundering and compliance risk.The domain is a cross section of technology using SAS, Python, Java, .Net, SQL, Oracle, Informatica, for data, analytics (including ML and AI utilizing cloud based tools), reporting, visualization. Overview:Provides designs, specifies information systems solutions and the highest level technical direction in the development of new or existing applications to solve basic to complex problems or enhancements. Often directs and monitors the activities of less experienced personnel.Primary Responsibilities:This is a hands on development position. This role will be responsible for designing, coding and unit testing of data integration solutions primarily involving Informatica along with MS SQL. Will need to learn and maintain current code as well as working on new development. Strong in performance tuning and designing in a large data volume environment. Will do individual development as well as peer code review.Scope of Responsibilities:The position works under supervision of Technology management. The jobholder is competent to work independently on all high level systems analysis and technical phases of development. The position is capable of managing the activities of others on any scope project and often leads project activities. The jobholder monitors staff performance on assigned projects related to their overall abilities and effectiveness in completing projects within schedules. The position participates in the development of less experienced staff. The position interacts with senior management, other technology personnel, clients and vendors. The jobholder provides backup to higher management as required and may be called upon to serve as a technical representative on committees, ad-hoc projects, etc.Education and Experience Required:Minimum of an Associate's degree and 6 years' systems analysis/application development experience, or in lieu of a degree, a combined minimum of 8 years' higher education and/or work experience, including a minimum of 6 years' systems analysis/application development experience5-7 years SQl ETL Development experience2-3 years Informatica ExperienceFamiliar with application development software and hardware platformsProficiency with personal computers as well as pertinent project management, word processing and spreadsheet softwareCapable of working on multiple projects of a complex natureExcellent problem-solving skills to assist in issue resolutionExcellent verbal and written communication skills, with prior experience presenting to the target audienceExcellent organizational and time management skillsDetail-orientedStrong lateral thinking skillsExperience coordinating between Applications and business unitsExperience recommending and implementing system solutionsExperience driving project milestones and delivery datesProven mentoring and leadership capabilities from a project management perspectiveEducation and Experience Preferred:Good understanding of the Bank's application frameworkSubject matter expert in business with knowledge or experience utilizing application/system being supportedMastered understanding of applications supported with an advanced knowledge of interfacing/integrated applicationsAbility to work in a team environment as well as autonomouslyAbility to multitask for various components of complex projectsMastered knowledge and focus of the entire system to work on projects outside of normal business-as-usual (BAU)

Keywords: M&T Bank, Buffalo , ETL SQL Developer, IT / Software / Systems , Buffalo, New York