AWS Snowflake Architect

We at Coforge are hiring an AWS Snowflake Architect with following skillset :

• Extensive experience ( 8 + years) in data architecture and engineering, with a proven track record in large – scale data transformation programs, ideally in insurance or financial services.
• Proven experience in architecting and implementing advanced data solutions using Snowflake on AWS.
• Expertise in design and orchestrating data acquisition pipelines using AWS Glue for ETL/ELT , Snowflake Open Flow and Apache Airflow for workflow automation, enabling seamless ingestion of different data from diverse sources.
• Proven experience in DBT to manage and automate complex data transformations within Snowflake, ensuring modular, testable, and version - controlled transformation logic.
• Experience in implementing the lake house solution, Medallion architecture for financial or insurance carriers.
• Experience in optimizing and tune Snowflake environments for performance, cost, and scalability, including query optimization and resource management.
• Experience in architecting/lead migration of workloads from Cloudera to Snowflake.
• Experience in converting policy/data conversion from legacy to modern platform
• Deep expertise in Snowflake (Snowpro advanced certification preferred), with hands - on experience delivering Snowflake as an enterprise capability.
• Hands - on experience with AWS Glue for ETL/ELT, Apache Airflow for orchestration, and dbt for transformation (preferably deployed on AWS ECS).
• Proficiency in SQL, data modeling, ETL/ELT processes, and scripting languages (Python/Java).