Teradata ETL Developer

Expand Techpro LLC; St. Louis (MO); On-site; USD 90,000 - 130,000; Full time

Job summary

Expand Techpro LLC is seeking a Strong Teradata Developer with extensive ETL, SQL, and UNIX expertise in St. Louis, MO. You will design and optimize ETL processes, work with Teradata stored procedures, and utilize BTEQ, FastExport, and MultiLoad to move and transform data from diverse sources.

You should be skilled in writing advanced SQL, tuning queries, and performing unit and integration testing. The role requires analytical thinking, ability to work under pressure, and strong problem-solving

Qualifications

• Strong Teradata developers with a good understanding of ETL and strong in writing Advanced SQL & UNIX.
• Strong ETL background (Data Extraction, Transformation, and loading in target from heterogeneous data sources).
• Experience in ETL development and integration.
• Expertise in Query optimization and Performance tuning techniques.
• Strong in Teradata Stored Procedures, BTEQ, Utilities.
• Python / UNIX Shell scripting Knowledge.
• Development experience using Teradata Stored procedures, BTEQ, FastExport, MultiLoad, etc., to perform ETL activities.
• Possess experience in writing SQLs to perform unit testing and integration testing activities.
• Demonstrated ability to complete multiple tasks under pressure with a high degree of flexibility
• A person must have good analytical skills

Skills

Teradata

ETL

Advanced SQL

UNIX

Query optimization

Teradata Stored Procedures

BTEQ

FastExport

MultiLoad

Python

UNIX shell scripting

Tools

FastExport

MultiLoad

BTEQ

Teradata Utilities

Job description

• Strong Teradata Developers with a good understanding of ETL and strong in writing Advanced SQL & UNIX
• Strong ETL Background (Data Extraction, Transformation, and loading in target from heterogeneous data sources)
• Experience in ETL development and integration
• Expertise in Query optimization and Performance tuning techniques
• Strong in Teradata Stored Procedures, BTEQ, Utilities
• Python / UNIX Shell scripting Knowledge
• Development experience using Teradata Stored procedures, BTEQ, FastExport, MultiLoad, etc., to perform ETL activities.
• Possess experience in writing SQLs to perform unit testing and integration testing activities.
• Demonstrated ability to complete multiple tasks under pressure with a high degree of flexibility
• A person must have good analytical skills