Quality Assurance Specialist (ETL)

Metrobank; Pasay; On-site; PHP 600,000 - 900,000; Full time

Job summary

Metrobank is hiring for a Data Warehouse/ETL Specialist to ensure timely, reliable data feeding our BI and analytics platforms. You will manage ETL workflows, source-system data acquisitions, and enhancements to existing data extract programs.

Responsibilities include data quality checks, metadata synchronization, and documentation. A strong foundation in SQL, data scripting, and QA testing is essential for success in this role.

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.

Responsibilities

• Ensure data in the DW system are timely and reliable for BI/analytics.
• Handle ETL processes and resolve issues encountered.
• Administer data acquisition from multiple source systems and enhancements of ETL/data extract programs.
• Prepare documentation for data acquisition/enhancement and participate in testing and implementation.

Skills

SQL

Database scripting

QA testing

Data analysis

Education

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

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!

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. He/She will also 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