ETL Migration Lead: Teradata to Redshift

Ellenco Estágios e Treinamentos; Connecticut; On-site; USD 85,000 - 120,000; Full time

Job summary

Ellenco Estágios e Treinamentos seeks an ETL Developer to migrate Teradata to Redshift and optimize SQL queries across relational and multidimensional databases. You will build robust ETL pipelines, implement testing, and collaborate with IT teams to deliver reliable analytics.

The role focuses on solving complex data problems, designing OLAP solutions, and applying dimensional modeling, star schema concepts, and warehousing fundamentals to deliver actionable insights.

Qualifications

• Experience migrating Teradata to Redshift data platforms.
• Strong SQL development with complex queries and tuning.
• ETL using relational and multidimensional databases.
• Unit testing and documenting tests.
• Telecom data experience is a plus (topology data preferred).
• Knowledge of dimensional modeling, star schema, and data warehousing.

Responsibilities

• Develop and fine tune IT solutions, including coding, testing, debugging, and design.
• Research and plan solutions for existing company problems.
• Build OLAP and work with relational and multidimensional databases.
• Manage others in IT department or the company.
• Mine data and present findings clearly for the organization.

Skills

Teradata to Redshift migration

SQL development

ETL and data extraction/loading

Unit testing

Telecom data experience (plus)

Dimensional modeling and star schema

Job description

Ellenco Estágios e Treinamentos seeks an ETL Developer to migrate Teradata to Redshift and optimize SQL queries across relational and multidimensional databases. You will build robust ETL pipelines, implement testing, and collaborate with IT teams to deliver reliable analytics.

The role focuses on solving complex data problems, designing OLAP solutions, and applying dimensional modeling, star schema concepts, and warehousing fundamentals to deliver actionable insights.