Offer summary

Qualifications:

Proficiency in Informatica and data transformation techniques., Experience with relational databases, particularly DB2., Familiarity with various data models including star and snowflake schemas., Knowledge of SDLC phases and scripting in PERL..

Key responsibilities:

Support and maintain the Cognos web portal for OLAP cube management.

Develop and implement data mappings and transformations using various sources.

Involve in all phases of the SDLC, including requirements gathering and testing.

Ensure data integrity and migrate repository objects to production environments.

Job description

Support and maintain production Cognos web portal to manage the OLAP cube and folders.
Used various transformations like expression, union, source qualifier, aggregator, router, store procedure, lookup transformations.
Work on transformations such as source qualifier, joiner, lookup, rank, expression, aggregator and sequence generator etc.
Work with relational databases like DB2.
Develop mappings with XML as target and formatting the target data according to the requirement.
Work with logical, physical, conceptual, star, snow flake schema data models.
Extract data from flat files, DB2 and to load the data into the SalesForce database.
Work with various data sources--relational, flat file (fix width, delimitate) and XML.
Involve in all phases of SDLC from requirements gathering, architecture design, development, testing, and data migration.
Involve in all phases of SDLC - requirement gathering, design, development, testing and implementation and post-production support.
Involve in writing PERL scripts for file transfers, file renaming and few other database scripts to be execute from UNIX.
Create functional and technical mapping specifications and documentation for QA team.
Support implementation and execution of MAPREDUCE programs in a cluster environment.
Maintain data integrity during extraction, manipulation, processing, analysis and storage.
Migrate repository objects, services and scripts from development environment to production environment.

Required profile