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

Workana

Shopify Developer (CRO/SEO Specialist) Job at Workana

 ...growth, the company is looking for a senior specialist to take full ownership of their Shopify ecosystem, focusing on performance, CRO, SEO, and long-term platform improvements. Their priority is clear: Fix conversion rate performance immediately, then build a scalable,... 

L3Harris Technologies

Technical Writers Job at L3Harris Technologies

 ...parametric CAD, rapid prototyping, and other tools in the development of designs and validation of those designs. Engineers will produce technical drawings, procedures, and other documents to thoroughly define the design. As an L3HARRIS engineer you will be involved in all... 

Med-Trans

Helicopter Pilot - HAA Job at Med-Trans

 ...Position Helicopter Pilot - HAA at Med-Trans Corporation If your passion is flying and you want to work in an environment where every second counts, contact us today! Were hiring a Helicopter Pilot to provide medical air transportation services to Med-Trans... 

Mayocreditunion

Digital Marketing Specialist Job at Mayocreditunion

 ...consistent communication materials to join our team as a Digital Marketing Specialist! Department: Marketing and Business Development...  ...mock-ups for leadership review, approval, and production direction. Works on the graphic production and copywriting of all web... 

Burnham, Capon & Wimer, LLC

Part-Time Administrative Assistant / Legal Assistant Job at Burnham, Capon & Wimer, LLC

 ...Part-Time Administrative Assistant / Legal Assistant Our boutique law firm, focused on estate planning, estate administration, and real estate matters, is seeking a part-time Administrative Assistant / Legal Assistant to join our team. This position is ideal for a...