Senior Technical Consultant

Job Requirements

Data layer architecting in the Data Architecture domain, responsible for the design and creation of standard and benchmark data models using Layered Scalable Architecture principles / Medallion Architecture to deliver the Data Marts across all Businesses of Titan with highest data quality, performance & costs.

Design optimization to handle high volumes having several decades of Business Data, External Data and complex structures.

Managing and maintaining data dictionary/ glossary/ERD

Creation of Conceptual, Logical and Physical Data Models

Project management

Work Experience

• Strong Technical knowledge of SQL (Advanced SQL store procedures, performance tuning), RDBMS, Data Warehousing and Modelling preferablyin AWS stack
• ER Modelling \u2013 Forward & Reverse Engineering should have worked on modelling tools and extensive knowledge on Conceptual, Logical and Physical Models
• Should have independently managed customers and projects of 4 members or more
• Minimum 3 projects implementation experience in Retail/Manufacturing/HR/Finance domains
• Good Knowledge on ETL tools (min 1 tool) preferably SAP Data Services/IBM Data Stage/AWS Glue
• Good process knowledge of minimum one Domain
• Experience in Leading Projects in agile framework at least 1 medium to complex project
• Experience in implementation of SF Customer Data Cloud would be an added advantage
• Good to have Statistical data modelling / Predictive modelling skills
• Hands On experience is SalesForce Customer Data Cloud (creation of Customer segmentations for campaigns) would be an added advantage
• Should have good understanding of Reporting Tools such as Tableau / Power-BI / AWS Quicksight
• Should have exposure to Data Governance