JobWatch

17 days old

ETL /Informatica Analyst/Developer

Kelly Services
Torrance, CA 90509
  • Jobs Rated
    61st
ETL/Sr. Informatica Analyst/Developer



Type: Contract (until at least 2023)



Location: Torrance, CA



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.


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 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 or DB2 Database Mandatory 7+ years experience

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 SQLs 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 (VLDBs)

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 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 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 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.


Communication Mandatory

Proven written and oral abilities.

Positive and friendly personality.





If this describes you, please apply today!




**Why Kelly** **** **?**



By partnering with Kelly Technology, youll have direct connections to top companies around the globegiving you the chance to put your tech skills to work on some of todays most intriguing, innovative, and high-visibility projects. In a world where change is the only constant, our unparalleled connections and IT market expertise help you take your skills exactly where you want to go. Were here to help you gain experience, keep learning, and move your career forward.





**About Kelly** ****




At Kelly, were always thinking about whats next and advising job seekers on new ways of working to reach their full potential. In fact, were 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.

Jobs Rated Reports for Computer Programmer

Posted: 2020-08-31 Expires: 2020-10-01

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

ETL /Informatica Analyst/Developer

Kelly Services
Torrance, CA 90509

Join us to start saving your Favorite Jobs!

Sign In Create Account
Computer Programmer
61st2018 - Computer Programmer
Overall Rating: 61/220
Median Salary: $82,240

Work Environment
Good
50/220
Stress
Very Low
17/220
Growth
Very Poor
211/220
Powered ByCareerCast