SQL Server & SSIS ETL developer Job at Robotics Prcocess Automation, LLC, Trenton, NJ

c2xJR29VbFhqdnlvWlRqZzlaeGhIdERnTnc9PQ==
  • Robotics Prcocess Automation, LLC
  • Trenton, NJ

Job Description

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. ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract #J-18808-Ljbffr Robotics Prcocess Automation, LLC

Job Tags

Permanent employment, Contract work, Work at office, Local area, 3 days per week,

Similar Jobs

Associates Systems LLC

Aerospace engineer Job at Associates Systems LLC

US Citizens All Qualified resumes will be contacted in 24 hours or less. Key Responsibilities The Aerospace Engineer will be responsible for: Interpreting mechanical hardware requirement specifications from interfacing systems. Developing and documenting...

MHS Hill Country - Hospital Medicine - HCA Healthcare

Internal Medicine - Physician Job at MHS Hill Country - Hospital Medicine - HCA Healthcare

 ...Internal Medicine - Physician at MHS Hill Country - Hospital Medicine - HCA Healthcare summary: The position is for a board certified or eligible internal medicine hospitalist at Methodist Hospital Hill Country in Fredericksburg, Texas, focusing on inpatient care... 

SAIC

Senior Software Engineer Job at SAIC

DescriptionSAIC is seeking a SW Engineer for the Joint Expeditionary Command and Control (JEXC2) program based out of Panama City, FL. This position is on-site. The qualified candidate will support the Joint & Expeditionary Command and Control (JEXC2) program, providing... 

Domino's Franchise

Customer Service Rep9421 806 E Airtex Dr 103 Job at Domino's Franchise

 ...or take pizzas during the hungry hours of the day and night, part or full time. You'll have plenty of time left over for school, hanging...  ...Pizza, our people come first! JOB REQUIREMENTS You must be 15 years of age or older, 16 or older preferred. You must be... 

Delaware North

Director of Marketing, Kennedy Space Center and Visitors Complex Job at Delaware North

 ...Resorts is hiring a Director of Marketing to join our team at Kennedy...  ...represents what we believe at the time of this job posting, that we...  ..., media, partnerships, digital, social media, and content to...  ...Delaware North, youre not just part of a team youre part of a global...