SUMMARY

• 6+ years of IT experience in Software Development life cycle (SDLC) that includes Business Requirement Gathering & Analysis, System Study, Application Design, Development, Testing, Implementation, System Maintenance, Support and Documentation.
• Proficient in Data Warehousing using Informatica Power Center 9.X/ 8.X/7.X (Designer, Workflow Manager, Workflow Monitor, Repository manager), Knowledge of scheduling tools like Control M and Informatica scheduler.
• Expert in working with RDBMS like Oracle 11g/10g/9i/, MS SQL Server 2008/2005, MS Access. Also strong knowledge in SQL, PL/SQL, T SQL, Complex Stored Procedures, Triggers. Strong Experience on database interfaces like Oracle SQL Developer, SQL plus, Toad, Microsoft SQL server management studio.
• Extensive experience in Designing and Developing complex Mappings, Mapplets, Transformations, Workflows, Worklets.
• Good knowledge of Dimensional Data Modeling, ER Modeling, Star Schema/Snowflake Schema, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Good Knowledge of OLTP and OLAP Concepts and knowledge of Ralph Kimball data warehousing methodologies.
• Good knowledge of data profiling concepts and Knowledge on Data Processing, Data Cleansing, Data Validation and Data Archiving Process.
• Extensive experience in Performance Tuning of targets, sources, mappings and sessions.
• Good understanding in Unix Shell Scripting for scheduling/running ETL jobs in production environment.
• Complete knowledge of migration process from DEV to TEST, TEST to UAT, UAT to PROD environments.
• Coordinated and provided technical oversight to onshore and offshore team to implement the project.
• A Team Player with Excellent communication and interpersonal skills, quick learner, self - motivated, analytical, verbal and writing skills and ability to work individually as well as in a team with good team spirit.
• Demonstrated ability to quickly grasp new concepts, both technical and business related and utilize as needed.

TECHNICAL SKILLS

Data Warehousing Tools: Informatica Power Center 9.x/8.x/7.x

Languages: SQL, PL/SQL, TSQL, HTML, XML, C

Databases: Oracle11g/10g/9i/8i/7i, MS SQL Server 2008/2005/2000

Operating System: Windows 9x/NT/2000/XP, UNIX, MS-DOS

Tools: /Utilities: SQL*plus, SQL Developer, Toad 5.x/6.x/7.x/8.x/9.x, TOAD for SQL Server, ERWin, ER/Studio

Scripting: UNIX Shell Script

PROFESSIONAL EXPERIENCE

Confidential, Wellesley MA

Sr. Informatica/ETL Developer

Responsibilities:

• Primary responsibility is to resolve issues related to Enterprise data warehouse (EDW), stored procedures in OLTP system and analyzed, design and develop ETL strategies.
• Worked with heterogeneous source to extract data fromOracle database, XMLand flat files and loaded to a relational Oracle warehouse.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Migrated day one data for existing members in PCMH program from EDW into OLTP system using ETL process.
• Performed tuning of SQL queries and Stored Procedure for speedy extraction of data to resolve and troubleshoot issues in OLTP environment.
• Troubleshooting of long running sessions and fixing the issues related to it.
• Worked withVariables and Parametersin the mappings to pass the values between sessions.
• Involved in the development of PL/SQL stored procedures, functions and packages to process business data in OLTP system.
• Carried out changes into Architecture and Design of Oracle Schemas for both OLAP and OLTP systems.
• Worked with Services and Portal teams on various occasion for data issues in OLTP system.
• Worked with the testing team to resolve bugs related to day one ETL mappings before production.
• Creating the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Involved in meetings with production team for issues related to Deployment, maintenance, future enhancements, backup and crisis management of DW.
• Worked with production team to resolve data issues in Production database of OLAP and OLTP systems.

Environment: Informatica PowerCenter 8.6.1, Oracle 11g, XML, PL/SQL, SQL Developer 3.0.1, Toad 11.0, Erwin

Confidential, Plano TX

Sr. Informatica Developer

Responsibilities:

