Required Skills

SQL Erwin OLTP

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 8th Jan 2025

JOB DETAIL

  • Develop, maintain, and enhance conceptual, logical, and physical data models for various business domains and applications.
  • Experience in building Data models in OLTP Systems from the scratch.
  • Experience in building generic DATA models for File Processing, Document Processing, Hierarchy models, Data Auditing, Notifications.
  • Translate business requirements into data models ensuring structural integrity and compliance with organizational standards.
  • Design and optimize database structures to support data storage, retrieval, and analysis.
  • Collaborate with database administrators and developers to implement data models in database systems (SQL Server, Oracle).
  • Ensure data integrity, security, and performance through proper database design and optimization techniques.
  • Perform data profiling, analysis, and validation to identify inconsistencies and anomalies.
  • Collaborate with stakeholders to elicit, analyze, and document data requirements.
  • Create clear and comprehensive documentation of data models, including entity-relationship diagrams, data dictionaries, and metadata.
  • Support data integration projects by mapping data sources to target data models and designing data transformation processes.
  • Facilitate data migration efforts, ensuring seamless transition of data from legacy systems to new platforms or environments.
  • Work closely with business analysts, developers, and project managers to align data modeling efforts with project timelines and objectives.
  • Conduct quality assurance reviews of data models to ensure accuracy, completeness, and usability.
  • Identify and resolve data model-related issues, such as performance bottlenecks, data anomalies, and schema conflicts.
  • Contribute to the overall success of the team by actively participating in meetings, sharing insights, and contributing innovative ideas.

Company Information