Location: Islamabad, Islamabad PK
Requisition Number: 210464
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.
- 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 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.
Skills and Qualifications
- S. / M.S. in Computer Sciences, Software Engineering, Computer Information Systems
- Data Warehouse modeling experience of at least 3-4 years
- 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.
- Work with the appropriate project management methodology (Agile or Waterfall) based upon customer and project requirements
- Experience on Teradata logical data models specially in financial domain will be an added advantage.
- Understanding of Teradata Reference Information Architecture and the Unified Data Architecture would be an advantage
- Prior experience with Teradata data models will be a big advantage
Community / Marketing Title: Data Modeller
Job Category: Consulting
Teradata helps businesses unlock value by turning data into their greatest asset. We’re the cloud data analytics platform company, built for a hybrid multi-cloud reality, solving the world's most complex data challenges at scale. Collectively, we endeavor to serve equal parts innovator and contributor. Because our mission isn’t just about the collection of data – it’s about revolutionizing the future of transportation to save lives, optimizing energy costs to make the planet a cleaner place, and using data to predict and identify cancer risks.
Location_formattedLocationLong: Islamabad, Islamabad PK