• Involved in requirement analysis, design, and development & testing of maintenance requests.
• Interacted with business analysts, data architects and application developer to develop a data model.
• Extensively worked with Designer tools like Source Analyzer, Target designer, Mapping designer, Mapplet designer, Transformation Developer.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator Transformations.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Optimized the existing applications at the mapping level, session level and database level for a better performance.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Designed and developed UNIX Shell scripts for creating, dropping tables which are used for scheduling the jobs.
• Involved in migration of mappings and sessions from development repository to production repository.
• Developed and maintained technical documentation regarding the extract, transformation and load process.
• Involved in Unit testing, UAT to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Preparation of test plans, support SIT & UAT testing. Responsible for migrating code to various environments.

Environment: Informatica PowerCenter 9.0, Oracle 11g, XML, PL/SQL, Toad 8.1, UNIX shell scripts

Confidential, Collegeville, PA

Informatica Developer

Responsibilities:

• Involved in gathering and analyzing the user requirements in coordination with the business.
• Supported ongoing design, development and maintenance of Informatica ETL workflows.
• Used Informatica power center for extraction, transformation and loading data from heterogeneous source systems.
• Documented the mapping strategies and transformations involved in the ETL process.
• Worked with ETL lead to prepare the documentation for the whole Extraction Transformation and Loading process.
• Member of the team responsible for extracting the data from relational source (Oracle), perform mappings based on company requirements and load into Oracle tables.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Reconciliation of data from scratch i.e., from source to target. Maintaining the flow and writing SQL queries and finding the mismatches in the data manually.
• Involved in designing the star schema and populating the fact tables.
• Worked extensively on Informatica repository manager, Designer, workflow manager.
• Created sessions, workflows and also monitor the results and validate them according to the requirement.
• Developed Oracle PL/SQL stored procedures and Shell Scripts.
• Tuning of SQL queries in SQL overrides for better performance.
• Worked with tools like TOAD and SQL tools to write queries and generate the results.

Environment: Informatica PowerCenter 8.1, PL/SQL, Oracle 9i, TOAD, UNIX, SQL developer

Confidential, Pleasanton, CA

Informatica Developer

Responsibilities:

• Involved in gathering business requirements in liaison with business users and technical teams.
• Involved with the team to create requirement specification documents and identified data sources and targets.
• Worked with data modeler to help in identify Facts and Dimensions levels/ Hierarchies of Dimensional model.
• Extracted data from different sources like SQL server, flat files, Relational Database and loaded into Data Warehouse.
• Created complex mappings for Claims and Policy dimension tables using Unconnected Lookups, and Aggregate and Router transformations for populating target table in efficient manner and used them in different Mappings.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Used the update strategy to effectively migrate data from source to target.
• Developed the Incremental ETL Processes like Mappings & Mapplets using various Transformations and workflows with Sessions/Tasks.
• Wrote SQL queries, PL/SQL stored procedures for implementing business rules and transformations.
• Used UNIX shell scripts for running batch jobs and scheduling them.
• Working with database connections, SQL joins, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Environment: Informatica PowerCenter 7.1, Oracle 8i, SQL, PL/SQL, UNIX Shell Scripting

Confidential

Informatica Developer

Responsibilities:

• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Extensively worked on Informatica client tools like Designer, Workflow Manager and workflow monitor.
• Created complex mappings using Aggregator, Expression, Joiner transformations including complex lookups, Stored Procedures, Update Strategy and others.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Extensively involved in migration of ETL environment, Database objects and EDW.
• Tested data integrity among various sources, targets and various performance related issues. Environment:

Environment: Informatica Power Center 6.2.1, Windows 2000, SQL Server 2000, Oracle 8i, PL/SQL.

Confidential

Database Developer

Responsibilities:

• Participating in gathering of business user requirements.
• Involved in analysis, design, testing, debugging phases of the System.
• Wrote triggers, menus and stored procedures in PL/SQL.
• Involved in writing SQL queries.
• Handled PL/SQL Compile-Time and Runtime Errors.
• Designed and developed all the tables, views for the system in Oracle.
• Designed and developed forms validation procedures for query and update of data.
• Supported technical teams involved with Oracle issues and operations.
• Involved in Implementation and production Support of the system.

Environment: Oracle 8i/7i, SQL*plus, PL/SQL