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.
What will you do?
- 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.
What are we looking for?
- 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.