Data Architect Senior Databricks Senior Manager

Pyramid It Consulting; Hyderabad, Bengaluru, Dadri; On-site; INR 1,400,000 - 2,200,000; Full time

Job summary

Pyramid It Consulting is looking for an experienced Data Engineer to design and implement modern data warehouse solutions using Databricks on AWS/Azure stacks. You will collaborate with DW/BI leads to define ETL pipelines and data models supporting reporting needs, while triaging and fixing issues in existing pipelines.

The role requires 6+ years IT experience with 3+ years in DW/ETL, SQL/Python/Spark, and strong knowledge of data modelling.

Qualifications

• Bachelor’s and/or masters degree in computer science or equivalent experience.
• Must have total 6+ yrs. of IT experience and 3+ years' experience in Data warehouse/ETL projects.
• Deep understanding of Star and Snowflake dimensional modelling.
• 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, Python and Spark (PySpark)
• Candidate must have experience in AWS/ Azure stack
• Desirable to have ETL with batch and streaming (Kinesis).
• Experience in building ETL / data warehouse transformation processes
• Experience with Apache Kafka for use with streaming data / event-based data
• Experience with other Open-Source big data products Hadoop (incl. Hive, Pig, Impala)
• 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 and troubleshoot
• Databricks Certified Data Engineer Associate/Professional Certification (Desirable).
• Should have experience working in Agile methodology.

Responsibilities

• Developing Modern Data Warehouse solutions using Databricks and AWS/ Azure Stack
• Ability to provide solutions that are forward-thinking in data engineering and analytics space
• Collaboration with DW/BI leads to understanding 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 via Airflow

Skills

Databricks

AWS

Azure

SQL

Python

Spark

Airflow

Kafka

Hadoop

NoSQL

Geospatial data

Delta Lake

Terraform

CircleCI

Git

RDBMS

PL/SQL

DevOps

Hive

Impala

MongoDB

Cassandra

Neo4j

Education

Bachelor’s or Masters in Computer Science

Tools

Databricks

Airflow

Terraform

CircleCI

Git

Hive

Impala

MongoDB

Cassandra

Neo4j

Delta Lake

Job description

Roles and Responsibilities

• Developing Modern Data Warehouse solutions using Databricks and AWS/ Azure Stack
• Ability to provide solutions that are forward-thinking in data engineering and analytics space
• Collaboration with DW/BI leads to understanding 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 via Airflow

Skills and Qualifications

• Bachelor's and/or masters degree in computer science or equivalent experience.
• Must have total 6+ yrs. of IT experience and 3+ years' experience in Data warehouse/ETL projects.
• Deep understanding of Star and Snowflake dimensional modelling.
• 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, Python and Spark (PySpark)
• Candidate must have experience in AWS/ Azure stack
• Desirable to have ETL with batch and streaming (Kinesis).
• Experience in building ETL / data warehouse transformation processes
• Experience with Apache Kafka for use with streaming data / event-based data
• Experience with other Open-Source big data products Hadoop (incl. Hive, Pig, Impala)
• 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 and troubleshoot
• Databricks Certified Data Engineer Associate/Professional Certification (Desirable).
• Should have experience working in Agile methodology.