*Location: Philadelphia, PA Duration: 6+ Interview mode: Phone then F2F *Microsoft SQL Server Enterprise Developer 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 Thanks Regards *Swami A* Technical Recruiter *Ennovace Inc* Ph: 214-541-9378 F: 972-262-9006 [email protected] www.ennovace.com 1801 S O'connor Rd Irving TX 75061 In my absence please contact Steven at [email protected] (214-541-9081) Disclaimer: We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intendedrecipient(s) and may contain confidential and privileged information.Any unauthorized review, use,disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at [email protected] and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. We are sorry for the inconvenience. -- You received this message because you are subscribed to the Google Groups "Hot List" 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/directclienteq. For more options, visit https://groups.google.com/d/optout.
