SUMMARY

• 7.6 years of experience in Information Technology including Data warehouse/Data Mart development using ETL/Informatica Power Center
• Experience in integration of various Operational Data Source (ODS) with Relational Databases Oracle and worked on integrating data from flat files like fixed width and delimited.
• Extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Extensively worked on Informatica Power Center 9.1.0, 8x, 7x.
• Experience in Relational Databases like Oracle 11g/10g/9i/8i
• Experience with Programming languages like SQL, PL/SQL, Unix Shell Scripting.
• Knowledge in writing Stored Procedures, Functions, Packages.
• Knowledge in Creating and maintaining Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequence, Table Partitions, Synonyms and Database Links.
• Knowledge on UNIX Shell Scripting. Designed various shell scripts for processing and scheduling Informatica workflows in different conditions.
• Highly Motivated to take independent responsibility as well as ability to contribute and be a productive team member

TECHNICAL SKILLS

Data warehousing: Informatica 9.1.0/8.x/7.x (Power Center/Power Mart/Power Exchange) (Designer, Workflow Manager, Workflow Monitor

Programming: Unix Shell Scripting, SQL, PL/SQL

Databases: Oracle 10g/9i/8i, MS Access 7.0/2000, SQL, PL/SQL

Environment: MS Windows 2003/2000/XP/98, LINUX, UNIX (Sun Solaris, HP-UX, AIX)

Job Scheduling: Informatica Scheduler, Control M

PROFESSIONAL EXPERIENCE

Confidential, CA

Senior Informatica Developer

Responsibilities:

• Involve in requirement gathering session with business users for a new/change requirement.
• Analyze the requirement and prepare Technical Specification doc.
• Analyze the incoming data from different source systems.
• Work with Data Modeler to finalize data model.
• Involve in development activities for the new or change requirement based on Technical Specification doc using Informatica 9.1.0, Shell script and Oracle database.
• Preparation of Program Specifications and parameterization of sessions and creation of workflows and command tasks.
• Responsible for developing STMs(Source to Target Mappings) for the newly created mappings.
• Perform UNIT test for new/change developed code.
• Involve in code deployment from one environment to another.
• Responsible for Production Monitoring after new code deployment.

Environment: Informatica PowerCenter 9.1.0, Oracle 11i, SQL/PLSQL, TOAD, MS Office, UNIX Shell Scripting, MS Excel, Redwood.

Confidential

Senior Informatica Developer

Responsibilities:

• Interacted with various business people and gathered the business requirements and translated them into technical specifications.
• Prepared Technical Design Documents based on the Functional/Business requirements from the Business Users on the Mapping Documents.
• Designed data model using Visio for the use of Business Analysts.
• Created users and groups, configured profiles and privileges, Configured shared folders for re-usable objects.
• Extensively worked on Informatica Power Center - Designer, Workflow Manager and Workflow Monitor.
• Designed the ETL processes using Informatica Power Center 9 to extract, transform and load data from multiple input sources like Oracle, flat files and XML to target Oracle database.
• Created complex mappings using various transformations such as Rank, Joiner, Expression, Lookup (Connected/Unconnected), Aggregate, Filter, Update Strategy, Sequence Generator etc to implement the user requirements.
• Implemented Type II Slowly Changing Dimensions Methodology to keep track of historical data.
• Created Reusable Transformations and Mapplets in the designer using transformation developer and mapplet designer according to the business requirements.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Extensive work experience in SQL and PL/SQL by writing Stored Procedures, Functions, Packages and Triggers Tuned the Performance of the targets, sources, mappings and sessions by eliminating the bottlenecks.
• Created and scheduled workflows using Workflow Manager to load the data into the Target Database.
• Worked with Autosys Scheduler to run the Informatica session on a daily/weekly/monthly basis.
• Performed Unit Testing and Integration Testing of Mappings and Workflows.
• Migrating jobs across Development, QA, Production environments.

Environment: Informatica PowerCenter 8.6.1, Oracle 11i, 10g, SQL*Loader, SQL/PLSQL, Flat Files, TOAD, MS Office, UNIX Shell Scripting, MS Excel.

Confidential

Informatica Developer

Responsibilities:

• Retrieving data from various sources like Web Interface, Share Drive and FTP in a timely manner
• After Decrypting, copying the data in the INPUT share drive.
• Processing this Input file in the TS2 web interface.
• After processing for the first time the status mail is generated, which contains the log file for the product and stores which needs the maintenance
• Maintenance for the particular products and store is done in DATMAN tool with the help of RDC ( Data Client) & Hierarchy web interfaces.
• After the maintenance, the master data is again processed along with the staging records.
• This time status mails need to be generated with zero maintenance required.
• The different customer server cubes are refreshed the next day.
• The accuracy check is performed again on the server cubes.
• After the data is visible, we can check if any further maintenance is required.

Environment: Informatica 8x/7x, Oracle 9i, UNIX, Cron Jobs, Flat Files, Toad, MS Office.

Confidential

Informatica Developer

Responsibilities:

• Analyze the Mapping Documents sent, prepare relevant doubt sheets and get clarifications. Analyze the incoming data from different source systems.
• Develop the mapping logic and finally develop actual mappings using Informatica, Shell script and Oracle database.
• Preparation of Program Specifications and parameterization of sessions and creation of workflows and command tasks.
• Worked on enhancements, read the already developed code in UNIX and INFORMATICA and then made changes as per requirements.
• Developed and supported the Extraction, Transformation, and load process (ETL) for data migration using Informatica power centre.
• Responsible for developing Source to Target Mappings.
• Extensively used Informatica Client tools- Source Analyzer, Warehouse Designer, Mapping Designer.
• Developed Informatica mappings for data extraction and loading worked with Expression, Lookup, Filter and Sequence generator and Aggregator Transformations to load the data from source to target.
• Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation.
• Developed mappings, sessions for relation and flat source and targets.
• Imported data from various source (Oracle, Flat file, XML) and transformed and loaded into targets using Informatica.
• Created and scheduled Session, jobs based on demand, run on time
• Monitored Workflows and Sessions while providing PROD support.
• Identified the facts and dimensions and designed the relevant dimension and fact tables.

Environment: Informatica 8x/7x, Oracle 9i, UNIX, Cron Jobs, Flat Files, Toad, MS Office.

Confidential

Informatica Developer

Responsibilities:

• Developed and supported the Extraction, Transformation, and load process (ETL) for data migration using Informatica power center.
• Extensively used Informatica Client tools- Source Analyzer, Warehouse Designer, Mapping Designer.
• Developed Informatica mappings for data extraction and loading worked with Expression, Lookup, Filter and Sequence generator and Aggregator Transformations to load the data from source to target.
• Involved in Production support work for all the tasks and schedulers running in PROD environment.
• Performance tuning of the Database.
• Data Loading during SQA support through Informatica as per schedule.
• Involved in Data Validation of the final data loaded in SIT/UAT environment.
• Error logging, defect tracking and Defect fix in Quality Center.
• Quality center maintenance.
• Release processes follow up.

Environment: Informatica 7x, Oracle 9i, Flat Files, Toad, MS Office.