Expertise in Snowflake - data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL concepts
Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features
Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns
Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)
Experience with data security and data access controls and design
Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
Build processes supporting data transformation, data structures, metadata, dependency and workload management
Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot
Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface
Must have expertise in AWS or Azure Platform as a Service (PAAS)
Certified Snowflake cloud data warehouse Architect (Desirable)
Should be able to troubleshoot problems across infrastructure, platform and application domains
Must have experience of Agile development methodologies
Strong written communication skills.
Should be effective and persuasive in both written and oral communication
Candidates should be flexible / willing to work across this delivery landscape which includes and not limited to Agile Applications Development, Support and Deployment.
Applicants for employment in the US must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in the US by Capgemini.
Delivery Architects assess a project's technical feasibility, as well as implementation risks. They are responsible for designing and implementing a project's technical architecture. They define the structure of a system, its interfaces, and the principles that guide its organization, software design and implementation. The scope of the Delivery Architect's role is bounded by the business issue at hand. A Delivery Architect needs to have knowledge of all the different aspects of the technical Delivery as well as robust business knowledge. This includes the Software Architect.
Day to Day Responsibilities:
â€¢ You are responsible for the end-to-end architecture of a Delivery, including its assembly and integration into the IT architecture principles defined with the client.
â€¢ You define the structure of the system, its interfaces, and the principles that guide its organization, software design and implementation.
â€¢ You are responsible for the management and mitigation of technical risks, ensuring that the Delivery services can be realistically delivered by the underlying technology components.
Required Skills and Experience:
â€¢ Qualification: 6-8 years (2 years min relevant experience in the role) experience, Bachelor's Degree.
â€¢ Certification: Has or seeking IAF level 1.
â€¢ Should be proficient in foundation, People Leadership, client acquisition & development, service & delivery and business leadership.
â€¢ Should be experienced in technology awareness & leveraging and innovation & growth capability.
Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.
This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.
Click the following link for more information on your rights as an Applicant - ~~~
Capgemini is a global leader in consulting, digital transformation, technology and engineering services. The Group is at the forefront of innovation to address the entire breadth of clients' opportunities in the evolving world of cloud, digital and platforms. Building on its strong 50-year heritage and deep industry-specific expertise, Capgemini enables organizations to realize their business ambitions through an array of services from strategy to operations. Capgemini is driven by the conviction that the business value of technology comes from and through people. Today, it is a multicultural company of 270,000 team members in almost 50 countries. With Altran, the Group reported 2019 combined revenues of â‚¬17billion.
Visit us at ~~~ . People matter, results count.
Title: Snowflake DW Architect
Location: NY-New York
Requisition ID: 051992