What are the responsibilities and job description for the ETL Developer position at VDart?
Job Title : ETL Developer (SSIS) / API Integration Developer
Location : Minneapolis, MN
Duration : 6-month contract
Job Responsibilities
- Design, develop and implement ETL workflows using SQL Server Integration Services (SSIS) to meet business and data processing needs.
- Integrate and process data from various sources like database tables, APIs, CSV, EXCEL, TXT, XML, JSON files etc.
- Develop, optimize, and maintain TSQL, stored procedures, views and functions to support ETL operations and datasets for Power BI reports
- Create custom ETL component and scripts using C# and Python for advanced data processing tasks
- Collaborate with cross functional teams to understand data requirements and deliver tailored solutions.
- Design, implement and maintain data model, database schema, tables, views, indexes etc.
- Document data workflows, mapping, and technical specifications
- Implement data validations and cleansing routines to ensure high data quality
- Monitor, troubleshoot and optimize data integration / SQL Agent jobs
Skills and Required Experience
