Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Jobs

Interviews

Home
>
Jobs in Kolkata
>
Zensar
>
DE&A - Core - Cloud Data Engineering - Snowflake Data Engineering

DE&A - Core - Cloud Data Engineering - Snowflake Data Engineering

Zensar

5 - 10 years

7 - 12 Lacs

Kolkata Mumbai New Delhi Hyderabad Pune Chennai Bengaluru

Posted:2 weeks ago| Platform:

Apply

Skills Required

Performance tuning Data modeling Debugging Workflow Scheduling Informatica Stored procedures Troubleshooting cisco SQL

Work Mode

Work from Office

Job Type

Full Time

Job Description

Snowflake + DBT

Mandatory Skills:

Candidate should have 5-10 years of experience in Snowflake (Cloud Data Warehousing) & ELT DBT (Data Build Tool) and (Informatica) Development and Design & Development experience:

Primary Technical skills:

Snowflake (Cloud Data Warehouse):
1. Good understanding of Snowflake ECO system
2. Good experience on Data modeling and Dimensional Modeling and techniques and will be able to drive the Technical discussions with IT & Business and Architects / Data Modelers
3. Need to guide the team and provide the technical solutions
4. Need to prepare the technical solution and architectures as part of project requirements
5. Virtual Warehouse (Compute) - Good Understanding of Warehouse creation & manage
6. Data Modeling & Storage - Strong knowledge on LDM/PDM design
7. Data Loading/Unloading and Data Sharing- Should have good knowledge
8. SnowSQL (CLI)- Expertise and excellent understanding of Snowflake Internals and Integration
9. Strong hands on experience on SNOWSQL queries and Stored procedures and performance tuning techniques
10. Good knowledge on SNOWSQL Scripts preparation the data validation and Audits
11. SnowPipe - Good knowledge of Snow pipe implementation
12. Expertise and excellent understanding of S3 - Internal data copy/movement
13. Good knowledge on Security & Readers and Consumers accounts
14. Good knowledge and hands on experience on Query performance tuning implementation techniques
DBT ( Data Build Tool) hands on experience with all modules :
1. In depth hands on experience in DBT CLI and DBT Cloud and GitHub version control and code repository knowledge.
2. Design and develop DBT models and build the data pipeline processes to perform complex ELT processes as per DBT scripting.
3. Good knowledge and hands on experience on dbt concepts such as Models, Materialization, Sources, Seeds, Snapshots, Packages, Hooks, Exposures, Analyses, write complex SQL queries
Informatica- 10.x and above with all modules :
1. ETL- Design & Development and Troubleshooting/debugging experience
2. Repository Manager
3. Mapping Designer - Candidate should have strong hands on experience Mapping & Mapplets creations using all Transformations
4. Workflow designer - Candidate should have good understanding on Session & Task implementation and Job scheduling
SQL Knowledge:
1. Advance SQL knowledge and hands on experience on complex queries writing using with Analytical functions
2. Strong knowledge on stored procedures
3. Troubleshooting, problem solving and performance tuning of SQL queries accessing data warehouse

Ability to participate in RFI/RFPs discussions and provide technical solutions and effort estimations
Excellent presentation and communication skills, both written and verbal
Ability to problem solve and architect in an environment with unclear requirements
Candidate should have good work attitude and ability to work in Onshore/Offshore model.

Nice to have skills:

Cisco Process and Data understanding like IB Data, Service contract Management, Auto Renewals, Services Domain, Booking, Quotes, Digital Case Services, Quote to Cash, Invoicing, Licensing, and Provisioning, Sales Compensation, Software and Recurring Revenue etc.
SnowPro-Core - Certification - Snowflake
Experience/Knowledge with reporting technologies (i.e. Tableau, PowerBI) is an added advantage.
Good to have Hi-Tech Manufacturing domain experience.

More Jobs at Zensar

Urgent Opening For GenAI with Python

Pune, Bengaluru, Hyderabad

6 - 10 yrs

INR 16 - 31 Lacs

PERL PL/SQL Developer

Pune

3 - 5 yrs

INR 8 - 9 Lacs

BUSINESS FINANCE MANAGER

Chennai, Pune, Delhi, Mumbai, Bengaluru, Hyderabad, Kolkata

5 - 15 yrs

INR 22 - 27 Lacs

Senior Data Architect

Chennai, Pune, Delhi, Mumbai, Bengaluru, Hyderabad, Kolkata

7 - 9 yrs

INR 9 - 11 Lacs

Martech resources - Internal

Chennai, Pune, Delhi, Mumbai, Bengaluru, Hyderabad, Kolkata

4 - 7 yrs

INR 9 - 13 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.