Data Engineer

Orcapod; Bengaluru; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A leading data solutions provider in Bengaluru is seeking a candidate with a graduate degree in a quantitative field and advanced SQL knowledge. The ideal candidate will have experience with big data tools such as Hadoop and Spark, relational and NoSQL databases, and data pipeline management. You will be responsible for building optimized data architectures and performing root cause analysis to drive business improvements. The role offers a collaborative environment with opportunities for professional growth.

Qualifications

• Proven advanced SQL knowledge and experience with relational databases.
• Experience in building and optimizing big data pipelines.
• Strong analytical skills with unstructured datasets.

Responsibilities

• Build and optimize data pipelines and architectures.
• Perform root cause analysis on data for business insights.
• Support data transformation and workload management.

Skills

Advanced SQL knowledge

Experience with relational databases

Familiarity with various databases

Experience with big data tools

Experience with data pipeline tools

Proficiency in scripting languages

Education

Graduate degree in Computer Science or related field

Tools

Hadoop

Spark

Kafka

AWS services

Job description

We are looking for a candidate who has attained a Graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field.

Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.

• Advanced working SQL/nosql, ADLS, Databricks, ADF, Azure DevOps
• Experience building and optimizing ‘big data’ data pipelines, architectures and data sets.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Strong analytic skills related to working with unstructured datasets.
• Build processes supporting data transformation, data structures, metadata, dependency and workload management.

Required Skills

• Advanced working SQL knowledge.
• Experience with relational databases and query authoring (SQL).
• Familiarity with a variety of databases.
• Experience with big data tools: Hadoop, Spark, Kafka, etc.
• Experience with relational SQL and NoSQL databases, including Postgres and Cassandra.
• Experience with data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc.
• Experience with AWS cloud services: EC2, EMR, RDS, Redshift.
• Experience with stream-processing systems: Storm, Spark-Streaming, etc.
• Experience with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc.