SSIS ETL Developer

Job Description

The candidate will primarily be working with data ingestion, querying, sanitizing and monitoring. He/she would offer a combination of strong SQL and ETL capabilities and help shape our large-scale data platform.

Responsibilities:

• Should have extensive working knowledge in various ETL processes and Data Warehousing.
  
• Must be experienced in designing and building complete ETL/SSIS process pipelines for moving and transforming data for Data Warehousing
  
• Design, develop and support Extract Transform Load (ETL) processes using SSIS
  
• Optimize and tune ETL applications to manage high volume batch data transfer.
  
• Troubleshoot data issues, recommend, test and implement solutions.
  
• Assist with data analysis and investigation.
  
• Document technical requirements and solutions
  
• Engage in project planning and delivering to commitments.
  
• Interact with cross-functional teams to ensure complete delivery of solutions.
  
• Assist with configuration and deployment.
  
• Work with other developers to provide datasets which would drive Tableau views and SSRS reports.
  
• Partake in weekly planning and review sessions.
  

Requirements

Required Skills:

• Bachelor s degree required, preferred in Computer Science, Engineering
  
• 5 - 7 years of T-SQL programming experience
  
• 4+ years of ETL experience
  
• Experience with SQL Server 2008/2012/2014/2017 and component services SSIS, SSRS
  
• Experience importing and exporting data from Excel and delimited flat files.
  
• Experience troubleshooting and resolving database integrity and performance issues.
  
• Experience with implement business rules/calculations in stored procedures and functions
  
• Experience with AWS RedShift and other tools in the AWS ecosystem is a plus.
  
• Experience with Python is a plus.
  
• Experience with credit card or other heavy transaction loading processed is a plus.