SQL Developer

 
Location: Jersey City, New Jersey
Posted On: 8/11/2017
Job Code: 7529_SQL_NJ
Print
 
Job Description
 
Job Description
Minimum 8 years solid experience in design and develop ETL solutions using SSIS.
Experience in Database Development utilizing SQL Server
Experience with MS (SQL Server Integration Services (SSIS) 2008 or later; using SSIS conditional splits, derived columns, lookups, and dimensions.
Experience C#scripts within SSIS
Must be strong in SQL and complex SSIS logic
Performance tune the ETL process and recommend and implement ETL tuning techniques.
Experience in mapping , transforming and loading data from/to heterogeneous sources / destinations: flat file, Oracle, SQL Server and object oriented databases through multiple layers and environments
Experience scrubbing, data validation checks and logging the results.
Have experience working in Windows, Linux, Autosys or other scheduler, FTP.
Create automated jobs to load data to databases.
Create complex Stored Procedures, Triggers and functions for validation and loading.
Must be comfortable working with Dev/QA/UAT/Prod environments.
Strong ability to test and deliver stable products with valid data
Execute unit tests and validate expected results; iterating until test conditions have passed.
Troubleshoot defects to determine root cause
Minimum 1 year experience in python, C#, xml coding nice to have
Category:IT  code:new
 
 
Job Requirements
 
 
SQL, MSSQL, C#, SSIS, ETL,
 

Not Ready to Apply?
Contact Details
 
Recruiter
Gourav Chakraborty
 
Phone
 
 
LinkedIn