Matillion ETL - Developer

The purpose of the role is to support process delivery by ensuring daily performance of the Production Specialists, resolve technical escalations and develop technical capability within the Production Specialists.

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

• Handle technical escalations through effective diagnosis and troubleshooting of client queries
  • Manage and resolve technical roadblocks/ escalations as per SLA and quality requirements
  • If unable to resolve the issues, timely escalate the issues to TA & SES
  • Provide product support and resolution to clients by performing a question diagnosis while guiding users through step-by-step solutions
  • Troubleshoot all client queries in a user-friendly, courteous and professional manner
  • Offer alternative solutions to clients (where appropriate) with the objective of retaining customers’ and clients’ business
  • Organize ideas and effectively communicate oral messages appropriate to listeners and situations
  • Follow up and make scheduled call backs to customers to record feedback and ensure compliance to contract SLA’s

• Build people capability to ensure operational excellence and maintain superior customer service levels of the existing account/client
  • Mentor and guide Production Specialists on improving technical knowledge
  • Collate trainings to be conducted as triage to bridge the skill gaps identified through interviews with the Production Specialist
  • Develop and conduct trainings (Triages) within products for production specialist as per target
  • Inform client about the triages being conducted
  • Undertake product trainings to stay current with product features, changes and updates
  • Enroll in product specific and any other trainings per client requirements/recommendations
  • Identify and document most common problems and recommend appropriate resolutions to the team
  • Update job knowledge by participating in self learning opportunities and maintaining personal networks