Informatica Developer

Informatica Developer at codersbrain · Remote only · 4 - 6 years · ₹6L - ₹10L / yr · Bootstrapped · Remote only · Posted 8 Feb 2023

Informatica Developer

at codersbrain

Posted by Aishwarya Hire

4 - 6 yrs

₹6L - ₹10L / yr

Remote only

Skills

ETL

Informatica

Data Warehouse (DWH)

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.

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.

Users love Cutshort

Read about what our users have to say about finding their next opportunity on Cutshort.

Shubham Vishwakarma

Full Stack Developer - Averlon

I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.

Companies hiring on Cutshort

About codersbrain

Founded :

2015

Type :

Services

Size :

100-1000

Stage :

Bootstrapped

About

Coders Brain is a global leader in IT services, digital and business solutions that partners with its clients to simplify, strengthen and transform their businesses. We ensure the highest levels of certainty and satisfaction through a deep-set commitment to our clients, comprehensive industry expertise and a global network of innovation and delivery centers. We achieved our success because of how successfully we integrate with our clients.