Position Details:

Senior ETL Software Engineer
 

Job Duties:

Design, develop and test ETL Mappings with Informatica. Develop and test ETL Sessions using Informatica and Datastage. Work on EssBase Cube and Planning cube design. Design parallel jobs and Server Jobs using DataStage. Design and develop pre and post session UNIX shell scripts. Integrate ETL done at offshore with onsite servers. Assist in the development of program plans, cost estimates and budgets, resource-loaded schedules, earned-value tracking, and issue papers for the planning, budgeting and evaluation of ETL development projects. Schedule and monitor weekly and monthly production. Implement change requests and impact analysis. Create security access to different users in both Essbase and Hyperion Planning. Use the DataStage Administrator for granting the privileges to the user, setting up the libraries for the DataStage project and setting up the projects. Implementation of Data Warehouse and Business Intelligence using ETL tools like Informatica,  PowerCenter/PowerMart, Datastage, Parallel Extender, IBM Information Server, Cognos, Hyperion Essbase, Hyperion Planning, Hyperion Reports, Hyperion Analyzer, ESSCMS, Essbase Excel Spreadsheet, Calc Scripts, Load Rules, Report Scripts and Unix. Will work in Glastonbury, CT and/or various client sites throughout the U.S. Must be willing to travel and/or relocate.