Role Name: Teradata / Semantic Developer
Location: Chicago, IL
Duration: 6 Months
Mandatory Skills/ Roles & Responsibilities:
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
Roles and Responsibility:
Experience in reporting/OLAP tool - Business Objects
Demonstrated ability to respond to changing priorities, multiple tasks and demands within short timeframes.
Good written and oral communication
Data Warehouse knowledge and TD performance tuning experience needed
Able to handle project independently and manage client expectations and deliverables in a timely manner
Experience in working in offshore / onshore Model
Experience in working in retail functional areas . i.e., Loyalty , Campaigns, etc..,
Kindly send us the following Mandatory details along with the updated resume for immediate Consideration:
| Full Legal Name |
|
| Email ID |
|
| Contact Number |
|
| Current Location |
|
| Willing to Relocate (Yes/No) |
|
| Visa Status and Validity |
|
| Best Time for Evaluation |
|
| Start Availability |
|
| Total Work Experience |
|
| US Work Experience |
|
| Hourly Rate |
|
| Last 4 Digit Of SSN# |
|
| Date of Birth |
|
| Year of passing Bachelor's Degree & University with Star & Ending Yer |
|
| Year of Entry in US |
|
| Skype ID |
|
Thanks & Regards
Prasad
United Software Group Inc..,
565 Metro Place South. Suite # 110
Dublin, OH 43017
Phone: 614-408-9313
Fax: 1-866-764-1148
(G/Y) : prasad1.itrecruiter
prasad.ks@usgrpinc.com
www.usgrpinc.com
"Relationship first, Business next"
To unsubscribe from this mailing, please reply to this email with the word UNSUBSCRIBE in the subject line, or click here.
To post a job send email to: xrecnet@googlegroups.com.
To unsubscribe send email to: xrecnet+unsubscribe@googlegroups.com
___________________________________________________________________
Visit http://xrecnet.blogspot.com for IT Recruitment News, Articles, Recruiting Tools & Resources
---
You received this message because you are subscribed to the Google Groups "Xrecnet IT Recruiters Network - Corp to Corp IT Jobs & Hotlists" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xrecnet+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment