No of years experience
8 +
Detailed job description - Skill Set:
- 6+ yrs of Experience working with Informatica PowerCenter (Repository Manager, Mapping Designer, Workflow Manager, Mapplet Designer),
Experience in Developing Informatica ETLs with transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Update Strategy and Sequence Generator transformations and Experience using Informatica PowerCenter with databases like Oracle, SQL Server.
- Experience working in Data Warehouse with Dimensional Data model: Star and Snowflake Schemas, slowly changing dimensions , Type1/2 dimension.
- Extensive experience in developing Informatica Mappings / Mapplets to Load data from Multiple Sources to Data Warehouse. Experience in creating Workflow with Worklets Tasks and Scheduling using Workflow Manager and other Scheduling tools.
- Experience in integrating data from flat files into data warehouse using Informatica
- Experience in estimations processes to build complex facts dimensions.
- Strong debugging and problem-solving skills.
- Should have excellent verbal and communication skills, has clear understanding of business procedures and ability to work as an individual or as a part of a team.
Mandatory Skills(ONLY 2 or 3)
Informatica PowerCenter and SQL server
Good communication and analytical skills
Work Location
Any offshore location
Joining time ( Notice period)
20 days
BGCHECK before or After onboarding
After