Overview
On Site
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)
Skills
ETL
Data Analyis
SQL
Stored Procedures
Data Warehouse
analytical
Job Details
Role: ETL Lead
Hire-Type: Contract
Location: St Louis, MO (Only On-Site)
Job Description:
The client is looking more for a ETL Lead with strong SQL stored procedure experience.
Here is what we need.
- Strong ETL Background (Data Extraction, Transformation and loading in target from heterogeneous data sources)
- Writing SQL Stored Procedures for ETL.
- Work with scheduling tools like One Automation
- Develop and provide inputs to design specifications within defined architecture, utilizing standard procedures and techniques.
- Interface with Product Owners, Scrum Masters and Business Clients to clarify requirements, as appropriate.
- Set up complex workflows and schedules
- Develop ETL data workflows and code for new data integrations and maintain/enhance existing workflows and code.
- Write documentation that describes installation and operating procedures.
- Deep knowledge of data extraction, transformation & loading (ETL) methods using Teradata.
- Advanced SQL skills (Teradata and RDBMS like Oracle, MS SQL, DB2).
- Advanced hands-on experience with Data Warehousing.
- Experience participating in multiple technical projects using Agile methodology
- 5 years of experience with SQL Query Design in large-scale data warehouse environments.
- 5 years of experience in data collection, database design, and report development.
- Demonstrated experience in delivering IT/BI solutions.
- Expertise in Query optimization and Performance-tuning techniques
- Knowledge in Teradata Stored Procedures, BTEQ, Utilities
- A person must have good analytical skills
- Good knowledge of UNIX programming.
- Good communication skills
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.