Job Title: ETL Developer (SSIS)/API Integration Developer
Location: Minneapolis MN
Duration: 6month 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
- 7 years of handson experience with SQL Server Integration Services with solid experience using script task TSQL and stored procedures.
- Minimum 5 years of working experience with API integrations
- Proven experience in API development and integration using coding language like C# Python Java and parsing & handling XML and JSON data
- Experience with API testing tools like Postman
- Strong analytical data management and troubleshooting skills
- Strong business intelligence and data warehouse experience.
- Nice to have Power BI Development and SQL Server Reporting Service development experience
- Detail oriented with a focus on data accuracy and quality
- Data integration or custom workflow experience with Deltek Vision or Vantagepoint is preferred