We are seeking a Snowflake Architect to play a crucial role in designing, implementing, and maintaining our clients' data platforms using the Snowflake cloud data platform, Informatica cloud, Azure and Oracle.
-
Design and develop scalable, high-performance data architectures on the Snowflake cloud data platform to meet the evolving business needs and data growth.
-
Lead the implementation of Snowflake-based data solutions, including data modeling, schema design, and data integration pipelines.
-
Optimize data storage, data retrieval, and query performance in Snowflake to ensure the efficient processing of large-scale datasets.
-
Implement and maintain robust data security practices, including data encryption, role-based access controls, and data privacy measures, to safeguard sensitive information.
-
Develop and maintain documentation of the data architecture, data flow and data models of the data warehouse appropriate for various audiences.
-
Provide direction on adoption of Cloud technologies (Snowflake) and industry best practices in the field of data warehouse architecture and modelling.
-
Take ownership of technical solutions from design and architecture perspective for projects in presales phase as well as on- going projects
-
Design end-to-end data integration architectures using Informatica, considering data sources, data transformation, data mapping, and data delivery to meet business objectives.
-
Possess a deep understanding of the Informatica platform, including PowerCenter, Data Quality, Master Data Management, and Informatica Cloud, and leverage its capabilities to design efficient and scalable data solutions.
-
Collaborate with data engineers and data analysts to define data mappings, transformation rules, and data workflows to ensure data accuracy and consistency.
-
Lead and participate in the development of ETL/ELT workflows using Informatica tools, optimizing data extraction, loading, and transformation processes.
-
Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
-
Proven experience as a Data Architect or similar role, with a focus on cloud-based data solutions.
-
In-depth knowledge of Snowflake cloud data platform and its components, such as Virtual Warehouses, Snowflake Data Sharing, etc.
-
In-depth knowledge of Informatica PowerCenter, Informatica Cloud, Informatica Data Quality, and other Informatica products.
-
Experience establishing data quality processes, performing data analysis, participating in technology implementation planning, implementing data integration processes.
-
Expertise in Snowflake data modeling in star, snowflake and data vault 2.0, ELT using Snow Pipe, implementing stored procedures and standard DWH and ETL concepts.
-
Create and maintain documentation of the data architecture, flow, and models of the data warehouse for various stakeholders.
-
Hands-on experience in data modeling, data integration, and ETL/ELT processes.
-
Design and implement scalable and streamlined data pipelines to address key business use cases and to meet data SLA requirements.
-
Proficiency in SQL and other data querying languages.
-
Collaborate with data engineers and analysts to establish data mappings, transformation rules, and workflows for ensuring data accuracy and consistency.
-
Experience in Data Migration to Snowflake cloud data warehouse.
-
Strong understanding of data governance, data security, and data management best practices.
-
Experience with cloud infrastructure and services, preferably AWS or Azure.
-
Excellent analytical, problem-solving, and communication skills.
-
Ability to work collaboratively in a team environment and interact with stakeholders at all levels of the organization.