PROFESSIONAL SUMMARY:

• A well - seasoned ETL Developer with7 years of Data Warehousing experience teamed with Business Requirements Analysis, Application Design, Data Modeling, Development, testing and documentation. Implementation of Warehousing and Database business systems. Exceptional analytical and problem solving skills.

• Solid years of ETL/DW/BI experience using Informatica PowerCenter 9.0/8.6/8.5/8.1/7.1/7.0/6.2/6.1 (Workflow Manager, workflow Monitor, Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica PowerMart 6.2/6.1/5.1.2/5.1.1/4.7, Datamart, ETL, OLAP, ROLAP, MOLAP, OLTP, IMS Data, Star Schema, Snowflake Schema, Trillium 7.0, FirstLogic, IBM DB2 8.2, DB2 Toad 4.0, FTP-PRO client 32, Windows XP, UNIX, Main frames AIX.. Well versed with Informatica Team based development (Versioning).
• Pass Oracle PL/SQL Developer Certified Associate: Oracle Database 11g: SQL Fundamentals
• Extensive experience using Oracle 11g/10g/9i/8i, DB2 8.2/7.0, Netedata,Teradata V2R5/V2R4, MS SQL Server 2008/2005//2000, MS Access 7.0/’97/2000, Oracle Report Writer, SQL, XML, PL/SQL, SQL*Plus, SQL*Loader, Win 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x.
• Extensive development experience for the Extraction, Transformation and Loading of data from multiple disparate sources such as Oracle, MS SQL Server, DB2, Teradata, Flat Files, XML Files into ODS (Operational Data Store) and EDW (Enterprise Data Warehouse) systems. Solid Expertise in Creating Migration Document and expertise in creating Functional and Technical Documentation for ETL.
• Have 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. Expertise in implementing complex business rules by creating re-usable transformations, Mapplets and Mappings.
• Experience working with Scheduling tools Autosys, Control M and Maestro. Extensive knowledge in handling slowly changing dimensions type.
• Extensively used Informatica Repository Manager and Workflow Monitor. Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Good experience in data profiling and data cleansing activities and documenting the ETL process flow for better maintenance and analyzing the process flow.
• Proficient in data warehouse and database concepts and methodologies. Worked on all aspects of the Data warehouse lifecycle: Requirements gathering, designing, data modeling, ETL, performance tuning, testing, Reporting and production support
• Good Knowledge of Dimensional Data Modeling experience using Data modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling, ERWIN 7.2/4.5/4.0.
• Expert in Business Intelligence using Business Objects XI/ 6.5/6.0/5.1/5.0, Cognos Impromptu 7.0/6.6/6.x, Micro strategy.
• Strong written and oral communication skills. Excellent conceptualization and analytical skills.

TECHNICAL SKILLS:

• Informatica PowerCenter 9.0/8.6/8.5/8.1/7.1/7.0/6.2/6.1 (Workflow Manager, workflow Monitor, Source Analyzer
• Data Warehouse Designer, Mapping Designer, Mapplet, Designer, Transformation developer), Informatica PowerMart 6.2/6.1
• Datamart, ETL, OLAP, ROLAP, MOLAP, OLTP, IMS Data, Star Schema, Snowflake Schema, Trillium 7.0, FirstLogic
• Windows XP, UNIX, Main frames AIX.BusinessObjects XI/6.5/6.0, Cognos Impromptu 7.0/6.6/6.x, Micro strategy
• Erwin 7.2/4.5/4.0/3.5.2/2. x, Visio, Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions)
• Entities, Attributes, Cardinality, ER Diagrams.Oracle 11g/10g/9i/8i/8.x/7.x, DB 2 8.0/7.0/6.0, Netezza, Teradata
• V2R5/V2R4, SQL Server 12.0/11.x, MS SQLSever 2008/2005/2000, PL/SQL,CA Autosys, BMC Control M, Cron tab
• IBM Maestro.UNIX (AIX), Windows XP/ 2003/2000/98, Mainframes, HTML, C, C++, Java, Visual C++, CSS, SQL

PROFESSIONAL EXPERIENCE:

Confidential

ETL Informatica Developer

