ETL Developer III

Job Description:
We are seeking a skilled ETL Developer III to join our team at a Fortune 100 Telecommunications company, based in Stamford, CT. In this role, you will be instrumental in the development, testing, debugging, and implementation of ETL processes, leveraging your expertise in data modeling, stored procedure development, SQL, and data warehousing. You will collaborate closely with team members and various departments to understand business requirements and advance the ETL development process. This is a dynamic role within a rapidly growing team, offering the opportunity to be a collaborative technical leader and contribute to innovative initiatives.

Minimum Qualifications:
• 5+ years of hands-on experience in ETL development, with a deep understanding of data modeling, stored procedure development, and SQL.
• Proficiency in writing complex SQL queries, stored procedures, and triggers.
• Experience with data extraction, transformation, and loading processes within a data warehousing environment, particularly with Teradata or Redshift.
• Familiarity with data warehousing architecture and concepts (e.g., 3NF, Dimensional model).
• Ability to manage multiple projects simultaneously and work across different workstreams.
• Strong capability to translate business requirements into technical specifications.
• Excellent communication skills and ability to collaborate with various business units to understand customer requests.

Responsibilities:
• Develop and maintain ETL processes for data extraction, transformation, and loading.
• Write complex SQL queries, stored procedures, and triggers to support ETL operations.
• Collaborate with the team to understand and address technical challenges during ETL development.
• Participate in data modeling activities to support ETL processes and data warehousing initiatives.
• Propose optimizations for ETL processes to enhance performance, maintainability, and scalability.
• Develop new unit tests and update existing ones to ensure the reliability of ETL processes.
• Actively engage in an Agile development environment as part of an experienced development team.