Senior SQL SSIS Developer

Confidential Company  •  Cary, NC
Salary depends on experience
Posted on 12/09/17 by Cynet Sytems
Confidential Company
Cary, NC
IT Consulting/Services
Salary depends on experience
Posted on 12/09/17 Cynet Sytems

?We are looking for Senior SQL SSIS Developer for our client in Cary, NC

Job Title: Senior SQL SSIS Developer

Job Location: Cary, NC

Job Type: Contract – 12 Months / Contract to Hire / Direct Hire

“US citizens and those authorized to work in the US are encouraged to apply. We are unable to sponsor H1b candidates at this time.”.

Job Description:

Mandatory Skills: 

  • SQL, SSIS

Responsibilities

  • Lead all data extraction, cleansing and load activities from legacy application’s SQL server to modern application’s SQL server.
  • Analyse SQL code and database schema of legacy application and modern application and provide suggestions as per SQL normalization rules.
  • Work with data owners to understand legacy data and produce detailed mapping documents.
  • Write complex SQL queries to extract the data from SQL server without performance impact.
  • Develop ETL programs using SSIS to extract the data from one system and load into another.
  • Knowledge and hands on work in Salesforce will be added advantage.
  • Automate ETL jobs for recurring imports.
  • Create queries to support various reporting needs.
  • Perform unit testing
  • Experience with Jira/Confluence
  • Experience with Agile SDLC.
Not the right job?
Join Ladders to find it.
With a free Ladders account, you can find the best jobs for you and be found by over 20,0000 recruiters.