Sign in

Talend ETL Developer

Company:
Ameritekglobal
Location:
Connecticut, United States
Posted:
November 09, 2018

Description:

Description

Performs the following activities:

• As a lead ETL developer you will be responsible for the design, development, testing and implementation of data warehouse and data marts enhancements.

• Working with Data architects and data modelers, perform source data profiling to identify business rule gaps, capture metadata, refine transformation mappings, develop technical design documents and process flow diagrams.

• Review model schema for stage, warehouse and marts.

• Make database changes to support model design.

• Build ETL jobs in compliance with established standards and patterns. Including error processing and integrated scheduling.

• Design, prototype, develop, test cases, and document ETL components.

• Perform unit testing of ETL components and document test results.

• Design and build an end-to-end orchestration process (Talend TAC Execution plan) to schedule/trigger and run the ETL process.

• Complete code reviews for ETL components and design documentation.

• Support all testing, including Development, Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing and Performance Testing.

• Perform troubleshooting on ETL components as needed.

• Respond to assigned defect tickets working with QA and users to resolve data load defects.

• Prepare documentation and production migration scripts.

Experience:

• 10+ years progressive experience in the design and development of relational database systems and more recently data warehouses.

Required skills:

• 2+ years Talend ETL open studio. (6.0 or higher)

• 4+ years Informatica or Datastage.

• 6+ years MS SQL Server or Oracle environment – creating tables/views/store procedures.

• 4+ years Data Warehouse/Data Mart data loading.