HI
ONLY LOCALS
position : ETL Informatica with Automation Specialist
location : Concord, CA
Duration : 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:
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.
