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

c3RPMzgrVU5XNGRuUjhJS3paa0RCNnB1bGc9PQ==
  • 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

New York Life

Sales Manager - Accelerated Path Job at New York Life

 ...disability income insurance, and investment products such as mutual funds through our broker-dealer, NYLIFE Securities LLC (member of FINRA and SIPC), a Licensed Insurance Agency. You will be required to hold securities licenses and FINRA registrations and affiliate... 

Staffing Network

Line Assembler Job at Staffing Network

 ...Job Description Job Description Staffing Network is looking for assemblers for our client, in the automotive industry in Newark, CA. Pay rate starts at $18.50 an hour. Must be available to work weekends and 12-hour shifts. Job Summary Staffing Network... 

Novant Health

Physician Surgery-General - Competitive Salary Job at Novant Health

 ..., as well as numerous outpatient surgery centers, medical plazas, rehabilitation programs, diagnostic imaging centers and community health outreach programs. Novant Health's nearly 40,000 team members and physician partners care for patients and communities in North Carolina... 

ABS Kids

Behavior Technician - Daytime Hours Job at ABS Kids

 ...day, learning new skills and reaching new goals. Join us as a Behavior Technician and discover wow for yourself in your career path....  ...including free financial advice, free counseling support, mental health resources Virtual office connection to hundreds of colleagues... 

CHRISTUS Health

Registered Nurse-Acute MedSurgical A-PRN Job at CHRISTUS Health

 ...Description Summary: The competent Nurse, in the same or similar clinical setting, practices independently and demonstrates an awareness...  ...BLS required RN License in state of employment or compact Work Schedule: PRN Work Type: Per Diem As Needed...