New Requirement :: ETL Lead Developer :: New Haven, CT - 06511 : Long Term Contract
Shalin Patel
Please go through the below requirement and If you have suitable candidate's kindly share updated resume along with below details on recr...@tcagroupmail.com.
Full name:
Contact number:
Email ID:
Current location:
Relocation:
Availability to join:
Visa status:
Expected Rate on C2C:
Role: ETL Lead Developer
Location: New Haven, CT - 06511
Duration: Above 6 Months
Interview: Face to face
JOB 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.
· 4+ years Informatic or Datastage.
· 6+ years MS SQL Server or Oracle environment – creating tables/views/store procedures.
· 4+ years Data Warehouse/Data Mart data loading.
Thanks,
Shalin
TCA Consulting Group Inc.
recr...@tcagroupmail.com
Mobile: 929-399-8651