SSIS Developer
Apply NowCompany: Futran Tech Solutions Pvt. Ltd.
Location: Charlotte, NC 28269
Description:
TITLE - SSIS Developer
ROLE LOCATION(S) - Purchase, NY; Florham Park, NJ; NYC; Charlotte, NC
ROLE SUMMARY AND RESPONSIBILITIES
The ETL Developer will be primarily responsible for developing and supporting ETL code in SSIS for an enterprise data warehouse.
ROLE RESPONSIBILITIES
Develop queries and stored procedures using T-SQL
Understand and analyze requirements to develop, test, configure and deploy SSIS packages. Use of SQL Server 2014, 2016 or 2017 experience to implement robust, maintainable solutions that meet requirements
Evaluate large and complex data sets
Troubleshoot SSIS packages to address critical production issues
Create tables, assign permissions, import data, perform app configurations, etc.
Write and maintain technical documentation
Manage source code versioning and deployment
REQUIRED TECHNICAL QUALIFICATIONS (in order of level of need)
5+ years development experience with Microsoft SQL Server including recent experience with 2014, 2016 and or 2017
5+ Years' experience coding T-SQL including the use of dynamic SQL
3-7 Years of SSIS development experience in developing ETL applications
Data warehouse development experience using SSIS/SQL best practices including the development of reconciliation and validation frameworks
Working knowledge of best practices for loading a data into normalized and/or Star schemas
Experience with best practice SSIS design patterns
Demonstrated skill and ability in interfacing programmatically with a variety of enterprise systems
Familiarity with source code management systems (TFS)
EDUCATION REQUIREMENTS
Bachelor's degree in Computer Science, MIS, related field, or equivalent experience
ROLE LOCATION(S) - Purchase, NY; Florham Park, NJ; NYC; Charlotte, NC
ROLE SUMMARY AND RESPONSIBILITIES
The ETL Developer will be primarily responsible for developing and supporting ETL code in SSIS for an enterprise data warehouse.
ROLE RESPONSIBILITIES
Develop queries and stored procedures using T-SQL
Understand and analyze requirements to develop, test, configure and deploy SSIS packages. Use of SQL Server 2014, 2016 or 2017 experience to implement robust, maintainable solutions that meet requirements
Evaluate large and complex data sets
Troubleshoot SSIS packages to address critical production issues
Create tables, assign permissions, import data, perform app configurations, etc.
Write and maintain technical documentation
Manage source code versioning and deployment
REQUIRED TECHNICAL QUALIFICATIONS (in order of level of need)
5+ years development experience with Microsoft SQL Server including recent experience with 2014, 2016 and or 2017
5+ Years' experience coding T-SQL including the use of dynamic SQL
3-7 Years of SSIS development experience in developing ETL applications
Data warehouse development experience using SSIS/SQL best practices including the development of reconciliation and validation frameworks
Working knowledge of best practices for loading a data into normalized and/or Star schemas
Experience with best practice SSIS design patterns
Demonstrated skill and ability in interfacing programmatically with a variety of enterprise systems
Familiarity with source code management systems (TFS)
EDUCATION REQUIREMENTS
Bachelor's degree in Computer Science, MIS, related field, or equivalent experience