Who are we?
For the past 20 years, we have powered many Digital Experiences for the Fortune 500. Since 1999, we have grown from a few people to more than 4000 team members across the globe that are engaged in various Digital Modernization. For a brief 1 minute video about us, you can check https://youtu.be/uJWBWQZEA6o.
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.
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 SnowPipe, 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.
Skills Required
- Bachelor's or Master's degree in Computer Science, Information Systems, or related field.
- Proven experience as a Data Architect or similar role focused on cloud-based data solutions.
- In-depth knowledge of Snowflake cloud data platform and components (Virtual Warehouses, Data Sharing).
- Expertise in Snowflake data modeling (star, snowflake, Data Vault 2.0) and ELT using SnowPipe.
- In-depth knowledge of Informatica PowerCenter, Informatica Cloud, Informatica Data Quality, and Informatica MDM.
- Hands-on experience designing and implementing ETL/ELT pipelines and data integration processes.
- Experience with data migration to Snowflake cloud data warehouse.
- Proficiency in SQL and other data querying languages.
- Strong understanding of data governance, data security, and data management best practices.
- Experience establishing data quality processes and performing data analysis.
- Experience with cloud infrastructure and services (AWS or Azure preferred).
- Excellent analytical, problem-solving, communication skills and ability to work with stakeholders at all levels.
What We Do
Photon.com has emerged as one of the world’s largest and fastest-growing Digital Agencies. We work with 40% of the Fortune 100 on their Digital initiatives and are known for our ability to integrate Strategy Consulting, Creative Design, and Technology at scale. Please visit www.photon.com to learn more about us, how we work, and our customer case studies. Digital Transformation Starts Here.
.png)
