Alp Consulting Ltd.
Website:
alp.consulting
Job details:
· Job Description:
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.
Click on Apply to know more.