Senior Matillion ETL 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