ETL LEAD DEVELOPER/TALEND
New Haven, CT
6 months +
F2F INTERVIEW -MUST
- 2 years of Talend experience
- 10 years of Informatica/datastage
- 6+ years MS SQL Server or Oracle environment creating tables/views/store procedures.
- 4+ years Data Warehouse/Data Mart data loading.
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.
10+ years progressive experience in the design and development of relational database systems and more recently data warehouses.
916 646 2080 EXT 216