Software Engineer - OLAP/OLTP

Job Description

Job Title : Software Engineer

Location : Bangalore (BLR)

Work Mode : Hybrid /

Role Type : Permanent (Talpro)

Notice Period : Immediate Joiner

Mandatory Skills :

- Data Modelling (Relational, Analytical, OLTP & OLAP systems)

- Strong SQL Development

- Snowflake (Data Warehousing & Performance Tuning)

- Python (for data handling, scripting, automation)

- AWS Cloud Services (S3, Lambda, Redshift, etc.)

- NoSQL Databases (e.g., DynamoDB, MongoDB)

Secondary or Good to Have Skills :

- NoSQL Data Modelling

- Data Governance, Cataloging Tools (e.g., Alation, Collibra)

- Experience with metadata management and enterprise architecture standards

- ETL tools and data pipeline orchestration

Years of Experience : 10+ Years

Job Summary:

We are seeking a highly experienced Software Engineer (Premium/Emerging 4 level) with over 10 years of experience in data modeling, SQL, Snowflake, Python, and AWS-based data architecture. This role is ideal for a technically strong individual who has led large-scale data platform initiatives and possesses a deep understanding of data structures, modeling practices, and cloud-native solutions.

Key Responsibilities:

- Design, implement, and optimize scalable data models for both structured (SQL) and semi/unstructured (NoSQL) data systems.

- Build and maintain Snowflake data warehouses, applying best practices for data performance, governance, and cost optimization.

- Develop data processing scripts and utilities using Python for ingestion, transformation, and automation.

- Work on AWS infrastructure to support data lake, pipeline, and data warehousing environments.

- Collaborate with architecture and data engineering teams to define data standards, modeling frameworks, and reusable components.

- Apply advanced data modeling principles to support historical, time-series, and real-time data requirements.

- Maintain documentation, metadata, and data lineage using governance tools (where applicable).

- Provide technical leadership on data architecture decisions and mentor junior engineers in modeling practices.

Required Qualifications :

- Bachelors or Masters degree in Computer Science, Data Engineering, or a related field.

- 10+ years of industry experience with a strong focus on data modeling and analytics.

- Proven experience working with Snowflake and building data solutions on AWS.

- Strong programming skills in Python with a clear understanding of its application in data workflows.

- Solid understanding of NoSQL data models and implementation techniques.

- Excellent problem-solving and communication skills, with the ability to articulate complex technical ideas