ETL Developer

Job Title: ETL Developer III

Schedule: On-site Monday-Friday in Stamford, Connecticut

Duration: 7 month contract with potential conversion to FTE in 2025

Responsibilities:

The ETL Developer job description is multifaceted and involves a blend of technical skills, an understanding of business processes, and data analysis capabilities.

Design and Development

Designing ETL Processes: They design the ETL process according to business requirements, ensuring efficient data flow from source to destination. This includes selecting the right tools and methodologies for data extraction, transformation, and loading.

Developing ETL Pipelines: ETL Developers code and configure the pipelines that automate data movement and transformation. This involves writing scripts or using ETL tools like Informatica, Talend, or SSIS (SQL Server Integration Services).

Data Management and Quality

Ensuring Data Quality: They implement measures to ensure data accuracy and integrity throughout the ETL process. This includes data validation, cleansing, deduplication, and error handling to ensure reliable and usable data.

Data Modeling: ETL Developers often participate in data modeling, designing the data structures and schema in the data warehouse to optimize query performance and align with business needs.

Optimization and Maintenance

Performance Tuning: They are responsible for optimizing ETL processes for speed and efficiency, addressing bottlenecks, and ensuring the ETL system can handle the volume, velocity, and variety of data.

Maintenance and Updates: Maintaining the ETL system involves monitoring its performance, updating ETL scripts and workflows as business requirements change, and ensuring the system scales with data growth.

Collaboration and Support

Collaborating with Stakeholders: ETL Developers work closely with business analysts, data scientists, and IT teams to understand data requirements and deliver the data infrastructure that supports business goals.

Providing Technical Support: They offer technical support for ETL systems, troubleshooting issues and ensuring the continuous availability and reliability of data flows.

Continuous Learning

Staying Updated: The field of data management and analytics is rapidly evolving, so ETL Developers must stay updated with the best prac

Skills:

RedShift data platforms new development expertise a must; previous TD --> RS migration experience a plus (we are migrating to RS by midyear)

No longer requiring Teradata experience as we are approaching our migration cutover in late June and primary RedShift dev in May.

Data Warehousing / RDBMs experience a must

Expert SQL skills

Unit testing and test case writing/documenting expertise

Analytical thinker, critical thinker, well-organized, team player (our team moves fast!)

Cable/telecom industry experience is a plus

Familiarity with outage, network topology, hybrid fiber coax networks, etc. are a plus