IMMEDIATE HIRE WITH ONE OF OUR DIRECT CLIENT!!!!!!!!!
Job Title: ETL Develoepr
• Review and Understand ETL design specifications for different parts of the ETL (Landing, CDC, Staging, DW Loading). Update design specifications as required.
• Build SSIS packages to support design specifications involving Source to Target transformations, Data Quality Screening and handling ETL Job/Task completion statistics.
• Build Dimensional load packages that can handle Slowly Changing Dimensions as specified using SQL Server 2016 Temporal Table concepts.
• Build Transact-SQL procedures/functions/views to handle complex business computations.
• Work with the ETL Lead to use Automate to schedule SSIS packages.
• Unit Test all aspects of the Build.
• Work with other team members during Integration Testing and resolve issues in any developed code and fix defects.
• Participate in team meetings and provide status updates on the progress of development/testing related to any assigned tasks.
• Performance tune ETL as required
• Activity Deliverable(s)
• ETL Development
• Assistance with the development of the following deliverables at the direction of the Client Technical
Lead / Project Manager:
• SSIS packages free of any defects
• Required documentation updates