Role Teradata / Semantic Developer
Mandatory Technical / Functional Skills 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) etc. • Experience with ERWin • Experience with Teradata Industry LDMs a big plus 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 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. 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 Other • Candidate should be TD 14 certified • Knowledge of Bus Architecture • Experience with Software Development Life Cycle, including requirement gathering, documentation testing and knowledge transfer is required. • Collaborates with business and technology resources to identify key business requirements for Business Intelligence (BI) • Experience with Data Integration, Data Mapping, ETL Work Location Chicago, IL Duration ~ 6 months *Hemendra Kumar* --------------------------------- *Sr. Technical Recruiter* 1920 Association Drive Suite # 302 | Reston | VA 20191 *Email: **[email protected]* <[email protected]> *Gtalk**: hemendramca22* *Yahoo**: hem_rajpoot2012* *Phone**: **703-468-3024* *Skype: Hemendra.rajput22* ABOUT THIS E-MAIL: The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" 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/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.
