ETL Developer III (CT)

Cedent; Connecticut; On-site; USD 80,000 - 130,000; Full time

Job summary

Une entreprise de technologie bien établie recherche un ETL Developer pour participer à la migration de Teradata vers Redshift. Ce poste implique le développement de solutions techniques, l'optimisation de requêtes SQL et la gestion d'équipes. Le candidat idéal aura une solide expérience avec des bases de données relationnelles, ainsi qu'un bon sens de l'analyse et de la communication.

Qualifications

• Expérience en migration de Teradata vers Redshift.
• Compétences en optimisation de requêtes SQL.
• Expérience avec des bases de données relationnelles et multidimensionnelles.

Responsibilities

• Développer et affiner les solutions informatiques.
• Créer des systèmes OLAP et travailler avec des bases de données.
• Résoudre des problèmes en extrayant des données et en créant des rapports.

Skills

Expertise en Teradata

Expertise en Redshift

SQL

Analyse critique

Modélisation des données

Job description

Position: ETL Developer - Teradata to Redshift Migration

Must Have Skills:

• Expertise in Teradata and Redshift data platforms, including prior migration experience from Teradata to Redshift.
• Strong proficiency in SQL development, including complex query writing, performance tuning, and optimization techniques.
• Experience working with relational and multidimensional databases for efficient ETL processes.
• Experience in unit testing and writing/documenting test cases.
• Prior Telecom experience, especially with telecom data such as topology, is a plus.
• Analytical and critical thinking skills, well-organized, and a team player.
• Proficiency in data modeling tools and techniques, including dimensional modeling, star schema design, and data warehousing concepts.

Day-to-day Responsibilities:

• Developing and fine-tuning IT solutions, including coding, testing, debugging, designing, or implementing new tools.
• Researching and planning solutions for existing problems.
• Building online analytical processing (OLAP) systems and working with relational and multidimensional databases.
• Managing team members within the IT department or company.
• Solve problems by mining data, creating tables, writing reports, and communicating technical findings clearly to others.

Application Process:

• Personal Information: First name, Last name, Email, Address, City, State, Zip code, Phone number.
• Attachments: Resume, Cover letter.
• Other Information: How did you hear about this position? Legal work authorization in the US? Current employment status? Availability to join? Desired salary/hourly rate? Visa transfer ability? Motivation for change? Notice period? Current location? Willingness to relocate? Proof of legal right to work? Earliest start date.