Technical Architect (MSBI)

JOB DESCRIPTION FOR THE ROLE OF TECHNICAL ARCHITECT (MSBI):

- 10+ years in IT with 5+ years in depth experience in Data Warehouse Projects
- Extensive experience to perform Data Analysis Activities
- Good hands on experience in MSBI technology
- Designs Data Architectures
- Designs and builds relational databases
- Develops strategies for data acquisitions, archive recovery, and implementation of a database
- Be able to design and develop Databases, Data Warehouses and Multidimensional Databases
- Prepare process models in accordance with the guidelines/conventions of designated process modelling methodology, includes creation and maintenance of process descriptions and glossary of terms.
- Facilitate the exposure of process data from functional experts and the user community.
- Provide mapping between existing processes and proposed replacement processes.
- Facilitate the discovery of entities, attributes, relationships, and business rules from the functional experts and the user community.
- Maintain and publish project business rules and the associated enterprise data dictionary.
- Participates in meetings with Client to understand business requirements in detail.
- Provides inputs on data aspects of the various Files throughout the project life cycle.
- Participates in creation of ETL/ELT Specifications.
- Interact daily and carry out knowledge transition through Mail/Tele/Video conference, etc.
- Work closely with Client and internal teams to define enhancements and requirements for development activities.
- Create Source to target Data mapping documents.
- Document finalized data mappings.
- Create detail design Documents (DLD).
- Must to have Insurance Domain Knowledge.
- A wide degree of creativity and lateral thinking is expected.