*SSIS Developer Location: Montvale, NJ(LOCAL OR NEARBY)Length: 6 months * Designs and builds relational databases for data storage or processing. Develops strategies for warehouse implementation, data acquisition, and archive recovery. Cleans and maintains the database by removing and deleting old data. May evaluate new data sources for adherence to the organization's quality standards and ease of integration. May require a bachelor's degree in a related area and 2-4 years of experience in the field or in a related area. Relies on experience and judgment to plan and accomplish goals. Performs a variety of tasks. Works under general supervision. A certain degree of creativity and latitude is required. Typically reports to a supervisor or manager.
Additional Requirements Job Description The SSIS developer will be responsible for writing stored procedures to move data based on requirements. This is a consulting position that will also require gathering business requirements and working with modelers of ODSs and Data Marts and coordinating with source system administrators. Responsibilities • Design and develop data movements using SQL Server Integration Services, TSQL and Stored Procedures • Consult with the business to determine logical design for new business solutions • Perform code reviews, analyze execution plans, and re-factor inefficient code • Follow data standards, resolve data issues, complete unit testing and system documentation for ETL processes • Collaborate with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements • Collaborate with IT operations and testing organizations to ensure timely releases of projects and make sure database environments are sustainable • Collaborate with IT operations to perform root cause analysis • Support IT staff and business users in the development, usage and troubleshooting of database-driven applications • Support the development of software programs. • Use customer requirements to improve functionality (speed, performance / usability). • Conduct system tests, troubleshoot customer issues and correct database defects. • Respond quickly to bug fixes and enhancement requests. • Support maintenance of local databases • Be able to take directions and complete tasks on-time with minimal supervision. • Participate in special projects as needed and performs other duties as assigned. • Work in a team environment • Work on multiple assignments concurrently under aggressive deadlines Skills Required • 5+ years IT industry experience • 3+ years experience with SQL Server Integration Services (SSIS) • Experience with concepts of data warehouse building and maintenance For Further information regarding the job or to apply please contact (*Zaid Mohammed*) at *412-450-1316 Ext: 115* or z...@shstinc.com -- You received this message because you are subscribed to the Google Groups "MCMS" group. To unsubscribe from this group and stop receiving emails from it, send an email to mcms+unsubscr...@googlegroups.com. To post to this group, send email to mcms@googlegroups.com. Visit this group at http://groups.google.com/group/mcms. For more options, visit https://groups.google.com/d/optout.