Role Requirements & Responsibilities
Experience in translating business and functional requirements into logical and physical data models that follow industry best practices and company standards and guidelines.
Experience with ER/Studio or ERWin.
Perform logical data modeling using both relational and dimensional modeling techniques as appropriate.
Design core database assets provides data architectural services and ensure consistent standardized solutions.
Working knowledge of ETL technologies and associated implementation methodologies.
Strong SQL skills to support analysis of data t.
Strong DB2 experience is a must.
Strong communication skills, both verbal and written.
A motivated team player.
Demonstrated ability to translate business needs into data solutions.
Thorough understanding of data architecture and data modeling concepts.
5 + years of experience in data warehousing with designing multi-layered data warehouses and data marts using both relational and dimensional modeling techniques.
5 + years of experience in integrating data both at logical & physical levels.
5 + years of experience with Erwin and ModelMart or equivalent tool.
8+ years working with multiple DBMS (SQL Server, Oracle, DB2, Teradata, etc.).
Experience using native SQL against relational databases.