Job Description :
Experience/Responsibilities:
Master Data Documentation
Maintain Corporate Data Model
Maintain Data Dictionary
Maintain Confidentiality documentation
Administer process for ensuring TEP adheres to the NS data confidentiality policies
Master Data Access
Creating/Maintaining Views
Assisting SQL development for Data Services
Query Performance
Master Data Maintenance
Coordinate Database Administration
Assist with Replication Method decisions & setup
Define, Create, and Coordinate Data Synchronization processes
Create Data Quality Views
Master Data Development
Maintain a Project Plan for implementation of areas of Master Data for Replication, Synchronization, Views, Services
Assist with Tool Evaluation & Proof of Concept for MDM tools for future direction
Develop Enterprise Information Management strategies and roadmap
Develop conceptual, logical and physical data models
Develop Data Governance and Stewardship strategies
Define policies, standards and guidelines for Enterprise Data Architecture
Skills:
Good Documentation and Communication skills.
Effective independent and team player and self-starter with high adaptability to new technologies.
ETL Tools: IBM Datastage 8.x, 9.1, Embedded SQL, PL/SQL, SSIS
Data modeling Tools: Erwin, Power Designer, MS Visio, Toad, SQL Developer
MDM Tools: IBM Enterprise MDM
RDBMS: Teradata, DB2, SQL Server, Oracle
BI/OLAP tools: Spotfire, Jaspersoft, OBIEE, Business Objects, SSAS, SSRS, Oracle 11i, Microsoft Power BI Platform
Other Tools & Utilities: Oracle SQL developer, Toad, Teradata SQL Assistant, Microsoft Visio, Microsoft Office, XML Spy, UML
Languages: SQL, PL/SQL, Shell scripting, Java, Javascript
Operating Systems: Windows 8/7, Linux (REL)