SQL Developer

Location: Jersey City, New Jersey
Posted On: 8/11/2017
Job Code: 7529_SQL_NJ
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

Not Ready to Apply?
Contact Details
Gourav Chakraborty