Add office photos
All Filters
26 Tredence Jobs
Associate Manager
Tredence
posted 4mon ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
- Working experience in Snowflake; use of Snow SQL CLI, Snow Pipe creation of custom functions and Snowflake stored producers, schema modelling, performance tuning etc
- Expertise in Snowflake data modelling, ELT using Snowflake SQL, Snowflake Task Orchestration implementing complex stored Procedures and standard DWH and ETL concepts
- Extensive experience in DBT CLI, DBT Cloud, GitHub version control and repository knowledge, and DBT scripting to design & develop SQL processes to perform complex ELT processes and data pipeline build.
- Ability to independently envision and develop innovative ETL and reporting solutions and execute them through to completion.
- Triage issues to find gaps in existing pipelines and fix the issues
- Analyze the data quality, align the technical design to data governance, and address all the required non-business but operational requirements during the design and build of data pipelines
- Develop and maintain data pipelines using DBT
- Provide advice, guidance, and best practices around Snowflake
- Provide guidance on moving data across different environments in Snowflake
- Create relevant documentation around database objects
- Troubleshoot production support issues post-deployment and come up with solutions as required
- Good Understanding and knowledge of CI/CD process and GitHub-DBT- Snowflake integrations.
- Advance SQL knowledge and hands-on experience in complex query writing using Analytical functions, Troubleshooting, problem-solving, and performance tuning of SQL queries accessing data warehouse as we'll as Strong knowledge of stored procedures.
- Experience in Snowflake advanced concepts such as resource monitors, virtual warehouse sizing, query performance tuning, zero-copy clone, time travel and understanding how to use these features
- Help joiner team members to resolve issues and technical challenges.
- Drive technical discussions with client architect and team members
- Good experience in developing scripts for data auditing and automating various database platform manual activities.
- Understanding of the full software lifecycle and how development teams should work with DevOps to create more software faster.
- Excellent communication, working in Agile Methodology/Scrum
Employment Type: Full Time, Permanent
Functional Areas: Other
Read full job descriptionTredence Interview Questions & Tips
Prepare for Tredence Associate Manager roles with real interview advice
What people at Tredence are saying
Rating based on 39 Associate Manager
reviews
Anonymous · Business Intelligence & Analytics
in Bangalore / Bengaluru
Likes
Compensation is good at start
Dislikes
Work life Balance is not good
Read 39 reviewsAssociate Manager salary at Tredence
reported by
326
employees
with 4-9
years exp.
₹12.5
L/yr - ₹35
L/yr
53%
more
than the average Associate Manager Salary in India
View more details
What Tredence employees are saying about work life
based on 426 employees
Flexible timing
Monday to Friday
No travel
Day Shift
Tredence Benefits
View more benefits
Compare Tredence with
Fractal Analytics
Compare
Mu Sigma
Compare
LatentView Analytics
Compare
AbsolutData
Compare
Bridgei2i Analytics Solutions
Compare
Axtria
Compare
Crayon Data
Compare
Analyttica Datalab
Compare
Algonomy
Compare
C5i
Compare
CMS IT Services
Compare
KocharTech
Compare
Xoriant
Compare
Photon Interactive
Compare
Sify Technologies
Compare
CitiusTech
Compare
NeoSOFT
Compare
Team Computers
Compare
Iris Software
Compare
HERE Technologies
Compare
Similar Jobs for you
Tredence Analytics Solutions - DevOps Observability Engineer - Google Cloud Platform (10-18 yrs)
10-18 Yrs
Senior Data Scientist - Forecasting
5-7 Yrs
Pune, Gurgaon / Gurugram, Bangalore / Bengaluru
Share an Interview