senior solutions Architect job at micropinnacle technology corporation in makati | workbankMicropinnacle Technology Corporation

The primary function of the Sr. Solutions Architect is to fulfill a key role as a team lead in developing and delivering of MTC's Enterprise Data Integration Solution. These responsibilities extend to planning, designing, coding, testing and documenting solutions for specific industries. The candidate will work as a hands-on lead developer working directly on data integration solution, data warehouse and back office data management system on cloud or on premise.
RESPONSIBILITIES
On premise or cloud deployment of the Enterprise Data Integration Solution or a portion of it
Design and develop long term data architecture for data integration following best practices
Participate in the high level design of processes for governing the identification, collection, and use of firm metadata
Take steps to assure metadata accuracy and validity
Establish methods and procedures for tracking data quality, completeness, redundancy, and improvement
Analyze data sources and determine process/approach for managing them in a central data warehouse and data marts
Help in understand reporting and analytics requirements, translating them into Database design
Design and develop ETL to load the data warehouse and data marts, utilizing reusable design components
Tune ETL for efficiency
Map data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality
Review and recommend any necessary changes in process written by other database developers
Perform unit and integration testing to meet requirements and make corrective changes as necessary
Linux/Unix system installation, configuration, and administration
Responsible for the configuration and administration of containerization technologies such as Kubernetes and Dockers
Responsible for development of data integration jobs from SAP or other ERP or any supported data sources to a target Relational Database
Administrate and monitor the data integration environment (Dev/QA/Prod)
Call attention to and deal with errors, failed load, other issues etc.
Provide advice to the group on Data Integration Solutions capabilities and weaknesses in the given environment
Schedule and manage jobs in a complex environment
Maintain best practices on managing systems and services across all environments
Works alongside business analysts to define, collect, and pre-process requirements from stakeholders and translate it into a solution
Develops a keen understanding of organizational requirements and business processes
Able to manage, assist and motivate group of developers
QUALIFICATIONS
A minimum of a Bachelor's degree in Management Information System, Computer Science or other related discipline.
A minimum of 8 years technical experience as a Database/ETL developer
Professional Linux/Unix Systems Admin experience as well as a firm grasp of networking fundamentals
Extensive experience in ETL design/development, Attunity, SSIS, Talend, and stored procedures or other related ETL tools
Strong knowledge of ETL process/design as well as data modelling, both relational and dimensional
Experience with cloud deployment: AWS, Azure, Google Cloud
Experience with Data Warehousing, Data Lake and Data Pipeline architectures and methodologies
Background with data warehouse automation solutions or used ETL tools to build data warehouses
Experience working with relational databases MSSQL, MYSQL, Oracle, PostgreSQL
Experience with containerization technologies (Docker and Kubernetes) prefrered
Prior work experience in an Internet/SaaS company is a plus
Understanding of Business Intelligence tools, dimensional modelling
Knowledge in cloud-based data warehousing like snowflake, Amazon Redshift, Google BigQuery, IBM DB2, Azure SQL DW etc.
Experience in business intelligence platforms and software such as Qlik, Tableau, SPSS, SAS and the like
Knowledge of Software Development Life Cycle (Agile, Waterfall, XP, RAD)
Strong Analytical Skills
Experience with Business Intelligence software is an advantage
Experience with administration and execution of an Attunity Replicate.
Workbank

Makati City, Metro Manila
Permanent
Full-time