kenkruto.blogg.se - Datastage 8.1 software

Deploying and Publishing of Report & Integration with the Portal.Development of Store procedures and Functions to support various SSRS Reports.Development of SSIS Packages and Jobs for the Uploading of Excel data to the Database.Developing the SSRS Reports as per the Requirements.Software/Tools MS SQL Server 2008, MS SSAS 2008 and MS SSIS 2008 Knowledge transfer to Support Team to enable them for the production support.Automated the Cube Partition creation using SSIS Packages.

Created Different Cube Partitions based on the Data Loads of various tables.Automated the Cube Processing using SSIS Packages.Developer Cubes and Calculations using MDX Queries to meet the requirements.Software/Tools Netezza DB 5.0.4, Unix, IBM WebSphere DataStage 8.1. Unit Testing & Post Deployment Support.Developed Shell Scripts to run data stage jobs, PL/SQL blocks & Nzsql Scripts.Performed Unit Testing and also Regression testing when needed along with Documentation.Responsible for using different types of Stages such as FTP, Sequential File, Sort stage, Transformer and ODBC to develop different jobs.

Used DataStage as an ETL tool to extract data from sources systems, aggregate the data and load into the Netezza database.

France, Germany, Ireland, Italy, switzerland, United KingdomĪ highly reputed MNC which defines designs and delivers technology-enabled business solutions that help Global 2000 companies and also provides a complete range of services by leveraging their domain and business expertise and strategic alliances with leading technology providers.