About this job
Position: Informatica Developer
Location: Noida
Shift Timings: UK shift--01:00 PM to 10:00 PM
Job Description:
*******************B1 Visa Mandatory**********************
**************Need to travel onsite*************************
1: In ETL :
1: Candidate must have worked on Informatica 8.6 and onward.
2: Knowledge of converting the PLSQL task to Informatica task.
3: Must have gone through all 3 parts of power center (Designer, Workflow manager and session manager).
4: Gone through all the transformation(Lookup, Update Strategy, Normalizer, Stored procedure, Joiner, etc)
5: Must have knowledge about the performance tuning through informatica.
6: Knowledge of Schedulers.
2: PLSQL and SQL:
1: Must have created the packages, procedure and functions, cursor, ref cursor, variable declaration, etc.
2: Able to write the complex queries using SQL.
3: Must have live experience with project in PLSQL.
4: Must have experience in writing various processes like Exception handling ,etc.
3: Dimensional Modeling :
1: Must be aware about the Dimensional modeling concept(includes the dimension, fact, slowly changing dimension ,star schema ,aggregates, etc)
2: Experience in Data warehouse project should be added advantage.
3: Must have clear understandability about various source system integration, change capture process of data and cleansing of data.
Salary:
Not Disclosed by Recruiter
Industry:
IT Software, Software Services
Functional Area:
Application Programming, Maintenance
Role Category:
Programming & Design
Role:
Software Developer
Keyskills:
Informatica ETL PL / SQL
Job requirement
Education:
(UG - Any Graduate - Any Specialization, Graduation Not Required) AND (PG - Any PG Course - Any Specialization, Post Graduation Not Required) AND ( Doctorate - Any Doctorate - Any Specialization, Doctorate Not Required)
Experience years: 4 to 7 yrs
How to apply
Address:
Noida NOIDA,Uttar Pradesh,India 201301
Telephone:
91-120-4343500
1