Source data analysis and Business requirement analysis. · Understanding the business requirements and translating them into Logical Data Models. · Creating Physical Data Model using Dimensional Modelling techniques. · Working with the DBA in creating efficient table designs. · Create and Maintain Data Model documentation. · Understand business transformation logic and create Data Mapping document (Source System to Target systems). · Creating ETL jobs as and when required. · Advising the reporting team on efficient methods of data retrieval. ·Skill Set:
Basic Qualification: · 6+ years of experience in Data Warehousing. · 5+ years of experience in Data Modelling. · 3+ years of experience in ETL. · Reporting experience preferred.
Required Skills: · Data Modelling concepts ʍimensional and Relational) · Data Modelling best practices and techniques · Logical Data Modelling · Physical Data Modelling · Advanced SQL Skills · Experience with databases like DB2, Netezza · Hands on Data analysis skills. · Experience in Manufacturing or Supply chain centric industries would be preferred · Hands on experience in ETL using Data Stage. · Hands on experience in Infosphere Data Architect would be preferred.
Technology and Tools: · RDBMS databases like DB2, Oracle. DB2 preferred. · MPP databases like Netezza, Teradata. · Brio · SQL · Infosphere Data Architect · Data Stage · Cognos (Good to Have)
Job Description :
To ensure customer service and support all operations. To create customer delight at every interaction.
Interacting with external customers and internal customers and addressing their queries, requests and complaints.
Committed TATs are met consistently
Complaints Management- addressing customer complaints at the branch, system updation, coordination with Sales/HUB/ other functions for resolution.
Refunds processing and dispatch
Undelivered policy documents tracking and management.
Maintenance of all files and registers.
New Business Processing:-
Handling end to end New business processing starting from creation of Client id,Case start up, New business login, Follow up for policy issuance, Quality Check
Follow up with HUB for policy issuance of pending cases