Dear Business Partner, Hope the day is treating you well !!!!
We are currently looking to fill these urgent positions with our Direct Client. Below is few details on them. Please let me know if you have anyone who might be interested in the below job opening. Please feel free to call/mail should you have any questions. Thanks & have a good day! *Kindly please send me the resumes on et...@innosoul.com <et...@innosoul.com> or feel free to call me on 512-522-7474 <512-522-7474>* *Position: SSIS Developer* *Location:Columbia SC * *Duration: 8 Months* *Max Rate: $60 * *SKILLS REQUIRED:* The successful candidate will have, at minimum, the following skills: Experience and expertise in gathering and analyzing business user requirements. Mid-Level Experience in Java development and/or .NET development. Experience and expertise in SQL, including development of T/SQL queries, stored procedures and data manipulation. Expert knowledge of databases and relational database concepts. Experience with SQL Server 2005 is desirable; experience with SQL Server 2012-14 is required.. Experience with Windows 7 operating system and the Windows 2012 server environment. Experience with Data Warehouse concepts, including the use of Extract, Transform, and Load (ETL) tools and creation of data marts. Expertise in SSIS is required. Ability to communicate clearly and concisely, both orally and in writing. Ability to establish and maintain good working relationships with business users, management, vendors, and peers. Strong organizational, multi-tasking, and time-management skills. Ability to complete assignments on time. Understanding of deployment methodology concepts including design, build, testing, and deployment. *Job Description: * The Client has implemented a Data Warehouse and related software components for purposes of tax and revenue compliance and analysis. The Data Warehouse also serves as a primary data source for other business intelligence activities. This work involves proprietary software from Revenue Solutions Inc. (RSI), particularly their Portfolio Warehouse (PW) product. Historically, the Data Warehouse application team has used the proprietary Embarcadero DT/Studio tool, along with custom transform code from RSI, to load data from federal and state data sources into the Data Warehouse. The team is now charged with converting all of the data load processes to use Microsoft SQL Server Integration Services (SSIS). At this time an experienced ETL (Extract, Translate, and Load) specialist with expertise in SSIS is needed to assist in this process. *Specific Duties and Responsibilities:* The following application tasks are expected to be executed by the Data Warehouse systems software developer ETL specialist. All tasks will involve some degree of up front analysis prior to development or execution, as well as several phases of system and user acceptance testing. These tasks/skills do not include database administration support or technical infrastructure support tasks, as these responsibilities fall under a different support area within the SCDOR IRM organization. Responsible for building ETLs using SSIS packages to load data from various data sources including files from internal and external data sources. Setting up and running the proprietary Portfolio Warehouse Associate and Grow (A&G) offline process for data cleansing and matching of these files. This includes configuring the A&G match keys with consultation from the business users and SCDOR Data Warehouse team. Conduct quality assurance for loaded data. Creating and executing “views” as required by business users. Performing database development and utility functions, such as SQL Server Analytical Services for OLAP, T-SQL, stored procedure, SSIS, etc. as needed for loading and analysis of data. *Experience* Administrative Verbal Communication Skills Yes 1 Advanced Administrative Written Communication Skills Yes 1 Advanced Database Platforms MS SQL Server 2012 Yes 1 Advanced Database Platforms Relational Database Experience Yes 1 Advanced Database Platforms SQL Server Yes 1 Expert Database Platforms SQL Server Integration Services (SSIS) Yes 1 Lead Database Platforms Team Foundation Server (TFS) 2012 Yes 1 Advanced Database Platforms MS SQL Server 2005 No 1 Development Tools SQL Yes 1 Expert Miscellaneous Analytical Skills Yes 1 Advanced Miscellaneous Detail oriented Yes 1 Advanced Miscellaneous ETL Process and Development Yes 1 Expert Miscellaneous Teamwork Yes 1 Advanced Miscellaneous Develop and Test Code No 1 Operating Systems/APIs Windows 7 Yes 1 Advanced Operating Systems/APIs Windows Server 2012 Yes 1 Advanced Programming Languages .Net Yes 1 Advanced Programming Languages Java Yes 1 Advanced Programming Languages C# No 1 Specialties Data Warehousing Yes 1 Advanced Specialties Data Modeling No 1 Specialties OLAP No 1 *Thanks & Regards* *Ethen Jones* *Staffing Manager* *Direct- (512)-522-7474 <5125227474>* *Fax: 206-666-1776 <206-666-1776>* *Email: et...@innosoul.com <ch...@innosoul.com>* *website: www.innosoul.com <http://www.innosoul.com/>* *InnoSoul, Inc. (An IBM Partner Company)* *NY Minority and Woman Owned Business Enterprise (MWBE)* *24 Fairfield Ave, Albany NY 12205* -- You received this message because you are subscribed to the Google Groups "project managment" group. To unsubscribe from this group and stop receiving emails from it, send an email to project-managment+unsubscr...@googlegroups.com. To post to this group, send email to project-managment@googlegroups.com. Visit this group at http://groups.google.com/group/project-managment. For more options, visit https://groups.google.com/d/optout.
