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.