SUMMARY

• 7 years of experience in Software Development Life cycle, gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse, Data Marts.
• Extensive experience of data warehousing using informatica PowerCenter 9.5/9.1/8.6/8.5/8.1/7.1 Client.
• Very strong knowledge in relational databases (RDBMS), data modeling and in building Data Warehouse, Data Marts using Star Schema and Snowflake Schema, physical data modeling using Erwin 7.2.
• Application Support, Performance Tuning, Optimization, Data warehousing, User & Security Administration, Data Administration and setting up teh Test, Supporting and Development environments.
• Extensive experience in designing developing Informatica Mappings & Mapplets using various transformations for Extraction, Transformation and Loading from Multiple Sources(SQL Server, Oracle, Flat files, DB2 Mainframes) to Data Warehouse and creating Sessions and Workflows/Worklets and executing teh Workflows.
• Responsible for Unit, System and Integration Testing and Performed Data Validation for all teh ETL’s and reports those are generated from Informatica.
• Involved in analysis, design and quality assurance of Client/server and Web applications for Healthcare, Health Insurance, Banking, Retail.
• Developed Test Plans, Test Scenarios, and Test cases, Test Scripts, Test reports and Test Metrics for Manual as well as Automated testing for various applications to ensure proper business compliance and testing Multi - Tier application architecture.
• Excellent communication, interpersonal, analytical skills and strong ability to perform in a team and to interact wif teh Business users and ability to manage (Multiple) project tasks wif changing priorities and tight deadlines.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities wif high level of adaptability.
• Demonstrated ability to work well wif a wide variety of people at various levels, coordinated wif Offshore and Onsite team, help team resolve conflicts constructively. A Self-starter wif a positive attitude, willingness to learn new concepts and acceptance of challenges.

TECHNICAL SKILLS

ETL, DW: Informatica Power Center 9.x, 8.x, 7.x,6.x, Power Exchange 9.1 CDCErwin 7.2, OBIEE

Databases: Oracle 11g/10g/9.x, DB2, SQL server 2005/2000, My SQL, MS-AccessSQL Developer 2008,Teradata

Operating Systems: Windows, Linux, UNIX, WINSCP, Tidal Enterprise Scheduler, AIXSunSolaris

Programming Languages & Scripting: SQL, PL/SQL,VB, C/ C++,Perl, HTML,XML, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Louisiana

Sr. ETL Developer

Responsibilities:

• Responsible for ETL design & implementation to source.
• Involved in requirement analysis, ETL design and development for extracting data from teh source systems like Oracle, flat files, XML files and loading into data mart by making new ETL designs.
• Analysis of Data by using IDQ.
• Worked on developing UNIX Scripts for file parsing and job automations.
• Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy and Sequence generator, SQL.
• Converted functional specifications into technical specifications (design of mapping documents).
• Developed Packages by using SSIS.
• Build New Data Models.
• Created deployment groups to deploy objects.
• Responsible for design and implementation needed for loading and updating teh warehouse.
• Worked wif Session logs and Work flow logs for Error handling and troubleshooting in Dev environment.
• Created scripts for better handling of incoming source files such as moving files from one directory to another directory and extracting information from file names, such as date, for continuously incoming sources.
• Wrote scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control auditing of different processes.
• Involved in Performance Tuning of existing mappings as well as new ones.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups .
• Migrated code/objects from teh development environment to teh QA/testing environment to facilitate teh testing of all objects developed and check their consistency end to end on teh new environment.
• Involved extensively in Unit testing, integration testing, system testing and UAT.
• Solution teh Data Quality and Data Cleansing tracks for teh MDM project
• Supervision of data quality, ETL development, data-integration, testing
• Conduct business and requirements analysis workshops, produce gap/fit

Confidential, Miami, FL

Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building teh ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of teh Data warehouse and used Erwin to design teh business process, dimensions and measured facts.
• Extracted teh data from teh flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in teh Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of teh workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to teh database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test teh mappings and fixed teh bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move teh mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 8.6.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, Erwin, Autosys, SQL Server 2005, Sybase, UNIX AIX, Toad 9.0

Confidential, White Plains, NY

DW Informatica Developer

Responsibilities:

• Analyze teh functional specs provided by teh data architect and created technical specs documents for all teh mappings.
• Develop logical and Physical data models dat capture current state/future state data elements and data flows using Erwin.
• Tune Informatica mappings for optimum performance.
• Provide Knowledge Transfer to teh end users and created extensive documentation on teh design, development, implementation, daily loads and process flow of teh mapping.
• Extensively used Power Center to design multiple mappings wif embedded business logic. Created Mapplet and used them in different Mappings.
• Create events and tasks in teh work flows using workflow manager.
• Use shell scripts for automating teh execution of maps.
• Design and developed Oracle PL/SQL Scripts for Data Import/Export, Data Conversions and Data cleansing.
• Did data cleansing using trillium such as converting male into M and female into F.
• Generate reports using OBIEE Impromptu tools querying database.
• Design and deployed in Perl.

Environment: Informatica PowerCenter 6.2/7.1, Server Manager, Power Connect, Erwin 3.5, Control M, Siebel 2000, PL/SQL, Oracle 8i, SQL Server 2000, DB2 7.0, HP-UX 10.20, Windows NT 4.0.

Confidential, Richfield, Minnesota

ETL Developer

Responsibilities:

• In - depth understanding of processes involving data modeling and building data marts.
• Translated teh business processes into Informatica mappings.
• Responsible for coordinating development and testing efforts wif offshore team members.
• Involved in optimization of Lookup SQL queries in order to reduce lookup cache size.
• Involved in teh deployment of restartibility logic in mappings to enable failed sessions to be run wifout any modification.
• Design and development of CDC process using time-stamping method.
• Developed ETL sessions for initial full loading and incremental loading.
• Worked wif heterogeneous sources including relational sources and flat files
• Extensively worked wif Teradata external loader (Mload) in upsert mode.
• Unit and Integration testing of Informatica mappings.
• Developed daily schedules for jobs to be run on Maestro considering various job dependencies.

Environment: Windows 2000, Informatica PowerCenter 6.2, Oracle 9i, DB2, SQL*Plus, TOAD, Mload, System me Navigator, Maestro JS Console 1.3, Unix.