ETL Matillion Architect

Company: ApTask
Location: East Brunswick
Posted on: May 25, 2023

Job Description:

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 Azure Snapsys data warehouses/databases 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 Azure Snapsys 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 environment
  
• Triage the Production issues and work on the code fixes
  
• Experience with Matillion configuration/Administration and Security setup will be added advantage.
  
• Good understanding of Snapsys with respect to Architect and best practices
  
• Should be very Good Team Player with Excellent verbal and written communication skills.
  
  

Keywords: ApTask, East Brunswick , ETL Matillion Architect, Professions , East Brunswick, New Jersey