Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 22nd Dec 2020
Competencies: Data Concepts & Data Modelling
Essential Skills: Data Modeler Position Requirements:Position Summary:The Data Modeler (DM) will consult with product management, information technology, data analytics, and other stakeholders to design logical data models (LDM’s) that normally act as the blueprint of a given line of work. The DM will then have to convert the LDM to a physical data model, walk the development team through the model, and then work with the responsible DBA to implement the model in a schema. The DM will have to develop a detailed knowledge of the underlying data and data products within the enterprise and become the subject matter expert (SME) on content, current and potential future uses of data, and the quality and interrelationship between core elements of the data repository and data products. The DM must be able to define how the information will be captured, retained and exploited. This individual must possess a combination of business knowledge, technical skills, and people skills to define and guide data strategies for projects.The successful candidate must be able to provide technical and data leadership to the application development group and other IT groups within the enterprise by being conversant with these teams, and cognizant of the future direction of systems, and a) how that direction will impact the enterprise, b) how future and current systems can be exploited for the benefit of the enterprise.Job Duties:The data modeler serves a critical role in the understanding, documentation, analysis, and design of proposed systems. This role encompasses all aspects of data management; conceptual, logical, and physical data model creation; being involved in end-to end data lifecycle management activities; evaluating and recommending new and emerging data management and storage technologies, and standards.Some of the daily activities include:• Reviewing Business Requirements Documents (BRDs) and/or User Stories (Agile methodology), translating them into viable conceptual and subsequently, logical data models• Creating data models that conform to existing standards and conventions• Develop mapping documents that demonstrate data lineage as well as the underlying logic for transformation• Revising data dictionaries, governance practices, and standards• Profile existing data by writing SQL scripts in the source systems to identify patterns• Convert Logical Data Models (LDMs) into working Physical Data Models (PDMs), document and maintain lineage between the two artifacts• If needed, convert the PDM into Dimensional Models for reporting purposes• Interact with different stakeholders and gather information that would help solve the challenge at hand and help achieve the long-term goals of the projectMinimum Qualifications:• 10 years of experience with information technology programs and services • 5 years of logical data modeling experience with demonstrated expertise in the analysis and design of large-sized systems• Thorough knowledge of ERwin Data Modeler (V8 or higher) or a comparable CASE tool• Knowledge of Agile development methodology and concepts• Understanding of information systems and data life-cycle management best practices and methodologies, formal systems engineering life cycle (SELC), and systems development life cycle (SDLC).• Experience with enterprise data management technologies, including database platforms, ETL tools, and proficiency in SQLRequired Skills:• Excellent communication skills• Hands-on SQL experience• Working knowledge of functional and data decomposition techniques• 5-7 years of overall data architect experience• Strong hands-on experience with the ERwin Data Modeler (V8 or above), or a comparable data modeling tool (ER Studio)• Experience with Service Oriented Architecture (SOA), web services, enterprise data management, information security, applications development, and cloud-based architectures• Experience with three or more of the following DBMS technologies: Oracle, Microsoft SQL Server, Greenplum, Sybase and UDB• Experience in translating business requirements documents into design artifacts, employing the core design principles• Ability to create process flow, data flow, and state diagrams• Thorough knowledge of Microsoft Office suite of productsDesired Skills:• Experience with any ETL tool (Informatica, DataStage, etc.)• Experience with any Business Intelligence (BI) tool (i.e. Cognos, MicroStrategy, Business Objects, etc.)• Knowledge of configuration management and version control processes• Experience with any commercially available industry data model (i.e. IBM’s Financial Services Data Model)• Good understanding of the concepts in the financial industry, especially in the areas of trade, clearing and settlement• Experience with any data profiling/data discovery tool• Working knowledge of data analytics and data mining techniquesEducation/Certification:• Bachelor’s degree in an appropriate area of specialization; advanced education• Understanding of two or more industry standard frameworks, including DAMA, DMBOK, or Zachman Framework• Data management and data architecture related certifications (i.e. TOGAF)
Role Description: Data Modeler Position Requirements:Position Summary:The Data Modeler (DM) will consult with product management, information technology, data analytics, and other stakeholders to design logical data models (LDM’s) that normally act as the blueprint of a given line of work. The DM will then have to convert the LDM to a physical data model, walk the development team through the model, and then work with the responsible DBA to implement the model in a schema. The DM will have to develop a detailed knowledge of the underlying data and data products within the enterprise and become the subject matter expert (SME) on content, current and potential future uses of data, and the quality and interrelationship between core elements of the data repository and data products. The DM must be able to define how the information will be captured, retained and exploited. This individual must possess a combination of business knowledge, technical skills, and people skills to define and guide data strategies for projects.The successful candidate must be able to provide technical and data leadership to the application development group and other IT groups within the enterprise by being conversant with these teams, and cognizant of the future direction of systems, and a) how that direction will impact the enterprise, b) how future and current systems can be exploited for the benefit of the enterprise.Job Duties:The data modeler serves a critical role in the understanding, documentation, analysis, and design of proposed systems. This role encompasses all aspects of data management; conceptual, logical, and physical data model creation; being involved in end-to end data lifecycle management activities; evaluating and recommending new and emerging data management and storage technologies, and standards.Some of the daily activities include:• Reviewing Business Requirements Documents (BRDs) and/or User Stories (Agile methodology), translating them into viable conceptual and subsequently, logical data models• Creating data models that conform to existing standards and conventions• Develop mapping documents that demonstrate data lineage as well as the underlying logic for transformation• Revising data dictionaries, governance practices, and standards• Profile existing data by writing SQL scripts in the source systems to identify patterns• Convert Logical Data Models (LDMs) into working Physical Data Models (PDMs), document and maintain lineage between the two artifacts• If needed, convert the PDM into Dimensional Models for reporting purposes• Interact with different stakeholders and gather information that would help solve the challenge at hand and help achieve the long-term goals of the projectMinimum Qualifications:• 10 years of experience with information technology programs and services • 5 years of logical data modeling experience with demonstrated expertise in the analysis and design of large-sized systems• Thorough knowledge of ERwin Data Modeler (V8 or higher) or a comparable CASE tool• Knowledge of Agile development methodology and concepts• Understanding of information systems and data life-cycle management best practices and methodologies, formal systems engineering life cycle (SELC), and systems development life cycle (SDLC).• Experience with enterprise data management technologies, including database platforms, ETL tools, and proficiency in SQLRequired Skills:• Excellent communication skills• Hands-on SQL experience• Working knowledge of functional and data decomposition techniques• 5-7 years of overall data architect experience• Strong hands-on experience with the ERwin Data Modeler (V8 or above), or a comparable data modeling tool (ER Studio)• Experience with Service Oriented Architecture (SOA), web services, enterprise data management, information security, applications development, and cloud-based architectures• Experience with three or more of the following DBMS technologies: Oracle, Microsoft SQL Server, Greenplum, Sybase and UDB• Experience in translating business requirements documents into design artifacts, employing the core design principles• Ability to create process flow, data flow, and state diagrams• Thorough knowledge of Microsoft Office suite of productsDesired Skills:• Experience with any ETL tool (Informatica, DataStage, etc.)• Experience with any Business Intelligence (BI) tool (i.e. Cognos, MicroStrategy, Business Objects, etc.)• Knowledge of configuration management and version control processes• Experience with any commercially available industry data model (i.e. IBM’s Financial Services Data Model)• Good understanding of the concepts in the financial industry, especially in the areas of trade, clearing and settlement• Experience with any data profiling/data discovery tool• Working knowledge of data analytics and data mining techniquesEducation/Certification:• Bachelor’s degree in an appropriate area of specialization; advanced education• Understanding of two or more industry standard frameworks, including DAMA, DMBOK, or Zachman Framework• Data management and data architecture related certifications (i.e. TOGAF)