ETL Developer

Role: Senior ETL developer

Experience: 6+ years

Location: Pune

About Tredence:

Tredence focuses on last-mile delivery of powerful insights into profitable actions by uniting its strengths in business analytics, data science and software engineering. The largest companies across industries are engaging with us and deploying their prediction and optimization solutions at scale. Head quartered in the San Francisco Bay Area, we serve clients in the US, Canada, Europe, and South East Asia.

We are seeking an experienced data engineer who apart from the required mathematical and engineering expertise also possesses the natural curiosity and creative mind to ask questions, connect the dots, and uncover opportunities that lie hidden with the ultimate goal of realizing the data’s full potential.

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

Airflow

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 Tredence is an equal opportunity employer.

We celebrate and support diversity and are committed to creating an inclusive environment for all employees. Visit our website for more details: https://www.tredence.com/