About the role
Primary skills:
- Database design and Data Modeling experience
- Strong with SQL with hands-on using Data Modeling tools like Power designer or Erwin
- Experience in any one of the Database like Teradata, SQL Server, Hadoop Hive, Snowflake etc
- Understand and translate business needs into data models supporting strategic solutions.
- Create and maintain conceptual, logical and physical data models along with corresponding metadata.
- Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
- Recommend opportunities for reuse of data models in new environments.
- Perform reverse engineering of physical data models from disparate databases and SQL scripts.
- Evaluate data models and physical databases for variances and discrepancies.
- Validate business data objects for accuracy and completeness.
- Analyze data-related system integration challenges and propose appropriate solutions.
- Develop data models according to company standards.
- Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces.
- Review modifications to existing software to improve efficiency and performance.
- Examine new application design and recommend corrections as required