Sr. Solutions Consultant – System/data Integration at Micropinnacle Technology Corporation in Metro Manila
Job Description:The primary function of the Sr. Solutions Consultant 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.ResponsibilitiesOn premise or cloud deployment of the Enterprise Data Integration Solution or a portion of itDesign and develop long term data architecture for data integration following best practicesParticipate in the high level design of processes for governing the identification, collection, and use of firm metadataTake steps to assure metadata accuracy and validityEstablish methods and procedures for tracking data quality, completeness, redundancy, and improvementAnalyze data sources and determine process/approach for managing them in a central data warehouse and data martsHelp in understand reporting and analytics requirements, translating them into Database designDesign and develop ETL to load the data warehouse and data marts, utilizing reusable design componentsTune ETL for efficiencyMap data sources, data movement, interfaces, and analytics, with the goal of ensuring data qualityReview and recommend any necessary changes in process written by other database developersPerform unit and integration testing to meet requirements and make corrective changes as necessaryLinux/Unix system installation, configuration, and administrationResponsible 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 DatabaseAdministrate 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 environmentSchedule and manage jobs in a complex environmentMaintain best practices on managing systems and services across all environmentsWorks alongside business analysts to define, collect, and pre-process requirements from stakeholders and translate it into a solutionDevelops a keen understanding of organizational requirements and business processes
Able to manage, assist and motivate group of developersQualifications: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 developerProfessional Linux/Unix Systems Admin experience as well as a firm grasp of networking fundamentalsExtensive experience in ETL design/development, Attunity, SSIS, Talend, and stored procedures or other related ETL toolsStrong knowledge of ETL process/design as well as data modelling, both relational and dimensionalExperience 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 warehousesExperience working with relational databases MSSQL, MYSQL, Oracle, PostgreSQLExperience with containerization technologies (Docker and Kubernetes) prefferedPrior work experience in an Internet/SaaS company is a plusUnderstanding of Business Intelligence tools, dimensional modellingKnowledge 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 likeKnowledge of Software Development Life Cycle (Agile, Waterfall, XP, RAD)Strong Analytical SkillsExperience with Business Intelligence software is an advantageExperience with administration and execution of an Attunity Replicate and Compose environment is an advantage'); }else{ //ambient pc code // document.write(' var gax_wid = 1464591839; var gax_zid = 1501224957; var gax_w =640; var gax_h =360; var gax_skip =5; var gax_flash =true; var gax_content_id = ".detail"; var gax_position=0; '); }We know that resume is a must to apply for a job. If you don't have one or yours is already obsolete. HireMe.ph gives you free editable resume templates here.
