Job Description:

Location: PAN India

6-9 Years of experience

Database design and Data Modelling experience

Exposure to Cloud Technologies Snowflake, Microsoft Azure

Hands-on using data modelling tools like Power designer or Erwin

Experience in any one of the Database like Teradata, SQL Server, Hadoop Hive, Snowflake etc

Strong SQL skill

Understand and translate business needs into data models supporting strategic solutions.

Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.

Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.

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

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.

Data Modeler