TorranceRecruiter Since 2001
the smart solution for Torrance jobs

ETL/Informatica Developer- W2 only- Local to Los Anagels only

Company: iSpace, Inc
Location: Torrance
Posted on: August 31, 2020

Job Description:

Interested candidates email resume to sonia(dot)menon(at)ispace(dot)com Here is the job description Title ETL Informatica Developer Location Torrance, CA Duration 3 Years Job Description Seeking an experienced Senior Informatica Developer who has experience with Oracle or DB2 databases and PL-SQL Data warehouses Unix servers and shell scripting. Ability to design solutions and conduct data analysis is required. Auto industry, CRM and knowledge of marketing concepts are pluses. Responsibilities The position will be supporting a custom CRM application comprised of both a transactional (DB2) and analytical (Oracle) information repository. The OS is Unix AIX. The responsibilities for the position include operational support tasks as well as enhancement activities like analysis, design, development, testing and deployment. The candidate will work under the supervision of the ECRM team manager and technical leads. Required Qualifications Data transformation (ETL) Mandatory 7 years experience Outstanding Informatica design and development abilities. Experience in ETL performance tuningoptimization. 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. Identifies areas of improvement. Oracle or DB2 Database Mandatory 7 years experience Understanding of Oracle PLSQL 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 PLSQL. 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. Design complete solutions. DatabaseOther Mandatory 5 years experience Experience in the analysis, design, development deployment of large scale databases. Experience in the design and development of data warehousing is a plus. Ability to write and understand complex SQL required. Knowledge of Oracle PLSQL best practices and development methodologies or standards - Stored Procedures, Packages, Triggers, Debugging, Tuning. Data modeling Experience a plus. Data Warehousing experience a plus. Unix OS Mandatory 5 years experience Experience working with Unix servers. Experience with Shell scripting. Qualifications and Experience - Mandatory Bachelor's degree in computer science or related discipline or have equivalent experience. Strong ETL design and development abilities, PL-SQL and Stored Procedures to upload data from different sources. Qualifications and Experience - Preferred Knowledge of the auto industry and CRM. Personal Initiative Mandatory Motivated self starter. Ability to work in a fast paced environment. Ability to work in a team environment where team conducts code and design reviews prior to implementation. Ability to lead tasks and follow up on progress specially if depending on others to do their tasks. Expected to assume the role of lead Informatica developer.

Keywords: iSpace, Inc, Torrance , ETL/Informatica Developer- W2 only- Local to Los Anagels only, IT / Software / Systems , Torrance, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Software Engineer
Description: LOCATION: br br Beautiful Sunny Southern California with 12 months of sunshine. Our office is located only 7 minutes from the beautiful beaches of Southern California. And if you are an engineer who (more...)
Company: NortonLifeLock Inc
Location: Culver City
Posted on: 09/27/2020

Field Sales Representative
Description: Field Sales Representative To empower AT Ts business to grow, we need to communicate in a way that translates our value. The right person for this role will be able to come into our dynamic environment, (more...)
Company: DSI Systems
Location: Long Beach
Posted on: 09/27/2020

Mobile Notary / Get your documents signed in a timely manner!
Description: Certified Mobile Notary Service certifiedmobilenotaryservice.com is now seeking Mobile Notaries nationwide. We currently have an exciting opportunity for Notary Publics in all 50 states looking for (more...)
Company: Certified Mobile Notary Service
Location: Long Beach
Posted on: 09/27/2020


IT Software Developer III
Description: As the IT Software Developer III, you will be responsible for developing business intelligence BI solutions in accordance with enterprise standards and user requirements. Areas of responsibility include (more...)
Company: THE METROPOLITAN WATER DISTRICT OF SOUTHERN CALIFO
Location: Los Angeles
Posted on: 09/27/2020

Mobile Notary Sign Up Here
Description: Certified Mobile Notary Service certifiedmobilenotaryservice.com is now seeking Mobile Notaries nationwide. We will help you with getting certified, bonded, and insured. We are a one-stop-notary shop (more...)
Company: Certified Mobile Notary Service
Location: Long Beach
Posted on: 09/27/2020

Angular Developer
Description: Please note that this is a 4 months contract position. JOB SUMMARY bull Develop User interfaces for Digital Customer facing Responsive Applications with the latest Front End Technologies bull Perform (more...)
Company: NetSource, Inc.
Location: Los Angeles
Posted on: 09/27/2020

(Nationwide) Looking for a mobile notary to sign and stamp your documents?
Description: Certified Mobile Notary Service certifiedmobilenotaryservice.com is now seeking Mobile Notaries nationwide. We currently have an exciting opportunity for Notary Publics in all 50 states looking for (more...)
Company: Certified Mobile Notary Service
Location: Los Angeles
Posted on: 09/27/2020

Senior Software Engineer I
Description: Are you a passionate C SOFTWARE ENGINEER looking for a CHANGE, then Raytheon is ready to help you achieve your goals. Join our team and get the opportunity and support to find purpose, thrive and succeed. (more...)
Company: RTX
Location: Santa Fe Springs
Posted on: 09/27/2020

Mobile Expert, Metro
Description: Mobile Expert, Metro br br Responsibilities br li Help customers pick up right where they left off in their shopping journey, whether online, through Customer Care or in-store. li Exploring (more...)
Company: Metro by T-Mobile
Location: Stanton
Posted on: 09/27/2020

Senior Node.js Developer
Description: Fuel Cycle is seeking a Senior Node.js Developer to join our Research and Development team. As a Senior Node.js Developer at Fuel Cycle, you will work with our AVP of Engineering to architect and develop (more...)
Company: FUEL CYCLE
Location: Los Angeles
Posted on: 09/27/2020

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Torrance RSS job feeds