SQL developer Resume

PROFESSIONAL SUMMARY:

Technical exposure:

Languages: SQL

Databases: Oracle, Teradata

Operating Systems: Windows 10, UNIX

Tools: Informatica power center, Toad, SQL developer

PROFESSIONAL EXPERIENCE:

Confidential

Environment: OS: Windows XP, Informatica Power Center, Oracle 12c, UNIX

Responsibilities:

Created mappings, reusable mapplets/transformations using transformations like - Source Qualifier, Joiner, Expression, Aggregator, Sorter, Router, Filter, Normalizer, Update Strategy, Union etc.
Usage of Debugger to find data issues etc.
Coding (IPC), writing unit and integration test cases.
Used Informatica Power Center for (ETL) extraction, transformation and loading data from admin source systems into target database.
Involved in extracting the data from the database &Flat file.
Worked on the Peer review.
Extracted data from various sources like Flat files, Oracle, DB2 using Informatica mappings, SQL scripts to load data into warehouse layers - Staging, Source Data warehouse, Business Data warehouse and then finally into EDW.
Worked on performance issues

Confidential

Environment: OS: Windows XP, Informatica Power Center, Oracle 12c, Teradata, UNIX

Responsibilities:

Designing mapping in Informatica Power Center.
Including development and Unit testing, our team is responsible for application production support.
Worked on data fix.
Used to share the daily status of the load.
Giving KT to support team.