AllianceIT Inc
Data Engineer Sr (ETL) Advisor-Raleigh, NC
AllianceIT Inc, Raleigh, North Carolina, United States, 27601
Strategic Staffing Leader | MSP/VMS Delivery | Process Improvement | Driving Growth & Operational Excellence Across IT & Non-IT Talent Solutions
Data Engineer Sr (ETL) Advisor – Raleigh, NC – Eligible for Public Trust
Rate:
$80/hr W2
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.
Seniority Level Mid‑Senior level
Employment Type Contract
Job Function Information Technology
Industries IT Services and IT Consulting
#J-18808-Ljbffr
$80/hr W2
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.
Seniority Level Mid‑Senior level
Employment Type Contract
Job Function Information Technology
Industries IT Services and IT Consulting
#J-18808-Ljbffr