Hi Associates, One of our business partner looking for , *Microsoft SQL Server Enterprise Developer*
Please find the JD given below, If you have suitable consultant please send their resumes to *[email protected] <[email protected]> * *Microsoft SQL Server Enterprise Developer* *Location*: Lititz,PA *Duration*: 9+ Months *THE CONSULTANT MUST ATTEND F2F INTERVIEW* *Description*: Experience in designing, developing and maintaining Database using MS-SQL server 2005/2008/R2/2012 Expertise in conceptual, logical and physical designing and development of Data Models, Data Normalization, OLTP and OLAP Database and Data Warehouse Coding, testing, deployment, support and maintenance of business applications using MS-SQL Server 2005/2008/R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) Expertise in T-SQL in creating and using Views, User Defined Functions, Triggers, Indexes, Stored procedures involving joins, sub-queries from multiple tables and established relationships between the tables using primary and foreign key constraints Performance tuning and query optimization using indexes, SQL profiler and SQL Enterprise Manager Writing complex stored procedure involving temp tables and cursors Experienced working in financial and/or banking services Experience using ETL tools such as Import/Export wizard and SSIS for transferring Data from different sources to a centralized SQL server High Level Designing of SSIS Packages to perform ETL from heterogeneous sources such as Excel, CSV, Oracle, flat file, Text Format Data by using multiple transformations provided by SSIS to generate underlying data for the reports and to export cleansed data. Solving run time issues using SSIS error and event handler, precedence constrain, breakpoint, check point and loggings Using global variables, expressions and functions for reports using SSRS Creating various types of dynamic reports like Tabular, Matrix, Drill-Down, Cascaded parameterized, Chart reports, Sub reports, Ad-Hoc Reports, Cross Tab Reports and Distributed Reports in multiple formats using SSRS based on client requirements Implementing dimensions and fact tables for star /snowflake schemas to process cubes in SSAS 2008/R2/2012 Implementing MDX queries to design OLAP architecture, MOLAP, ROLAP and HOLAP Developing Dashboards, Scorecards using multiple KPI’s by using Microsoft SharePoint is a plus Utilizing Microsoft Power BI tools such as Power View, Power Pivot, Power Query and Power Map to retrieve, analyze and present data in well-designed visualizations *Best Regards,* *Sathya.C* *Resource Manager* [email protected] +1 614-525-9205 www.jobpencil.com *Job Pencil * -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/mcms. For more options, visit https://groups.google.com/d/optout.
