Associate Program Manager Roles and responsibilities:
- Understand clients requirement and provide effective and efficient solution in Snowflake.
- Understanding data transformation and translation requirements and which tools to leverage to get the job done.
- Ability to do Proof of Concepts (POCs) in areas that need R&D on cloud technologies.
- Understanding data pipelines and modern ways of automating data pipeline using cloud based Testing and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions.
- Perform data quality testing and assurance as a part of designing, building and implementing scalable data solutions in SQL.
Technical and Functional Skills:
- Masters / Bachelors degree in Engineering, Analytics, or a related field.
- Total 7+ years of experience with relevant 4+ years of Hands-on experience with Snowflake utilities- SnowSQL, SnowPipe, Time travel, Replication, Zero copy cloning.
- Strong working knowledge on Python.
- Understanding data transformation and translation requirements and which tools to leverage to get the job done Understanding data pipelines and modern ways of automating data pipeline using cloud based Testing and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions.
- In-depth understanding of data warehouse and ETL tools.
- Perform data quality testing and assurance as a part of designing, building and implementing scalable data solutions in SQL.
- Experience Snowflake APIs is mandatory.
- Candidate must have strong knowledge in Scheduling and Monitoring using Airflow DAGs.
- Strong experience in writing SQL Queries, Joins, Store Procedure, User Defined Functions.
- Should have sound knowledge in Data architecture and design.
- Should have hands on experience in developing Python scripts for data manipulation.
- Snowflake snowpro core certification.
- Developing scripts using Unix, Python, etc.
