Data Engineer jobs

Informatica / PL/SQL Developer

Sonsoft Inc (agency)Torrance, CAFull-time

Pay not listed

Key facts

Experience
7+ years
Degree
Bachelor's degree or equivalent
US visa
No US visa sponsorship

2 things to check before you apply.

On Sonsoft Inc’s own careers site (SmartRecruiters), checked open today.

  • To check: Posted by the employer 9 years agoLong-open jobs are sometimes already filled. Ask when they plan to hire.
  • To check: No pay range listed, though one is likely required in CAAsk for the pay range before you interview. The law here likely requires one.
  • Checked: On the company's own careers siteSmartRecruiters board
  • Checked: Checked open todaySmartRecruiters board
  • Checked: No reposts foundSmartRecruiters board
  • Trust score 55 / 100 · Check details
See all 6 checksShow fewer
How we check

What you’ll do

  • Support a custom CRM application’s analytical repository, an Oracle database running on Unix AIX 6.x.
  • Analyze, design, develop, and provide 24/7 support for production processes and applications.
  • Support CRM analytics and campaign operations as part of the ECRM team.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • 7+ years of data transformation experience
  • Experience tuning and optimizing ETL performance
  • Experience with complex Informatica transformations and ETL mappings
  • Experience identifying, researching, and resolving ETL issues and documenting root cause analysis
  • Experience writing ETL specifications
  • Experience using ETL tools to load large amounts of data
  • Experience with versioned repositories and configuration management
  • 7+ years of Oracle database experience
  • Experience writing Oracle PL/SQL stored procedures, triggers, and packages that analyze millions of rows across multiple tables
  • 5+ years of experience analyzing, designing, developing, and deploying large-scale databases
  • Knowledge of the auto industry, CRM, and marketing concepts (preferred)
  • Experience designing and developing data warehouses (preferred)
  • Data modeling experience (preferred)

Skills

  • Outstanding Informatica design and development abilities
  • Ability to program using SQL and PL/SQL and write complex SQL
  • Understanding of SQL analytical processing capabilities and Oracle dynamic SQL
  • Familiarity with Oracle data partitioning and parallel execution features
  • Ability to write efficient PL/SQL procedures and design complete solutions

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Full job description

From Sonsoft Inc’s careers site

Company Description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

Job Description:

· Seeking an experienced Senior Developer who specializes in Informatica, 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.

Responsibilities

Show full descriptionShow less

· 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, development and 24/7 support of the production processes and applications.

· The candidate will work under the supervision of the ECRM team lead.

· Will be part of a team responsible for supporting CRM analytics and Campaign operations.

Musts

· BA/BS in Computer Science or equivalent training

Business Experience:-

Data transformation with Mandatory 7+ years of 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 Database with Mandatory 7+ years of 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 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 with Mandatory 5+ Years of 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 with Mandatory 5+ years of Experience

· Experience working with Unix servers.

· Experience with Shell scripting.

Qualifications and Experience:

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

Qualifications

Personal Initiative:-

· 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:-

· Proven written and oral abilities.

· Positive and friendly personality.

Additional Information

Note:- This is a Full-Time & Permanent job opportunity for you. Only US Citizen, Green Card Holder, GC-EAD, H4-EAD & L2-EAD can apply. No OPT-EAD, H1B & TN candidates please. Please mention your Visa Status in your email or resume.

Something wrong with this job? Report it · This flag looks wrong

Similar jobs nearby

Data Engineer

K2 Space · Los Angeles, CA

$120k–$160k/yr

StrongChecked open todayPosted 11 days ago

Data Engineer

ACCO Engineered Systems · Pasadena, CA

$106k–$143k/yr

StrongChecked open todayPosted 1 month ago

W2PE - Engineer

Trace3 · Irvine, CA

$120–$150/hr

StrongChecked open todayPosted 1 month ago

Data Engineer

UJET · Austin, TX +2 places

$140k–$160k/yrHybrid

StrongChecked open todayPosted 1 month ago

Data Engineer

Two95 International Inc. · Glendale, CA

Full-time

Looks goodPay not listedChecked open todayPosted yesterday

See more like this