Data Engineer

Overview

We’re looking for a skilled and driven Data Engineer who thrives in a data-rich environment. You will focus on managing and optimizing our existing data ecosystem, with a strong emphasis on SQL development for Oracle, BigQuery, and Tableau data sources, alongside NoSQL with MongoDB. You will also contribute to our Lakehouse development and will play a key role in ensuring data accuracy while supporting the scalability of our data infrastructure.

Roles and Responsibilities:

• Develop, optimize, and maintain SQL queries for Tableau data sources, ensuring efficient and accurate data delivery.
• Write and optimize complex queries for Oracle and BigQuery databases to support business reporting needs.
• Develop, maintain and enhance existing ETL/ELT pipelines, ensuring data is ingested, transformed, and delivered efficiently.
• Collaborate with cross-functional teams to identify and implement improvements in data workflows.
• Participate in early development efforts related to Lakehouse architecture initiatives.
• Assist in preparing existing data workflows for integration with modern cloud-based data platforms.
• Perform thorough data validation and reconciliation to ensure consistency across different data sources.
• Identify and resolve discrepancies by working closely with data analysts and business stakeholders.
  
  
  

• Bachelor’s degree in computer science, Data Engineering, Information Systems, or a related field.
• 5+ years of experience working with SQL and managing data pipelines.
• Strong proficiency in SQL, with experience in Oracle and Big Query databases.
• Experience querying MongoDB, including working with semi-structured data.
  
  
  

Technical Skills:

• Advanced SQL skills for query performance tuning and optimization.
• Knowledge of ETL/ELT processes and experience optimizing data transformations.
• Experience working with relational (Oracle, BigQuery) and NoSQL (MongoDB) databases.
• Experience with Python or scripting for automation.
• Familiarity with cloud platforms such as AWS, GCP, and Azure.
• Advantage: Hands-on experience with BI tools such as Tableau.
  
  
  

Aumni Techworks, established in 2016, is a Software Services Company that partners with Product companies to build and manage their dedicated teams in India. So, while you are working for a services company, you are working within a product team and growing with them.

We do not take on projects, and we have long-term (open-ended) contracts with our clients. When our clients sign up with us, they are looking at a multi-year relationship.

For e.g. Some of the clients we signed up with 8 or 6 years, are still with us.

We do not move people across client teams and there is no concept of bench.

At Aumni, we believe in quality work, and we truly believe that Indian talent is at par with someone in NY, London or Germany.

350+ and growing

Benefits of working at Aumni Techworks:

• Our award-winning culture reminds us of our engineering days.
• Medical insurance (including Parents), Life and Disability insurance.
• 24 leaves + 10 public holidays + leaves for Hospitalization, maternity, paternity and bereavement.
• On site Gym, TT, Carrom, Foosball and Pool table.
• Hybrid work culture