?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.”.
- SQL, SSIS
- 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.