MakatiAbout Security BankWe are the Philippines’ largest independent bank, having won countless awards over the years including the most prestigious industry award in both 2015 and 2016 the Bank of the Year Philippines by The Banker.
We’re changing how people bank. From the moment customers enter our branches to their experience online, we make them feel valued and empowered.
Now, with more than 300 branches spanning the country, BetterBanking has become the gold standard in improving the banking lives of millions of Filipinos.
But we’re far from done. In our constant pursuit of excellence and improvement, we create teams that support our business and each other.
SPECIFIC DUTIES AND RESPONSIBILITIES Analyzes source data against business requirement and understands the business needs, then designs, develops and implements highly efficient, highly scalable ETL processes.
Develops, maintains and supports SQL Server Integration Services (SSIS) packages related to the extraction, transformation and loading (ETL) process using Microsoft SQL ServerWrites T-
SQL queries, complex stored procedures, indexes, and functions to perform database tasksResponsible for data profiling as well as SQL and database tuning / optimization.
Diagnoses ETL and database related issues; performs root cause analysis and recommends corrective actions.Provides appropriate documentation supporting implementation and maintenance of the above tasks.
QUALIFICATIONS : Bachelor's Degree in Computer Science or related fieldMust have at least 5 years’ work experience with at least 3 years in SQL Server Integration Services (SSIS)Experienced in complex ETL transformationsMust have SQL development experience in environments that may include a combination of SQL Server, Oracle, MySQL and DB2 (AS / 400)Able to handle different RDBMS such as Microsoft SQL Server 2016, Oracle, DB2, SybaseKnowledgeable in Windows Batch Scripting, and T-
SQL ScriptingExperience in processing various source and destination typesAble to navigate unfamiliar data models of all types and to develop methods for reliably and accurately extracting dataKnowledge in Agile methodology is a plusKnowledge in Data Vault Model is a plus.
SQL performance tuning expertise and other SQL Server DBA skills preferred.Windows Batch scripting preferred, Perl Scripting (nice to have).