QUALITY ASSURANCE SPECIALIST

Metrobank Group

Pasay

On-site

PHP 600,000 - 900,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Metrobank is seeking a Quality Assurance Specialist to ensure data loaded in the Data Warehouse is timely and reliable for BI and analytics. You will manage ETL processes, source data acquisition, and data object migrations.

The role requires at least 3 years in SQL, database scripting and QA testing, with strong analytical and problem-solving skills. You will collaborate with source system owners and document data acquisitions, tests, and controls to support regulatory and internal reporting.

Qualifications

  • Bachelor’s degree in IT, Computer Science, Mathematics, Statistics, Data Management, or related field.
  • At least 3 years of experience in SQL, database scripting, and QA testing.
  • Strong analytical, data analysis, and problem-solving skills.
  • Knowledgeable in data flows, requirements gathering, testing, and documentation.
  • Experience managing multiple projects simultaneously.
  • Exposure to enterprise-wide or bank-wide projects is an advantage.

Responsibilities

  • Ensure that data loaded in the DW system are timely, reliable for business intelligence and analytics.
  • Handle data acquisition from different source systems/units as well as enhancements of existing ETL/data extract programs and migrate data objects.
  • Prepare the necessary documents for data acquisition/enhancement (e.g., Extract Specification document, Enhancement Request).
  • Participate in testing of acquired data/enhancement and its production deployment.
  • Coordinate with source system owners regarding data acquisition, mapping of source fields, and enhancements to ETL/data extract programs.
  • Maintain and update hierarchies such as General Ledger, Responsibility Center, Product, etc.
  • Administer and control user access to Data Warehouse applications and support end-users by monitoring database sessions.
  • Investigate and resolve data errors encountered during the ETL process and recommend enhancements.

Skills

Analytical thinking
Problem-solving
Data analysis
Requirements gathering

Education

Bachelor’s degree in IT/CS/Mathematics/Statistics/Data Management

Tools

SQL
Database scripting
QA testing

Job description

Here at Metrobank, we don't simply hire employees—we hone future leaders. We provide opportunities that enhance your skills and unlock your talents, helping you evolve into a well-rounded individual. We supply you with all the pieces you need to do your best work, unleashing your full potential to help you secure your future and lead a fulfilling career. And with Metrobank's strong heart for the community, you have the chance to give back and make worthwhile contributions to our nation's economic and social development.

With Metrobank, a meaningful life is within your reach!

Position Title: Quality Assurance Specialist

Job Summary:

  • Ensure that data loaded in the DW system are timely, reliable for business intelligence and analytics. Handle/monitor the Extract, Transfer and Load (ETL) process and resolve problems/issues/errors encountered.
    Handle data acquisition from different source systems/units as well as enhancements of existing ETL/data extract programs. Administer the migration of data objects. Conduct data clean-up to improve accuracy and completeness of data.

Role Exposure:

  • Ascertain that metadata in the data warehouse are synchronized with the production sources and transformed in accordance with the business rules governing the data acquisition.
  • Ascertain that all databases are updated and useful.
  • Devise query scripts for detecting and identifying possible data errors.
  • Maintain various look up tables used in the transformation and conversion of data in accordance with regulatory and internal reports requirements on a regular basis.
  • Conduct data cleanup/data validation routines and error-trapping procedures to further improve data quality.
  • Coordinate with the source system owners regarding data acquisition; mapping of source fields; enhancement to existing ETL/data extract programs; or change in the source systems to further improve accuracy, completeness and timeliness of data.
  • Prepare the necessary documents for the data acquisition/enhancement, e.g. Extract Specification document, Enhancement Request, etc.
  • Participate in the testing of acquired data/enhancement and its implementation to production.
  • Ensure that all acquired data/enhancement are properly documented and passed the necessary processing controls, such as validation, system/parallel test and UAT.
  • Handle the migration of all procedures, tables, report definition file (RDF), control file (CTL), log file, forms/screens, etc. to production or UAT environment.
  • Investigate and resolve data errors encountered during the ETL process.
  • Recommend enhancements to further improve the ETL process.
  • Assist the Database Administrator in maintaining the data tables and determining data retention to ensure efficient end-user access.
  • Handle housekeeping of processed extract files and maintain database file server to maximize data storage space.
  • Maintain and update the various hierarchies such as General Ledger, Responsibility Center, Product, etc.
  • Administer and control user access to specific Data Warehouse applications.
  • Provide support to end-users by monitoring database sessions.
  • Handle the month-end reconciliation of general versus subsidiary ledger of selected accounts in coordination with other units of the bank.

Qualifications:

  • Bachelor’s degree in IT, Computer Science, Mathematics, Statistics, Data Management, or related field
  • At least 3 years of experience in SQL, database scripting, and QA testing
  • Strong analytical, data analysis, and problem-solving skills
  • Knowledgeable in data flows, requirements gathering, testing, and documentation
  • Experience managing multiple projects simultaneously
  • Exposure to enterprise-wide or bank-wide projects is an advantage
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

QUALITY ASSURANCE SPECIALIST
QUALITY ASSURANCE SPECIALIST

Metrobank • Taguig

On-site
PHP 390,600 - 669,600
DATA QUALITY ENGINEER
DATA QUALITY ENGINEER

Metrobank • Taguig

On-site
PHP 400,000 - 700,000
DATA QUALITY ENGINEER
DATA QUALITY ENGINEER

Metrobank Group • Manila

On-site
PHP 600,000 - 1,000,000
ETL & Data Quality Assurance Specialist
ETL & Data Quality Assurance Specialist

Metrobank • Taguig

On-site
PHP 390,600 - 669,600
Data Quality & ETL QA Specialist
Data Quality & ETL QA Specialist

Metrobank Group • Pasay

On-site
PHP 600,000 - 900,000
DATA GOVERNANCE OFFICER
DATA GOVERNANCE OFFICER

Metrobank • Taguig

On-site
PHP 600,000 - 900,000
DATA INTELLIGENCE ENGINEER
DATA INTELLIGENCE ENGINEER

Metrobank • Makati

On-site
PHP 800,000 - 1,200,000
DATA INTELLIGENCE ENGINEER
DATA INTELLIGENCE ENGINEER

Metrobank • Pasay

On-site
PHP 900,000 - 1,300,000
DATA GOVERNANCE OFFICER
DATA GOVERNANCE OFFICER

Metrobank • Manila

On-site
PHP 600,000 - 900,000
MDM Engineer (Master Data Management)
MDM Engineer (Master Data Management)

BDO Unibank, Inc. • Philippines

On-site
PHP 800,000 - 1,100,000
Top locations