Client is a Top tier investment bank. you will be working with a talented team in the prime services area. No bureacracy or red tapes.

·         Must have completed at least 1 full FINANCIAL Data Warehouse development from the scratch with MS SQL 2005 including ETL (SSIS) and OLAP design (SSAS) and SQL Services Reporting Services (SSRS 2008) Reports.

·         Proven expertise in data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies. Must have SCD and cube processing experience.

·         He/She will not be doing designing on a day to day basis BUT Must have a good sense of layout and graphic presentation of Financial Data/ Dimensional Data Modeling.

·         Must Have proven expertise in OLAP cubes and MDX Queries experience.

·         Experience of designing strategies for ETL audit, load balance, exception handling and high data volumes. .

·         Must have the ability to design, organize, and implement module, perform system testing, plan and automate tasks to maintain existing system.

                ·         Should be able to own reporting module efforts. Gather requirements for financial fund performance reports with charts. 

                ·         Design and develop SQL Server Integration (SSIS) ETL packages. Proven expertise in high volume financial Data Loading

                ·         Must have proven expertise in designing  and developing SQL Services Reporting Services (SSRS 2008) Reports.

                ·         Tune the database for performance.

                ·         Design Data Marts and SQL Server Analysis Services (SSAS 2005) Data Cubes.

·         Design and integrate a Data Warehouse for data collection, distribution, real-time and time-series based reporting.

·         Good to have experience with Developing Reports using SQL Services Reporting Services (SSRS 2008) Reports. Configure and maintain Report Manager and Report Server for SSRS.

·         Create complex reports (ex: drill down reports) using cursors and multi-dimensional objects.

·         Develop complex SQL queries (ex: using various joins and sub-queries) and stored procedures.

·         Be able to use complex expressions to calculate, group, filter, parameterize, and format the contents of a report.

We strongly adhere to strict non-discriminatory employment practices. All candidates in USA are encouraged to apply.R Square is an Equal Opportunity employer and complies with all applicable laws and regulations regarding equal employment opportunities. R Square gives hiring preference to qualified U.S. citizens and other protected individuals

Corporate Profile:
R Square*s mission is to be the destination and source for great technical talent.
We have strong presence in the following industries: Financial, Pharma, Healthcare and Publishing.
We deliver top technical talent with competencies covering full IT spectrum: Application Development (Microsoft .Net

and Java/J2EE), Integration and Infrastructure Services, PMO, CRM, ERP and SCM Services, Data Warehousing & Business

Intelligence and QA Services;
R Square Inc, is an IT services provider for Global 2000 companies with a comprehensive set of IT Project Solutions,

IT Staff Augmentation Services solutions.
R Square is based in NJ, Ohio and India, with a project management and development center in Princeton, NJ &

Chennai, India.