Description

You will design and implement complex relational data models to support large-scale technical requirements.

Responsibilities

• Design, develop, and maintain logical, conceptual, and physical data models in third normalization form and canonical formats.
• Extract data requirements by reviewing business and technical artifacts alongside SMEs and analysts.
• Create technical documentation including data dictionaries, data lineage, data mapping, and data flow diagrams.
• Develop data modeling and migration strategies, including schedules and task planning.
• Monitor databases to identify and resolve data quality issues and performance bottlenecks.

Required Skills

• 10+ years of experience designing and implementing entity relational diagrams and physical relational data models.
• 10+ years of hands-on experience using data modeling software such as Erwin Data Modeler.
• Extensive experience with forward engineering DDL and reverse engineering physical databases.
• Expertise in creating subject areas, naming standards, model templates, domains, and macros.
• 7+ years of experience developing complex SQL queries, PL/SQL packages, stored procedures, functions, and views.
• 7+ years of experience in performance tuning SQL scripts, PL/SQL, complex joins, and database objects.
• Proficiency with Oracle and PL/SQL.
• Experience transforming legacy mainframe system models into modern relational database management systems.
• 7+ years of experience creating fit-gap analysis and technical data documentation.

Preferred Skills

• 10+ years of experience designing data models for data migration or consolidation in staging and OLTP environments.
• Experience importing COBOL Copybook files into data modeling software.

Key Skills

Education

Any Graduate