2,462,060open jobs
149,674companies
318,904added this week
Browse all
Salary
≈ $19k – $40k per year (Estimated)
Location
Hybrid (Kolkata, India, 2pm - 11pm)
Seniority
Senior · 12+ years exp
Visa
Sponsors visas in United States; no register of this country names it

Confirmed on the employer's own hiring board on Nov 22, 2026. First seen by Alion on Aug 6, 2026. LTM scores B on the Alion truth index.

Overview
Company
Impact
Profile match

LTM

LTM, formerly LTIMindtree, is an Indian IT services and consulting company providing application development, cloud, data engineering, AI, enterprise application implementation and managed services to large enterprises. Headquartered in Mumbai and majority-owned by Larsen & Toubro, it was formed in 2022 by the merger of L&T Infotech, founded in 1996, and Mindtree, and is listed on the BSE and NSE. It hires Salesforce and full-stack developers, data engineers, program managers and software engineers in Bengaluru, Kolkata, Pune and Bellevue, Washington.

Work Timings 2PM to 11 PM IST

Working Model Hybrid 3 days work from LTIM office

Location Offshore

Responsibilities

Design and develop Logical Physical Data Models for Data Warehouse Data Mart layers in Snowflake

Create and maintain SourcetoTarget Mapping STM documents ensure accurate data mapping for policy claims and financial domains

Define data entities attributes and relationships based on business requirements data sources and analytical needs

Validate transformation logic for downstream consumption layers used by DBT pipelines and Power BI models

Conduct indepth data analysis and profiling including JSON payload understanding and complex domain structures

Ensure conformance to dimensional modeling normalization denormalization practices

Collaborate closely with Data Engineers to design optimized structures supporting DBT pipelines and Snowflake performance considerations

Technical Primary Skills

12 years of extensive handson experience in Data modeling with Insurance domain background

Experience working in Data warehousing environment

Experience in translating business requirements into logical and physical data model

Design and implement effective data models in Snowflake optimizing for analytical and operational reporting needs

Ability to perform data analysis on source data to come up with relevant models

Experience in developing SCD1SCD2SCD3 Dimension Data models and data warehouse

Strong experience working with Erwin Data Modeler for conceptual logical and physical models

Strong in Snowflake data warehousing concepts staging curated layers marts

Strong SQL skills with the ability to validate transformations and model outputs

Knowledge of handling JSONXML structures schema interpretation and source payload analysis

Strong understanding of data integration issues validation and cleaning familiarity with complex data and structures

Experience working with agile methodology

Secondary Skills

Insurance Domain Expertise in LOB like Workers Compensation WC Commercial Multi Peril CMP Excess Surplus ES Excess Casualty XS Casualty

Soft Skills

Strong analytical thinking and ability to interpret complex business logic

Proactive communication and documentation skills

Ability to work in fast paced multi LOB data programs

Qualifying Questions

1Do you have data modeling experience for building Insurance Data warehouse

2Do you have experience on Data Profiling

3Do you have experience working Erwin tool

4Do you have experience in designing models for Snowflake data warehouse

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,462,060 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Data Science
Similar stack
Same company
Kolkata
Data Engineer 3 days ago
In office · Full-Time · 3+ years exp · Pune · Hyderabad · Mumbai
Databases
Databricks
DevOps
Azure
Analytics
ETL/ELT
Apply
Data Engineer 2 hours ago
In office · 5+ years exp · Bengaluru
Python
Scala
Python
pySpark
Databases
Snowflake
Databricks
AI/ML
Spark
Analytics
ETL/ELT
Apply
Data Scientist 1 year ago
In office · 3+ years exp · Bachelor's Degree · Bengaluru
Python
C++
C++
TensorFlow C++
AI/ML
Claude
NLP
Transformers
TensorFlow
PyTorch
OpenAI
Hugging Face
Machine Learning
DevOps
GCP
Azure
AWS
Apply
In office · Full-Time · 8+ years exp · Bachelor's Degree · Bengaluru
Databases
Snowflake
DevOps
Prometheus
Cortex
Analytics
ETL/ELT
Apply
In office · Full-Time · 9+ years exp · Bachelor's Degree · Bengaluru
Databases
Snowflake
Apply
In office · Kolkata
SQL
Databases
MS SQL
Analytics
ETL/ELT
SSIS
Apply
In office · Kolkata
DevOps
CI/CD
Cybersecurity
Burp Suite
Nmap
OWASP Top 10
GDPR
OWASP ASVS
Threat Modeling
Veracode
Fortify
OWASP
Management
ServiceNow
Apply
In office · Kolkata
Management
Oracle ERP
Apply
Hybrid · 8+ years exp · Bachelor's Degree · Kolkata
DevOps
Terraform
Azure DevOps
Azure
CI/CD
Kubernetes
Azure AKS
Cybersecurity
Active Directory
Management
ServiceNow
ITIL
Apply
In office · Kolkata
Management
Oracle ERP
Apply
See all jobs
This is one of many
2,462,060 more open roles from verified company boards, updated every day.