PL​/SQL Developer; F2F

Position: PL/SQL Developer (F2F Interview)
Company Description Son Soft  Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Son Soft 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/SQLA 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/SQLAbility 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 abilitiesPL-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 SQLAbility 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

Qualifications5 plus years experience with major DBMS5 plus years experience with coding, testing, and design5 plus years experience with software development methodologies

Additional Information Connect with me at   (For Direct 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.

Summary Type:
Contract Function:
Information Technology Experience level:
Associate Industry: Information Technology And Services