Job Description

Job Role: ETL lead/Developer (ETL/Redshift/DWH /SQL)

Location: St Louis, MO Onsite only

Duration: Long-term

Hire-Type: Contract

Snowflake to Redshift migration exp or work on both.

SQL Skills very strong (Need to take online test)

ETL skills

Json data types in SQL

Job Description:

• 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.

• Dice Id: 80163760
• Position Id: 8429250

Job Tags

Similar Jobs