SQL Server Production Support Developer (ETL processing with SSIS and SSMS) Job at Stellent IT LLC, New York, NY

Z2tTcWlnZEEyOEt1TUY3aVpZb1hSWDNv
  • Stellent IT LLC
  • New York, NY

Job Description

SQL Server Production Support Developer (ETL processing with SSIS and SSMS)

Manhattan, New York

Interview in-person

Long Term

Job Description:

  • Must be a true expert with SQL Server with SSIS and ETL process to data warehouse (again, please don't put in a keyword if they don't really have it).
  • The job is mainly database production support and they don't have to be in the financial industry. Can even be in retail with huge retailers like Target or Walmart. Please, Please, Please don't fabricate the resume and just put in keywords.
  • The work is doing ETL (extraction, translation, loading) into a data warehouse all day. 50-70% of the work all day is complex SQL SERVER programming, ETL into a data warehouse.
  • Only light Python of 2-3 years is needed for cleaning data or automation. They don't need to be experts with Python.

- Hands on experience with day-to-day batch processes and understanding existing processes and also providing a fix if there is any issue.
- Good understanding of Microsoft SQL server and database.
- They should be good with identifying issues within the database and provide any changes to fix if there is any issue.
- Good to have SSIS experience.
- Tidel experience would be an advantage.
- Expected to be quick in acknowledging and responding and finding the root cause.
- Minimum 5 years of experience would be required.
- Additional tools like python would be an advantage.
- Interview: Two to three rounds of interviews last round would be in-person.






DICTATION



This group is in Market Risk IT they deal with the financial transaction data, and do all the calculations and generate reports for the business users

These reports are submitted to the regulators



They deal with a lot of applications on a daily basis and they need someone to help with all these applications and support them this is for business as usual, they also need to this person to be a developer

HANDS ON in day to day Batch Process monitoring, ( they use Jira to manage workflow and expect time log entries done in Jira ) someone who can learn quickly to understand existing process and do a fix if there is an issue in production.



Tech Stack

MS SQL server as a core database most of their rules are defined in Stored Procedures . (they can look thru this to understand how the application work)

Need good knowledge in SQL Server database and identify the issue in the database if something goes wrong and do changes to fix it



Also need Microsoft SQL Server as an ETL tool. Like SSIS

Job Tags

Similar Jobs

University of Alaska Fairbanks

Graduate Research Assistant (Grad RA's)-International Arctic Research Center Job at University of Alaska Fairbanks

 ...The International Arctic Research Center (IARC) is recruiting for graduate students interested in a research assistantship for the academic...  ...throughout the applicant screening process. If you need assistance in completing this application or during any phase of the interview... 

ChristianaCare

Executive Assistant - Gene Editing Institute Job at ChristianaCare

 ...passionate about delivering health, not just health care. Come join us at ChristianaCare!ChristianaCare is looking for a full-time Executive Assistant to provide administrative support to the Executive Director and coordinate the overall endeavors of the Gene Editing... 

Rivian

Sr. Staff Thermal Engineer Job at Rivian

 ...Responsibilities Architect, design, simulate and validate thermal performance of microelectronic devices and systems. Model thermal...  .... Qualifications ~ Bachelor's degree in Mechanical Engineering, or related field; Masters or PhD degree preferred. ~12+... 

The Castle Fun center

$50/H Data Analyst (Entry-Level) Remote Job at The Castle Fun center

Job Title: Entry-Level Data Analyst (Remote) Hourly Rate: $50/hour Job Summary: We are seeking an enthusiastic and detail-oriented Entry...  ...analysis. Opportunities for career growth as you gain experience and expand your skill set. Employment Type: Full-Time... 

Parker Towing Company

Equipment Operator/General Labor Job at Parker Towing Company

 ...to work a flexible schedule, eager to work with a multitude of cargos, be prepared to serve our customers in a variety of projects and...  ...within 50 miles of Mobile, AL One (1) year or more related shipping /receiving or warehouse preferred Forklift and crane certification...