Senior Technical Architect
- Full time
- Pune IN
- @Birlasoft
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