*ETL/Informatica Developer* Location: Kansas City, MO Duration: 6+ Months..
*Must be local, someone that lives a short plane ride or drive from Kansas City* Skills needed: * Expertise in Extraction, Cleansing, Validating and Integrating of data from multiple systems. * Hands on experience in Transforming Business specific rules into functional Specs. * Work with the Data Integration Architect to create ETL standards, High Level and Low-level design documents. * Strong experience in designing Parallel, (Note – Parallel experience is REQUIRED) Server Jobs, Job Sequencers and Batch Jobs in IBM DataStage Enterprise Edition 8 and above. * Strong experience in Informatica ETL including complex mappings, transformations and workflows. * Extensively worked with portioning for splitting multiple data streams into sub chunks to distribute the load evenly across all available processors to achieve maximum thru put. * Strong Knowledge of Data Warehouse Architecture, Star Schema, Snow flake Schema, Fact tables and Dimensional tables. * Experience in Integration of various data sources like SQL Server and Oracle. * Strong experience in writing database procedures, functions and fine-tuning SQL for performance optimization. * Good experience in writing Shell Scripts to automate file manipulation and data loading procedures Regards*. . .** * ANSAR ** Sr. Technical Recruiter CAT Technology Inc. ‘*Committed to Human Excellence Through IT'* Office: (201) 257 5081 Ext: 299 'or' 283 an...@catstaffing-us.com <an...@catstaffing-us.com> || ansar.catstaff...@gmail.com www.catamerica.com || www.cattechnologies.com *P** **Save trees. Print Only When Necessary* **** ** ** -- You received this message because you are subscribed to the Google Groups "OracleD2K" group. To post to this group, send email to oracled2k@googlegroups.com. To unsubscribe from this group, send email to oracled2k+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/oracled2k?hl=en.