Consultant
India
About Tredence
Tredence is a global analytics services and solutions company. We are one of the fastest growing private companies in the country for three straight years according to the Inc. 5000 and we continue to set ourselves apart from our competitors by attracting the greatest talent in the data analytics and data science space. Our capabilities range from Data Visualization, Data Management to Advanced analytics, Big Data and Machine Learning. Our uniqueness is in building Scalable Big Data Solutions on Onprem/GCP/Azure cloud in a very cost effective and easily scalable manner for our clients. We also come in with some strong IP and pre-built analytics solutions in data mining, BI and Big Data.
Job Summary
Primary Roles and Responsibilities:
• Collaborate with DW/BI leads to understand new ETL pipeline development requirements
• Triage issues to find gaps in existing pipelines and fix the issues
• Work with business to understand the need in reporting layer and develop data model to fulfill reporting needs
• Help joiner team members to resolve issues and technical challenges.
• Drive technical discussion with client architect and team members
• Orchestrate the data pipelines in scheduler (UC4 and Airflow)
Job Location
Bangalore/Pune/Gurgaon/Kolkata/Chennai
Roles & Responsibilities
Skills and Qualifications:
● Bachelor's and/or master’s degree in computer science or equivalent experience.
● Must have total 5+ yrs. of IT experience and 3+ years' experience in Data warehouse/ETL projects.
● Should have experience at least in 1 end to end implementation of Snowflake cloud data warehouse and 2 End to end data warehouse implementations on-premise.
● Expertise in Snowflake – data modelling, ELT using SQL, implementing stored Procedures and standard DWH and ETL concepts
● Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe
● Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
● Deep understanding of Star and Snowflake dimensional modelling
● Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot
● Certified in Snowflake (SnowPro Core) (Desirable).
● Comfortable working in a dynamic, fast-paced, innovative environment with several ongoing concurrent projects
● Should have experience working in Agile methodology
● Strong verbal and written communication skills.
● Strong analytical and problem-solving skills with a high attention to detail.
● Self-motivated, collaborative, innovative, eager to learn, and hands on
Qualification & Experience
Skills and Qualifications:
● Bachelor's and/or master’s degree in computer science or equivalent experience.
● Must have total 5+ yrs. of IT experience and 3+ years' experience in Data warehouse/ETL projects.
● Should have experience at least in 1 end to end implementation of Snowflake cloud data warehouse and 2 End to end data warehouse implementations on-premise.
● Expertise in Snowflake – data modelling, ELT using SQL, implementing stored Procedures and standard DWH and ETL concepts
● Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe
Why Join Tredence?
There is a reason we are one of the fastest growing private companies in the country! You will have the opportunity to work with some of the smartest and fun-loving people in the data analytics space. You will work with the latest technologies and interface directly with the key decision stakeholders at our clients, some of the largest and most innovative businesses in the world. Our people are our greatest asset and we value every one of them. Come see why we’re so successful in one of the most competitive and fastest growing industries in the world.