Sagarsoft
 
 
 
 
 
 

Position Details: Senior ETL Software Engineer


Location: Glastonbury CT, Various client sites throughout the United State, and must be willing to travel and / or relocate
Openings: 1
Salary Range:
 

IMAGE: Apply to Position

IMAGE: Available Positions

Description:




- Involved in project planning, analysis and designing the applications.

- Perform Business Process Requirement analysis, project integration management, scope management, quality management, project management and tracking, IT life-cycle development process, and risk management.

- Develop project charters, program plans, cost estimates and budgets, resource-loaded schedules, earned-value tracking, and issue papers for the Planning, Budgeting and Evaluation.

- Design, Develop and test ETL Mappings with Informatica.

- Develop and test ETLSessions 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.

- Schedule and monitor weekly and monthly production. Implement change requests, impact analysis.

- Move code to production.

- Maintain versions of ETL code.

- Involved in creating 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, setting up the projects.

- Work in: ETL Informatica, Powermart, Power Center, Cognos, Hyperion Essbase, Hyperion Planning, Hyperions Reports, Hyperion Analyzer, ESSCMS, Essbase Excel Spreadsheet, Calc Scripts, Load Rules, Report Scripts and Unix.