TCI has an immediate need for multiple Data Engineers in Raleigh, NC. This is not a Corp2Corp opportunity. This is a long-term contract opportunity with the possibility of hire. In addition to competitive, market-rate based pay, TCI provides all our Consultants with Comprehensive Medical/Dental Insurance, 401k, Life Insurance and Long-Term Disability benefits.

NOTE: This position requires US Citizenship and the ability to obtain a Public Trust Security Clearance. This role will be ONSITE for 2 months, then a Hybrid schedule (local/remote in Raleigh).

SUMMARY

The Data Engineer will join a dynamic team responsible for product support and maintenance of the data warehouse.

RESPONSIBILITIES

• Performs data warehouse design and construction.
• Codes and documents scripts and stored procedures.
• Designs and implements data strategy methods.
• Develops appropriate programs and systems documentation.
• Assists with metadata repository management.
• Prepares and implements data verification and testing methods for the data warehouse.
• Creates index and view scripts.

REQUIREMENTS

• Minimum 10 years of experience in software development or related field with at least 5 years of experience in data warehouse.
• A degree from an accredited College/University in Software Engineering, Computer Science, or related discipline is preferred
• Extensive experience with data warehouse design, construction, and/or maintenance, to include design and implementation of data strategy methods, coding and documentation of scripts and stored procedures, and creation of index and view scripts.
• Extensive experience with development of data warehouse program and system documentation.
• Able to assist with metadata repository management.
• Extensive experience preparing and implementing data verification and testing methods for data warehouses.
• A working knowledge of how Ab Initio conducts data extract, transformations, and loading - especially to and from Teradata.
• Development of graphs, plans, PSETs and how to develop tests and debug.
• PDL scripting.
• UNIX commands and concepts in order to navigate source code directories, find error logs, perform impact analysis assessments, edit code, version files.
• Linux Shell scripting in order to read and create driver scripts.
• Specific ability with the following languages, tools and utilities is required:
• Ab Initio ETL Coding in GDE
• Ab Initio Metadata Hub Lineage
• Ab Initio TRMC
• ANSI SQL and Teradata SQL extensions
• Teradata SQL Assistant (a.k.a. QueryMan) for EDS Support
• BTEQ
• FastLoad
• MultiLoad
• FastExport
• TPump
• Cloud operations
• Cloud Governance
• Data Engineering
• Platform Engineering
• Data Integration
• Data Observability
• AI/ML
• Excellent communication skills.
• Must be a US Citizen and have the ability to obtain a Public Trust Security Clearance.