MIS Software Application Developer/Analyst 3000287D00.

MIS Software Application Developer/Analyst 3000287D00.

Valhalla, NY or Irving, TX

Pay rate is $68.00 per hour on a W-2.

•3 years EXTENSIVE experience in building 2005/2008 SSAS OLAP Cubes with expertise in MDX scripting and MDX complex functions and calculations.
•Expertise in Cube Processing and Performance, Creating SSIS Packages for Data Migration, Processing different tasks and Schedules.

•Information technology professional with at least 6 years of experience with minimum College bachelor’s degree, expertise in OLAP Cubes using SSAS 2005 or higher.
•This position will also be involved in the design and building of Cubes on top of Normalized/semi-normalized data.
• Involved and contributed to the requirements gathering, analysis and conversion of business requirements to high level technical design and technical specs, development, Unit/SIT testing, implementation, delivery documentation and support.

Required skills:
•3 years EXTENSIVE experience in building 2005/2008 SSAS OLAP Cubes with expertise in MDX scripting and MDX complex functions and calculations.
•Expertise in Cube Processing and Performance, Creating SSIS Packages for Data Migration, Processing different tasks and Schedules.

•Hands on experience with SQL Server databases.
•ETL Architect in designing Packages with SSIS 2005 or higher.
•Expertise in creating OLAP Cubes –using Star and snowflake Schema on SSAS 2005 or higher.
•MDX scripting and Advance MDX language expertise.
•Performance tuning of Cubes for better Processing and Query response.
•Better understanding of Storage Modes (MOLAP, ROLAP and HOLAP) and processing Cubes using SSIS and SSMS.
•Strong RDBMS Concepts like Table Normalization, De-Normalization, T-SQL Queries, DDL and DML, Stored procedures along with knowledge of Data Warehousing and Dimensional modeling.
•Query optimization using clustered, non-clustered and Online Indexes.
•Experienced in Importing and exporting data between homogeneous/heterogeneous systems using ETL (Extraction Transformation & Loading) tools such as DTS (Data Transformation Services), SSIS (SQL Server Integration Services), or SQL Loader.
•Basic to Intermediate experience on pivoting cubes and Raw data for Reporting.

Job location could be Valhalla, New York or Irving TX.


Comments are closed.