Job Description :
Must Haves:
2 years of Talend experience
2+ years Talend ETL open studio.
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.
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.
EXT 218