Cognos Developer - Business Intelligence

Soft tech Career Info system Pvt. Ltd
  • Chennai
  • 10-15 lakh
  • 3-5 years
  • Views
  • 18 May 2017

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

- Participate in creating Data models and Architecture strategy and deliverables such as architecture, interface, detailed, database design documents.

- Create a conceptual data architecture including the data representations at each point in the data flows to cover Regulatory Affairs, R&D QA and PPS/Safety (RQS data model); develop Logical Data Model (LDM) and Physical Data Model (PDM)

- Create logical model(s)

- Participate in finalizing Source to Target Data Map

- Perform data quality analysis

- Able to utilize data profiling results to identify data issues and challenges. Able to define, test and communicate solution

- Able to work jointly with Data Stewards to develop Conceptual, Logical and Physical data models

- Collaborate with Data Stewards as well as developers on data modeling practices

- Create / maintain data model change control / version control procedures, emergency change procedures, and monitor new software releases impacts

- Develop / promote ongoing maintenance of standards/ best practice templates on naming / usage of tables / views / attributes / triggers / stored procedures, de-normalization cost/benefit, DB-referential integrity vs. programmatic RI enforcement

- Support OLTP/OLAP ETL from core databases; available for consultation on OLAP designs / slow changing dimension (Type 1, 2, 3)- conform dimension design, facts, measure, factless fact.

- Map and document data subject areas related to analytical needs

- Document data quality issues through observations.

- Assist in defining processes and culture for agile implementation approaches

Competencies/Skill sets for this job

Agile Consultation Database Design

Job Posted By

O.P. Chawla