Matillion ETL Lead

Job Description for 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

Snowflake 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 two Successful implementation Matillion with Snowflake

is must.

Problem management and RCA for recurring issues

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.

Secondary skills:

Snowflake