Hi
Position : ETL Informatica Automation Specialist Location: Concord, CA (near San Francisco) Duration: 6 – 9 months Key Responsibilities: · Perform Core Informatica Development tasks utilizing PowerCenter 8.6 such as session on grid node based parallelism · Performance tuning, monitoring and troubleshooting · Build Informatica shared module workflows and mappings following strict naming and coding standards · Work with existing functionality for Unix automation, status, and reporting run-time functionality; ensuring satisfactory response time with reliable database connectivity and/or system command interfaces · Utilize Unix Shell Scripts (ksh on Linux or equiv) for automaton of Informatica runtime components in a Linux environment including interfaces to other systems, control tables, logging, etc. · Interact with Business teams and Analytical Teams on a limited basis · Involvement and contribution to complex Schedules (Tivoli), set priorities, and implement action plans · Implement best practices on new Informatica implementations with cross environmental considerations (DEV/QA/PROD) · Facilitate knowledge transfer and mentor other team members · Knowledge of Informatica CDC (change data capture) utilities is a plus · Have comprehensive knowledge of Informatica design and build techniques for high-performance loads and re-run · Have direct experience in the build or design and build of 'Slowly changing Dimensions', build of fact extracts, lookups, joins, and transformation logic including, but not limited to numeric conversion, string manipulation, persistent variables, etc. · Understand dynamic and static memory allocation with regards to lookups and join functionality and how to best apply it to high performance processing Requirements: · Senior-level experience in Informatica (5 years) · Proficient in SQL and PL/SQL · Must have 6+ years of experience in Oracle (8, 9i, and 10g) · Knowledgeable in Informatica architecture, design, and development · Knowledgeable of Datawarehouse design, automation and Implementation at an Enterprise level, specifically with regards to SCD (slowly changing dimensions) · Must have experience using CRC (Cyclic Redundancy Checks) for delta processing in Informatica · Strong problem solving skills · Excellent leadership capabilities and communication and documentation skills · Candidates must be proficient in Unix Scripting and editing tools and be able to work with and modify existing scripts with minimal assistance or supervision · Ability to be proactive and work well under pressure -- Thanks and Regard’ anshu IT Recruiter G technologies 4340 Stevens Creek Blvd San Jose , CA 95129 Email: [email protected] Office: 408-414-2032 Ext: 204 Fax: 408-716-8873 http://www.gtechnologiesinc.com Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include contact information and a remove link for removal from our mailing list. To be removed from our mailing list reply with "remove" in the subject heading and your email address in the body. Include complete address and/or domain/ aliases to be removed. If you still get the emails, please call us at the numbers given above. -- You received this message because you are subscribed to the Google Groups "ORACLE DWH DBA" 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/oracle-dwh-dba?hl=en.
