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.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 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 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) preffered•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 and Compose environment is an advantage