Responsibilities:

• Participated in team meetings to discuss and understand the user requirements.
• Designed the mapping documents according to the requirements.
• Used Informatica for ETL and BO for reporting.
• All the tables are built on Oracle database.
• The data mart was built to accommodate the current data and no historical data is maintained.
• Identified the staging, dimension and fact tables.
• Type I strategy is followed to build all the Dimension tables so that the new records overwrite the existing records upon any changes.
• Responsible to lead and coordinate with the offshore team.
• Assigned tasks to them and collected the status accordingly from the offshore team in the daily status call.
• Reviewed their design strategy before submitting to the client for code review and suggested necessary changes in order to meet the client standards.
• Guided and educated the offshore team members regarding the project standards and development standards.
• Designed complex mappings Informatica which loaded about 24 million records to the target.
• Used different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregator, Sequence Generator, Joiner, Union, Filter, Update Strategy and Router transformations in the mappings.
• Built Stage mappings to load the data directly from source tables.
• Built all the business logic in Dimension mappings by looking up various database tables.
• Worked with the team lead on code promotions to TEST and PROD.
• Wrote complex SQL queries to test the data loaded in the tables.
• Prepared test cases, test plan and test script documents in order to record the test and validated data loaded in Stage, Dimension and FACT tables.
• Performed Unit testing and System testing in order to validate the data.
• Opened tickets when found bugs while testing and reported them using Quick Base application.
• Reported the overall status of the work directly to the project manager in the weekly status meetings.
• Fixed issues in the mappings whenever reported related to data or a change in business logic.
• All Submission files were designed according to HIPPA standards.

Tools: and Technologies: Informatica Power Center 9.1/8.6, (Source Analyzer, Data warehouse designer, Mapping Designer, Mapplet Designer, Transformations Developer, Workflow Manager, Workflow monitor, Repository Manager), Oracle 11g/10g, Unix, Business Objects XI, ERWIN 7.2/4.5, SQL Server 2008, DB2, Flat files

Confidential, Bloomington, IL

ETL Informatica Developer

Responsibilities:

• Composed low level design documents of ETL from source (Oracle, DB2, flat file) to target (Oracle 11g).
• Analyzed requirement documents and queried the source systems for ETL design
• Create Informatica mappings using MS Visio and write DB2 SQL override
• Presented the design documents in review meeting to the whole data movement team
• Communicated with testing and coding team to assist their building and testing works.
• Studied and Analyzed the Business requirement and prepared scope document, ETL specification documents according to the business requirements.
• Design of ETL mappings for the CDC (change data capture)
• Source and Target databases resided on Oracle.
• Conducted design review meetings with the architect for any new requirement to get the approval and designed the mappings according to the company standards.
• Used MS-Visio to populate the Informatica design flows.
• Assisted in Informatica Administration using Repository manager.
• Developed Complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Sequence Generator, Joiner, Union, Filter, Update Strategy, Rank and Router transformations.
• Worked with Informatica Labels in labeling the designed components for deployment of code to TEST and PROD.
• Well versed with Informatica Team based development (Versioning).
• Used Informatica versioning to check in and check out the objects in designer and workflow manager.
• Troubleshoot problems by checking sessions and error logs. Also used debugger for complex problem troubleshooting.
• Write complex SQL queries to test the data generated by ETL process against target data base.
• Used Golden and also Toad to access the Oracle tables execute SQL queries.
• Designed complex mappings involving target load order and constraint based loading.
• Performance tuning, bug fixing and error handling.
• Create parameter files for the all the designed mappings and used parameter files for defining all the connection values( Source, Target, Lookup) and mapping parameters used in the Informatica sessions.
• Used Delta loading to extract New Claims in Informatica and processed the data and loaded the target data to Oracle tables.
• Used BO for reporting purposes.
• Design Technical documents, ETL Unit test plan document, Migration Check list document.

Tools: and Technologies: Informatica Power Center 8.6/8.1, (Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Data warehouse designer, Mapping Designer, Mapplet Designer, Transformations Developer), Business Objects XI, Oracle 11g/10g,Erwin 4.5, MS Vision, HIPAA, ICD/CPT codes.

