PL/SQL Developer (F2F Interview)
SonSoft Inc
PL/SQL Developer (F2F Interview)
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 modeling Experience a plus.
- 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
** 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.
- ...Senior.Net Developer (In-Person Interview) 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...SuggestedContract workWork experience placementH1bWork at office
$125k - $145k
...A leading software and financial management service provider based in California is looking for a Senior Oracle PL/SQL Developer. This role requires over 7 years of experience with Oracle SQL and PL/SQL, focusing on database architecture and performance optimization....Suggested$125k - $145k
...systems, services and solutions across a wide variety of government agencies. Position Description IDS is seeking Senior Oracle PL/SQL Developers with expert-level command of the Oracle RDBMS, SQL, and PL/SQL. You will be responsible for the architecture, development, and...SuggestedContract workWork experience placementWork at officeLocal areaImmediate startRemote workRelocationVisa sponsorshipMonday to FridayFlexible hoursWeekend work- ...Informatica / PL/SQL Developer 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...SuggestedPermanent employmentFull timeH1b
$125k - $145k
...exciting than one where we are not. Today SpaceX is actively developing the technologies to make this possible, with the ultimate goal... ...or applicants requiring reasonable accommodation to the application/interview process should reach out to ****@*****.***....SuggestedPermanent employmentTemporary workImmediate startWeekend work- ...IVR Tech Lead Location: Torrance, CA Rate: DOE $/Yr. Position Type: Full Time Interview Process: Phone Followed by F2F US Citizen, Green Card and GC EAD Expert in IVR Development, specially GVP (Genesys Voice Platform) Version 8. Expert in Integration with backend...Full time
$200k - $285k
...exciting than one where we are not. Today SpaceX is actively developing the technologies to make this possible, with the ultimate goal... ...or applicants requiring reasonable accommodation to the application/interview process should reach out to ****@*****.***....Permanent employmentTemporary work- ...focused on Actuation & Control Systems, you will be responsible for developing embedded software that controls a variety of actuated systems... ...Received Stage 2: Resume Review Stage 3: Intro Phone Interview Stage 4: Technical Phone Interview(s) Stage 5: Onsite...Permanent employmentFull time
$130k - $150k
...exciting than one where we are not. Today SpaceX is actively developing the technologies to make this possible, with the ultimate goal... ...or applicants requiring reasonable accommodation to the application/interview process should reach out to ****@*****.***....Permanent employmentTemporary workWorldwideFlexible hoursWeekend work- ...candidates the requisite skills and experience to outperform at interviews and clients. Here at SynergisticIT We just don't focus on... ...looking for entry-level software programmers, Java Full stack developers, Python/Java developers, Data analysts/ Data Scientists, Data...Full timeH1bRemote work
- ...CMMC/NIST SP 800-171 requirements while remaining scalable and developer friendly. Responsibilities Secure and harden cloud... ...Application Received Stage 2: Resume Review Stage 3: Intro Phone Interview Stage 4: Technical Phone Interview(s) Stage 5: Onsite...Permanent employmentFull time
$132.1k - $178.8k
...disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit for more information. If the country/region you're applying in isn't listed, please contact your...Local areaFlexible hours$132.1k - $178.8k
...contribute to the shared data platform when needed - improving developer tooling, maintaining infrastructure, and supporting the... ...the application and hiring process, including support for the interview or onboarding process, please visit for more information. If...Local areaFlexible hours$125k - $145k
...exciting than one where we are not. Today SpaceX is actively developing the technologies to make this possible, with the ultimate goal... ...or applicants requiring reasonable accommodation to the application/interview process should reach out to ****@*****.***....Permanent employmentTemporary workWorldwideWeekend work$125k - $145k
...exciting than one where we are not. Today SpaceX is actively developing the technologies to make this possible, with the ultimate goal... ...applicants requiring reasonable accommodation to the application/interview process should reach out to ****@*****.*** ....Permanent employmentTemporary workWorldwideWeekend work$145k - $195k
...exciting than one where we are not. Today SpaceX is actively developing the technologies to make this possible, with the ultimate goal... ...applicants requiring reasonable accommodation to the application/interview process should reach out to ****@*****.*** ....Permanent employmentTemporary workWeekend work$125k - $145k
...exciting than one where we are not. Today SpaceX is actively developing the technologies to make this possible, with the ultimate goal... ...or applicants requiring reasonable accommodation to the application/interview process should reach out to ****@*****.***....Permanent employmentTemporary workLive inRemote workWorldwideWeekend work$75.8k - $144.2k
...minimum of 2 years of prior relevant experience. Experience in developing, testing, and integrating real-time software applications... ..., candidates may be asked to attend select steps of the interview process in-person at one of our office locations, regardless of...Temporary workWork experience placementWork at officeRemote workRelocation packageFlexible hours- ...performance and reliability Work with ground software teams to develop and test satellite to ground data pipelines Minimum... ...want to go. Our Hiring Process Stage 4: Technical Phone Interview(s) Stage 5: Onsite Interview Stage 6: Offer! Stage 1:...Permanent employmentFull time
$95.5k - $181.7k
...VxWorks, or other Real Time Operating Systems. Experience in developing, testing, and integrating real-time software applications... ...process, candidates may be asked to attend select steps of the interview process in-person at one of our office locations, regardless of...Temporary workWork experience placementWork at officeRemote workRelocation packageFlexible hours$220.5k - $300k
...exciting than one where we are not. Today SpaceX is actively developing the technologies to make this possible, with the ultimate goal... ...applicants requiring reasonable accommodation to the application/interview process should reach out ****@*****.*** ....Permanent employmentTemporary workImmediate startFlexible hoursWeekend work$132.1k - $178.8k
...We seek an AI Platform Builder-a Data Engineer focused on developing Platforms and Agentic AI solution-who embraces prompt-driven development... ...the application and hiring process, including support for the interview or onboarding process, please visit for more information. If...Local areaFlexible hours- ...As a API Solution Architect the resource should be designing, developing, and implementing API solutions across various industries. Should... ...Verification Info : Exclusive to Apex :No Face to face interview required :No Candidate must be local :No Candidate must...Local area
$125k - $145k
...exciting than one where we are not. Today SpaceX is actively developing the technologies to make this possible, with the ultimate goal... ...or applicants requiring reasonable accommodation to the application/interview process should reach out to ****@*****.***....Permanent employmentTemporary workImmediate startRemote workWeekend work$122.43k - $194.39k
...manufacturing ecosystem. In this role, you will independently design, develop, and deliver production-ready software solutions that support... ...levels based on experience, technical capability, and interview performance: E04 – Engineer II: $122,430 – $168,340 Exceptional...Temporary work$150k - $200k
...standard operating procedures (SOPs). Workflow Optimization: Develop and implement best practices for large assembly management,... ...Application Received Stage 2: Resume Review Stage 3: Intro Phone Interview Stage 4: Technical Phone Interview(s) Stage 5: Onsite...Permanent employmentFull time$122.43k - $194.39k
...on schedule. The Role Full-stack Development: Design, develop, and maintain scalable applications using modern web technologies... ...candidates at levels E04 - E05 as evaluated through our interview process. E04/ Engineer II - $122,430 - $168,340 E05 /...Temporary work$125k - $150k
...exciting than one where we are not. Today SpaceX is actively developing the technologies to make this possible, with the ultimate goal... ...or applicants requiring reasonable accommodation to the application/interview process should reach out to ****@*****.***....Permanent employmentTemporary workImmediate startWeekend work$125k - $145k
...exciting than one where we are not. Today SpaceX is actively developing the technologies to make this possible, with the ultimate goal... ...applicants requiring reasonable accommodation to the application/interview process should reach out to ****@*****.*** ....Permanent employmentTemporary work$125k - $145k
...exciting than one where we are not. Today SpaceX is actively developing the technologies to make this possible, with the ultimate goal... ...or applicants requiring reasonable accommodation to the application/interview process should reach out to ****@*****.***....Permanent employmentTemporary workRemote workWorldwideWeekend work
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to PL/SQL Developer (F2F Interview). Be the first to apply!
- senior mulesoft developer Torrance, CA
- interface developer Torrance, CA
- interactive developer Torrance, CA
- pega developer Torrance, CA
- sas programmer Torrance, CA
- senior rails developer Torrance, CA
- remote programmer Torrance, CA
- remote ruby on rails developer Torrance, CA
- senior mainframe developer Torrance, CA
- student programmer Torrance, CA

