Senior Technical Architect

Job Detail

  • Job ID 8046
  • Career Level  Others
  • Experience  12-15 Years
  • Industry  Finance
  • Qualifications  Degree Bachelor

Job Description

About The Job:

  • Role: Senior Technical Architect
  • Location: Pune
  • Experience: 14 to 20 Years
  • Educational Background: Any Graduate
  • Skills Required: Snowflake, AWS Glue, Matillion

Key Responsibilities:

  • Experience in end-to-end data analytics strategy, design and architecture for AWS Cloud Services (EC2, SQS, S3, Glue,
  • MWAA (Airflow), Snowflake, Matillion Cloud, and Visual Code Studio.
  • 10+ years of experience in DWH, including 4 years of experience in implementing DWH on Snowflake.
  • Strong knowledge of AWS Platform.
  • Design and develop/review ETL programs primarily using AWS Glue and Matillion Cloud.
  • Design and implementation of Data Platform projects in a large-scale enterprise data warehouse environment.
  • At least 2 successful implementations of AWS Glue with Snowflake or Matillion with Snowflake.
  • Technical reviews, data validation & end-to-end testing of ETL objects, source data analysis, and data profiling.
  • Handle multiple projects in parallel and deliver solution designs while working closely with the architecture team.
  • Understand business requirements and convert them into detailed technical specifications for data models and ETL programs.
  • Collaborate with business users to create architecture in alignment with business needs.
  • Lead in developing project requirements for end-to-end data integration processes using ETL for structured, semi-structured, and unstructured data.
  • Experience with data security and data access controls and design in Snowflake.
  • Design the data warehouse and provide guidance to the team in implementation using Snowflake SnowSQL.
  • Experience in migrating data from on-premise databases and files to Snowflake.
  • Strong understanding of ELT/ETL and integration concepts and design best practices.
  • Experience in performance tuning of snow pipelines and troubleshooting quickly.
  • Experience in Snowsql, Snowpipe, and Snowpark.

Primary Skillset:

  • AWS Glue
  • MWAA (Airflow)
  • Snowflake
  • Matillion

Required skills