SQL Server & SSIS ETL developer
Job Details
Title - SQL Server & SSIS ETL developer
Location - Warren, NJ - Resource should be In person 3 days a week at client office (Hybrid)
Job Description -
Lead and guide developers responsible for ETL development, data pipelines, and data warehouse loads.
Design, develop, and optimize complex SQL queries, stored procedures, functions, and views.
Build and maintain workflows for data ingestion, cleansing, transformation, and transfer using SQL Server Integration Services (SSIS) and SQL.
Demonstrated Experience with Microsoft SQL Server 2019 and above including managing databases.
- Demonstrated experience working with Microsoft SSIS to create and deploy packages and deploy for ETL processes.
- Demonstrated experience around writing and troubleshooting T-SQL statements, creating stored procedures, views, and SQL functions.
- Understands different data models like normalized, de-normalized, stars, and snowflake models.
- Strong SQL coding experience with performance optimization experience for data queries.
- Ability to multi-task and thrive in fast paced, rapidly changing, and complex environment.
- Work with team members to identify and resolve technical issues in a timely fashion.
- Analyse problems and communicate with stake holders to assess needs and determine optimal solutions.
- Deep understanding of data warehousing concepts
- Experience using Azure Devops and CICD pipeline for deployments
- Strong understanding of data structures and formats such as JSON and XML and SSIS Scripting.
Recommended Jobs
Mate (Assistant Store Manager)
Enjoy what you do every day! Jointhe Crew at Trader Joe's. We're looking for leaders who enjoy helpingcustomers and who can lead teams that create WOW experience for ourshoppers. If you: Thrive …
SUPPORT SERVICES ASSOCIATE
About us At Cooper University Health Care, our commitment to providing extraordinary health care begins with our team. Our extraordinary professionals are continuously discovering clinical innovat…
Caregiver/Home health aide
Join the Village Caregiving Team - Your Path to a Rewarding Career in Healthcare!Are you passionate about making a difference in people’s lives? Village Caregiving is looking for compassionate caregiv…
Electrician I Industrial
McCormick & Company, Incorporated , a global leader in flavor, is seeking a Electrician I reporting to an Engineering/Maintenance Manager . This individual will work at Brand Aromatics located …
Barista
Please note...This position is for weekdays only: **Morning shifts from 6:30am-12:30pm **Afternoon shifts from 12:00pm-5:30pm. Since 2018, Cedar Bean's Coffee Joint at 575 Pompton Avenue in the …
Internal Medicine Physician Opening in Northern New Jersey w/Signing Bonus
A physician-led medical group in New Jersey is adding Internal Medicine physicians to its growing staff of more than 170 Providers in 60 practice locations. Become part of the fastest-growing indepen…
STUDIO Assistant F&B Manager
JOB TITLE: Lead Food and Drink Enthusiast/ Assistant F&B Manager REPORTS TO: Director of Food and Beverage POSITION SUMMARY: The Assistant Food & Beverage Manager is responsible for coordina…
Senior Business Banker - NJ
Senior Business Banker - NJ The Senior Business Banker plays a critical role in driving the growth and profitability of the bank by generating new deposits, business loans, treasury managemen…
No CDL Auto Transport Driver Job
No CDL Auto Transport Driver Job We are a small business that builds mobile bar carts on Piaggio Apes. We are in need of a regular driver to make deliveries of these units all over the country once t…
Activity Aide
Job Type: Tuesday and Thursday evenings 6:00-8pm and every weekend 9-5 Make a Difference Every Day. At Complete Care at Plainfield, our residents are more than patients—they’re part of our exten…