Data Engineer Sr (ETL) Advisor-Raleigh, NC jobs in United States
cer-icon
Apply on Employer Site
company-logo

AllianceIT Inc · 20 hours ago

Data Engineer Sr (ETL) Advisor-Raleigh, NC

AllianceIT Inc is seeking a Senior Data Engineer (ETL) Advisor to focus on the development and maintenance of applications providing ETL services. The role requires significant experience with Teradata and involves optimizing database performance and ensuring effective data modeling.

Human ResourcesStaffing Agency
check
Growth Opportunities
check
H1B Sponsor Likelynote
Hiring Manager
Vemula Ranjith kumar
linkedin

Responsibilities

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

Qualification

Ab InitioTeradata SQLETLTeradata optimizerData modelingMicroStrategyGDEWeb API developmentStreaming data analysisCloud technology

Required

15+ years of hands-on data modeling and querying experience
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

Preferred

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

Company

AllianceIT Inc

twittertwittertwitter
company-logo
AllianceIT is an IT company that provides staffing and recruiting services.

H1B Sponsorship

AllianceIT Inc has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (1)
2023 (1)

Funding

Current Stage
Early Stage

Leadership Team

leader-logo
Purushothama Polkampalli
President & CEO
linkedin
Company data provided by crunchbase