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 ( 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.
#J-18808-Ljbffr