Product Architect Snowflake cloud data warehouse Dublin, OH
Snowflake cloud data warehouse, Data modelling, ELT using Snowflake, implementing complex stored procedures and standard DWH and ETL concepts.
Experience level: Mid-senior
Experience required: 10 Years
Education level: Bachelor’s degree
Job function: Information Technology
Industry: Information Technology and Services
Pay rate: View hourly pay rate
Total position: 1
Relocation assistance: No
Visa sponsorship eligibility: No
Must have experience with at least two end-to-end implementations of Snowflake cloud data warehouse.
Job Description:
- Expertise in Data modelling, ELT using Snowflake, implementing complex stored procedures and standard DWH and ETL concepts.
- Experience in Data Migration from RDBMS to cloud data warehouse.
- Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, zero copy clone, time travel, and understanding how to use these features.
- Experience in Data Masking & Security features of Snowflake.
- Experience in handling Structured & semi-structured data (JSON, XML).
- Experience with AWS or Azure data storage and management technologies such as S3 and ADLS.
- Must have experience with Agile development methodologies.
- Strong written communication skills. Is effective and persuasive in both written and oral communication.
- Exposure or expertise working in the healthcare domain will be an added advantage.
- Study as and TO planning along with TCS and customer stakeholders.
- Build solution architecture, design, reviews.
- Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
- Implementation of this architecture.
- Provide resolution to an extensive range of data pipeline-related problems, proactively and as issues surface.
- Work with development team and customer teams during the entire execution.
- Represent as architect to customer on various forums during the lifecycle of the project.
- Co-ordinate with offshore team during project execution.