PL/SQL Developer (F2F Interview)

Sonsoft Inc

Torrance (CA)

Presencial

USD 110.000 - 150.000

Jornada completa

14 días+

Una candidatura completa en un minuto

Currículum y carta de presentación personalizados, listos para enviar.

Supera los filtros ATS

Descripción de la vacante

A US-based software development firm is seeking an experienced Senior Developer to support its custom CRM application, focusing on analytics and Oracle databases. The ideal candidate must possess strong skills in PL/SQL and Unix servers, with a minimum of 5 years of experience in software development. Responsibilities include analysis, design, and development tasks, along with 24/7 production support. The firm is unable to sponsor at this time and only U.S. Citizens or residents may apply.

Formación

  • 5+ years experience with major DBMS.
  • 5+ years experience with coding, testing, and design.
  • 5+ years experience with software development methodologies.

Responsabilidades

  • Support a custom CRM application focused on analytical repository.
  • Conduct analysis, design, development and 24/7 support of production processes.
  • Work under the supervision of the ECRM team lead.

Conocimientos

Oracle Database
PL/SQL
Data transformation (ETL)
Unix servers
Shell scripting
SQL
Informatica
Performance Tuning
SQL
Stored Procedures

Educación

Bachelor's degree in Computer Science or related discipline

Herramientas

Informatica

Descripción del empleo

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
  • Seeking an experienced Senior Developer who specializes in Oracle database and PL-SQL / Data warehouses / Unix servers and shell scripting
  • Ability to design solutions and conduct data analysis is required
  • Informatica knowledge is a plus
  • Auto industry, CRM, and knowledge of marketing concepts are pluses

Responsibilities:

  • 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

Required Skills:

Oracle Database

  • Strong 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
  • A Clear understanding of SQL’s analytical processing capabilities such as RANK, DENSE RANK etc.
  • Strong understanding of Oracle dynamic SQL and ability to write complex procedures using dynamic SQL
  • Performance tuning methodologies and understanding of Relational database join techniques like HASH, NESTED LOOPS etc. and the use of Oracle Hints
  • Advanced knowledge of Oracle Indexing techniques like BIT Map indexes and Index Organized tables
  • Optimize and tune stored procedures, embedded SQL, taking advantage of Oracle specific features
  • 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
  • Bulk Collect functionality, pipelined functions and other features of Oracle PL/SQL
  • Ability to write efficient PL-SQL procedures
  • Design complete solutions

Data transformation (ETL)

  • Knowledge of Informatica is a plus
  • Familiarity with Extraction, Transformation, and Loading (ETL tools) to facilitate loading large amounts of data
  • Strong ETL design and development abilities
  • PL-SQL and Stored Procedures to upload data from different sources

Unix OS

  • Experience working with Unix servers
  • Experience with Shell scripting

Database/Other

  • Experience in the analysis, design, development, deployment & tuning of large scale databases
  • Experience in the design and development of data warehousing
  • Expert knowledge of SQL
  • Ability to write and understand complex SQL required
  • Query analysis and tuning experience (hints, explain plan, TKPROF)
  • Expert knowledge of Oracle PL/SQL best practices and development methodologies or standards
  • Stored Procedures, Packages, Triggers, Debugging, Tuning
  • Data Warehousing experience a plus
  • Bachelor's degree in Computer Science or related discipline or have equivalent experience

Desired Skills:

  • 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 especially if depending on others to do their tasks
Qualifications
  • 5 plus years experience with major DBMS
  • 5 plus years experience with coding, testing, and design
  • 5 plus years experience with software development methodologies
Additional Information

Connect with me at https://www.linkedin.com/in/mir-hasham-ali/ (ForDirect Clients Requirements)

U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.

Note:-

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

All your information will be kept confidential according to EEO guidelines.

Consigue la evaluación confidencial y gratuita de tu currículum.

o arrastra y suelta tu archivo aquí

Similar jobs

Puestos de trabajo similares que vale la pena comparar

Informatica / PL/SQL Developer
Informatica / PL/SQL Developer

Sonsoft Inc • Torrance (CA)

Presencial
USD 100.000 - 120.000
Big Data Consultant (Permanent Job)
Big Data Consultant (Permanent Job)

Sonsoft Inc • Moline (IL)

Presencial
USD 90.000 - 120.000
,PL/SQL Developer
,PL/SQL Developer

Sonsoft Inc • Omaha (NE)

Presencial
USD 85.000 - 120.000
Informatica Analyst Consultant
Informatica Analyst Consultant

Sonsoft Inc • Moline (IL)

Presencial
USD 80.000 - 100.000
Salesforce (Functional or Technical Sales) Principal Consultant
Salesforce (Functional or Technical Sales) Principal Consultant

Sonsoft Inc • Indianapolis (IN)

Presencial
USD 100.000 - 140.000
Oracle/ PL/SQL Developer (PERL , Powershell ),
Oracle/ PL/SQL Developer (PERL , Powershell ),

Sonsoft Inc • Greenville (SC)

Presencial
USD 80.000 - 110.000
Java/J2ee Developer (In-Person Interview)
Java/J2ee Developer (In-Person Interview)

Sonsoft Inc • Newark (DE)

Presencial
USD 90.000 - 120.000
Senior .Net Developer (In-Person Interview)
Senior .Net Developer (In-Person Interview)

Sonsoft Inc • Torrance (CA)

Presencial
USD 80.000 - 120.000
DBA DB2 – Level III
DBA DB2 – Level III

Sonsoft Inc • Marysville (OH)

Presencial
USD 90.000 - 120.000
MS Dynamics CRM Architect
MS Dynamics CRM Architect

Sonsoft Inc • Cherry Hill Township (NJ)

Presencial
USD 90.000 - 120.000