Teradata Data Warehouse Consultant - Data Modeler in Islamabad, Pakistan

Role Description:

This role is responsible for transforming business information into logical data models and managing the enterprise data model. The candidate should be proficient in industry standard techniques for process modeling and data modeling also have skills of designing and instantiation of the physical data model based on the logical data model. The candidate must be proficient in 3rd normal form relational modeling as well as dimensional modeling. Experience with alternate modeling techniques such as Data Vault, and key modeling as it relates to Big Data would be a strong added value. This candidate must be experienced in group facilitation with participants from diverse business functions and work skills.

Keys Areas of Responsibility

  • Design and normalize the logical data model to third normal form.

  • Facilitate the discovery of entities, attributes, relationships, and business rules from the functional experts and the user community.

  • Prepare fully refined data models in accordance with the guidelines/conventions of Integration DEFinition (IDEF) or equivalent methodology.

  • Develop and manage data models and associated metadata for the enterprise.

  • Work with all related consultants to design and document semantic models.

  • Work with consultants to translate LDMs and Semantic Models into their physical representations.

  • Enhance new and existing logical models with entities to represent client specific key models

  • Work with ETL consultants to map source system data to Teradata, Teradata Aster, and Hadoop physical models.

  • Maintain and publish project business rules and the associated enterprise data dictionary.

  • Evaluate access paths for data which spans multiple deployed technologies; provide recommendations for optimizations in accessing these heterogeneous relationships.

  • Work with all Teradata Solutions including Teradata, Teradata Aster, Hadoop, and Applications.

    Basic Qualifications:

  • B.S. / M.S. in Computer Sciences, Software Engineering, Computer Information Systems

  • Data Warehouse modeling experience of at least 5-10 years

    Skills & Attributes:

  • In depth knowledge of business processes and business information models.

  • In depth knowledge of data modeling methodologies and techniques.

  • In depth knowledge of the ERwin and/or Embarcadero data modeling tool.

  • Understanding of one or more business areas and industries: Telecom, Retail, Manufacturing, Financial etc.

  • In depth knowledge of facilitation and conflict resolution processes.

  • Knowledge of Architecture Principles, Advocated Positions, Design Patterns, and Implementation Alternatives.

  • Understanding of the Teradata Reference Information Architecture and the Unified Data Architecture would be an advantage

  • Work with the appropriate project management methodology (Agile or Waterfall) based upon customer and project requirements