Notice of filing of Application for Permanent Employment Certification
Job Title
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.
Salary
$105,000/year
Location
200 Glastonbury Boulevard, Ste 304, Glastonbury, CT 06033 and various client sites throughout the United States,and must be willing to travel and / or relocate
This notice is provided as a result of the filing of an application for permanent alien labor certification for this job opportunity in the compliance with 20 CFR 656.10(d). Any person may provide documentary evidence bearing on this application to:
Certifying Officer, U.S. Department of LaborEmployment and Training AdministrationAtlanta Processing CentreHarris Towers233 Peachtree Street, Suite 410Atlanta, GA 30303
