Matillion Lead

Company: Diverse Lynx
Location: Remote
Posted on: May 24, 2023

Job Description:

Role - Matillion Architect I Matillion Lead Both are different positions



Location - Remote



Agency rate -80/hr



Note - Please don't submit more than 2 profiles in a day. Plese read the JD carefully and submit profiles accordingly.



The Senior Matillion ETL Architect will be working with the Enterprise IT team to maintain and develop data integration solutions to support our Analytics platform. The candidate will need to understand business and technical requirements and translate this into data integration designs and deliverables by working with Snowflake Architect. The solutions must align with EDW, Data mart and Dimensional modeling, ETL standards and guidelines. The data modeling and data integration solutions will be based on Matillion with Azure Snapsys data warehouses/databases platform. The position also requires supporting the Agile process in terms of Development ,testing,

deployment and post production support.



Essential Duties/Responsibilities



10+ years of experience in implementation of BI projects in a large-scale enterprise data

warehouse environment and at least one Successful implementation Matillion with Azure Snapsys is must.



Handle multiple projects in parallel, Participate and deliver Solution design, working closely with the architecture team



Understand business requirements and convert them into detail technical specifications for Data models and ETL programs



Design the Logical and Physical data models using the Dimensional modeling techniques.



Design and Develop/Review ETL programs primarily using Matillion, Python and R

Coach and guide the technical team in terms development of ETL jobs



Performance improvement & tuning of Matillion mappings.



Technical reviews, Data validation & end to end testing of ETL Objects, Source data analysis and data profiling.



Create necessary documentation as per the Standards and Update the project documentation.



Support QE on End-to-End testing and provide daily/weekly project status to the Project manager



Work with deployment team in the code migration across the environments

Triage the Production issues and work on the code fixes



Experience with Matillion configuration/Administration and Security setup will be added

advantage.



Good understanding of Snapsys with respect to Architect and best practices

Should be very Good Team Player with Excellent verbal and written communication skills.



Position 2 - Matillion Lead



The Senior Matillion ETL Lead will need to understand business and technical requirements and translate this into data integration designs and deliverables by working with Snowflake Architect. The solutions must align with EDW, Data mart and Dimensional modeling, ETL standards and guidelines.

The data modeling and data integration solutions will be based on Matillion with Azure Snapsys data warehouses/databases platform.

Essential Duties/Responsibilities

8+ years of experience in implementation of BI projects in a large-scale enterprise data warehouse environment and at least one Successful implementation Matillion with Azure Snapsys is must.

Understand business requirements and convert them into detail technical specifications for Data models and ETL programs

Design the Logical and Physical data models using the Dimensional modeling techniques.

Design and Develop/Review ETL programs primarily using Matillion and Python

Coach and guide the technical team in terms development of ETL jobs Performance improvement & tuning of Matillion mappings. Technical reviews, Data validation & end to end testing of ETL Objects, Source data analysis and data profiling. Create necessary documentation as per the Standards and Update the project documentation. Work with deployment team in the code migration across the environments Triage the Production issues and work on the code fixes Should be very Good Team Player with Excellent verbal and written communication skills.



Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.

Keywords: Diverse Lynx, Eugene , Matillion Lead, Other , Remote, Oregon