Senior Data Architect

Tredence Inc.; Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Tredence Inc. Bengaluru-based data analytics leader seeks an experienced Data Warehouse/ETL professional. You will architect modern data solutions using Databricks and cloud stacks, shaping ETL pipelines and reporting data models.

The role requires deep SQL, Python and Spark expertise, plus hands-on experience with AWS/Azure and streaming/batch ETL. Collaboration with DW/BI teams and mentoring teammates are key components.

Qualifications

• Bachelor's/ Master’s degree in computer science or equivalent.
• Total 12+ years of IT experience and 3+ years in Data warehouse/ETL projects.
• Deep understanding of Star and Snowflake dimensional modelling.
• Strong knowledge of Data Management principles.
• Hands-on experience in SQL, Python and Spark (PySpark).
• Experience with AWS/Azure stack.

Responsibilities

• Develop Modern Data Warehouse solutions using Databricks and AWS/Azure Stack.
• Provide forward-thinking solutions in data engineering and analytics.
• Collaborate with DW/BI leads to understand ETL requirements.
• Triage issues to identify and fix gaps in pipelines.
• Work with business to design data models for reporting needs.
• Mentor team members and drive technical discussions with client architects.
• Orchestrate data pipelines using Airflow.

Education

Bachelor's/Master's in CS

12+ years IT experience

3+ years Data warehouse/ETL

SQL

Python

Spark (PySpark)

Tools

Databricks

Airflow

Kafka

Hadoop

MongoDB

Cassandra

Neo4J

Terraform

CircleCI

Git

Job description

Location: Bengaluru, Chennai, Kolkata, Gurugram, Pune and Hyderabad.

Profile Summary

We are seeking an experienced professional who apart from the required mathematical and statistical 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.

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 datamodel 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

Qualifications

• Bachelor's and/or master’s degree in computer science or equivalent experience.
• Must have total 12+ 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. Job Description:
• Good Communication and presentations skills.
• At least 3 years 'experience in Databricks implementations, 2large scale data warehouse end-to-end implementation experience.