SQL Reporting Analyst

Description

We are seeking a creative, energetic handson professional who enjoys analyzing business challenges, applying technical solutions to improve efficiencies and deliver business value. The ideal candidate should have strong SQL reporting experience with both Oracle and MS SQL server. The ideal candidate should also demonstrate foundational knowledge of other programming languages such like .Net, Java, ASP.net. Key Responsibilities
Data development using ANSI SQL Data Mining in various data warehouses and datamarts Quality assurance on tools by configuring test plans in SOAP UI, executing test cases, firstlevel triage of defects found Create and maintain ETL process in SSIS Conduct peer testing, code review and impact analysis of the script developed by the other members
Must have Experience
4 or more years in SQL reporting development Strong expertise in PLSQL / TSQL queries and use of stored procedures Proficiency with SSIS Knowledge of web services (XML, SOAP, REST, JSON, HTTPS) Excellent verbal, written and interpersonal communication and collaboration skills Database administrator experience
Nice to Have
Working knowledge of Salesforce.com Experience with Cisco Composite Data Virtualization tool Experience with one or more of the following is a plus Java, Javascript, C#, VBA, ASP.net Knowledge in the Pensions or Benefits Administration industry is a plus