Confidential, NY, NY

ETL Informatica Developer

Responsibilities:

• Requirement gathering from the Business Unit and end users of the proposed Product
• Design and creation of detailed Technical Mapping document with information on implementation of business logic
• Associated with Physical and Logical Data Modeling using Erwin.
• Design of ETL mappings for the CDC (change data capture)
• Extensively used various transformations like Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads
• Worked with slowly changing dimension Type1, Type2, and Type3
• Performance tuning of the process at the mapping level, session level, source level, and the target level
• As a Sr.Developer Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements.
• Guided and Mentored the ETL team in Informatica
• Extensively used mapplets for use in mappings thereby saving valuable design time and effort
• Worked with various tasks like Session, E-Mail, Workflows, Worklets, and Command
• Worked with the Informatica Scheduler for scheduling the delta loads and master loads
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, and Count in the Aggregator Transformation.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Extensively worked with various re-usable tasks, workflows, Worklets, mapplets, and re-usable transformations
• Extensively worked with various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
• Worked with session logs, Informatica Debugger, and Performance logs for error handling when we had workflows and session fails
• Responsible for the Promotion of Mappings, Workflows and other Informatica objects like sources, targets, and transformation between environments like DEV, INT, UAT and PRD-Development, Integration Testing, User Acceptance Testing, and Production.
• Extensively used Repository Manager for Promotion of XML objects from one environment to the other
• Extensively worked with Versioning of objects in Informatica with Check in and Check out options
• Worked with Third party scheduler Control M for Scheduling of Informatica Workflows.
• Worked extensively with the business intelligence team to in corporate any changes that they need in the delivered files

Tools: and Technologies: Informatica Power Center 7.0/6.2, (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Erwin 7.1, Cognos, SQL Server 2000, DB2 8.0/7.0, UNIX, Windows Server 2003, Control M, Business Objects XI, Oracle 9i.

Confidential, Bridgewater, NJ

DW Informatica Developer

Responsibilities:

• Studied and Analyzed the Business requirement and prepared technical documents, ETL specification documents according to the business requirements.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Develop Logical and Physical data models, created the (ER) Entity Relationship diagrams & maintained corresponding documentation for corporate data dictionary with all attributes, table names and constraints.
• Designed Sources to Targets mapping using Informatica PowerCenter for their Sales and Marketing department.
• Ultimately loaded the target tables resided on Oracle to populate the Sales Datamart.
• Performed Repository manager tasks.
• Used Trillium 7.0 and its components Parser, Geo-Coder, Matcher, Converter for Data Cleansing and Data Profiling. Studied the existing system(s) and Created facts, dimensions for the data mart.
• Analyzed IMS Rx Data using IMS tools such as Xponent and Xponent Plantrak, regarding segmentation & profiling
• Followed Ralph Kimball Methodology in designing the warehouse. Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations.
• Various kinds of the transformations were used to implement simple and complex business logic. Transformations used are: connected & unconnected lookups, Router, Expressions, source qualifier, aggregators, filters, sequence Generator, Update etc.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Used Informatica versioning to check in and check out the objects in designer and workflow manager.
• Designed Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability.
• Troubleshoot problems by checking sessions and error logs. Also used debugger for complex problem troubleshooting.
• Created Stored Procedures for data transformation purpose.
• Did Performance Tuning on Informatica Mappings and Sessions for optimum performance.
• Designed and developed UNIX shell scripts for file watching criteria.
• Scheduled ETL jobs using Autosys.
• Maintained Development, Test and Production mappings.
• Used Cognos to create various reports.

Tools: and Technologies: Informatica Power Center 6.1/5.1(Source Analyzer, Data warehouse designer, Mapping Designer, Mapplet Designer, Transformation developer, Workflow Manager, Workflow monitor), Oracle 8i, Erwin 4.0, Trillium (Parser, Geo-Coder, Matcher, Converter), Autosys 3, Power Exchange, Cognos 7.0,Mainframes, IMS Rx Data, SQL Server 2000, SQL*Plus, SQL*Loader, XML, Windows NT 4.0, Unix, Shell Scripting.