REMOTE-Snowflake Architect (Migration of Oracle to Snowflake)

[Shashank kumar]

Hi Professionals,

Hope you all doing great,

Kindly share suitable Resumes for this role,

Interview next week.

Role: Snowflake architect 

Duration:  6 Months +

Location : Remote 

 snowflake Architect – Responsibilities (Oracle to Snowflake Migration)

1. Lead the end-to-end migration of large-scale Oracle databases to Snowflake, including assessment, planning, design, and execution.
2. Analyze existing Oracle schemas, stored procedures, and data models to design optimized Snowflake architecture and data pipelines.
3. Design and implement data migration strategy, including data extraction, transformation (ETL/ELT), and loading processes using tools like Informatica, Talend, dbt, or Python scripts.
4. Develop Snowflake objects such as databases, schemas, tables, views, stored procedures, UDFs, and materialized views to replicate Oracle functionality.
5. Ensure data quality, consistency, and integrity during migration by implementing robust validation and reconciliation processes.
6. Tune performance by optimizing Snowflake queries, clustering keys, partitioning, and leveraging caching mechanisms.
7. Implement security, access control, and role-based permissions in Snowflake, mapping from Oracle user models.
8. Collaborate with data engineers, DBAs, and stakeholders to gather requirements, resolve issues, and deliver scalable solutions.
9. Develop documentation for architecture, data flow, and transformation logic to support maintainability and future scalability.
10. Monitor and troubleshoot migration issues, providing support and guidance through resolution and post-migration optimization.
11. Stay current with Snowflake features, Oracle deprecation risks, and best practices in cloud data architecture.

Thanks.

Shashank

Millennium Software Inc.

sk.mille...@gmail.com