Previous Job
Previous
SDET/ETL Engineer(MDM)
Ref No.: 21-03005
Location: Iselin, New Jersey
 You will be part of QA Center of Excellence team for Enterprise Data Warehouse/Datahub/ETL testing projects. Primary responsibilities are to understand requirements & data mapping, define test plan, design review, develop test cases & technical test scripts including test automation, conduct reviews and execute test cases in sprints (Agile).
You will interact with Dev team, BSA, Data Analyst, and Data architects to understand project requirements, technical design, downstream systems impact and data mapping. You will 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 MDM, Digital, Marketing, Transactional systems data ingestion through batch and streaming framework.
  • Perform detailed Data Analysis, Data Reconciliation and Data Integrity in databases and file systems using SQL, Hive, Spark and other programming languages/tools.
  • Validate the data ingestion pipeline built using NIFI, Spark, Kafka, Ariflow and Denodo.
  • Create test data in various file formats an databases.
•Analyze the logs created by data ingestion jobs and report any failures and performance issues in detail.
•Build reusable standard TCOE automation frameworks for functional, regression, performance and E2E testing using DevOps tools and scripts.
Define and document software test plan and perform several phases of testing cycles and record test results, test metrics and track defects using Jira-Xray in order to ensure applications, products and/or releases are in compliance with Bank of the West`s QA standards.
•Partner end-to-end with Product Managers, Architects, Tech Leads, Data Governance team to understand business requirements to recommend quality improvement best practices and processes.
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.