Dice - The career hub for tech™
  • Post Jobs

More Jobs Like This

Data Warehouse Architect (Oracle) Holland Technologies, Inc. - Kansas City, MO US
Database Programmer Randstad Technologies - Kansas City, MO US
Oracle Applications Developer Genesis10 - Kansas City, MO US
OBIEE Developer Genesis10 - Kansas City, MO US
Oracle DBA Randstad Technologies - Kansas City, MO US

Dice Instant Referrals

Powered by Facebook

Who you know gets you noticed

You can add Facebook friends as Instant Referrals to your application.

Data Modeler

Location:
Kansas City, MO 
Area Code:
913 
Telecommute:
no 
Travel Required:
none 
Skills:
Data Modeler, Kimball 
Pay Rate:
DOE 
Tax Term:
FULLTIME CON_W2 
Length:
Long Term 
Date Posted:
7-24-2014 
Position ID:
865298 
Dice ID:
saicon 

Responsibilities:

  • Data Modeling for both transactional and data warehouse databases
  • Creation of ETL Mappings; mapping of tables from source to target using standard SDLC mapping templates
  • Creation of EAI Mappings; mapping of XML Schemas from source to target using standard SDLC mapping templates – nice but not required
  • Create and maintain data model
  • Create queries and stored procedures in SQL
  • Profile data and validate results
  • Communicate with customers to obtain data requirements and perform data analysis on data provided

Required Qualifications:

  • Must have 4 years experience in writing/developing SQL queries.
  • Minimum 3 years of software development experience - nice but not required
  • Experienced in defining and manipulating complex SQL including mathematical functions, grouping, joins, sub-select, etc.
  • Experienced in data loading, extraction and manipulation for diverse RDBMS- specifically SQL Server and Oracle - nice but not required
  • Strong skills in Microsoft Excel and other spreadsheet formats for data analysis, organization, and loading
  • Knowledge of Ralph Kimball methodology.
  • Experience in query tuning and concepts
  • BS/MS in Computer Science, Software Engineering, or related areas

Familiarity with following tools/technologies

  • Data Modeling: Embarcadero ER/Studio – this is a plus but not required as long as the candidate has used Erwin, PowerDesigner, etc.
  • XML Tool: XML Spy - nice but not required
  • Query Tools
  • Data/SQL Mapping
  • Databases: SQL Server - nice but not required
  • Knowledge of any of the following Subject Areas would be a Plus:  Marketing; Loyalty; Campaign Management; Sales ( Point of Sale Systems), Customer MDM, Product MDM




Please send resume at  ****   schattopadhyay@saiconinc.com *******



  

Shambhunath Chattopadhyay
Saicon Consultants Inc.