SSIS Developer ETL Specialist
ClinDCast LLC
Job Title: SSIS Developer / ETL Specialist Role Overview The SSIS Developer will design, develop, and maintain ETL workflows using SQL Server Integration Services (SSIS) to support data integration, transformation, and loading processes for enterprise data solutions. Key Responsibilities ETL Development Design and implement complex SSIS packages for data extraction, transformation, and loading (ETL) from multiple sources (DB2, Oracle, Flat Files, XML). Utilize advanced SSIS transformations such as Conditional Split, Fuzzy Lookup, For Each Loop, MultiCast, and Script Components for data processing. Implement error handling, logging, and checkpoints for robust package execution. Performance Optimization Tune SSIS packages and SQL queries for optimal performance. Apply best practices for SSIS performance, including parallelization, lookup caching, and bulk loading techniques. Integration & Scheduling Schedule and monitor SSIS packages using SQL Server Agent. Configure credentials, proxy accounts, and permissions for secure execution. Testing & Troubleshooting Perform debugging and troubleshooting of SSIS packages. Conduct backend database testing and validate data integrity. Collaboration Work closely with BI teams to provide data for analytics and reporting. Support Power BI and SSRS reporting requirements when needed. Qualifications 3+ years of experience in SSIS development and ETL processes. Strong knowledge of SQL Server, T-SQL, and database objects (procedures, functions, views). Experience with SSIS performance tuning and troubleshooting. Familiarity with data warehousing concepts (Star Schema, Fact/Dimension tables). Exposure to Power BI and SSRS is a plus. Excellent analytical and communication skills. Preferred Skills Knowledge of advanced SSIS components (CDC Splitter, DQS Cleansing, Fuzzy Grouping). Experience in handling large datasets and optimizing ETL workflows. Understanding of Agile methodologies. #J-18808-Ljbffr ClinDCast LLC
- ...+ experience in Computer Science, Engineering, Math or another quantitative field. 3+ Experience with developing Batch ETL/ELT processes using SQL Server and SSIS ensuring all related data pipelines meets best-in-class standards offering high performance. 3+ experience...SSIS
Purple Drive
Chicago, IL5 days ago - ...DescriptionUSM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and... ...keenness.Job DescriptionJob Tile : ETL DEVELOPERLocation : Oak Brook, IL, United... ...Green Card holderJOB SUMMARY: The Senior SSIS Developer is a member of the IT Business...SSISTemporary workCasual workWork at officeWorldwide
- ...ETL Developer Job Position: ETL Developer (SSIS & SQL) Location: 300 S Riverside Plaza (Travel to Beloit, Wisconsin 10-20%, Chicago Office primary location) Start Date: ASAP Contract: 12 months with potential for 24 months Program Overview: The Agility...SSISContract workWork at officeImmediate start
Software Technology Inc
Chicago, IL3 days ago - ...Azure Data Lake Storage, Azure Databricks, SQL Server, SSIS, SSAS, SSRS, and Power BI.Develop and maintain relationships with key stakeholders, including... ...and Analytics consumption.Strong understanding of ETL processes and data pipelines, and experience developing...SSIS
$98.3k - $145k
...retiring legacy reportsReport development experience across more than one BI platform (Power BI, Tableau, Cognos)Familiarity with SSIS or similar ETL and scheduled job frameworks, including troubleshooting failed or partial loadsExposure to confidential financial or HR data...SSISFull time- ...or certifications: Experience as a lead for decent sized ETL team Experience with Apache Iceberg Observability tools... ...data set in an enterprise setup. Job Summary: ~ An ETL developer needs to design build test and maintain systems that extract...Odd jobWork at officeFlexible hours
3B Staffing LLC
Chicago, IL3 days ago - ...over 10 years of experience for a role emphasizing strong skills in SSIS and SQL Server. The ideal candidate will have participated in... ...detailed. This opportunity promises significant responsibility and a chance to work with a variety of ETL tools. #J-18808-Ljbffr ITBrainiacSSIS
$90k - $200k
...opportunities to learn from and share knowledge with other developers, architects, and our clients. The Value You... ...) Advanced level proficiency with at least one ETL / Data Orchestration technology (Azure Data Factory, SSIS, Informatica, Alteryx, Ab Initio, Pentaho, Talend...SSISWork at officeRemote workVisa sponsorshipWork visaFlexible hours- A data solutions company in Chicago is seeking an SSIS Developer / ETL Specialist to design and maintain ETL workflows. The ideal candidate will have over 3 years of experience in SSIS development and strong SQL Server skills. Responsibilities include tuning ETL processes...SSIS
- ...SQL Developer Location: Onsite in Downers Grove IL (local only) Interview Mode: Virtual 2 rounds Type: Contract... ...between MS SQL and Teradata Experience with ETL (Extract, Transfer, Load) Experience, Job Monitor, SSIS Packages, Bulk Data Transfer, Teradata Namespace,...SSISContract workWork experience placementLocal area
RIT Solutions
Chicago, IL4 days ago - Company DescriptionUSM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development... ...Business Intelligence and Data Warehouse products5 years ETL experience with SSIS or DataStageTableau experience highly desiredBusiness...SSISFull timeTemporary workCasual workWork at officeWorldwideFlexible hours
- ...initiative. Our area of focus in BI Technology to develop Agile and economic solutions is using the... ...products: Microsoft SQL Server 2008 R2 SSIS - SQL Server Integration Services SSRS -... ...with large enterprise Data warehouse / ETL environments Must have strong experience...SSISFull time
- ...documentation and deliverables· Good communication skills. Ability to liason with AbbVie IT / business on a regular basisOracle(Pl/SQL + ETL) Additional InformationAll your information will be kept confidential according to EEO guidelines.SummaryFunction: Information...
- ...Database Engineer with over 6 years of experience in Microsoft SQL Server and T-SQL development. Key responsibilities include designing ETL pipelines and managing database architecture. The ideal candidate will have a solid foundation in Microsoft .NET technologies and...SSIS
- ...seeks an experienced Data Engineer. Candidates should have over 6 years of experience with Microsoft SQL Server, T-SQL, and ETL pipelines using SSIS. Ideal applicants will possess strong skills in database architecture and data modeling, along with automation using .NET...SSIS
- A leading cloud analytics firm in Chicago seeks a skilled Database Developer with over 6 years of experience in Microsoft SQL Server and ETL design. You will be tasked with optimizing database performance and managing critical migration projects. A Bachelor's degree and...SSIS
$150k - $170k
...architectural directions. Support and mentor junior designers and developers through knowledge sharing, collaboration and effective problem... ...Web API), Entity Framework, LINQDatabases (SQL MI, SQL Server)ETL (SSIS, Databricks, Azure Data Factory), and CI/CD Tools (JIRA,...SSISFull time- ...Qualifications • Advanced direct work experience developing business focused automated reports using tools as well as building necessary... ...with Data Warehouse and related technologies such Microsoft SSIS, SQL, ETL, and OLAP data structures. • Advanced direct work...SSISWork experience placement
3B Staffing LLC
Chicago, IL3 days ago $130k - $160.8k
...Databricks, Azure Data Factory, and Azure SynapseImplement robust ETL/ELT workflows for structured and unstructured financial data... ...DevOpsSupport migration of legacy data and application solutions (SQL, SSIS, Synapse, custom ETLs) to modern Azure‑native...SSISTemporary work- ...to understand requirements and support application, work with Developers, Business Analyst and QE team to ensure quality solution... ...financial reconciliation, and reporting processes. Experience in ETL and SSIS packages and workflow/automation creation. Experience with Documaker...SSISNight shift
Holistic Partners, Inc
Chicago, IL1 day ago - ...Job Title Hands on experience in Ab Initio ETL Projects, Ab Initio solution design and development. Ab initio experience including... ...of DW BI projects, especially in data warehouse and mart developments Knowledge and experience with full SDLC lifecycle. Work proactively...
United IT
Chicago, IL3 days ago - ...5+ years of experience designing and implementing ETL pipelines using SQL Server Integration Services (SSIS) and ETL best practices. 5+ years of experience... ...deployment/administration. 4+ years of experience developing automation and application components using...SSIS
Cloud Analytics Technologies LLC
Chicago, IL11 days ago - ...Information Technology Enabled Services.Job DescriptionAt least 4 years of experience in ASP .NET 4.5, Silverlight, WCF, SQL , SSRS, SSIS, C# , .NET Webforms & MVC, Jquery, Javascript, Knockout JS & Telerik controls At least 2 years of experience in .net Framework,...SSIS
- ...description: Project Overview: Looking for an experienced Snowflake developer responsible for enhancing and supporting data ingest\egress... ...in design/development in Snowflake on Azure • Experience in ETL tools like SnowSQL from design/development and implementing data...For contractors
Perfict Global, Inc.
Chicago, IL2 days ago - ...ETL Architect We are seeking an experienced Onsite Lead to manage and drive end-to-end ETL Data Migration activities. The role involves... ...Experience with ETL tools such as Informatica, Talend, SSIS, or DataStage. Working knowledge of cloud data platforms (AWS,...SSIS
United IT
Chicago, IL3 days ago - ...DescriptionIDEALFORCE has a CONTRACT position available immediately for a .NET Developer to join our customer in Chicago, IL. This is an ONSITE position... ...libraries, JQuery, CSS/HTML. * Strong SQL Server (TSQL, SSIS, Reporting Services, etc.) and Relational Query building skills...SSISContract workImmediate start
- ...ETL Developer/Administrator Individuals in the category are expected to have experience working with AWS ETL tools with multiple RDBMS environments on multiple platforms. ETL Developer/Administrator will support ETL processes and tools, which may include commercial...
Samprasoft
Chicago, IL4 days ago - ...to understand requirements and support application, work with Developers, Business Analyst and QE team to ensure quality solution... ...financial reconciliation, and reporting processes. Experience in ETL and SSIS packages and workflow/automation creation. Experience in...SSIS
$124.99k - $154.98k
...Overview We are seeking a new Database Developer to join our team at Ardmore Roderick. As... ...(SSMS), SQL Server Integration Services (SSIS), and/or SQL Server Reporting Services (... ...Ability to perform and develop ETL processes in the context of multiple integrations...SSISFull timeWork at officeLocal areaRelocationArdmore Roderick
Chicago, ILa month ago- ...Technology Enabled Services.Job DescriptionJob Description:-At least 4 years of experience in ASP .NET 4.5, Silverlight, WCF, SQL , SSRS, SSIS, C# , .NET Webforms & MVC, Jquery, Javascript, Knockout JS & Telerik controls At least 2 years of experience in .net Framework,...SSISH1b
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to SSIS Developer ETL Specialist. Be the first to apply!
