SUMMARY

• Eight years of experience in system analysis, design, data warehouse/data mart design, development and implementation of client server applications.
• Over eight years of experience in Informatica Power Center with financial, health care, marketing, mobility, consumer, and inventory management clients. Hands on experience in all aspects of software development life cycle.
• Proficient in transforming data from various sources flat files, XML, Oracle to data warehouse using ETL tools.
• Expertise in Informatica Power Center 5.x/6.x/7.x/8.x/9.x repository manager, workflow manager, mapping designer, transformation designer, mapplet designer, and reusable transformations.
• Significant experience with TriZetto Facets 4.51 tables.
• Strong experience in health care claims processing, billings and payments.
• Strong experience as an Informatica administrator for Informatica Server, repository services, maintaining repository security and exchange server.
• Extensive experience in supporting production jobs, data enhancements and code fixes.
• Worked with dimensional data warehouses in star and snowflake schemas, created slowly growing target mappings, type1/2/3 dimension mappings.
• Experience using Teradata load utilities like MultiLoad, FastLoad, TPump, and FastExport.
• Designed database schemas using ERwin.
• Expertise in using SQL LOADER to load data from external files to Oracle database.
• Extensive experience in writing PL/SQL programming units like Triggers, Procedures, Functions and packages in Unix and Windows environment.
• Actively implemented performance tuning by identifying and removing the bottlenecks and optimized session performance by tuning complex mappings.
• Experience in optimizing the performance of SQL scripts and Oracle database/application tuning.
• Excellent in coding using SQL, PL/SQL, Procedures/Functions, Triggers and Packages.
• Developed batch jobs using UNIX Shell scripts csh, bash, ksh to automate the process of loading, pushing and pulling data from and to different servers.

SKILLS

• ETL Tools Informatica Power Center 9.5/9.1/8.6/8.5/8.1.1/7.1.1/6.2.2
• Databases Oracle 11g/10g/9i/, TeradataV2R5/V2R6/V2R12, DB2 UDB 9.7.0.6, MS SQL
• Server, 2000/2008, MySQL, MS Access, Netezza
• Data Modeling MS Visio 2002, ERWin
• BI Tools Cognos 7
• OS MS DOS, Windows NT/2000, SCO UNIX 5.0.5, Red Hat Linux 8.x
• Languages SQL, PL/SQL, C, C , Java, VB
• Scripting VB Script, JavaScript, PERL, SHELL Scripting korn, csh
• Querying Tools SQL Plus, TOAD, SQL Developer, SQL Navigator, Query Analyzer, Jay SQL
• WEB Applications MS Office 2007, HTML, DHTML, XML, ASP 2.0/3.0
• HealthCare Products Facets 4.51

EXPERIENCE

Confidential

Sr. Informatica Developer

• Interacted with Data Analysts to translate business requirements into technical specifications.
• Involved in the design of a STAR schema to load Dimension and Fact tables.
• Developed ETL jobs to Extract, Transform and Load ETL the data by using Pentaho ETL tool.
• Extracted source data from flat files, oracle and DB2 and loaded to a relational warehouse.
• Implemented SCD methodology including type 1 and type 2 changes to keep track of historical data.
• Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Stored Procedures, Router, Sorter, Rank, Expression and Update Strategy.
• Used the Workflow manager to create workflows, worklets and tasks.
• Performed unit testing and developed user test cases for Dimension and Fact tables.
• Scheduled jobs in Automic as per the dependencies.
• Documented source to target mapping and job schedules.

Environment: Informatica Power Center 9.5, Pentaho 5.22, Oracle 11g, IBM DB2 9.7.0.6, TOAD, Unix, Automic

Confidential

Sr. Informatica Developer

• Involved in regular discussions with the data analysts to gather the requirements.
• Extracted data from various sources like Oracle and flat files and loaded into the target MS SQL Server database.
• Designed and developed Mobile orders tax report for Ohio.
• Involved in the design and development of Insight replication from NCR to load the data into Oracle
• Designed and developed data quality for replicated Insight tables to catch missing data.
• Loaded data into MS SQL Server from Oracle replicated tables, the jobs were run in sync group for each franchise and company stores.
• Developed DMA market plan to calculate the net sales for franchise and company stores in North America.
• Involved in the ETL process from development to testing and production environments.
• Design and development of ETL routines, using Informatica mappings, usage of Lookups, aggregator, Joiner, Router, Expression, connected and unconnected Lookups, and source filter usage in source qualifiers and data flow management into multiple targets using routers was extensively completed.
• Worked on SQL queries to fix the defects for current fiscal period for labor data
• Created documents for ETL source to target mapping with business rules.
• Involved in monitoring jobs for failures in production.

Environment: Informatica Power Center 9.5, Oracle 11g, Microsoft SQL Server 2008, SQL, TOAD, Microsoft SQL Server 2008 R2, Project Envision

Confidential

Sr. Informatica Developer

• Extensively worked with business users to gather the requirements and translated them into technical requirements.
• Extensively worked on loading Dimensions and fact tables in a star schema.
• Extracted data from Oracle and loaded into DB2 target database.
• Participated in implementation and testing of various type 1 and type 2 dimensions.
• Lead testing of various fact and dimensions tracking child foster care placements.
• This table tracks abuse allegations for the department and vitally important for correct reporting.
• Analyzed source data and developed Fact Allegation table with supporting dimensions.
• with current flag and effective date ranges due to updates and deletes in the source schema.
• provide data groupings for federally required reports. The fact table is treated as type 2
• and surrounding dimensions. This fact table tracks disability claims and the dimensions
• Responsible for developing and testing ETL mappings for Fact Child Disability fact table
• Implemented SCD methodology including type 1 and type 2 changes to keep track of historical data.
• Designed and built staging tables to restrict the data for Incremental loads.
• Developed ETL exception jobs to load the filtered data into tables.
• Used the Workflow manager to create workflows, worklets and tasks.
• Involved in performance tuning of mappings, and sessions.
• Migrated Informatica mappings, sessions and workflows from Powerceneter 8.6 to 9.1
• Developed and tested the mappings when the target database is changed from Oracle 11g to DB2.
• Performed ETL unit testing and delivered objects as per deadlines.
• Prepared design documents, ETL data mapping and migration documents.

