Hi, My name is Ruby and I'm an IT recruiter at United Software Group Inc.., Below is an urgent requirement for our direct client. please have a look and reply if you are comfortable.
*Designation**:: Sr. Data Warehouse Developer (SQL Server 2016/Azure)* *Work Location**: **:* *Chicago, IL(F2F Must)* *Duration**:: 5-10 Months* Horizon Technology Partners has an immediate opening Sr. Data Warehouse Developer. Your skills are needed to assist a multi-billion dollar Residential Property Management company headquartered in Chicago, IL. with a high-profile Data Warehousing initiative. *Our client is migrating from an Oracle 12c Data Warehouse environment with PL/SQL load processes and outputs, to the SQL Server 2016 Azure platform with SSIS and TSQL**.* In this role you will be involved in the development of data warehouse batch applications to load/aggregate business data from ~25 internal systems making the data available to ~40 consumer and connecting applications. The ideal candidate will have SQL Server Data Warehousing experience as well as experience building custom T-SQL and SSIS ETL processes with expertise in Package development & Tuning. Please note that the legacy 12c RDBMS and PL/SQL ETL processes will be moved to SQL 2016/Azure and T-SQL. You will also be asked to modify application connectors on the .NET platform or SQL BI stack. *Activities & Responsibilities:* - Analysis of legacy PL/SQL ETL and Stored Procedures so they can be rewritten in T-SQL and SSIS - Design on new data extraction procedures to load data marts - Produce specifications for data load jobs, while working with users and developers to understand their data needs and relationships to existing corporate data - Follow Data Warehouse group standard design life cycle when completing new development projects, including detailed design plan, process flow, test plan, implementation plan and documentation - Assist Data Architecture group to capture data definitions of major data sources and data elements - Responsible for TSQL code performance analysis and tuning. - Provide detailed documentation concerning process flow/interface between feeder systems and the data warehouse - Coordinate testing with other development groups, users, and operation group, identify appropriate level of testing and ensure that testing is complete before signing off - Provide support for development and production systems *Required Skills:* - 8+ years Data Warehousing experience on a SQL Platform - Strong familiarity with SQL Server and TSQL (SQL 2012 or Newer) - Solid understanding of the Oracle RDBMS and PL/SQL (Oracle 10 or newer) - Strong T-SQL query writing and optimization (Tuning) - Familiarity with Data and Referential Integrity concepts - C# coding skills are a plus (not required) to rework the application pointers for the new data source - Strong Oral and Written Communications skills *Thanks,* *Ruby Kumari* United Software Group Inc. 565 Metro Place S. Suite # 110 Dublin, OH 43017 Phone: 614-414-3130 Ext- 1121 Fax: 1-866-764-1148 *rubykum...@usgrpinc.com <rubykum...@usgrpinc.com>* To unsubscribe from this mailing, please reply to this email with the word UNSUBSCRIBE <techsupp...@usgrpinc.com,viv...@usgrpinc.com?subject=UNSUBSCRIBE%E2%80%9D.>in the subject line, or click here. *USG is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law.* -- You received this message because you are subscribed to the Google Groups "mainframe" group. To unsubscribe from this group and stop receiving emails from it, send an email to mainframe+unsubscr...@googlegroups.com. To post to this group, send email to mainframe@googlegroups.com. Visit this group at https://groups.google.com/group/mainframe. For more options, visit https://groups.google.com/d/optout.
