FOR IMMEDIATE DETAILS ABOUT THIS POSITION, contact ANY of us direct, referencing the job# below:
JUSTIN MATLIN: (949) 860-4716 // JMatlin@calance.com
RASHMI KHULLAR: (949) 860-4705 // RKhullar@calance.com
MICHELL CASEY: (949) 860-4715 // MCasey@calance.com
** We will NOT accept 3rd Party/Corp to Corp (C2C) consultants **
Position: Sr. Informatica Developer
JOB REF#: 16139
Duration: 12+ Months (On-going Contract)
Location: Torrance, CA 90501 (on-site only)
Rate: Open, depends on exp level (W2 Only/H1 Transfer)
** MUST BE LOCAL (Resides in S. California) **
Senior Informatica Developer who has experience with Oracle database and PL/SQL , Data Warehouse, Unix Servers and Shell scripting.
Improving data quality, working under the supervision of the ECRM team lead.
Design solutions and conduct data analysis is required.
Supporting a custom CRM application, specifically the analytical repository. The repository is an Oracle database, the OS is Unix AIX 6.x.
Responsibilities analysis, design, and development
REQUIRED SKILLS/EXPERIENCE: (Resume must reflect this experience)
7+ years of Data Transformation (ETL):
Strong ETL design and development abilities, PL/SQL and Stored Procedures to upload data from different sources
Outstanding Informatica design and development abilities.
Experience in ETL performance tuning/optimization.
Experience working with complex Informatica transformations.
Strong experience identifying, researching, and resolving ETL issues and producing root cause analysis documentation.
Experience writing ETL specifications.
Experience developing complex ETL mappings.
Experience with Extraction, Transformation and Loading (ETL tools) to facilitate loading large amounts of data.
Experience with versioned repositories and configuration management.
Oracle Database (7 years):
Understanding of Oracle PL/SQL techniques to write stored procedures, triggers and packages that analyze several million rows across several database tables.
Ability to grasp relational data models quickly and program using SQL and PL/SQL.
Clear understanding of SQL s analytical processing capabilities
Understanding of Oracle dynamic SQL and ability to write complex procedures using dynamic SQL.
Familiarity with Oracle Data Partitioning techniques to manage, support and performance tune very large databases (VLDB s)
Understanding of Parallel execution features of Oracle to dramatically reduce response times for data intensive operations.
Ability to write efficient PL/SQL procedures.
Unix OS (5 years):
Experience working with Unix servers
Experience with Shell scripting
Other Must Have's:
Education: Bachelor's degree in computer science or related discipline
Must be able to work as a W2 hourly consultant (H1 Transfer's available)
Must reside LOCALLY (S. California) area
MUST be available for a face to face interview
Auto industry, CRM and knowledge of marketing concepts
Calance Benefits Offerings:
H1 Transfers/Green Card processing is available
Medical/Dental/Vision benefits (HMO/PPO)
401K Retirement program
Paid Bi-Weekly/Direct Deposit
Flex Spending Plan
Voluntary Life, AD&D, STD or LTD plans
Recruiter: Calance Recruiters
Phone: (800) 732-4680