The bank for a changing world

We are looking for

ETL Developer

Contract

Full-time

Location

United States-Arizona-Tempe

Country

USA

Job function

Technology

Apply REF: 041459

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


Provides technical expertise in the examination and definition of objectives of existing or proposed systems and in the design of improved systems utilizing information technology

 

Assists in the development of cost and time estimates for capital budgeting plan and operational budget plan for the area.

 
May conduct vendor negotiations and develop contract proposals.
 
Performs other duties as assigned.
 
Required Experience
 
Experience in leading, managing and implementing complex ETL/Data Warehouse projects.
 
 
• Experiences to include data mapping, ETL development and, testing, and database design (for operational systems, data warehouses and data marts).
 
• Experience providing functional/team management of data projects related to one or more of the following: data quality/data governance assessments, data strategy and roadmaps, integration scoping (requirements, design and mapping), and data warehouse architecture, design and implementation.
 
• Ability to perform information management assessments (review of needs, data quality, data security, etc.) and accurately estimate the implementation effort.
 
• Applicable knowledge of the tools and technologies used by the team – Informatica, Toad, SQL, PL/SQL, SharePoint, JIRA, etc.
 
• Strong Informatica technical knowledge in the areas on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
 
• Good knowledge of analytical and logical conceptual level programming skills, data analysis, data mapping, data loading, and data validation.
 
• Understand reusability, parameterization, workflow design, etc.
 
• Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
 
• Should have thorough understanding of Entire life cycle of Software and various Software Engineering Methodologies.
 
• Performance tuning and end-to-end lifecycle experience with Enterprise wide data warehouse
 
• At least two years of experience in a development team in an environment that has followed the Agile methodology and applied Scrum principles, practices, and theory.
 
• Experience being on multiple Scrum teams in a variety of different contexts (different team sizes, different organizations, different cultures, onshore vs. offshore, co-located vs. distributed).
 
• Excellent skills and knowledge of leadership, facilitation, situational awareness, conflict resolution, continual improvement, empowerment, influence and increasing transparency.
 
• Conducting ceremonies: Daily Standup, Daily Prioritization, Backlog Grooming, Retrospectives, Sprint Planning, etc.
 
• Knowledge of Agile approaches (e.g. XP, Kanban, etc.).
 
• Awareness and experience with widely successful Agile techniques: User Stories, backlog grooming, Continuous Integration, Continuous Testing, Pairing, Automated Testing, Agile Games.
 
• Previous software development experience, working within a team of architects, modelers, database developers and engineers working to design and deliver data solutions.
 
• Applicable knowledge of the tools and technologies used by the team – Informatica, Toad, SQL, PL/SQL, SharePoint, JIRA, etc.
 
• Ability to function as a BSA to understand and capture relevant business level detail to assist with bridging the gap between the various roles.
 
• Experience in leading, managing and implementing complex ETL/Data Warehouse projects.
 
• Experiences to include data mapping, ETL development and, testing, and database design (for operational systems, data warehouses and data marts).
 
• Experience providing functional/team management of data projects related to one or more of the following: data quality/data governance assessments, data strategy and roadmaps, integration scoping (requirements, design and mapping), and data warehouse architecture, design and implementation.
 
• Ability to perform information management assessments (review of needs, data quality, data security, etc.) and accurately estimate the implementation effort.
 
• Applicable knowledge of the tools and technologies used by the team – Informatica, Toad, SQL, PL/SQL, SharePoint, JIRA, etc.
 
• Strong Informatica technical knowledge in the areas on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
 
• Good knowledge of analytical and logical conceptual level programming skills, data analysis, data mapping, data loading, and data validation.
 
• Understand reusability, parameterization, workflow design, etc.
 
• Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
 
• Should have thorough understanding of Entire life cycle of Software and various Software Engineering Methodologies.
 
• Performance tuning and end-to-end lifecycle experience with Enterprise wide data warehouse
 
• At least two years of experience in a development team in an environment that has followed the Agile methodology and applied Scrum principles, practices, and theory.
 
• Experience being on multiple Scrum teams in a variety of different contexts (different team sizes, different organizations, different cultures, onshore vs. offshore, co-located vs. distributed).
 
• Excellent skills and knowledge of leadership, facilitation, situational awareness, conflict resolution, continual improvement, empowerment, influence and increasing transparency.
 
• Conducting ceremonies: Daily Standup, Daily Prioritization, Backlog Grooming, Retrospectives, Sprint Planning, etc.
 
• Knowledge of Agile approaches (e.g. XP, Kanban, etc.).
 
• Awareness and experience with widely successful Agile techniques: User Stories, backlog grooming, Continuous Integration, Continuous Testing, Pairing, Automated Testing, Agile Games.
 
• Previous software development experience, working within a team of architects, modelers, database developers and engineers working to design and deliver data solutions.
 
• Applicable knowledge of the tools and technologies used by the team – Informatica, Toad, SQL, PL/SQL, SharePoint, JIRA, etc.
 
• Ability to function as a BSA to understand and capture relevant business level detail to assist with bridging the gap between the various roles.
 
*LI-IB1
 
 

Required Experience
  • Requires advanced knowledge of job area typically obtained through advanced education combined with experience.
  • May have practical knowledge of project management.
  • Requires 5 years minimum prior relevant experience.

Education
  • 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.
Primary Location: United States-Arizona-Tempe Job Type: Full-time Job: Technology