Bank of the West Sr Software Engineer in Tempe, Arizona
Sr Software Engineer
At Bank of the West, our people are having a positive impact on the world. We’re investing where we feel we can make the most impact, like advancing diversity and women entrepreneurship programs, financing for more small businesses, and promoting programs for sustainable energy. From our locations across the U.S., Bank of the West is taking action to help protect the planet, improve people’s lives, and strengthen communities. We are part of BNP Paribas, a global leader supporting the UN Sustainable Development Goals (SDGs). Yes, we’re a bank, but as the bank for a changing world, we are continually seeking to improve the ways we help our customers, while contributing to more sustainable and equitable growth.
Job Description Summary
Perform full SDLC life cycle work, including analysis, design, development,enhancements, testing, maintenance and technical support for various KYC projects.
Design, implement, automate and maintain large scale enterprise data ETL processes.
Evaluate the integration a various data sources like Oracle, SQL server, VSAMand sequential files into staging area and recommends and/or implements efficiencies
Big data technology experience
Performs technical walk‐through as needed to communicate design/codedsolution and to seek input from team members.
Develop ETL processes using Informatica, ETL control tables, error logging,auditing, data quality, etc.
Implement data cleanup procedures, transformations, scripts, storedprocedures, and execution of test plans for loading the data successfully into thetargets.
Enterprise‐level ETL development and ETL architecture using Informatica and understanding/ using the COBOL file structures.
Work on Oracle Database using SQL and PL/SQL.
Work on Informatica Designer Components ‐Source Analyzer, WarehouseDesigner, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
Perform data analysis, data mapping, data loading, and data validation; reusability, parameterization, workflow design, etc.
Support other ETL developers; providing mentoring, technical assistance,troubleshooting and alternative development solutions.
Perform performance tuning and work end‐to‐end lifecycle using Enterprise wide data warehouse.
7 years of relevant experience
Full life cycle development experience
Excellent data analysis and debugging skills, Unix scripting, SQL queries and performance tuning
Exposure IDQ preferred
Good knowledge on Informatica Data Services ﴾IDS﴿, Informatica Analyst and Informatica Developer, Informatica Power center Components 9.x
Data mapping experience ‐ mapping data sources to and from multiple applications
Ability to design, develop and implement data feeds and transformations
Expertise working with different kinds of sources ‐ XML, flat files, Web services
Team Player with excellent collaborative skills.
- Bachelor's Degree
Equal Employment Opportunity Policy
Bank of the West is an Equal Opportunity employer and proud to provide equal employment opportunity to all job seekers without regard to any status protected by applicable law. Bank of the West is also an Affirmative Action employer - Minority / Female / Disabled / Veteran.
Bank of the West will consider for employment qualified applicants with criminal histories pursuant to the San Francisco Fair Chance Ordinance subject to the requirements of all state and federal laws and regulations.
Location: United States-Arizona-Tempe
Requisition ID: 055650