Hi friends Greetings, Please send the resumes to [email protected]
*JOB TITLE: SENIOR LEAD DW/ETL DEVELOPER *** * * Location: Charlotte, North Carolina Duration: 1 year + SIEBEL 4 - 6 YRS REQUIRED *REQUIRED SKILLS:* *SIEBEL OLAP*: Working knowledge of the Siebel Data Warehouse: Key generation, WIDS, Slowly changing dimensions, basic table sources, etc. Concrete familiarity with OLTP-to-OLAP. Proven experience with EIM Data Loads. *SIEBEL DATA WAREHOUSING*: Multi Terabyte data warehousing experience. Understanding the design considerations for star schemas and its relationships. Understanding the concept of data rollups/aggregation, capacity planning, data standardization, slowly changing dimensions, and data security. *INFORMATICA*(version 7.5 and up): Multiple project experience with Informatica. Ability to communicate design considerations using this tool. Practical experience in loading data, troubleshooting mappings, tuning mappings, etc. *ORACLE* Multi-terabyte data experience with Oracle 8/9i/10g, demonstrates the basic ability/understanding to design data structures, performance tune data loads and ability to read/write PL/SQL. *UNIX:* Proven experience with reading and writing Shell Scripts (ksh). Ability to navigate, edit/find files, check disk space and transfer files. Knowledge of performance monitoring tools in the UNIX environment. Business: Demonstrated knowledge in the financial services arena focusing on Annuity Products, Mutual Funds, Brokerage, etc *Tasks and Responsibilities: * Map and deploy Informatica mappings from various legacy source systems into Siebel. Develop and execute test and implementation plans Typically experienced across multiple Information Technology areas and all system / applications software development. Serves as point of escalation for complex issues. Responsible for developing and executing project plans, as well as coordinating groups of IT staff. *Plus Skills/Experience include:* TERADATA experience is a BIG PLUS. SAS - Ability to program in SAS Siebel EIM: Ability to create and modify Siebel EIM IFB files. Knowledge of mapping EIM tables to Siebel base tables. Ability to troubleshoot EIM loads. Knowledge of Siebel visibility and list of value design considerations. Operating Systems: Unix AIX 5.1/5.2, Windows 2K, MVS/OS 390, AS400. Ability to navigate in these environments, ability to script technical solutions in each of these environments *Other Analytics Tools*: Usage of Cognos, Business Objects, Microstrategy, Brio, Hyperion, Actuate or Crystal Other ETL Tools: DecisionStream, ETI, Ab Initio, Data Stage Other Databases: Teradata, DB2/UDB, ADABAS, MS SQL server Required education/experience: Bachelors Degree or equivalent work experience in Computer Science, Information Systems, or other related field. 10 plus years of IT work experience in systems programming / analysis Please call me if you have any questions. Regards Seshu MetaPro IT Solutions Ph : 913-660-0395 Fax: 913-234-4369 Email: [email protected] Website: www.metaprousa.com
