Job Title: Data Modeler(7116- PR- RECA- IO35 -VA)

Location: Vienna,VA

Duration : Long Term

Requirements:

Client is looking for 5 years of experience in working with Data quality, Teradata architecture, Teradata upgrade, Trillium debugging, Trillium workflows/concepts, Unix.
Expertise in the area of Business Intelligence, Data Warehousing and Big Data Technologies.

Experience in dimensional modeling, star schemas, snow flake schemas, Physical data modeling as well as logical data modeling.

Experience with data quality tools like Informatica IDQ and Trillium.

Requirement gathering, analysis, Design, Development using different Teradata utilities such as TPT, Mload, Fload, Fastexport and BTEQ, Informatica power centre 9.1, UNIX, Mainframes, Oracle PL/SQL.

Desired Skills:

Data Architecture, Data Modeling, ETL & Reporting.

Databases: Oracle 12c/11g/10g/9i/8.x/7.x, Teradata 14/13/12, Cassandra 2.1/2.0, Microsoft SQL Server 2000/2005, Amazon Web Services(AWS) Redshift cloud with S3
storage, DB2 V8.1/V7, MS-Access 7.0/2000, IMS for IBM Mainframe.

Operating Systems: Solaris, HP-UX, MVS for IBM Mainframes, MS Windows 7, XP, 98, NT/2000, NT 4.0.

Tools : SQL*Plus, Erwin 9.6/7.3/7.2/7.1/4.1, Teradata SQL Assistant, Teradata Utilities(BTEQ, FastLoad, FastExport, MultiLoad), Altova xmlspy 2012, Trillium Software(TS Discovery V5), Toad for Oracle 12.0/10.1/9.1/8.6/ V7.2, WinCVS 2.0, Control-M V6.2, Appworx V6.1. 

To Apply, Please click here: APPLY NOW