Logo for CodersBrain

Informatica Developer

CodersBrain

Roles & Responsibilities

  • Experience with OLAP cubes
  • Proficient in various transformations
  • Knowledge of relational databases like DB2
  • Familiarity with SDLC phases

Requirements:

  • Support and maintain production Cognos web portal
  • Develop mappings with XML as target and format data
  • Extract data from flat files and DB2 to load into SalesForce
  • Write PERL scripts for file transfers and database scripts

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.
Ready to apply?
APPLY
ยท

Related jobs

India

Other jobs at CodersBrain

We help you get seen. Not ignored.

We help you get seen faster โ€” by the right people.

๐Ÿš€

Auto-Apply

We apply for you โ€” automatically and instantly.

Save time, skip forms, and stay on top of every opportunity. Because you can't get seen if you're not in the race.

โœจ

AI Match Feedback

Know your real match before you apply.

Get a detailed AI assessment of your profile against each job posting. Because getting seen starts with passing the filters.

Upgrade to Premium. Apply smarter and get noticed.

Upgrade to Premium

Join thousands of professionals who got noticed and hired faster.