Job Title:  Data Modeler Level II (Ref Code: 073013-FORKAT-IO39-E-RAJ)
Location:  WDC (WASHINGTON, District of Columbia)
Duration:  5 months+

Work Authorization: We are unable to sponsor H1B Visa

Job Description:

Name of Project: Integrated Planning Systems

Description of Services:
Data modeling, database creation and maintenance, creation and maintenance of ETL scripts, day to day support including data migration activities

Duties and Responsibilities:

General:

Minimum 4 year Engineering/Technical/Science/Communication Degree
Prepare technical documentation of existing databases, ETL feeds
Design data model and create databases for new application modules
Design and develop ETL scripts for data migration across corporate systems
Provide day to day support to users for data updates
Conduct requirements definition meetings with end users and document/validate system requirements in diagrammatic and textual format
Create and maintain Logical and Physical Data Models. Generate DDLs and DMLs.
Work on multiple systems/tasks at the same time
Create process models to represent business processes for the area under analysis
Gain an understanding of business processes and system functionality, compare current/envisioned business processes to system functionality, and document gaps
Document systems and related processes using modeling constructs use cases, activity diagrams, sequence diagrams, etc.

Technical:
Possess good data modeling skills (logical and physical data models). Minimum 2+years of hands on experience on Erwin or other modeling tools
Must have working knowledge of Oracle Database
Working knowledge of BO Universe Design is required
Possess excellent writing and communication skills. (Must provide a writing sample)
Ability to conduct presentations and interact effectively with business users and gather requirements.
Must be familiar with ETL technologies
Demonstrated analytical skills.
Working knowledge of MS SQL Server is desirable
Working experience with SAP/BW is desirable
Exposure to the financial industry would be plus


Please mention the job Title in the subject line: Data Modeler Level II (Ref Code: 073013-FORKAT-IO39-E-RAJ)
Please rush your resumes to careers@iormyx.com <mail to: careers@iormyx.com>