Experience with designing data warehouses, Table design and architecture, and data modeling using Erwin (logical design, conceptual design, and physical design).
•Proven experience in an Enterprise Data Warehouse
•Ability to effectively communicate with business users to translate Business requirements into Technical Specs.
•Technical skills in RestAPI or Mulesoft
•JSON required and XML preferred
•Designed Physical and Logical Models.
•Modeling software: Erwin
•Querying tool: AQT
•Data Models: Star & Snowflake Schema
•Environment: SQL Server, DB2
•Where our data is found: SAP, DB2 databases, Sales Force, and MS SQL Server
•Master’s or Bachelor’s degree in Computer Science, Data Science, MIS, Mathematics or related area and
•Demonstrated analytical and computer proficiency necessary through a combination of work and class work.
•5+ years of experience creating connectors, building interfaces, and developing data warehouses from a "Source of Record"
•Experience with warehouse data extraction/transformation and load tools, as well as metadata repository tools.
•Advanced proficiency in relational Database concepts, Database design using star and snowflake schema along with ability to write and execute complex SQL queries and stored procedures.
•Convert functional requirements into technical specifications. Perform data analysis, data mapping, functional testing, unit testing, and test case preparation using required tools based on project needs.
•Knowledge of various database platforms (DB2, SAP, MS SQL Server) required and experience with one or more of the following, Power BI, Informatica, Azure Cloud, IoT, MuleSoft, AQT, ErWin Data Modeling.
•Design and develop DDL scripts, ad hoc queries and data models for high performance projects and deliverables. Understand and evaluate existing SQL scripts and Data Models.
•Demonstrate ability to communicate technical recommendations to a non-technical audience in a clear and concise manner.
•Demonstrate ability to understand logical relationships and to ensure that programming faithfully replicates these relationships.
•Demonstrated ability to test and validate programming steps