Required Skills :
- Good knowledge on Teradata architecture
- Ability to understand the bigger/complex logical models
- Experience in data profiling
- Experience in Design and instantiation of the physical data model in the data warehouse / data marts typically based on a existing logical data model
- Hands on experience in Reverse engineering
- Experience in Query tuning
- Good working knowledge on Data Modeling Tool preferably Erwin
- Good knowedge on model management tool and experience in multi user environment
- Knowledge of best practices in the physical modeling and ability to contribute to the organisation standards
- Integration of multiple physical data models in order to create global enterprise wide data warehouse
- Using inputs from the Logical Modeller, Database Administrators and ETL Consultants to define indexes and other performance features offered by the platform in order to create a world class Enterprise Data Warehouse.
- Knowledge on the features available in the latest versions of the RDBMS to create a performing physical model
- Good knowledge on data lineage related aspects
- Knowledge on preparing end-to-end data mapping document
Secondary skills:
- Ability to work independently and without supervision
- Comfortable working within a multi-organisation environment
- Ability to fit in / adapt to a geographically mobile consulting environment
- Need to be a very good team player
- Ability to work with senior team in order to escalate risks and issues, report progress and flag dependencies or design issues
- Experience in iLDM physicalisation is nice to have
Please mail your profile at KRam@antal.com
Didn’t find the job appropriate? Report this Job