*DataStage Developer (ETL)* This is an opportunity for an experienced (5+ years) Developer that is highly skilled and competent using IBM DataStage.
Duration: up to 24 months Location: downtown Chicago, IL When responding, please show current location, and phone and email contact information. *L**ocal Chicago, IL area candidates are highly preferred.* *##### **IMPORTANT NOTE:* All interviews will take place *on-site in Chicago*. *Please do not apply if you can't do a face-to-face /* *in person interview on Tuesday afternoon, September 9th. No Skype interviews*.. #### *Position Description:* Direct responsibility for the design, maintenance, and support of Data Warehouse Systems. The developer requires a high level of analytical and creative skills and an in-depth knowledge of database structure, data warehouse configuration, methodology, design, and modeling. The developer’s typical duties include designing and building data warehouses, designing ETL processes and procedures using tools such as IBM InfoSphere, performing analysis, SQL scripting, Unix Scripting tuning and optimization on very large (multi-terabyte) databases. Works with lead application developers to design and develop database objects and structures according to project specifications; addresses data quality issues with users; analyzes organizational data requirements and review/understand logical and physical Data Flow Diagrams and Entity Relationship Diagrams using tools such as Visio and Erwin. Must be able to work with and within a cross-functional development, QA and production team. *Requirements: * Individual needs to be highly skilled and competent using the IBM Data Stage product. • 5+ years of experience in IT • 5+ years as a Data Integration practitioner • 3+ years of solid hands-on experience in using IBM DataStage • Understand DataStage clustering architecture and parallel jobs • Intimate knowledge in combine/sort/aggregate/transform data • Able to create reusable objects and job templates • Schedule, compile, and run DataStage jobs efficiently • 1+ year of solid hands-on experiences in using XML stage • Intimate knowledge in interpreting/manipulating XML document • 3+ years in UNIX scripting, FTP and basic network principles • 3+ years skills in database and data warehouse design principles • 3+ years of SQL Coding and querying skills • 3+ years of experience in testing, debugging skills and troubleshooting support and development issues • Experience in providing onsite support • Customer focused and work well in a team environment • Proactive and self-managed to achieve deliverables • Demonstrate strong analytical/problem solving skills • On-site consulting experience at customer locations • Must possess good verbal and written communication skills • Ability to write consistent, clear and accurate documentation *Preferred Skills:* • Experience with version 8.5 (Quality Stage/DataStage) • Experienced in application development • Data modeling experience *Responsibilities include the following:* • Reviewing and understanding complex database structures and maps. • Solid understanding of both relational and dimensional database structures. • Local Installation and configuration of IBM InfoSphere Data Integration suite. • Troubleshooting IBM InfoSphere Data Integration components. • Project migrations to/from various environments. • Develop and troubleshoot UNIX scripts. • Set up database connectivity to various database environments. • Monitor environments according to security requirements. • Monitor jobs for performance issues and troubleshooting. • Develop, enhance, and support best practices and standards for data integration. • Provide performance tuning insight to project teams. • Mentor developers on data integration best practices and standards. • Perform design and code reviews for the projects to ensure alignment with best practices and standards. *General Information:* · Resumes must show month and year for each job/assignment. · No Visa sponsorship available, however, we can accept 3rd party resumes for this position. · Client prefers local candidates, but all qualified candidates will be considered. · Candidates must be able to interview in person, if requested by client (client does not pay this expense), and NO Skype interviews. · Should be able to begin work with no more than 2 weeks’ notice from time of offer. · Must be willing to work at client site. *Regards,* *Manju Shree* *Sr IT Recruiter* *IDC Technologies, Inc. 1851 McCarthy Boulevard, Suite 116,Milpitas, CA, USA, 95035* *Phone: 408-418-5779 ext 1012 |Fax: 408-608-6088 | * *Email: **ma...@idctechnologies.com* <kara...@idctechnologies.com>*| Web: * *www.idctechnologies.com* <http://www.idctechnologies.com/> -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at http://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.