Home   Register   Sign In
Company Info
Maganti IT Resources LLC

5 meadow street,suite 201&202.
naugatuck, CT, United States

Phone: 2035670144
Web Site: www.mitresource.com

Company Profile

Data Modeler Position at Portland,OR


Job ID:



Portland, OR, United States 


Business-Development, Information-Technology, Retail

Job Views:


Zip Code:


Employment Type:

Contract - Corp-to-Corp



Job Description:

Position: Data Modeler
Location: Portland,OR
Duration: 3+ months
Job description:
  • Participate in requirements as definition, analysis, and design of EDW solutions
  • Drive design of data structures within an EDW environment (all layers) to ensure that business requirements are met
  • Facilitate modeling sessions with business and technical disciplines.
  • Create Conceptual/Logical/Physical models for EDW staging and data integration, and analytics and reporting.
  • Conduct model reviews with project team
  • Develop data requirements/technical specifications for data transformations across EDW layers
  • Drive metadata capture through data modeling application (ERwin)
  • Establish and support Standards, Guidelines, and Best Practices for data modeling
  • Drive model management and version control of all data models
  • Collaborate with BI team to create data structures for reporting
  • Collaborate with ETL team to create data structures that facilitate data integration
  • Collaborate with DBA team to capture volumetrics and optimize data structures for data integration and reporting.
Required skills:
  • Fluent in both 3NF and Dimensional modeling techniques and solutions
  • Proficiency in SQL and other DBMS language tools
  • Exposure to Master Data Management solutions
  • Strong familiarity with reporting tools such as Cognos
  • Strong familiarity with integration tools such as Informatica
Education and Experience:
  • Bachelor's Degree in Software Engineering, Computer Science or Information Systems (or equivalent experience).
  • 5+ years’ experience using data modeling tools such as ERwin or ER Studio
  • 5+ years’ experience working with ERP data (JDE, SAP)
  • 5+ years of SQL experience
  • 5+ years working with large DBMS systems (Teradata, DB2, Oracle)
  • Experience in Retail industry a plus
Should someone need more information I can be reached at satishm@mitresource.com or 203-567-0144.
Thank you for your time

© 2016 Powered by Rootjobs     About Us   Sitemap   Terms and Conditions   Privacy Policy   Mobile Version     Twitter RSS LinkedIn Facebook