ETL Developer

Telequest Communications•Middletown, NY

About The Position

The Data Warehouse is seeking an enthusiastic ETL Developer to join a growing team undertaking a complete refresh of its data warehouse environment. The refresh includes Active Batch Automation and Scheduling, Informatica Data Integration, and Oracle Exadata running the latest 19g database. The analytics tools include Oracle OBIEE and Tableau. The role supports a dependable, accurate, and flexible reporting platform accessed by more than 1,000 users, working collaboratively across Data Warehouse areas as needed. The ETL Developer handles application development tasks related to data integration, prepares detailed specifications and diagrams for ETL processes, and designs, codes, tests, debugs, documents, and maintains moderately complex programs and applications. The position also supports production workflows and contributes to efficient, high-quality integration solutions and technical best practices.

Requirements

Bachelor's degree in Computer Science or a related field.
At least 2–3 years of experience in technical development.
At least 2–3 years of experience with Informatica PowerCenter.
At least 2–3 years of experience with Oracle Database.
Excellent SQL, PL/SQL, and database skills.
Explicit understanding of SQL and some experience in a database environment.
Familiarity with data modeling, including star and snowflake schemas.
Experience working in a corporate IT or similar environment.
Persuasive communication skills.
Dependability and adaptability, including flexibility to respond to changing priorities.
Ability to work in a collaborative team setting.
Technical proficiency.

Nice To Haves

Experience with SSIS or Talend.
Python or R skills.
Prior use of Toad for Oracle or a similar tool.
Experience with erwin Data Modeler software.

Responsibilities

Design, develop, and document ETL processes.
Work in a complex environment involving databases, job scheduling, automation, and performance tools.
Participate in ETL design sessions with the team.
Provide production support for new or changing mappings and workflows and produce technical specifications.
Perform analysis, data profiling, development, and integration of disparate systems throughout all phases of the project life cycle.
Work as part of a team to deliver high-quality and efficient integration solutions.
Assist in developing technical best practices for data movement, data quality, data cleansing, and other ETL-related activities.
Implement best practices and tune solutions for optimization.
Complete assignments in a timely manner.
Complete other work as assigned.
Design, code, test, debug, document, and maintain moderately complex programs and applications.