Job Description :
Job Description for Matillion Architect
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 Snowflake data warehouses/databases & Qlik for reporting 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 Snowflake 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.
Should be very Good Team Player with Excellent verbal and written communication skills.