Software Development in Informatica Resume

SUMMARY

A competent professional with a total experience of 10+ Years in Software Development in Informatica, Oracle and Unix.
Having Knowledge of Data warehousing concept, hands on Informatica, Oracle, UNIX, NETEZZA and Informatica Cloud (IIcs).
Created Mapping, Mapping configuration task, synchronization task, saved query, customized query in IICS.
Created mappings and workflows using Informatica
Tested and troubleshot mappings and workflows.
Created and managed users
Created and managed database connections to various data store
Created and managed users and Logs
Translated business requirements into Informatica mappings and IICS jobs.
Involved in code migration from Dev to different environment.
Good Exposure to Unit Testing using SQL .
Involved in Scheduling Informatica workflow through Autosys and Informatica Scheduler
Involved in maintenance and enhancement of teh codes.
Basic knowledge on Hadoop(Spark,Hive,MapReduce,HDFS, HBase ).

TECHNICAL SKILLS

Operating Systems: WINDOWS 7, LINUX

Languages: SQL, PL/SQL

Databases: Oracle, Neoview, Netezza

GUI: SQL PLUS

Tools: InformaticaCloud,Informatica Powercenter 8.6.1/9, SQL Developer, Toad,Aginity Workbench for Netezza.

PROFESSIONAL EXPERIENCE:

Software Development in Informatica

Confidential

RESPONSIBILITY: -

Tool used: - Informatica powercenter 10.2, Sql developer 17.0,unix

Oracle

Confidential

RESPONSIBILITY: -

Involved in requirement analysis
Responsible to create Synchronization task, mapping configuration task, mapping and monitoring My jobs.
Involve in creating taskflows and published them for scheduling.
Worked on parameterization of each component mapping. Worked on for IN-OUT parameter
Monitoring teh Task flow and Checked teh Logs file and verify teh process.
Verify teh record by using Input source file and target files
Involved in code migration to different environment and in shakedown testing.
Prepared Unit test case along technical coding.
Involved in code change with unit testing.
Involved in creating LLD.
Guide teh team to start with IICS code.
Created Task flow.
Work on in-out parameters.
Involved in creating informatica PowerCenter mapping, workflow.

Confidential

RESPONSIBILITY: -

Confidential

Responsibilities:

Involved in requirement analysis
Responsible to create mapping, Designing, and Workflow monitoring.
Monitoring teh Workflow and Checked teh Logs file and verify teh process.
Verify teh record by using Input source file and target files
Prepared Unit test case along technical coding.
Involved in code change with unit testing.
Prepared test cases for those script, Validated teh Informatica Mapping and Workflow.
Involved in Monitoring, maintenance and enhancement of teh codes.

ETL Informatica

Confidential

RESPONSIBILITY: -

Database

Confidential

RESPONSIBILITY: -

ETL Informatica

Confidential

RESPONSIBILITY: -

Involved in requirement analysis
Responsible to create mapping, Designing, and Workflow monitoring.
Executing teh mapping by using Unix Script.
Monitoring teh Workflow and Checked teh Logs file and verify teh process.
Verify teh record by using Input source file and target files
Prepared Unit test case along technical coding
Migrated data from SQL server to Staging area and from staging area to Neoview database.
Wrote Reference script for migrating data from staging area to Neoview.
Prepared test cases for those script, Validated teh Mapping and Workflow.
Optimized and modified teh triggers, complex store functions, procedures, user base data type etc.