US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 2nd Sep 2022
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