Sign In
 [New User? Sign Up]
Mobile Version

Senior Data Modeler

Secunderabad, Telangana
Job Code:
  • Banking & Finance
Applying for this job will take you to an external site
  • Shortlist
  • Email Friend
  • Print

Job Details

As member of the CST Data Management COE, the Data Modeler will lead the effort in developing a consistent use of data and logical and physical data architecture across the Control System Technology portfolio including data/database standards/guidance, business glossaries, data dictionaries, conceptual, logical and physical data models, mapping between models/ systems, and creation of data definition language (ddl) in a framework of OLTP, OLAP, and Data Warehouse design methodologies. The Senior Data Modeler will work closely with the Database Engineer to instantiate DDL into the Test and Production environments. The Data Modeler will conduct model reviews and tests, and work closely with development teams to ensure consistency during application builds and upgrades. She/he will ensure Firmwide standards and guiding design principles are adhered to when mapping and auditing data/information assets as they flow from upstream and are delivered to downstream systems and/or display sub-systems.ResponsibilitiesTranslate Business Requirements to Conceptual and Logical Data Models (ERDs Entity relationship Diagrams)Create Physical Data Models (ERDs), of different types, from Logical Data ModelsRecognize the need for a specific relational design OLTP, OLAP, Data Warehouse from a set of project requirements, and/or from a Logical Data ModelMapping of Logical to Physical Data Models and vice versaCreate DDL from Physical Data ModelsWork closely with Database Engineering to move DDL to Test and Production environmentsEvaluate other Modelers logical and/or physical data models for (a) adherence to LDM modeling principles, such as 3NF (b) adherence to CST Standards and Guidelines and (c) a match between business requirements and model content.Participate in model design reviews and testingExplain/ teach classical Conceptual, Logical and Physical Data ModelingManage multiple assignments simultaneously, while working independently, and with other engineers and SMEsIdentifying, recommending and implementing emerging Modeling and IT trends, developments, tools and improvements/solutionsExcellent problem solving skills and technical reasoningThe Ideal candidate will have 8 years experience with the following10 years of employment history in the Financial Services industry and a corresponding history of data models deliveredExpert in both OLTP 3NF modeling and Kimball-style dimensional modeling; OLAP is a plusFamiliarity with SDLCA track record of using Erwin, versions 7 9; experience with other data modeling tools will be consideredExcellent problem solving skills and technical reasoningAwareness of other modeling techniques such as UMLFamiliarity with reference data at the global and local levelFamiliarity with a standard Financial Industry Data Models (examples IBM, Teradata, etc.) is a plus, but not required
Degree: MCA/ PGDCA

Additional Degree: BE/ B.Tech (Engineering)

Experience: 10-15


Data Warehousing | Database Administration (DBA) | Quality Assurance/Testing | System Analyst/Tech Architect
Applying for this job will take you to an external site


© Copyright 2015 Al Nisr Publishing LLC - powered by Gulf News