Analyze, design, develop, deploy, tune, and provide 24/7 production support for processes and applications supporting a custom CRM analytical repository.
Develop and optimize Oracle PL/SQL and SQL to analyze large datasets and load data from different sources.
Support CRM analytics and campaign operations as part of the ECRM team.
Work with Oracle databases on Unix AIX servers and use ETL tools to load large amounts of data.
Summarised from the posting by AI and can be wrong. The full description is the source.
Requirements
Experience
Experience working with Unix servers and shell scripting
Experience in the analysis, design, development, deployment, and tuning of large-scale databases
5+ years of experience with a major DBMS
5+ years of experience with coding, testing, and design
5+ years of experience with software development methodologies
Auto industry experience (preferred)
Data modeling experience (preferred)
Data warehousing experience (preferred)
Education
Bachelor's degree in Computer Science or a related discipline, or equivalent experience
Skills
Strong understanding of Oracle PL/SQL, including stored procedures, triggers, packages, and dynamic SQL
Expert knowledge of SQL and ability to write and understand complex SQL
Strong ETL design and development abilities
Ability to design complete solutions and conduct data analysis
Informatica knowledge (preferred)
CRM knowledge (preferred)
Knowledge of marketing concepts (preferred)
Other requirements
Must be a U.S. citizen, Green Card holder, GC-EAD, H4-EAD, or L2-EAD holder; OPT-EAD, H1B, and TN candidates are not eligible
Your match
Sign in and add your resume to see which of this job's requirements it shows.
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 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:
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
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
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
Bachelor's degree in Computer Science or related discipline or have equivalent experience
Business Experience
5 plus years experience with major DBMS
5 plus years experience with coding, testing, and design
5 plus years experience with software development methodologies
Qualifications
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 specially if depending on others to do their tasks
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.