CTC004898 - Database Modeler

Secteur industriel: Telecommunications

Type d'emploi: Contract

Durée:

Mode de travail: On Site

Description

IMPORTANT

Top 3 skills:

Analyze and provide database schema and data flow design for OLTP and OLAP data model

Work with application owner, analyst and developers and oversee end to end solution implementation

Strong experience ER data modeling tools and with SQL (design and profiling)

Description:

RESPONSIBILITIES

Gather business requirement and translate into logical and physical data model design

Reverse engineer current applications design and provide enhanced model and data flow architecture

Design application relational model (OLTP), Star schema model (OLAP) and ETL documentation (STM)

Work with application owner, analyst and developers and oversee end to end solution implementation

Data profiling current RDBMS application and related system to assure model and data quality

Work in a prototyping and development environment, test your solution with developers and produce database DDL for production

Optimize design to prevent application bottlenecks and implement data archiving strategy

Provide estimate, work breakdown structure (WBS) and progress status

Conduct and create scenarios for functional and integration unit testing in different environment

Post deployment application support, fix and enhancement to data model REQUIREMENTS

Strong experience with SQL language

Strong experience with ER data modeling tool (ex: Erwin, Oracle Data Modeler, etc.)

Experience with SQL server

Experience with Git and Team Foundation

Experience with Word, Excel and PowerPoint

Experience in both data warehouse and OLTP databases architecture

Communication skills and team collaboration

At least 5 years of experience in data modeling

Bachelor degree in computer science, engineering, or equivalent related project experience.

Other beneficial skills: Programming knowledge on ASP, VB.NET, C# and JAVA

Job Location: Montreal, QC.