Data Architect/Modeler

Bridgewater, NJ. Posted 2 years ago

Resource Informatics Group Inc
400 E Royal Lane
Posted By
Sravan Annam
6 Months
Start Date
Tech Category
10 - 11 Years
Tech Sub-Category
Work Permit
Any Work Permit encouraged to apply
Tax Terms

Job Description

Job Title : Data Architect / Modeler 

Location : Bridgewater, NJ

Duration : 6+Months

Role Overview: 
ETL Technical Lead to gather requirements, design and implement IBM InfoSphere based ETL ecosystem for enterprise Ware house implementation. Candidate should have experience in designing complex data warehouse specific ETL solution and working geographically diverse development teams.
Job Responsibilities: 
- Technical expertise regarding data models, database design development, data mining and segmentation techniques 
- Ability to lead technical discussion with Client partners – converting business requirement for Data warehousing solution to appropriate Data Design components and frameworks 
- Strong knowledge of and experience with ETL frameworks, BI and Analytics framework , databases, PL/SQL programming.
- Must know Enterprise level application modeling and inter relation of application for Data Ware house Solution.
- Understand the data requirements for the project and drive the solution based on the information needs. 
- Ability to understand the implications & understand how the data will be used in upstream/downstream applications and accordingly guide the team on logical / physical models using Erwin application or equivalent modeling tool
- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy 
- Adept at queries, identifying errors in data and presenting findings 

Data warehousing expertise/tools: Data Marts/ Materialized Views/Star Schema, Erwin, Oracle.
Skills Required:
- 10+ years of experience in Complex data Ware house solution and knowledge of Data modeling techniques for enterprise applications and/or ware housing solutions.
- Advance knowledge of Data warehousing concepts and BI Components. 
- Experience in working with in complex source system and data acquisition environment. 
- Ability to correlate different modules for data ware house solution components – ETL, DW modeling, Reporting and Analytics
- Familiarity with advance ETL concepts to build complex warehouse solutions.
Good to have Skills
- Experience in building complex DataWare house solutions for Supply chain domain.
- Experience working with accounting reconciliation applications, SAP modules and specific accounting report solution will be handy.

Key Skills
data warehouse etl data models database design development data mining techniques etl frameworks bi and analytics framework databases pl/sql programming analytical skills data warehousing data marts/materialized views star schema erwin oracle data modeling techniques data acquisition environment chain domain accounting reconciliation applications sap modules accounting gather requirements infosphere etl ecosystem frameworks solution based on the information needs data warehousing concepts and bi components modules reporting and analytics

Similar Jobs