Introduction
In this role you'll work in one of our IBM Consulting Client Innovation Centers (Delivery Centers) where we deliver deep technical and industry expertise to a wide range of public and private sector clients around the world. Our delivery centers offer our clients locally based skills and technical expertise to drive innovation and adoption of new technology.
Your role and responsibilities
- Expertise in designing and implementing scalable data warehouse solutions on Snowflake including schema design performance tuning and query optimization.
- Strong experience in building data ingestion and transformation pipelines using Talend to process structured and unstructured data from various sources.
- Proficiency in integrating data from cloud platforms into Snowflake using Talend and native Snowflake capabilities.
- Hands-on experience with dimensional and relational data modelling techniques to support analytics and reporting requirements.
- Understanding of optimizing Snowflake workloads including clustering keys caching strategies and query profiling.
- Ability to implement robust data validation cleansing and governance frameworks within ETL processes.
- Proficiency in SQL and/or Shell scripting for custom transformations and automation tasks
Required education
Bachelor's Degree
Preferred education
Master's Degree
Required technical and professional expertise
- Expertise in designing and implementing scalable data warehouse solutions on Snowflake including schema design performance tuning and query optimization.
- Strong experience in building data ingestion and transformation pipelines using Talend to process structured and unstructured data from various sources.
- Proficiency in integrating data from cloud platforms into Snowflake using Talend and native Snowflake capabilities.
- Hands-on experience with dimensional and relational data modelling techniques to support analytics and reporting requirements
Preferred technical and professional experience
- Understanding of optimizing Snowflake workloads including clustering keys caching strategies and query profiling.
- Ability to implement robust data validation cleansing and governance frameworks within ETL processes.
- Proficiency in SQL and/or Shell scripting for custom transformations and automation tasks