Snowflake Data Engineer - Bengaluru, India - Tredence Inc.
Description
Tredence is a global analytics services and solutions company. Our capabilities range from Data Visualization, Data Management to Advanced analytics, Big Data and Machine Learning. Our uniqueness is in bringing the right mix of technology and business analytics to create sustainable white-box solutions that are transitioned to our clients at the end of the engagement. We do this cost-effectively using a global execution model leveraging our clients' existing technology and data assets. We also come in with some strong IP and pre-built analytics solutions in data mining, BI, and Big Data.
Primary Roles and Responsibilities:
● Developing Modern Data Warehouse solutions using Snowflake, Databricks and ADF.
● Ability to provide solutions that are forward-thinking in data engineering and analytics space
● 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 the reporting layer and develop a data model to fulfill reporting needs
● Help joiner team members to resolve issues and technical challenges.
● Drive technical discussions with client architect and team members
● Orchestrate the data pipelines in the scheduler via Airflow Skills.
Qualifications:
● Bachelor's and/or master's degree in computer science or equivalent experience.
● Must have total 6+ yrs. of IT experience and 3+ years' experience in Data warehouse/ETL projects.
● Expertise in Snowflake security, Snowflake SQL and designing/implementing other Snowflake objects.
● Hands-on experience with Snowflake utilities, SnowSQL, Snowpipe, Snowsight and Snowflake connectors.
● Deep understanding of Star and Snowflake dimensional modeling.
● Strong knowledge of Data Management principles
● Good understanding of Databricks Data & AI platform and Databricks Delta Lake Architecture
● Should have hands-on experience in SQL and Spark (PySpark)
● Experience in building ETL / data warehouse transformation processes
● Experience with Open Source non-relational / NoSQL data repositories (incl. MongoDB, Cassandra, Neo4J)
● Experience working with structured and unstructured data including imaging & geospatial data. ● Experience working in a Dev/Ops environment with tools such as Terraform, CircleCI, GIT.
● Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning, troubleshooting and Query Optimization.
● Databricks Certified Data Engineer Associate/Professional Certification (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.
Mandatory Skills: Snowflake/Azure Data Factory/ PySpark / Databricks
We are open for Bangalore, Chennai, Gurgaon, Pune and Kolkata