IC System Hiring for ETL Developer at Saint Paul, MN Full Time

Job Summary:
The Software Engineer will join our ETL team and be responsible for developing and supporting our ETL processing to ingest and integrate data to/from our Microsoft SQL Server Platform. This will include s, vendor exports, data warehousing, and other data related tasks.

This position is hybrid and located in the Northeast Metro area (St. Paul)

Key Responsibilities:

• Design, develop and support ETL processes and tools.
• Responsible for data loading and manipulation to ensure that the data sources are efficiently and effectively loaded into our organizations data assets.
• Create SSIS ETL solutions with Microsoft SQL Server.
• Review ETL programs for compliance with best practices, standards, enterprise architecture and documentation requirements.
• Conduct root cause analysis and resolve performance and production problems and data issues.
• Develop QA algorithms and processes
• Implement production fixes, and enhancements; on-call rotation included

Qualifications:

• Experience working with Informatica Data Integration – (preferred 3 – 5 years of experience)
• Microsoft SQL Server 2014+, Transact SQL (SSIS,SSMS), XML, Stored Procedures, Triggers, Views, Functions.
• Experience working with relational databases.
• Experience working with programming concepts.
• Demonstrated ability to meet deadlines, balance multiple priorities, and ensure quality standards.
• Excellent analytical, problem-solving, and innovative thinking skills.
• Knowledge of Using REST API’s a plus.
• Knowledge of Pervasive/Actian data integration software a plus.

IC System is an Equal Opportunity Employer and promotes a drug-free work environment.

Job Type: Full-time

Pay: $70,000.00 – $80,000.00 per year

Schedule:

• Monday to Friday

Work Location: Hybrid remote in Saint Paul, MN 55127