Overview
Skills
Job Details
Position: SQL Server / ETL Developer Location: Chicago, IL(On-site/Hybrid) Duration: Long Term
Job Summary:
We are seeking a skilled SQL Server Developer with strong expertise in designing, developing, and maintaining complex SQL Server databases and ETL solutions using SSIS. The ideal candidate will have hands-on experience in data integration, performance tuning, and enterprise-level workflows, along with solid server-side development knowledge.
---------------------------------------------------------------
Responsibilities:
Design, develop, and maintain SQL Server databases and ETL workflows using SSIS.
Implement and optimize stored procedures, functions, and indexing strategies for performance improvement.
Develop, test, and deploy ETL packages for large-scale data integration.
Collaborate with cross-functional teams to integrate data from APIs, flat files, and cloud storage.
Troubleshoot database and ETL issues, ensuring high availability and performance.
Develop REST and SOAP web services as part of client/server integration.
Ensure compliance with data governance and security policies.
---------------------------------------------------------------
Required Skills & Knowledge: Client-Side:
Ability to utilize REST and SOAP web services.
Server-Side:
Expert-level SQL development (T-SQL, stored procedures, indexing, performance tuning).
Advanced SSIS ETL package design, deployment, and troubleshooting.
Strong knowledge of C#, .NET Standard & .NET Core frameworks.
Experience with REST API development, Message Bus technologies, TypeScript, and JavaScript.
---------------------------------------------------------------
Nice to Have:
Experience integrating data across systems (APIs, flat files, cloud storage, HDFS, etc.).
Familiarity with healthcare data exchange standards (HL7, FHIR, CCDA).
Regards,
Radiantze Inc