Tata Consultancy Services · 2 weeks ago
Data Modeler with Data Vault Engineer
Tata Consultancy Services is a global leader in IT services, consulting, and business solutions. They are seeking a Data Modeler with Data Vault Engineer who will be responsible for data modeling and analysis, utilizing cloud data warehouses and modern ELT approaches to enhance data processes.
Business Information SystemsConsultingInformation TechnologyIT Management
Responsibilities
Should have strong understanding of cloud Datawarehouse like SnowFlake and Data modelling skill using Data Vault 2.0
Should have knowledge of SSIS ETL packages and need to analyze existing business logic and convert them into modern ELT approach
Should have in depth understanding or executed new concepts like Data Lakehouse and should have worked on Big Data data sources / tools such as Hive , S3 , Trino , HUE , etc
Should have done complex (100+ entities/tables) Data Modeling programs in both on-prem and cloud environments
Experience in designing normalized, denormalized, relational, dimensional, star and snowflake schemas for cloud, big data and on prem databases using any one of these data modeling tools (Erwin, ER/Studio, Toad Data Modeler, etc)
Qualification
Required
5 + years of experience in Data Modeling & Data Analyst and should have excellent communication and leadership skills
Financial Domain knowledge is plus
Strong understanding of cloud Datawarehouse like SnowFlake and Data modelling skill using Data Vault 2.0
Knowledge of SSIS ETL packages and need to analyze existing business logic and convert them into modern ELT approach
In depth understanding or executed new concepts like Data Lakehouse and should have worked on Big Data data sources/tools such as Hive, S3, Trino, HUE, etc
Done complex (100+ entities/tables) Data Modeling programs in both on-prem and cloud environments
Experience in designing normalized, denormalized, relational, dimensional, star and snowflake schemas for cloud, big data and on prem databases using any one of these data modeling tools (Erwin, ER/Studio, Toad Data Modeler, etc)
Extensive Data Modeling experience in same or similar bigdata and cloud databases such as Hive, Redshift, Snowflake and on prem databases such as Oracle, SQL Server and DB2
Experience in working with product managers, project managers, business users, applications development team members, DBA teams and Data Governance team on a daily basis to analyze requirements, design, development and deployment technical solutions
Implemented Bill Inmon and Ralph Kimball methodologies to design data warehouses
In depth understanding on Data Warehousing, Data Analysis, Data Profiling, Master Data Management (MDM), Data Quality, Data Lineage, Data Dictionary, Data Mapping, Data Policy, and Data Governance
Need to have at least 2 hours overlap with Pacific Timings to interact with Onsite team and to attend daily standup meetings
BACHELOR OF COMPUTER SCIENCE
Company
Tata Consultancy Services
Tata Consultancy Services is a business solutions company that specializes on information technology services and consulting.
H1B Sponsorship
Tata Consultancy Services has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7880)
2024 (9690)
2023 (8537)
2022 (11159)
2021 (9813)
2020 (11984)
Funding
Current Stage
Public CompanyTotal Funding
unknown2004-08-25IPO
Leadership Team
Recent News
Hindu Business Line
2026-01-16
TradingView
2026-01-16
Company data provided by crunchbase