Sr QA Engineer I - ETL / Data Warehouse

Bank Of The West Tempe , AZ 85280

Posted 4 months ago

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.

While Bank of the West considers all applicants, we will not sponsor candidates for work visas at this time.

Job Description Summary

This resource will be part of QA Center of Excellence team for ETL/Data warehouse testing projects. Primary responsibilities would be, understand requirements & data mapping, define test plan, develop test cases & technical test scripts, conduct reviews and execute test cases.

Resource should be primarily interacting with Dev team, BSA, Data Analyst, and Data architects to understand project requirements, Technical design, downstream systems impact and data mapping. Resource should participate in daily status meetings to provide accurate QA status with Project manager. Should be able to understand data mapping and document test cases and test scripts independently and have excellent team player skills to work with cross domain teams in a dynamically changing environment.

Essential Job Functions

  • Create & Execute software test design, test strategies, test cases for Bank's Treasury systems such as ALMT, ILM and FARM.

  • Perform detailed Data Analysis, Data Profiling, Data Cleansing, Data Reconciliation and Data Integrity using SQL, Shell scripts and other approved tools

  • Implement approved test automation framework for functional, regression and E2E testing.

  • Develop complex PL/SQL & SQL scripts using Oracle Toad & SQL Developer tools to validate the ETL process/design implemented in Informatica Power Center, Informatica IDQ and Denodo Platform Control Center from Heterogeneous source systems to Enterprise Data Warehouse and Regulatory data marts.

  • Develop database analytical/aggregation functions and stored procedures to validate different drill down metrics and dashboards in OBIEE Reporting.

  • Schedule and execute TIDAL jobs for end to end ETL process implemented in multiple products/software like Informatica MDM, Informatica Address Doctor, Denodo and ESB using UNIX shell scripting, Workflow Monitor and Workflow Manager tools to perform integration and regression test.

  • Define and document software test plan and perform several phases of testing cycles and record test results, test metrics and track defects using HP ALM/Quality Center and JIRA tools in order to ensure applications, products and/or releases are in compliance with Bank of the West`s QA standards.

  • Partner with test leads at onsite and offshore, architects and senior management to recommend quality improvement best practices and processes based on current and emerging technologies/applications/software.

Other Job Duties

  • High level of personal commitment to each task, a can do attitude and a drive to deliver.

  • Strong communication skills to be able to communicate at all levels.

  • Ability to understand banking financial requirements.

  • High level of responsibility and Ownership from inception through to implementation.

  • The candidate should have a proactive approach to problem solving.

  • Good analysis skills in order to aid in trouble shooting and problem solving.

  • Good testing principles as well as good defect management skills should have experience in handling.

  • Multiple assignments at same time and long with other team members.


  • Bachelor's Degree in Information Technology or Computer Science

Required Experience

  • Overall 8 years of experience of IT experience with minimum of 6 years of ETL/ Data Warehouse Testing.

  • Experience in writing complex SQL & PL SQL statements to test ETL code based on the data mapping & requirements provided and perform extensive data analysis to identify the defects.

  • Strong Data ware house and BI concepts.

  • Experience in working testing through Informatica or related ETL tools, Oracle database, BI tools like OBIEE, etc. and has experience working with UNIX/LINUX.

  • Experience in working with large scale Enterprise Data Warehouse, Data Integration, Data Migration and upgrade projects.

  • Experience in testing data warehouses systems and have defined test approaches for data warehouse projects.

  • Experience in creating Test plan, test cases and engineering best practices related to software test engineering, both manual and automated testing.

  • Experience coordinating testing activities and optimizing test cycles working with project team.

  • Experience with utilization of appropriate test methodologies and use of test management tool like HP ALM.

  • Experience with conducting and running defect triage meeting with project teams.

  • At least 3 - 5 years' experience of working with financial services applications.

  • Strong in STLC process, Test Strategy/Plan, Test Estimation

  • Effective Project & People Management Skills, exposure to Knowledge Management. Solid time management and prioritization skills.

  • Excellent verbal and written communication skills.

Preferred Skills

  • Domain knowledge & previous experience with Banking and Financial service domain knowledge.

  • Passion towards giving technical solutions and using different testing tools.

  • ETL test automation.

  • Experience working with Database upgrades, tool upgrades and Interface testing.

  • Should have experience in handling multiple assignments at same time and long with other team members.

  • Should be best team player.

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.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Business Intelligence Sr Data Engineer


Posted 5 days ago

VIEW JOBS 10/15/2019 12:00:00 AM 2020-01-13T00:00 ADP is hiring a Business Intelligence Sr Data Engineer In this position you will define and develop new data management, business intelligence and analytics capabilities that provide business with new insights for their external clients and internal operations. In this role the Business Intelligence Senior Data Engineer will help to manage initiatives in Data, BI and Analytics, supporting existing and planned activities within its business unit as well as the broader ADP organization. You will assist in defining standardized methods to capture and report key metrics and KPI's related to business objectives and initiatives. You will engage with key stakeholders to define and adopt Data Analytics methodologies and standards. This position will report up to the Senior Director of Business Intelligence and will work closely with client services, business operations and product management, as well as key members of the technology organization. RESPONSIBILITIES: * Lead the design and development of data management, business intelligence and analytics projects to drive strategic decisions through data driven actionable metrics and insights. * Provide subject matter expertise in data modeling and architecture design. * Assist in evaluating and selecting the best technologies and tools to support the data mission. * Manage development and production issues impacting our clients and operations. * Monitor and improve data and BI processes to meet firm SLAs and increase efficiency. * Help define user stories as a part of the BI scrum team by analyzing business requirements, defining technical specifications and sizing the development effort. * Leverage technology capabilities and standards while working with technology system owners to identify appropriate data sources, define and build required data transformation logic. * Perform detailed data analysis to derive insights and deliver operational mechanism such as dashboards or ad-hoc reports. QUALIFICATIONS REQUIRED: * Minimum of 8 years of hands-on experience with SQL Server, Oracle and SSIS * Minimum of 3 years of hands-on experience with building semantic-layer business intelligence solutions including metrics, dashboards and data visualization * Bachelor's Degree or equivalent in Computer Science or Information Management * Minimum of 5 years of hands-on experience with data engineering including ETL and data warehousing PREFERRED QUALIFICATIONS: * Working experience with Tableau, Power BI and Alteryx * Working experience in the HCM or financial industry * Working experience with large or medium size companies * Expert problem solving skills to rapidly create ad-hoc queries to answer complex business questions or debug data issues * Experience developing complex queries against normalized and dimensional data models * Ability to work co-operatively as part of a team, as well as independently Excellent verbal and written communication skills #LITECH #LI-VB1 We're designing a better way to work, so you can achieve what you're working for. Consistently named one of the 'Most Admired Companies' by FORTUNE® Magazine, and recognized by DiversityInc® as one of the 'Top 50 Companies for Diversity,' ADP works with more than 740,000 organizations across the globe to help their people work smarter, embrace new challenges, and unleash their talent. "Always Designing for People" means we're creating platforms that will transform how great work gets done, so together we can unlock a world of opportunity. At ADP, we believe that diversity fuels innovation. ADP is committed to equal employment opportunities regardless of race, color, genetic information, creed, religion, sex, sexual orientation, gender identity, lawful alien status, national origin, age, marital status, or protected veteran status. We support an inclusive workplace where associates excel based on personal merit, qualifications, experience, ability, and job performance. ADP Tempe AZ

Sr QA Engineer I - ETL / Data Warehouse

Bank Of The West