SUMMARY:

• Overall 8+ years of IT experience in full life cycle of Software Development (SDLC) including Analysis, Design, Development, Implementation, Testing.
• Having 7+ years of experiences in Data Warehousing (ETL) Requirements Gathering, Analysis, Design, Development, Implementation, Integration, Testing, Profiling, Cleansing and Validation of data using the Technology, Informatica PowerCenter/Data Quality (IDQ) .
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
• Thorough knowledge with dimensional modeling using star schema and snowflake models.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center
• Experience in using Informatica PowerCenter tools Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Expertise in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experienced in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Experience in UNIX shell scripting to create, schedule and control jobs along with exception handling routines. Used pmcmd and pmrep commands.
• Database experience using Oracle, MS SQL Server and DB2
• Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine-tuned transformations to make them more efficient in terms of session performance.
• Ability to meet deadlines and handle multiple tasks, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Comprehensive technical, oral, written and communicational skills.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX.

Tools: MS XP, MS 2000, MS Word, MS Excel, MS Access, Outlook, PowerPoint, SQL loader.JIra,Winscp,Putty, Toad for Oracle 12.8,XML SPY,Notepad++.

Databases: SQL Server 2008/2005/2000 , Oracle 11g/10g/9i,TeradataV12/13.

Data Warehousing ETL Tools: Informatica PowerCenter 9.6/9.5/9.1/9.0/8.6/8.1 (Workflow Manger, workflow Monitor, Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica Test data manager(TDM tool).

Languages: HTML, XML, SQL, PL/SQL, Unix Shell Scripting.

Scheduling tools: Autosys, Skybot, Control: M

Other Technologies: Unit Testing, Integration testing, Production support.

WORK EXPERIENCE:

Confidential, VA

Informatica Developer

Responsibilities:

• Involved in Designing Informatica mappings and creating the mappings from the scratch as per the requirement.
• Loaded data fromand to XML files, Heterogeneous Database tables and Excel spreadsheetinto targetOracle database and applied Business Logic on Transformation Mapping for inserting and updating records when loaded.
• Designed and developed mappings with optimal performance using Aggregator, Joiner, Rank, Sequence Generator, SQL, Uncached & various kinds of Cached Lookup, Connected-Unconnected-Source Target pre and post load Stored Procedure Transformations, Update Strategy, Union, XML Transformations.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Worked with Session Logs, and Workflow Logs for Error handling and troubleshooting in DEV environment.
• Developed Reusable Transformations and Reusable Mapplets.
• Involved in determining the bottlenecks and fixing the bottlenecks for optimum performance.
• Worked with Index Cache and Data Cache in cache using transformation like Rank, Lookup, Joiner, and Aggregator Transformations.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV environment.
• Written complex SQL Query as per business requirement to fetch the data from relational tables.
• Worked on XML source/target and used XML Source Qualifier, XML Parser and XML Generator transformation.
• Scheduled batch and sessions within Informatica using Informatica scheduler.
• Documented technical specification, business requirements, functional specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables and defined ETL standards. Documented test cases and test plans data for the mappings developed.
• Monitored the jobs daily and involved in production support including immediate fixes for the production job failures.

Environment: Informatica PowerCenter 9.X,Informatica Testdata Manager (TDM tool),Toad, SQL Server, PL/SQL, XML files,XML spy, JIRA, PUTTY, Winscp,.

Confidential, Specialty Insurance, NJ.

Informatica ETL Developer

Responsibilities:

• Developing mappings using different sources like flat files, csv files, SQL server and Oracle
• Used different transformations Expression, lookups, update strategy, Filter, Router, Sequence generator, etc.
• Developing the mappings as per Informatica standards of following naming standards for mappings, transformations.
• Used re-usable sessions, command tasks, email tasks
• Implemented different logics using lookups, expression and other transformations.
• Testing performed on target tables to ensure the data is correct by writing different quires.
• Expertise in writing quires of SQL statements, joins, functions.
• Prepared different documents which includes Data flow diagram, mapping doc, testing scenarios.
• Involved in migrating code from Dev to Uat.
• Active team member and always proactive to learn new things.

Environment: Informatica 9.X, windows 2007, Microsoft office, Flat files, Sql server, Oracle 11g, Unix, Agile Methodologie.

Confidential, NY

Informatica Developer

Responsibilities:

• Developed mappings to load the source files .txt, .csv to staging area.
• Cleansing source data using different transformations when loading source files
• Used different transformations like expressions, filter, lookups, routers, etc to validate the data
• Developed mappings to load data from staging to DataMart
• Written different types of quires when testing the data.
• Used Email task, command task, decision task
• Actively participated in through testing of the mappings and moving the code to UAT.
• Successfully completed all deliverables in time.

Environment: Informatica PowerCenter 9.X,Teradata, SQL SERVER, PL/SQL, Oracle 10g, Flat files, UNIX.

Confidential - Indianapolis, IN

Informatica Trainee/Jr Developer

Responsibilities:

• Developing mappings using different sources like flat files, csv files, SQL server and Oracle
• Used different transformations Expression, lookups, update strategy, Filter, Router, Sequence generator, etc.
• Developing the mappings as per Informatica standards of following naming standards for mappings, transformations.
• Used re-usable sessions, command tasks, email tasks
• Implemented different logics using lookups, expression and other transformations.
• Testing performed on target tables to ensure the data is correct by writing different quires.
• Expertise in writing quires of SQL statements, joins, functions.
• Prepared different documents which includes Data flow diagram, mapping doc, testing scenarios.
• Involved in migrating code from Dev to Uat.
• Active team member and always proactive to learn new things.

Environment: Informatica 7.1, windows 2007, Flat files, Sql server, Oracle, Skybot, Waterfall model.

Confidential

Database Trainee/developer

Responsibilities:

• Creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Writing queries and stored procedures in PL/SQL to fetch data from the OLTP system and executed at regular intervals of time.
• Developed PL/SQL scripts to validate and load data into interface tables. The backend was in Oracle and database operations were handled using stored procedures.
• Written quires for analyzing the data for managers to run the business.
• Moved data from one database to other database, Used SQL*Loader for data migration.

Environment: Oracle 8i, PL/SQL, SQL Server 2008, windows.