Data Modeller

Job Description

Job Description Overall 7-10 yrs of IT experience with a Bachelor's degree in computer science, information technology, or a similar field. Must have 4+ years strong experience in Data modelling. Able to understand, analyze and design enterprise data model, and have expertise on any data modelling tool Erwin,power designer. Have created flexible and scalable model Have experience at least two end-to-end implementation of cloud data warehouse. 3 years of hands-on experience with physical and relational data modeling. Expert knowledge of metadata management and related tools. Supporting and providing consultation to database users and developers Preparing accurate database design and architecture reports for management and executive teams Overseeing the migration of data from legacy systems to new solutions Recommending solutions to improve new and existing database systems Experience with team management. Excellent communication and presentation skills. Roles & Responsibilities Involvement in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support. Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators, Data Engineers and BI Developers. Strong skills in SQL, PL/SQL packages, functions, stored procedures, triggers and materialized views to implement business logic in database. Develop mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions , and corporate meta-data definitions. Exceptional communication and presentation skills and established track record of client interactions. Experience with Database SQL tuning and query optimization tools like Explain Plan. Experience in designing Conceptual, Logical and Physical Data Models SKills - Data-Modeler, Data-Modelling, Erwin, Power-Designer, SQL