*Teradata / Semantic Developer * *Chicago, IL*
*12 Months* 3NF (Relational) Logical and Physical Modeling • 2+years hands on experience with Logical Data Modeling (3NF) • Comprehensive Knowledge of Bill Inmon’s Data Modeling Concepts (Logical and Physical) including 3NF, Supertypes, Subtypes, Abstraction, Associative entities / tables • Physical Modeling and Performance Tuning including Primary, Secondary index, JIs, AJIs, PPIs (SLPPI, MLPPI) • Experience with ERWin • Experience with Teradata Industry LDMs a big plus TD ETL Tools • Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD. • Experience with automated data warehousing and datamart refreshes using Transportable table space option. • Worked on creating and managing partitions. • Experience with basic database health checks commands and Experience with tuning databases using Teradata Manager. Dimensional Modeling • 5+ years hands on experience designing and implementing Star Schemas • Comprehensive Knowledge of Ralph Kimball’s Data Modeling Concepts including Transaction dimensions, conformed dimensions and facts, slowly changing dimension, multi-Star/ Snowflake Schema Modeling, different types of Fact tables • Prior experience implementing DW presentation layer - including design and definition of logical tables, physical sources, dimensions, columns and aggregation rules a plus Business Intelligence • Hands-on experience with BI application architecture and development • Experience with BI tools like MicroStrategy, Cognos, Business Objects, or Tableau a plus • Experience creating mockup reports, demo, & storyline a plus Phone: 703-468-3307 -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.
