Informatica Developer

Kelly IT has an excellent opportunity for an Informatica Developer!

Seeking an experienced Senior Informatica Developer who has experience with Oracle database 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.

The position will be supporting a custom CRM application, specifically the analytical repository. The repository is an Oracle database, the OS is Unix AIX 6.x. The responsibilities for the position include the analysis, design, and development of assigned work activities.
The candidate will be assigned to work on a specific project related improving data quality, under the supervision of the ECRM team lead.

Data transformation (ETL):
7+ years (mandatory)
• 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.
• Identifies areas of improvement.

Oracle Database:
7+ years (mandatory)
• 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.
• Design complete solutions.

Database / Other:
5+ years (Mandatory)
• 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 PL/SQL 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
5+ years (Mandatory)
• 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.

*• Knowledge of the auto industry and CRM. (Preferred)

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 minor tasks and follow up on progress specially if depending on others to do their tasks.

Communication (Mandatory)
• Proven written and oral abilities.
• Positive and friendly personality.


Please visit the Kelly Career Network for more opportunities!

Kelly IT Services is a leading IT staffing firm, providing employers with the best candidates & job-seekers with IT career opportunities.

Why Kelly®?

With Kelly, you’ll have direct connections to leading IT organizations in the best companies around the globe—offering you the chance to work on some of today’s most intriguing, innovative and high-visibility projects. In a field where change is the only constant, our connections and opportunities will help you take your career exactly where you want to go. We work with 90 of the Fortune 100™ companies companies and found opportunities for more than 8,600 IT professionals last year. Let us help advance your career today.

About Kelly®

At Kelly, we’re always thinking about what’s next and advising job seekers on new ways of working to reach their full potential. In fact, we’re a leading advocate for temporary/nontraditional workstyles, because we believe they allow flexibility and tremendous growth opportunities that enable a better way to work and live. Connecting great people with great companies is what we do best, and our employment opportunities span a wide variety of workstyles, skill levels, and industries around the world.

Kelly is an equal opportunity employer committed to employing a diverse workforce, including, but not limited to, minorities, females, individuals with disabilities, protected veterans, sexual orientation, gender identity. Equal Employment Opportunity is The Law.

Kelly complies with the requirements of the Fair Chance Initiative. A conviction record does not automatically bar individuals from employment.

Related jobs you might be interested in...
Hadoop Developer
Torrance CA
8 days ago
Full Time
.NET Developer
Torrance CA
8 days ago
Full Time
IT Business Analyst
Torrance CA
8 days ago
Full Time
One moment please...

Create an Account or sign in using one of your social networks by clicking an icon below. You can also Create an Account by uploading your resume

As of Sep 19, 2019 our security requirements for account passwords have been updated and you are required to click the Forgot Password link to create a new password.
Forgot Password        
Verify Email
First Name
Last Name
Verify Password


Choose your resume:
You currently don't have any resumes uploaded. Please upload one to continue.
Resume Title
Upload a Resume
Candidate Experience Site Guest User
Time Zone:
EST (Eastern Standard)
Area(s) of expertise:
Communication Preference:
Thank you for your interest in this job.
Your resume has been successfully submitted.

What would you like to do next?

One moment please...