What's this role about?
As a Snowflake developer, you will be working across all components of Snowflake involved in a typical data engineering, data warehousing and reporting portfolio. You would be working in a team of developers fostering a culture of support and collaboration.
Here's how you'll contribute:
You will contribute to the role by:
· Ingesting data from various sources and building scalable data model in Snowflake.
· Creating/maintaining ETL pipeline with Informatica Power Center
Skills required to contribute:
5-7 Years of Data and Analytics experience with minimum 3+ years in Snowflake Cloud Data warehousing
1. Excellent communication and interpersonal skills.
2. Extensive experience in Snowflake – Virtual warehouse (Compute), Data modeling & storage including LDM/PDM design, data loading/unloading and data sharing, SnowSQL (CLI) as well as Snowflake Internals and integrations, SnowPipe implementation, S3 Internal data copy/movement, Snowflake security including readers and consumers accounts.
3. Advance SQL knowledge and hands on experience on complex queries writing using with Analytical functions, Troubleshooting, problem solving and performance tuning of SQL queries accessing data warehouse as well as Strong knowledge on stored procedures
4. 4+ Years of experience in Informatica 10.x & above with all modules including ETL design & development and troubleshooting / debugging, Repository Manager, Strong experience in Informatica Mapping Designer (Mapping & Mapplets creations using all Transformations) and Workflow Designer (Session & Task implementation and Job scheduling)
5. Good experience in Requirements Analysis and Solution Architecture Design, Data modelling, ETL, data integration and data migration design
6. Well versed with Waterfall, Agile, Scrum and similar project delivery methodologies.
7. Experienced in internal as well as external stakeholder management
8. SnowPro-Core / SnowPro-Advanced certification will be added advantage.
9. Nice to have skills: Working experience in Reporting technologies like Tableau or Power BI and Open source stack Pyspark, Python etc.
10. Good to have Hi-Tech manufacturing domain experience
Advantage Zensar
We are a technology consulting and services company with 11, 500+ associates in 30+ global locations. More than 145 leading enterprises depend on our expertise to be more disruptive, agile, and competitive. We focus on conceptualizing, designing, engineering, marketing, and managing digital products and experiences for high-growth companies looking to disrupt through innovation and velocity.
Zensar Technologies is an Equal Employment Opportunity (EEO) and Affirmative Action Employer, encouraging diversity in the workplace. Please be assured that we will consider all qualified applicants fairly, regardless of race, creed, color, ancestry, religion, sex, national origin, citizen status, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veterans’ status.
Zensar is a place where you are free to express yourself in an environment that values individuality, nurtures development and is mindful of wellbeing. We put our people and customers at the center of everything that we do. Our core values include:
• Putting people first
• Client-centricity
• Collaboration Grow. Own. Achieve. Learn. with Zensar: www.youtube.com/watch?v=i2NZsiQqVnU Visit www.zensar.com to know more.
Ready to think velocity?
Put in details of how you want the candidate to apply. Add links to the portals, mention email ID. Can we also have links to a process guide, that we can direct the candidate to?
ResponsibilitiesWhat's this role about?
As a Snowflake developer, you will be working across all components of Snowflake involved in a typical data engineering, data warehousing and reporting portfolio. You would be working in a team of developers fostering a culture of support and collaboration.
Here's how you'll contribute:
You will contribute to the role by:
· Ingesting data from various sources and building scalable data model in Snowflake.
· Creating/maintaining ETL pipeline with Informatica Power Center
Skills required to contribute:
5-7 Years of Data and Analytics experience with minimum 3+ years in Snowflake Cloud Data warehousing
1. Excellent communication and interpersonal skills.
2. Extensive experience in Snowflake – Virtual warehouse (Compute), Data modeling & storage including LDM/PDM design, data loading/unloading and data sharing, SnowSQL (CLI) as well as Snowflake Internals and integrations, SnowPipe implementation, S3 Internal data copy/movement, Snowflake security including readers and consumers accounts.
3. Advance SQL knowledge and hands on experience on complex queries writing using with Analytical functions, Troubleshooting, problem solving and performance tuning of SQL queries accessing data warehouse as well as Strong knowledge on stored procedures
4. 4+ Years of experience in Informatica 10.x & above with all modules including ETL design & development and troubleshooting / debugging, Repository Manager, Strong experience in Informatica Mapping Designer (Mapping & Mapplets creations using all Transformations) and Workflow Designer (Session & Task implementation and Job scheduling)
5. Good experience in Requirements Analysis and Solution Architecture Design, Data modelling, ETL, data integration and data migration design
6. Well versed with Waterfall, Agile, Scrum and similar project delivery methodologies.
7. Experienced in internal as well as external stakeholder management
8. SnowPro-Core / SnowPro-Advanced certification will be added advantage.
9. Nice to have skills: Working experience in Reporting technologies like Tableau or Power BI and Open source stack Pyspark, Python etc.
10. Good to have Hi-Tech manufacturing domain experience
Advantage Zensar
We are a technology consulting and services company with 11, 500+ associates in 30+ global locations. More than 145 leading enterprises depend on our expertise to be more disruptive, agile, and competitive. We focus on conceptualizing, designing, engineering, marketing, and managing digital products and experiences for high-growth companies looking to disrupt through innovation and velocity.
Zensar Technologies is an Equal Employment Opportunity (EEO) and Affirmative Action Employer, encouraging diversity in the workplace. Please be assured that we will consider all qualified applicants fairly, regardless of race, creed, color, ancestry, religion, sex, national origin, citizen status, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veterans’ status.
Zensar is a place where you are free to express yourself in an environment that values individuality, nurtures development and is mindful of wellbeing. We put our people and customers at the center of everything that we do. Our core values include:
• Putting people first
• Client-centricity
• Collaboration Grow. Own. Achieve. Learn. with Zensar: www.youtube.com/watch?v=i2NZsiQqVnU Visit www.zensar.com to know more.
Ready to think velocity?
Put in details of how you want the candidate to apply. Add links to the portals, mention email ID. Can we also have links to a process guide, that we can direct the candidate to?
Qualifications5-7 Years of Data and Analytics experience with minimum 3+ years in Snowflake Cloud Data warehousing
About UsAt Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.
We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.
