OBIEE/Informatica ETL Developer

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

• Client needs analysis, installation, migration, integration, and the deployment of Oracle OBIEE solutions.
• Hands-on OBIEE experience as data modeler, data analyst, report developer and to understand and relate to user issues and make informed decisions.
• Strong ability to think strategically while operating with tactical responsibilities on OBIEE programs and initiatives.
• Experience in integrating Oracle OBIEE with Siebel Marketing.
• Configuring and Create Informatica ETL Workflows and DAC tasks.
• Create Debug and troubleshoot, tune existing Informatica ETL Workflows.
• Create debug and troubleshoot complex sqls for staging ETLs.
• Having Shell Scripting knowledge will be a big help.
• Understanding of Marketing and MDM a big plus.
• 4 years expertise in analysis and development which includes client needs analysis, installation, migration, integration and deployment of Oracle OBIEE and Informatica Power center
• Familiar with DBA concepts – Materialized Views, Indexing, Partitions, tuning at the database level.
• Experience with various ETL methods – such as sqlldr and shell scripts, Informatica, PL/SQL using database links.
• Experience with the CRM application.
• Strong experience designing custom BI applications from the data warehouse to the dashboard.
• Strong experience supporting production BI systems in Windows and Unix environments.
• Strong experience with dimensional modeling.
• Experience with both OBI 10 and OBI 11G.

Qualifications

• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• At least 4 years of experience with Information Technology.

Additional Information ** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time. Note:-

• This is a Full-Time Permanent job opportunity for you.
• Only US Citizen, Green Card Holder, TN Visa, GC-EAD, H4-EAD & L2-EAD can apply.
• No OPT-EAD & H1B Consultants please.
• Please mention your Visa Status in your email or resume.