Description
We are Cognizant Artificial Intelligence
Digital technologies, including analytics and AI, give companies a once-in-a-generation opportunity to perform orders of magnitude better than ever before. However, clients need new business models built from analyzing customers and business operations at every angle to really understand them.
With the power to apply artificial intelligence and data science to business decisions via enterprise data management solutions, we help leading companies prototype, refine, validate, and scale the most desirable products and delivery models to enterprise scale within weeks
* You must be legally authorized to work in United States/Canada without the need of employer sponsorship, now or at any time in the future *
Job Title: Snowflake Data Architect (Hybrid)
Role/Responsibilities:
§ Proficiency in RDBMS complex SQL, PL/SQL, Unix Shell Scripting performance tuning and troubleshoot.
§ Build processes supporting data transformation, data structures, metadata dependency and workload management.
§ Provide resolution to an extensive range of complicated data pipeline related problems proactively and as issues surface.
Required Qualifications:
§ Must have total 10+ yrs. in IT and 3+ years’ experience working as a snowflake Data Architect and 8+ years in Data warehouse, ETL BI projects.
§ Must have experience at least two end to end implementation of Snowflake cloud data warehouse migration.
§ 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.
§ Should have experience in ELT or ETL tools like informatica/Talend/ Matillion (preferable)
§ Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
§ Must have expertise in AWS or Azure Platform as a Service (PAAS).
§ Certified Snowflake cloud data warehouse Architect (Desirable).
Salary and Other Compensation :
The annual salary for this position is between $115,000.00 – $130,000.00 depending on experience and other qualifications of the successful candidate.
This position is also eligible for Cognizant’s discretionary annual incentive program, based on performance and subject to the terms of Cognizant’s applicable plans.
Benefits : Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:
- Medical/Dental/Vision/Life Insurance
- Paid holidays plus Paid Time Off
- 401(k) plan and contributions
- Long-term/Short-term Disability
- Paid Parental Leave
- Employee Stock Purchase Plan
Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.
Cognizant is an Equal Opportunity Employer M/F/D/V. Cognizant is committed to ensuring that all current and prospective associates are afforded equal opportunities and treatment and a work environment free of harassment.
Cognizant is recognized as a Military Friendly Employer and is a coalition member of the Veteran Jobs Mission. Our Cognizant Veterans Network Assists Veterans in building and growing a career at Cognizant that allows them to leverage the leadership, loyalty, integrity, and commitment to excellence instilled in them through participation in military service.
#LI-KV1 #CB #Ind123
Qualifications
Technical Skills
SNo
Primary Skill
Proficiency Level *
Rqrd./Dsrd.
1
Data Architect
PL3
Desired
2
Snowflake
PL3
Desired
3
ER Modeling
PL4
Required
* Proficiency Legends
Proficiency Level
Generic Reference
PL1
The associate has basic awareness and comprehension of the skill and is in the process of acquiring this skill through various channels.
PL2
The associate possesses working knowledge of the skill, and can actively and independently apply this skill in engagements and projects.
PL3
The associate has comprehensive, in-depth and specialized knowledge of the skill. She / he has extensively demonstrated successful application of the skill in engagements or projects.
PL4
The associate can function as a subject matter expert for this skill. The associate is capable of analyzing, evaluating and synthesizing solutions using the skill.