Overview
Data Modeler ( Mainframe Sources Jobs in Scarborough – Ontario at Viva Tech Solutions
Title: Data Modeler ( Mainframe Sources
Company: Viva Tech Solutions
Location: Scarborough – Ontario
Category: IT/Tech, Software Development
Position: Data Modeler ( Mainframe Sources)
Key Account abilities Work with business users to obtain data requirements and analyse source systems data.
Design and develop conceptual, logical and physical data models for the Mainframe, operational and analytical databases & other file sources
Work closely with the technical and application architects, and developers to implement the solution architecture for on-prem & Cloud Maintain technical & business metadata. Generate metadata for Mainframe copybooks, Hadoop/Google cloud ingestion for different frameworks. Functional
Competencies:
Relational and dimensional data modeling and database design.
Ability to
translate business needs into technical solutions. Strong
analytical skills
.
Strong exposure on Mainframe, RDBMS & cloud data platforms
Strong SQL and Erwin (modeling) skills
Knowledge of data architectural approaches, patterns and emerging technologies
Experience creating architecture and strategy artifacts
Experience of
EBCDIC, xml, json and Hive (Hadoop)
Experience working
in Agile environment
Domain Knowledge in financial services and enterprise functions
Knowledge of database administration, database performance tuning, source & target data structures, ETL processes & products