*Kindly reply me:: ssi...@compunnel.com <ssi...@compunnel.com>*
Hi , Greeting for the day… We are having an urgent requirement with one of our client in NJ. Kindly review the requirement and if interested please send me an updated copy of resume with contact details and also fill the required information of below matrix. *Position:: SSIS & SSAS Report Developer* *Location:: NYC* *Duration:: Long term contract* *Description::* *Primary Skill Set:* *SSIS, SSAS, SQL Server, Oracle* *Requirement Description**:* · 8-10 years of IT experience in Data Design and Development on Microsoft SQL Server 2008 R2/2008/2005, using T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing. · Experience in using Business Intelligence tools (SSIS, SSRS, SSRS) in MS SQL Server 2008 R2. · Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005/2008. · Migration of SSRS reports from SQL 2005 to SQL 2008. · Excellent Knowledge in creating databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User Defined data types, Cursors, Triggers and Indexes using T-SQL. · Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage. · Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization. · Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2008R2/2008/2005. · Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS). · Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS. · Good understanding of (SDLC) software development life cycle process and Agile and Waterfall methodologies. · Excellent knowledge of Scrum methodologies and principles in Agile and Waterfall environments. · Working experienced in Dimensional Modeling and ETL design; designing of STAR, SNOW FLAKE Schemas. · Experienced in using ETL tools in (SSIS) MS SQL 2008R2,MS SQL 2008 and in MS SQL 2005 · Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services. · Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS. · Supported team in resolving SQL Reporting services(SSRS) and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Drill Through, Top N, Summary, Form, OLAP and Sub reports, and formatting them. · Experienced in managing Alerts, Operators and Jobs through SQL Server Agent. · Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions. · Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Drill Through, Top N, Summary, Form, OLAP and Sub reports, and formatting them. · Experience in writing complex SQL queries involving multiple table’s inner and outer joins, stored procedures. · Proven ability in Performance Tuning, Query Optimization. · Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi-site development *Kindly fill the required information of below matrix.* *Full Name* *Current Location:* *Mobile Phone No* *Available from* *Candidate preferred work location* *Contract or Permanent* *Salary expectations for ctc assignment* *Visa status* *Total Years of experience* *Candidate Date of Birth* *Candidate highest fulltime qualification and year of passing* *Mail Id* *Skype id for VC interview* *SSN(last 4 digit)* *Best time to reach* *Thanks & regards,* *Saubhagya Singh* *Senior Technical Recruiter* *Compunnel Software Group, Inc.* 103 Morgan Lane, Suite 102, Plainsboro, NJ- 08536 T: (609) 606-9010, Extn: 1702 F: (609) 750-0981 E: ssi...@compunnel.com W: www.compunnel.com [image: Description: Description: Description: Description: Description: cid:image002.jpg@01CEB411.FDCC6E40] [Compunnel is an E-Verify Employer] *20 Years in Business I* *Microsoft Certified Gold Partner* *I* *Amongst the Top 20 IT Training companies in the world* *I* *Member of NMSDC* -- You received this message because you are subscribed to the Google Groups "USITCV" group. To unsubscribe from this group and stop receiving emails from it, send an email to usitcv+unsubscr...@googlegroups.com. To post to this group, send email to usitcv@googlegroups.com. Visit this group at http://groups.google.com/group/usitcv. For more options, visit https://groups.google.com/d/optout.
