Informatica developer with 3.5 years of experience

Jogomaya Panigrahy Email: - *********.********@*****.*** Contact No: - +918*********

Summary

Having 3+ years of experience in Informatica power centre, Oracle SQL with PLSQL. Involved in client requirement analysis, development and mapping.

Technology expertise includes

Strong understanding of data warehouse concepts.

Good knowledge in all types of SCD concepts.

Experience in implementing SCD TYPE-1.

Developing Business Intelligence solutions in Enterprise Data Warehouse (EDW) Systems Using Informatica Power Centre 9.x ETL tool.

Good knowledge in Star schema, Snowflake schema.

Experience in documenting Low level design and Unit testing documents

Experience in Repository Configuration/using Transformations, creating Informatica Mappings, Sessions, Workflows, Processing tasks using Informatica Designer/Workflow Manager to move data from multiple source systems into targets.

Experience in integration and transforming of various data sources from Databases like Oracle, and formats like flat-files, CSV files.

Experience in using Debugger for data analysis from source to target.

Good knowledge Oracle SQL queries and PLSQL data base objects.

Experience in UNIX commands and basic shell scripting.

Knowledge on RDBMS concepts.

Working on Normaliser transformations.

Experience in performance tuning in the mapping designer level and in session level

Developing effective working relationships with client team to understand support requirements.

Having excellent interpersonal and communication skills, technically competent and result oriented with problem solving skills and ability to work independently.

Technical Skills

Databases

Oracle 10g

ETL Tools

Informatica 8.6, 9.X

Languages

Oracle, SQL

Operating Systems

Windows XP/2000/7, Unix

Concepts and Technologies

Data Warehouse, Data Analysis, RDMS Concepts., Agile Methodology

DBMS

TOAD, SQL Developer

Project Details :

1.Project Name : American Family (AMFAM) Insurance Implementation

Main Technologies : Informatica power centre 9.6, SQL Developer

Role : Informatica Developer

Summary : Project involved collecting the information about insured vehicle and other non-living things. When is the incident happens, whether someone is injured or not, what is the policy number, how to claim for insured money, how much is the insured money.

Responsibilities :

Understood the business requirement documentation and high level design documentation.

Ensure adherence to quality process and procedures, up to Product satisfies the Customer Requirements.

Analysing and understood project functional requirements from business and technical perspective .

Applied business intelligence logics in data analysis, ETL and reporting according to the client requirements.

Created own low level design.

Worked on Informatica - Source Analyser, Mapping Designer & and Transformation Developer.

Imported data from flat file sources and loaded into Data Warehouse Targets using Informatica.

Fixed invalid Mappings, Unit testing of Informatica Sessions, Batches and Target Data.

Used Transformations like Router, Filter, Aggregator, Source Qualifier, Joiner, Expression and Sequence generator, Lookup.

Involved in incremental loading using variables.

Used SCD TYPE-1,SCD TYPE-2 for project.

Involved in documentation to describe program development, logic, coding, testing, changes and corrections.

Optimized the mappings by changing the logic to reduce run time.

2. Project Name : IMS Complaint Booking System

Main Technologies: Informatica Power Centre 9.6, TOAD, Unix, XML Targets, XML Sources

Role : Informatica Developer

Summary : This is a user-friendly complaint booking system for IT specific request including their details on which they can put their feedback and process their respective tickets. The system is also capable of resource, time & issue managements. As an individual engineer, they can find out number of tickets allocated to them and their details and also reassign tickets to other engineer if requires.

Responsibilities :

Analysed given requirement specification.

Involved in transformations of various mappings for development, Worked with .csv files, xml source qualifiers and xml targets.

Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, Filter, Update strategy, Lookup, sorter, Normalizer, Sequence generator.

Defined and worked with mapping parameters and variables.

Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.

Performed the performance evaluation of the ETL for full load cycle.

Checked sessions and error logs to troubleshoot problems and also used debugger for complex.

Created test cases for unit testing and functional testing.

Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.

Professional Experience:

Working as a Software engineer at Ernst Young(EY) as a contract basis employee from Primus, Bangalore from March 2017 to July 2017.

Working as an ETL Developer/faculty at i-Nurture Education Solutions Private Limited, Bangalore from 25th May 2015 to 25th Oct 2016.

Having an experience as an IT Trainer/ IT Lecture at Gurukul International College, Odisha from19th April 2014 to 06th Jan 2015.

Having an experience as a BCA - IT faculty at Supreme Institute of Science & Technology, Odisha from 22nd Oct 2013 to 11th April 2014.

Having an experience as an Assistant Professor at Rahul Institute of Engineering And Technology, Odisha from 19th Sep 2010 to 1st Oct 2013.

Education Detail:

MCA (2010) – in Computer Application from Roland Institute of Technology, Odisha with 79.63%.

BCA (2007) – in Computer Application from

Roland Institute of Computer & Management Studies, Odisha with 79.25%.

CHSE(2004)– +2COMMERCE (2004) from Khallikote Junior College, Odisha with 55.5%.

HSC – (2002) from Government Secondary and Training School, Odisha with 60.5%.

Academic Achievements:

Achieved best faculty/trainer certificate in i-Nurture Education Solutions Private Limited, Bangalore.

Participated in ISTE (Indian Society for Technical Education) workshop on

"Data Base Management System" conducted by IIT Bombay.

Attended Workshop: OPPERTUNITES IN IMS INDUSTRY (Organized by NIIT).

Personnel Details:

Date of Birth: 04th May 1987

Language known: English, Hindi & Odia

Date:

Place: Bengaluru Jogomaya Panigrahy

Contact this candidate