Mandatory Technical Skills
Have strong experience in databases like Teradata, Netezza or Oracle etc.
Good Experience in Unix Environment
Good experience in Industry standard data modelling tools like Erwin.
Have good working knowledge of Data warehousing concepts. 3+ experience is required.
Experience in Performance tuning in DW environment.
Experience on data modeling using Dimensional as well as ER-Model
Have working Knowledge of Industry Standard Reporting/ETL tools.
Having good PL SQL Skills
Have good Banking and Financial Domain Knowledge is Must.
Preferred/Good to have
Worked in both OLTP and DW implementation
Experience on Ab Initio.
Job description
Person needs to Interacting with Project stake holders to understand functional as well as technical requirements and documenting, publishing to Team.
Experience in developing, validating, publishing, maintaining LOGICAL data models with exposure to or experience in developing, validating, publishing, maintaining PHYSICAL data models
Evaluate existing data models and physical databases for variances and discrepancies
Experience with managing meta data for data models
To develop, publish, maintain all documentation for data models
Work with Business Analysts, Data Architects, Software developers, DBAs to achieve project objectives - delivery dates, cost objectives, quality objectives, business customer satisfaction objectives, etc.
Take part Data Quality, Data governance processes
Leverage and enforce standards for data naming conventions to ensure consistency and reuse of data models
Validate business use cases for accuracy and completeness of proposed data models.
Ability to communicate strategies and processes around data modeling and architecture to cross functional groups and senior levels
Good hands on knowledge on Erwin knowledge is must require.
The job entails sitting as well as working at a computer for extended periods of time. Should be able to communicate by telephone, email or face to face. Travel may be required as per the job requirements.