5+ years of experience in the implementation of BI projects in a large-scale enterprise data
warehouse environment and at least one successful implementation Matillion with Snowflake
is a must.
• Handle multiple projects in parallel, Participate and deliver Solution design, working closely
with the architecture team.
• Should have experience API integration using Matillion and this is a must skill
• Understand business requirements and convert them into detailed technical specifications
for Data models and ETL programs.
• Design the Logical and Physical data models using Dimensional modeling techniques.
• Design and Develop/Review ETL programs primarily using Matillion and Python.
• Coach and guide the technical team in terms of the development of ETL jobs.
• Performance improvement & tuning of Matillion mappings.
• Technical reviews, Data validation & end - 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 the 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.
Non–Technical Skills:
• Communication.
• Interpersonal Skills.
• Problem-Solving.
• Time Management.
• Flexibility to work in shifts if required.