Please respond to vikr...@revosysit.com * *
*Position # 1* * * * * *Position: *Informatica ETL Developer** *Location: *Simi Valley, CA** *Duration: *9 Months** * * * * *Job Requirements:* * * *Mandatory Expectations:* - Work directly with the Lead Data Warehouse Architect and Data Modeler to analyze user requirements and translate those requirements into proper system specifications and technical design solutions. - Maintain a high level of competence, professionalism, and systems expertise while working through Software Development Life Cycle (SDLC). - Design and implement ETL solutions which support the requirements of the Business in data scope, data quality, and timeliness of delivery. - Perform unit testing on ETL solutions - Support the QA team and/or End Users during QA Testing and User Acceptance Testing - Implement ETL best practices to ensure and validate data quality and integrity. Work with developers and data source owners to resolve and escalate data issue promptly. - Create and maintain data loading schedules - Collect data load statistics and provide support to data load reporting *Education* * * - 4 year Bachelor’s degree in Engineering or Computer Science. - Master’s degree preferred. *Qualifications:* - Ability to work on multiple projects concurrently. - Ability to stay abreast of significant technological developments that may impact the business - In-depth understanding and strong hands-on experience with the Informatica Data Integration Tool Suite (including DAC, IDE, etc.). - Strong understanding of data & application integration concepts. - Experienced in data analysis in relational & dimensional databases (Oracle). - Extensive experience with a 3rd Party Oracle Developer Tool (T.O.A.D., SQL Navigator, etc.). - Strong knowledge of data transfer protocol (ftp). - General knowledge of UNIX Operating System (AIX). - Strong working knowledge of PL/SQL * * * * *Position # 2* * * * * *Position: Lead *Informatica ETL Developer** *Location: *Simi Valley, CA** *Duration: *9 Months** * * * * *Job Requirements:* * * *Mandatory Expectations:* * * - Analyze and translate business requirements into technical specifications Build prototype using EssBase and work with users to solidify requirements and design - Lead data cube design activities - Define cube data structure and calculation rules - Create ETL specifications to importing data and building cubes - Work with the OBIEE developers to create reports using cube data - Tune performance and troubleshoot applications - Work with out-sourced vendors to setup, configure, maintain and upgrade hardware configurations for EssBase implementations - Train Report Developers and end-users to maximize the utilization of EssBase features - Evangelize the capability and power of EssBase's toolset to other parts of the organization *Education* * * - 4 year Bachelor’s degree in Engineering or Computer Science. - Master’s degree preferred. * * * * *Qualifications:* * * - Overall 8-10 years of work exp with at least 3-5 years of hands-on work exp with developing on Essbase, Planning and Shared Services. - Experience with Hyperion System 11 is desired - Extensive experience with writing Business Rules, Calc scripts and Maxl scripts - Extensive experience with building and modifying Financial Reports (FR) and/or WebAnalysis (Dashboards) - Extensive experience with Windows scripting and writing batch files in support of ETL Processes. - Experience in multidimensional analysis, designing applications and databases, designing and building dimensions, loading data, calculating data and aggregation techniques - Thorough knowledge of end user tools including Smartview, and Essbase Add-in for Excel (Visual Explorer) - Demonstrated knowledge of drill to detail functionality - Demonstrated knowledge of both native security and Shared Services security - Working knowledge of OBIEE - Working knowledge of Linux OS & Windows OS - Working knowledge of software version control concepts and change management processes - Working knowledge of ETL processes - Working knowledge of data modeling concepts, both relational and dimensional - Knowledge of JDBC, ODBC, PL/SQL, TOAD/any SQL query tool - Knowledge of Oracle Financials or any other ERP system. - Proven Data Analysis and Troubleshooting Skills - Good team player and detailed oriented, resourceful, motivated and creative - Must be flexible, organized and able to handle competing priorities, demonstrate sound, logic based decision making - Strong verbal and written communication skills are a must Thanks N' Regards, Vikram M** Revosys IT Inc.** 108-31, 47th Avenue, Corona, NY 11363 Ph: 347 468 7163 | Fax: 347 649 2053 vikr...@revosysit.com | www.revosysIT.com -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To post to this group, send email to sap-basis@googlegroups.com. To unsubscribe from this group, send email to sap-basis+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sap-basis?hl=en.