Job Title
Senior Specialist – Data Engineering
Location
Bengaluru
Experience
7 to 11 years
Job Description
LTIMindtree is looking for an experienced Data Modeler to design, implement, and support high-quality data structures. The role requires strong skills in data modeling, Azure data services, SQL, and modern data engineering practices.
You will collaborate with analysts, architects, and database teams to ensure scalable, accurate, and high-performing datasets aligned with business and technical needs.
Key Responsibilities
- Design and implement conceptual, logical, and physical data models.
- Ensure integration and consistency across multiple data sources.
- Work with business teams to translate data needs into technical specifications.
- Align data models with enterprise architecture and governance standards.
- Develop and manage ETL processes using modern tools and frameworks.
- Collaborate with DBAs to ensure optimized database design.
- Maintain metadata, data dictionaries, and documentation.
- Troubleshoot data modeling, quality, and integration issues.
- Mentor junior team members when needed.
- Stay updated on trends in data modeling and architecture.
Requirements
- 2 to 5 years of experience building data pipelines with Azure Data Factory, Azure Synapse, and Databricks.
- Strong SQL and T-SQL skills; knowledge of Azure SQL Database or Synapse SQL pools.
- Experience with data ingestion via ADF pipelines from databases, APIs, and file systems.
- Strong understanding of Spark and Databricks.
- Experience with schema design and data modeling in Azure environments.
- Knowledge of ETL, data warehousing, and integration concepts.
- Solid understanding of Azure data services and infrastructure.
- Good troubleshooting and problem-solving skills.
Qualifications
- Bachelor’s degree in Computer Science, IT, or related field.
- 4 to 9 years of experience in data modeling or data architecture.
- Hands-on experience with ERStudio, Erwin, or similar modeling tools.
- Strong understanding of relational databases, data warehousing, and SQL.
- Exposure to big data platforms (Hadoop, Spark, NoSQL) is a plus.
- Strong communication skills and ability to work cross-functionally.
- Experience working in Agile or Scrum environments.
Mandatory Skills
ERWIN, MS SQL Server, TOAD Data Modeler, Data Vault ODS Modeling, ANSI-SQL, Dimensional Data Modeling, ER Studio, Microsoft Fabric, GCP BigQuery, Redshift, Snowflake, Databricks, TOAD
Disclaimer
All job information belongs to the hiring company. We do not guarantee interviews or job selection. Applicants should verify all details on the official career page before applying.
