Required Skills

SQL databases

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 2nd Sep 2022

JOB DETAIL

Looking for experience withERWIN as a modelling tool. Experience with multiple Responsibilities

• Work with application/solutionteams to implement data strategies, build data flows, and develop

conceptual/logical/physical datamodels

• Create logical and physicaldata models using best practices to ensure high data quality and

reduced redundancy. • Define andgovern data modeling and design standards, tools, best practices,

and related development forenterprise data models.

• Identify the architecture,infrastructure, and interfaces to data sources, tools supporting

automated data loads, security concerns,analytic models, and data visualization.

• Hands-on modeling, design,configuration, installation, performance tuning

• Understand and translatebusiness needs into data models supporting long-term solutions.

• Optimize and update logicaland physical data models to support new and existing projects.

• Maintain conceptual, logicaland physical data models along with corresponding metadata.

• Develop best practices forstandard naming conventions and coding practices to ensure

consistency of data models. •Recommend opportunities for reuse of data models in new

environments.

• Perform reverse engineering ofphysical data models from databases and SQL scripts.

• Evaluate data models andphysical databases for variances and discrepancies.

• Validate business data objectsfor accuracy and completeness.

• Develop data models accordingto company standards.

• Guide System Analysts,Engineers, Programmers and others on project limitations and capabilities,

performance requirements andinterfaces.

• Review modifications toexisting software to improve efficiency and performance.

• Examine new application designand recommend corrections if required. Requirements

• Bachelor’s or master’s degreein computer/data science technical or related experience.

• 5 years of hands-onrelational, dimensional, and/or analytic experience (using RDBMS,

dimensional, NoSQL data platformtechnologies, and ETL and data ingestion protocols).

• Experience with datawarehouse, data lake, and enterprise big data platforms in multi-data-center

contexts required.

• Good knowledge of metadatamanagement, data modeling, and related tools (Erwin or ER Studio

or others) required.

• Experience in inter-team,communication, and presentation. databases (Teradata, Oracle,

SQLServer, D

Company Information