Dear Folks, Hope you are doing great! We Need consultant for --ETL Datastage Developer
Please go through the below requirement & if you feel comfortable forward your updated resume so that I can get back to you. Please send me your resumes at [email protected] or call me at 203-652-1444 EXT 119 for further details Position: ETL Datastage Developer Location: Naperville IL Duration: 6 months plus ///ETL Datastage Developer///Naperville IL///6 months plus 1 in person interview Need a solid Datastage developer that will work closely with the business team, take non technical specs and translate them into technical requirements/develop based upon them. Position Summary The Business Intelligence Database and Reports Developer will serve on the Business Intelligence team, supporting data extractions, creating advanced database queries and transformations of data between physical structures, Oracle, ParAccel, SQL Server and/or DB2 systems and serve as a technical expert to the Business Analytics team. This position will provide development, performance, and monitoring within the BA/BI team to code interfaces, extractions, based on business usage. Skills should also include the ability to develop and interpret technical design documentation, have organizational skills sufficient to manage and complete the work load assigned with minimal supervision, and have excellent verbal and written communication skills. Position Responsibilities Participate as a team member on technical projects involving the use of Data warehouse for development of Business Reports. Develop written Technical Specifications describing details necessary to build advance SQL queries, data structures and data jobs based on business functional objectives. Develop and unit test queries and reports according to requirements in the Technical Specifications. Performs performance tuning and capacity planning activities relevant to queries and dependent processes. Facilitates root cause analysis on query performance issues, and communicate issues and resolutions effectively. Applies policies, procedures and standards relating to BI process development, in conjunction with Data Warehouse best practices. Works closely with other associates working on the same project. Will be required to work on moderately to very complex tasks. Follow SDLC processes and master the rules governing the project. Demonstrates a commitment to OfficeMax core values of safety, integrity, process improvement, and customer satisfaction. The position responsibilities outlined above are in no way to be construed as all encompassing. Other duties, responsibilities, and qualifications may be required and/or assigned as necessary. Position Requirements Minimum of 5 years experience in Oracle and/or SQL Server databases Experience developing ETL jobs to accommodate unstructured information available in Excel worksheets. Experience with Toad, SQL plus and advance performance tuning tools Experience with Developing both Server and Parallel jobs running on a UNIX platform. Working knowledge of ETL processes using Oracle databases and/or SQL Server as Source and Target data environments. Experience working in all phases of a full project life cycle. Experience with very large database management environments as it pertains to the development strategies necessary for building complex SQL queries in such an environment. Working knowledge of Unix Bourne and Korn shell scripting. Must be a high energy team player with a positive working attitude and possess excellent documentation skills Must be able to manage multiple assignments simultaneously Excellent verbal and written communications skills required. Understanding of the retail industry is preferred. Technical Skills Required skills 5+ years experience: Working knowledge of Oracle versions 9i, 10G and/or SQL Server 2008 with respect to building writing advance SQL queries and data extract routines. Extensive experience with building Historical and Daily Incremental ETL load processes in a large terabyte database environment. Expert knowledge in development of Server and Parallel processing jobs. LINUX and UNIX Bourne and Korn shell scripting Previous work with Enterprise scheduling tools such as UC4 for control DataStage job and sequencer execution. A working knowledge of SAP and the use of Standard Extractors in the SAP environment. A working knowledge of SAP BW and interpretation of Transfer Rules. ___________________________________________________________________________________________________________ Thanks and Regards, Tony Wilson | Technical Recruiter Panzer Solutions LLC 45 Stuart Ave, K Norwalk, CT 06850 US Voice: 203-652-1444 EXT 119 [email protected] URL: www.panzersolutions.com -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sap-basis?hl=en.
