ETL Developer/Informatica Developer/Designer/Module Leader Resume

SUMMARY:

7+ years of experience in Information Technology. Over two and a half years of experience as a production support executive and remaining years of experience with Informatica/Oracle/UNIX.
Current Role: ETL Designer/Informatica Developer/Designer/Module Leader
Involved in migrating oracle database from 10g to 11g.
Expert in Performance Engineering.
ETL development experience using Oracle 10g and Informatica (Source Analyzer; Target Designer; Transformation Developer; Mapping Designer; Mappings; Transformations such as Source Qualifier, Aggregator, Sorter, Joiner, Rank, Router, Filter, Expression, Unconnected Lookups, Connected Lookups, Update Strategy; Workflow Manager; Workflows; Sessions; Reusable Sessions; Workflow Monitor, Parameter Files, Variables).
Functional experience includes Health Care and Trade Logistics.
Extensive hands on experience in ETL domain.
Experience in Designing, Development of ETL.
Experience in PL/SQL and UNIX Shell Scripting and Batch Scripting.
Created batch scripts to automate the daily load.
Performance tune databases, targets, sources, mappings and sessions.
Good Knowledge in database development (SQL, PL/SQL, packages, stored procedures, functions and triggers).
Participated in problem solving and troubleshooting for the applications implemented with Informatica.
Expert in Enterprise job scheduling. Extensive experience in team development and .
Excellent customer interfacing skills and excellent communication and interpersonal skills.

WORK EXPERIENCE:

Confidential

ETL Developer/Informatica Developer/Designer/Module Leader

Responsibilities:

Delivering opportunities to the customer regarding their next purchase of the prescription and to retain existing customer base.
Interacting with the client for Knowledge Sharing sessions to understand their business requirements.
In - depth understanding in Conceptual, Entity Relationship (ER), Relational, Logical, Multi Dimensional and Physical data models for various Online Transaction Processing (OLTP) systems, Online Analytical Processing (OLAP) systems, Operational Data Stores (ODS), Data Marts and Enterprise Data Warehouses (EDW).
Designed and developed Informatica Mappings using optimum transformers like Aggregator, Sorter, Expressions and Filters, Joiners, Union and Lookups and creating Workflows.
Designed and implemented standard and re-usable mapping to accomplish data migrations.
Sources were Oracle database and flat files from Data Warehouse and targets are loaded into flat files for further use and updates/insertions into existing tables in Database.
Calling Java and PL/SQL procedures in mapping. Writing PL/SQL stored procedures and functions.
Writing batch scripts using Kernel shell scripting to run the workflows; automating and scheduling the batches in Control-M.
Writing and using stored procedures and functions for Purging old data in Database using PL/SQL tables and ref cursors and writing shell scripts to execute the same and schedule the process as well e.g. Process to purge old data from the DW.
Created Stored Procedures, packages, triggers, cursors, tables, and views and other SQL joins and statements for applications and exception handling.
Testing the mapping and fixing the bugs using debuggers and session/workflow logs. Performance tuning of the existing mapping with optimal use of the transformations.
Worked with Memory cache for static and dynamic for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations
Working on defects or Change requests for the reports generated by batches.
Maintenance of all the documents on the server through Tortoise SVN at respective locations, based on their categories and releases, including scripts, logs, design documents, flowcharts, MOMs, guideline documents etc.

Technologies: Informatica PowerCenter 8.1, 9.0, 9.1, PL/SQL, Unix Shell Scripting, Oracle 10g/11g, MS SQL server, PMCMD to schedule workflows in Informatica through Unix, Control, WinSCP, Putty, SVN subversion, Mercury Quality Center, SharePoint

Confidential

Production Support Executive

Responsibilities:

To acknowledge the user ticket within the defined SLA.
Provide support to trouble-shooting client issues with high level data analysis and project review.
Maintain interaction within entire organization and third party related entities.
Assist in support hours of operation and off hour production emergencies.
Automated many activities that need to be performed daily.
Identify root causes of technical issues in production and out of box failures.
Interact with project teams for new products development giving insights from technical issues of previous products.
Study and recommend corrective solutions for enhancing manufacturing efficiency.
Worked for more than 6 months at Santa Clara California US.
Numerous Client appreciations for quality and ability to perform in challenging roles.

Technologies: PL/SQL, Unix Shell Scripting, Oracle 10g, WinSCP, Putty, VSS code, OVSD, EPMS

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship