SSIS Developer

Overview

On Site
Depends on Experience
Contract - W2
Contract - 1 Year(s)
No Travel Required
Unable to Provide Sponsorship

Skills

Analytical Skill
Analytics
Attention To Detail
Big Data
Collaboration
Communication
Continuous Delivery
Continuous Integration
Data Lake
Data Processing
Data Warehouse
Databricks
DevOps
Extract, Transform, Load
Finance
Insurance
Management
Mapping
Microsoft Azure
Microsoft SSIS
Project Implementation
Project Scoping
PySpark
Python
Relational Databases
SQL
SQL Azure

Job Details

Role: SSIS Developer

Location: NJ/NY (Onsite)

Note: Only on W2

 

About the job

We are seeking a SSIS Developer with experience in designing and developing data pipelines using Azure Databricks, Data Factory, and Datalake. The role involves managing large volumes of data, building complex ETL solutions, and working closely with business teams to deliver robust data transformations and analytics solutions.

Responsibilities:

·        Design and develop ETL pipelines using SSIS for data transformation.

·        Collaborate with Azure stack modules like Data Lakes and SQL DW to build robust data solutions.

·        Write SQL, Python, and PySpark code for efficient data processing and transformation.

·        Understand and translate business requirements into technical designs.

·        Develop mapping documents and transformation rules as per project scope.

·        Communicate project status with stakeholders, ensuring smooth project execution.

Requirements Must have:

·        10-12 years of experience in SSIS ETL for data ingestion, data processing, and analytical pipelines for big data and relational databases.

·        Hands-on experience with Azure services: ADLS, Azure Databricks, Data Factory, Synapse, Azure SQL DB.

·        Experience in SQL, Python, and PySpark for data transformation and processing.

·        Familiarity with DevOps and CI/CD deployments.

·        Strong communication skills and attention to detail in high-pressure situations.

·        Experience in the insurance or financial industry is preferred.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Resource Innovative Technologies LLC