Total yrs of experience : 10 to 15yrs
Data Modeler- Architect Level
The primary purpose of this position is to work as an Expert Data Modeler.
This position will work closely with business owners to capture the business requirement and translate it to Enterprise data Model
ROLE AND RESPONSIBILITIES
Having thorough knowledge on Enterprise Data architecture principles and standards, best practices, industry standards
Enterprise data model development and standardization experience. Excellent knowledge of Conceptual, Logical and Physical data models
Thorough knowledge of Erwin Data Modeler or a comparable data modeling too; along with preparation of DDLs from the model or creating the model report.
Working knowledge of data warehousing concepts and the ability to convert a physical design into a dimensional design
Review and understand data requirements including reporting, analytics and data warehousing.
Collaborate with business and IT partners to refine and document system data requirements
Perform data analysis activities including data profiling, creation of data dictionaries, data transformation rules and integration requirements
Knowledge of Agile development methodology and concepts
Participate and oversee all stages of systems development life cycle (requirements, design, coding, testing, and implementation)
Create Tables, Views, Indexes, Sequences, PL / SQL Packages, Stored Procedures, Functions, Triggers, SQL statements in Oracle
Performance Tuning including tuning / optimizing existing SQL, PL / SQL code
Experience with the DBMS technologies : Oracle, MS SQL Server, Sybase, MySQL.etc.
Reviewing Business Requirements Documents (BRDs) and / or User Stories (Agile methodology) and translating them into viable conceptual and subsequently logical data models
Translate the business requirements into design artifacts, employing the core design principles
Profiling the data in the source system(s) by writing SQL statements
Develop mapping documents that demonstrate data lineage
Revising data dictionaries, governance practices, and standards
Provides advice to business and technical personnel on data analysis principles, methods and trends
Designs complex Data Transformation Strategies for Business Intelligence or Data Migration
Salary : INR 15,00,000 - 30,00,000 PA.
Industry : IT-Software / Software Services
Functional Area : IT Software - Application Programming, Maintenance
Role Category : Programming & Design
Role : Software Developer
Employment Type : Full Time, Permanent