Informatica/ETL Developer

  • Calance,
  • Torrance, CA
Informatics, ETL, Oracle, PL/SQL, Oracle Dynamic, SQL, UNIX/Shell
Contract W2, 12 Months
Work from home not available Travel not required

Job Description


FOR IMMEDIATE DETAILS ABOUT THIS POSITION, contact ANY of us direct, referencing the job# below:


Kindest Regards:


JUSTIN MATLIN: (949) 860-4716

SUMIT KUMAR: (949) 860-4718

MICHELL CASEY: (949) 860-4715

E M A I L: Recruiter.key1@calance.com

=====================
=====================

** We will NOT accept 3rd Party/Corp to Corp (C2C) consultants **

Position: Informatica/ETL Developer
JOB REF#: 16139A

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) **

Informatica Developer who has experience with Oracle database and PL/SQL , Data Warehouse, Unix Servers and Shell scripting.


RESPONSIBILITIES INCLUDE:


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 (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):
Outstanding Informatica design and development abilities.
Experience working with complex Informatica transformations.
Strong ETL design and development abilities, PL/SQL and Stored Procedures to upload data from different sources
Experience in ETL performance tuning/optimization.
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


DESIRED:


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
Dice Id : cxbcsi
Position Id : JobNum33376
Have a Job? Post it

Similar Positions

Informatica Developer
  • Sharp Decisions
  • Torrance, CA
Informatica Cloud Developer
  • Farmers Insurance
  • Woodland Hills, CA
Informatica/ETL Developer (Big Data)
  • Tentek, Inc.
  • Torrance, CA
Informatica Developer/Tech Lead
  • Sysmind, LLC
  • Woodland Hills, CA
Talend informatica developer
  • Xebia US
  • Santa Monica, CA
Senior Informatica PowerCenter ETL Developer
  • Kforce Technology Staffing
  • Irwindale, CA
Sr Informatica Consultant
  • Dataflix Inc.
  • Orange County, California
ETL/Informatica Analyst/Developer
  • Delta Computer Consulting Inc
  • Torrance, CA
Informatica ETL admin
  • Enterprise Solutions
  • Los Angeles, CA
MDM Informatica Developer
  • Solugenix Corporation
  • Los Angeles, CA
ETL Developer
  • LegalZoom.com, Inc.
  • Glendale, CA
Informatica Developer
  • LinkPro Technologies Inc.
  • Orange County, California