Mandatory Skills: Snowflake/Azure Data Factory/ PySpark / Databricks
Experience: 314
Work Type: Hybrid
Location: Bangalore Chennai Pune Gurgaon and Kolkata
Primary Roles and Responsibilities:
Developing Modern Data Warehouse solutions using Snowflake Databricks and ADF.
Ability to provide solutions that are forwardthinking 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 and Qualifications:
Bachelors 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.
Handson 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 handson experience in SQL and Spark (PySpark)
Experience in building ETL / data warehouse transformation processes
Experience with Open Source nonrelational / 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 fastpaced innovative environment with several ongoing
concurrent projects
Should have experience working in Agile methodology
Strong verbal and written communication skills.
Strong analytical and problemsolving skills with a high attention to detail.
pipe,snowflake,skills,pipelines,reporting,unix shell scripting,unix,database management,snow,data lakes,delta v,pyspark,query optimization,dev/ops,devops,etl,pl/sql,agile methodology,troubleshooting,rdbms,databricks,adfs,data,sight reading,data engineering,shell scripting,data management,git,azure data factory,data warehouse,circleci,azure,sql,connectors,projects,terraform,dimensional modeling