Environment: Informatica Power Center 9.5/9.1.0, Oracle 11/10g, IBM DB2 9.7.0.6, SQL, UNIX, Shell Scripting, HP Quality Center, TOAD.

Confidential

Sr. Informatica Developer

• Gathered the requirements from data architect and wrote source to target data matrix.
• Designed a star schema with dimensions and fact tables.
• Extensively involved in understanding the legacy code which was developed in Oracle Warehouse Builder, SQL Loaders, and PL-SQL packages.
• Developed Informatica mappings to load the data into staging, ODS layer and to data marts.
• Data analysis to understand the natural key combination of fields for SCD type 1 and type 2 dimensions.
• Developed mappings to load dimension and fact tables into SALES MARKETING data mart.
• Involved end to end in the project from design, data analysis, and development, unit testing and resolving the defects found in UAT.
• Developed mappings and mapplets using various transformations like Joiner, Filter, Aggregator, Lookup, Stored Procedures, Router, Sorter, Rank, Expression and Update Strategy.
• Participated in daily stand up meetings in an agile methodology.
• Documented unit test results and source to target data matrix documents.
• Migrated the code to QA and UAT environments.

Environment: Informatica Power Center 9.1/8.6, Oracle Warehouse Builder, Oracle 11g/10g, TOAD, PL-SQL, SQL, UNIX, Shell Scripting, TFS Workbench.

Confidential

Sr. Informatica Developer

• Designed dimensions and fact tables in a star schema.
• Crated source to target data mapping documents.
• Created the design and implementation of bridge tables in a data warehouse.
• Implemented SCD methodology including type 1 and type 2 changes to keep track of the historical data.
• Designed ETL test case scenarios and completed ETL unit testing.
• Wrote SQL queries to extract the source data from Oracle
• Prepared design documents, ETL data mapping and migration documents.

Environment: Informatica Power Center 9.0.1/8.6, Oracle 11/10g, IBM DB2, SQL, UNIX, Shell Scripting, Quality Center, TOAD.

Confidential

Sr. Informatica Developer

• Interacted with Business Analysts to translate business requirements into technical specifications.
• Developed ETL jobs to Extract, Transform and Load ETL the data by using Informatica Power Center 9.0
• Extracted source data from flat files, oracle and Netezza and loaded to a relational warehouse.
• Implemented SCD methodology including type 1, type 2 and type 3 changes to keep track of historical data.
• Used shortcuts global/local to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Extensively worked on mapping variables, mapping parameters, workflow variables and session parameters.
• Used the Workflow manager to create workflows, worklets and tasks.
• Identified performance issues and performance tuned of targets, sources, mappings, and sessions.
• Created post-session and pre-session shell scripts and mail-notifications.
• Documented Informatica mappings, design and validation rules.
• Maintained process run book, documentation for mappings, workflows with updated functional specifications for future references.
• Delivered and sign-off of deliverables pertaining to the operations data warehouse.
• Composed Maestro schedules.
• Prepared design documents, ETL specifications and migration documents.

Environment: Informatica Power Center 9.0.1/8.6, Oracle 11/10g, Netezza 4.5, SQL, PL/SQL, UNIX, Shell Scripting, Maestro Scheduler, Quality Center, TOAD, WINSQL

Confidential

Sr. Informatica Developer

• Involved in regular discussions with the data analysts to gather the requirements.
• Created the application design document to get approvals for development.
• Design and development of ETL routines, using Informatica mappings, usage of Lookups, aggregator, ranking, mapplets, connected and unconnected Lookups, and source filter usage in source qualifiers and data flow management into multiple targets using routers was extensively completed.
• Involved in the ETL process from development to testing and production environments.
• Extracted data from various sources like Oracle and flat files and loaded into the target Oracle database.
• Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Stored, Router, Sorter, Rank, Update Strategy, Expression, Router and Normalizer.
• Developed and documented data mappings/transformations, and Informatica sessions as per the business requirement.
• Extensively used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from flat files
• Documented design documents and unit test plan for Informatica mappings, design and validation rules.
• Involved in writing Bteq's to load the data into teradata and used fast export scripts to generate flat files.
• Loaded the data into oracle using Informatica and then loaded the data into Teradata from flat files using Mloads to load the data into teradata tables.
• Involved in preparing unit test case document and performed unit testing in development environment.
• Used Teradata Fast Load to load the data into the empty tables in the Staging area.
• Worked with Informatica shortcuts in order to maintain the consistencies in the sources and targets throughout the Informatica mappings.
• Worked with Informatica Debugger in order to debug the mapping and the session and to find out the bottlenecks in the mapping.
• Handled production issues and monitored Informatica workflows/teradata jobs in production.
• Handled system test defects in a timely order to meet the dead lines for UAT.

Environment: Informatica Power Center 8.6/8.5, Oracle 10g, Teradata V2R12,TOAD 9.0, UNIX, Mercury Quality Center, Teradata SQL Assistant.