Data Engineer Sr (ETL) Advisor-Raleigh, NC

Data Engineer Sr (ETL) Advisor-Raleigh, NC-Eligible for Public Trust

Rate: $80Hr. W2

Location:

• Raleigh, NC (Preferred)
• Remote Considered

Skills: Ab Initio, Ab Initio Extract Transform Load (ETL) Tool, Teradata SQL

Education:

• Bachelor’s degree in computer science, or a related field is highly preferred.

Experience:

• 15 years of hands-on data modeling and querying experience

Required Skills and Abilities:

• Focus on development and maintenance of applications providing ETL services in support of the Postal Data Asset Services group.
• Significant experience with the Teradata optimizer is required
• The ability to read SQL “explain” plans and take action to effectively utilize the massive parallel nature of the database engine.
• Must have Teradata SQL, due to business logic embedded in the queries.
• Must have a thorough understanding of the internal “DBC Accounting” information to effectively measure the performance of application code.

Desired Skills and Abilities:

• A working knowledge of how MicroStrategy and other OLAP tools interact with Teradata.
• Knowledge of Ab Initio tools, architecture, process and analytics
• A working knowledge of the major competing Data Warehouse modeling techniques (Third-Normal-Form and Dimensional modeling) and how data modeling decisions affect the performance of ETL, structured report queried, and unstructured data analysis.
• A working knowledge of GDE (Graphical Development Environment - used by Ab Initio)
• A working knowledge of Web API development.
• A working knowledge of storing, reading and analyzing streaming data – i.e., Kafka, MQSeries, or similar technologies, such as JMS.
• A working knowledge of Cloud technology - developing and architecting.