Be #InGoodHands with Metrobank 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: <ul style="margin-left:0.375in;margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="margin-top:0.0px;margin-bottom:0.0px;vertical-align:middle;color:#3c3c3c;font-size:10.0pt">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.</li> </ul> Role Exposure: <ul style="margin-left:0.375in;margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">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.</li> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">Ascertain that all databases are updated and useful.</li> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">Devise query scripts for detecting and identifying possible data errors.</li> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">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.</li> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">Conduct data cleanup/data validation routines and error-trapping procedures to further improve data quality.</li> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">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.</li> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">Prepare the necessary documents for the data acquisition/enhancement, e.g. Extract Specification document, Enhancement Request, etc.</li> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">Participate in the testing of acquired data/enhancement and its implementation to production.</li> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">Ensure that all acquired data/enhancement are properly documented and passed the necessary processing controls, such as validation, system/parallel test and UAT.</li> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">Handle the migration of all procedures, tables, report definition file (RDF), control file (CTL), log file, forms/screens, etc. to production or UAT environment.</li> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">Investigate and resolve data errors encountered during the ETL process.</li> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">Recommend enhancements to further improve the ETL process.</li> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">Assist the Database Administrator in maintaining the data tables and determining data retention to ensure efficient end-user access.</li> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">Handle housekeeping of processed extract files and maintain database file server to maximize data storage space.</li> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">Maintain and update the various hierarchies such as General Ledger, Responsibility Center, Product, etc.</li> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">Administer and control user access to specific Data Warehouse applications.</li> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">Provide support to end-users by monitoring database sessions.</li> <li style="margin:0.0in 0.0in 1.0E-4pt 0.0px;line-height:107%;font-size:10.0pt;font-family:Calibri, sans-serif;text-indent:24.0px">Handle the month-end reconciliation of general versus subsidiary ledger of selected accounts in coordination with other units of the bank.</li> </ul> Qualifications: <ul style="margin-left:0.375in;margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="font-size:10.0pt">Bachelor’s degree in IT, Computer Science, Mathematics, Statistics, Data Management, or related field</li> <li style="font-size:10.0pt">At least 3 years of experience in SQL, database scripting, and QA testing</li> <li style="font-size:10.0pt">Strong analytical, data analysis, and problem-solving skills</li> <li style="font-size:10.0pt">Knowledgeable in data flows, requirements gathering, testing, and documentation</li> <li style="font-size:10.0pt">Experience managing multiple projects simultaneously</li> <li style="font-size:10.0pt">Exposure to enterprise-wide or bank-wide projects is an advantage</li> <li style="font-size:10.0pt">Detail-oriented and highly organized</li> </ul> Other Details: Rank: Junior Officer Unit: FCS/ EDMGD Location: Metropark, Pasay Work Set-up: Monday to Friday, Onsite

QUALITY ASSURANCE SPECIALIST (Taguig, Philippines) @ MBTCHCM

About this role

Ready to apply?