Add office photos
Engaged Employer
i
This company page is being actively managed by
Titan Company Team. If you also belong to the team, you
can get access from
here
Titan Company
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
All Filters
78 Titan Company Jobs
Data-Modeller-Build
Titan Company
posted 8d ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
Technical Lead in the Data Architecture Domain, Responsible for the design and creation of standard and benchmark data models using Layered Scalable Architecture concepts to deliver the Data Marts across all Businesses of Titan. This includes complexities like several decades of Business Data, External Data, high volume, complex structure, Performance & Costs.
Should have expertise in RDBMS concepts, data warehousing, modelling and agile concepts and have strong hands on experience in SQL
External Interfaces
Internal Interfaces
Qualitest
Empower sys / Aliment
Tableau India Pvt Ltd
Alpharithm
CRG
AWS
SAP
IBM
Google
Technical consultants of BI
Functional consultants / Business Analysts
Business users
Testing Team
Development Team
Job Requirements
Education
Scenario 1: Engineering
Scenario 2: MCA Graduation
Relevant Experience
Scenario 1: >4 Years
Scenario 2: >6 Years
Behavioural Skills
Good Communication & Interpersonal skills
Excellent Analytical skills- Problem solving/troubleshooting
Excellent Team player
Knowledge
Strong Technical knowledge of SQL, RDBMS, Data Warehousing and Modelling
Minimum 3 projects implementation experience in Retail/Manufacturing/HR/Finance domains
Good Knowledge on ETL tools ( min 1 tool)
Good process knowledge of minimum one Domain
Experience in Project management atleast 3 medium to complex project
Process Contributions
Process Contribution
Process Outcome
Performance Measure
Digital: Business KPI for Various Personas
1. Ability to translate requirements / functional specifications to Technical Specifications and the Business KPI/ metrics based on user requirements.
2. Calculation of various derived KPI/metrics using logic shared by business
3. Understanding the Granularity of Data for various KPI/metrics.
Technical Specification
Metrics calculation using SQL functions / Stored Procedure
Dimension to Measure Matrix
Technical Specification Document of KPI/Metrics for various functions
Algorithm and Pseudo code to build the data mart layers
Digital: Data Requirement and Source Mapping
1. Data
2. Understanding Data granularity and availability of Data in source system
Mapping of Data WRT source system
Arrive availability of Data/Granularity for various KPI/Metrics with source system
Identify Gap wrt Data requirement.
Data requirement Document (DRD)
Digital: Data modelling/ LSA Build
1. Arrive the various data elements and the logical data structure/tables
2. Identify the relationship between various data tables structure
3. Identify the primary key and the surrogate keys for various data structure
4. Arrive the layers of data to be provision source staging to final harmonisation layer/reporting layer
Conceptual/Logical data model
ER diagram
Data dictionary
Data layers and purpose
Build layers using SQL code with optimal performance
Scalable Model when new requirements or modification of KPI/data comes up
Ease of Design to accommodate changes
Digital: Testing strategy and data integrity
1. Identify the Test criteria s for the various data layers
2. Arriving the test strategy along with required stake holder (Testing , ETL , Reporting team)
3. Identify area of improvements based on the internal and user feedback
Testing criteria for data layers
Process redefine for robustness
Feedbacks and Data issues faced by users
Digital: Ease of Using data for Business
1. Identify the harmonisation layers for various business
2. Identify various mechanism for reducing the leadtimes for development of Dashboards
3. Identify various mechanism/approaches for enabling self service
4. Identify various mechanism for reducing the leadtimes for development of data consumptions layers ( Downstream/Ibots)
Datamarts
Data dictionary
Harmonisation layers
Lead time reduction in dashboard /consumption layer development
Number of users/domains on self service
Key Skills:
SQL, Python
Vac. Id: 9012
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Modeller roles with real interview advice
People are getting interviews at Titan Company through
People are getting interviews through
(based on 93 Titan Company interviews)
Job Portal
Campus Placement
Company Website
Referral
Walkin
Recruitment Consultant
29%
19%
10%
8%
8%
3%
23% candidates got the interview through other sources.
High
Confidence
?
High Confidence means the data is based on a large number of responses received from the candidates.
What people at Titan Company are saying
What Titan Company employees are saying about work life
based on 2.4k employees
Flexible timing
Monday to Saturday
No travel
Day Shift
Titan Company Benefits
Submitted by Company
Employee Assistance Program Internal Career Mobility Rewards and Recognition Employee Friendly Policies Health Benefits
Submitted by Employees
View more benefits 
Compare Titan Company with
PC Jewellers
Compare
Malabar Gold and Diamonds
Compare
Kalyan Jewellers
Compare
Tanishq
Compare
Joyalukkas
Compare
Senco Gold
Compare
GRT Jewellers
Compare
PNG Jewellers
Compare
Bhima Jewellers
Compare
Reliance Jewels
Compare
Reliance Digital
Compare
Shoppers Stop
Compare
V-Mart
Compare
Future Retail
Compare
Trent
Compare
Decathlon
Compare
Spencer's Retail
Compare
V2 Retail
Compare
VIP Industries
Compare
Westside
Compare
Similar Jobs for you
Titan Company Bangalore / Bengaluru Office Locations
Bengaluru/Bangalore, Karnataka Office
Headquarter
Titan Company Limited, Tower A, Golden Enclave, Airport Road, Bangalore, Karnataka 560017, IN
Bengaluru/Bangalore, Karnataka
Bengaluru Office
All India Institute Of Local Self Government, Komarla Plaza, 1st floor, 3rd Main, 8th Cross, Margosa Road, Malleshwaram, Near SBI Bank, Opp Sudarshan Family store, Above Titan Eye+ Optical Show room
Bengaluru
Karnataka 560003
Karnataka 560003
Share an Interview