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 Informatica, Oracle database, PL-SQL, Data warehouses, Unix servers, and shell scripting.
Ability to design solutions and conduct data analysis is required.
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, and 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.
Musts
Business Experience:
Data transformation with Mandatory 7+ years of Experience:
- Outstanding Informatica design and development abilities.
- Experience in ETL performance tuning/optimization.
- Experience working with complex Informatica transformations.
- Strong experience identifying, researching, and resolving ETL issues and producing root cause analysis documentation.
- Experience writing ETL specifications.
- Experience with Extraction, Transformation, and Loading (ETL tools) to facilitate loading large amounts of data.
- Experience with versioned repositories and configuration management.
- Identifies areas of improvement.
Oracle Database with Mandatory 7+ years of Experience:
- 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.
- Understanding of Oracle dynamic SQL and ability to write complex procedures using dynamic SQL.
- Familiarity with 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.
- Ability to write efficient PL-SQL procedures.
- Design complete solutions.
Database / Other with Mandatory 5+ Years of Experience:
- Experience in the analysis, design, development & deployment of large scale databases.
- Experience in the design and development of data warehousing is a plus.
- Ability to write and understand complex SQL required.
- Knowledge of Oracle PL/SQL best practices and development methodologies or standards.
- Data warehousing experience a plus.
Unix OS with Mandatory 5+ years of Experience:
- Experience working with Unix servers.
- Experience with Shell scripting.
Qualifications and Experience
- Bachelor's degree in computer science or related discipline or have equivalent experience.
- Strong ETL design and development abilities, PL-SQL, and Stored Procedures to upload data from different sources.
- Knowledge of the auto industry and CRM.
Qualifications
Personal Initiative:
- Motivated self-starter.
- Ability to work in a fast-paced environment.
- Ability to work in a team environment where the 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.
Communication:
- Proven written and oral abilities.
- Positive and friendly personality.
Additional Information
Note:
This is a Full-Time & Permanent job opportunity for you.
Only US Citizens , Green Card Holders , 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 .