PROFESSIONAL SUMMARY:

• 4+ years experience as Informatica Developer in developing large - scale Data Warehouse and Client/Server Applications, including Data Profiling, Data Migration, Data Modeling, Business Process, Design and Development, Integration and Testing, Database Programming, SDLC, Project Management and Production Support.
• Experience in Business Intelligence, Data warehousing, ETL and Mainframe technologies including expertise in design and development of Relational Database Systems (RDBMS), Design and Development of Data Warehousing using Informatica (V 7.x, V 8.x, and V9.x & V 10.x) power Center ETL tool and Informatica power exchange.
• Experience in Banking, Telecom and Insurance domain.
• Experience in complete Software development life cycle (SDLC) with a strong background in Design/Modeling, database development and implementation of various business intelligence and data warehouse / datamarts projects that cover gathering Business Requirements, Development, Implementations and Documentation.
• Strong work experience with Business Users to analyze the business process model and made necessary changes to schema objects to cater users reporting needs.
• Mainframe technologies
• Extensive experience in ETL methodologies for supporting Data Migration, Data Exchange, Data Transformation using Informatica Power Center v 10.x/9.x/8.x Suite
• Implemented Informatica Naming standards and Best Practices for the full life cycle of data warehouse projects, right from design to development through go-live and support
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer, Workflow Manager and Monitor.
• Sound knowledge of Relational and Dimensional modeling techniques of Data warehouse (EDS/Data marts) concepts and principles (Kimball/Inman) - Star, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization
• Experience in integration of various data sources like Oracle, Teradata, DB2, SQL Server, Flat Files( mainframes) Excel, and XML files
• Worked on Slowly Changing Dimensions (SCD's) and its implementation (Type1, Type 2, and Type 3) to keep track of historical data.
• Extensively used various Performance Tuning techniques to improve the performance for data loads
• Experience in interacting with Business users and Architecting high level requirements, high level design and detailed level design documents.
• Strong Quality Assurance and debugging skills in ETL Process
• Solid understanding of OLAP concepts and challenges with large sets of data
• Proficient in Toad, SQL navigator, and UNIX Shell Scripting

TECHNICAL SKILLS:

Data Warehousing ETL: Informatica Data Quality (IDQ), Informatica PowerCenter 10.x/9.x/8.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) ETL, Power Exchange 8.0, Repository, Metadata, Data Mart, OLAP, OLTP.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flack, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams

Databases: Oracle 11g/10g/9i, MS SQL Server 7.0/2000/2005/2008, TERADATA, DB2, OLTP

Programming: SQL, T-SQL, PL/SQL, SQL*Loader, Unix, Shell Scripting, SQL Tuning/Optimization, C, Java, HTML, Perl, PHPMainframe Tools SQL, Mainframe-Cobol, JCL, IMS

Tools: TOAD, SQL*Plus, Excel, Word, Autosys, Control-M, MS ACCESS

Reporting Tools: SSRS, Business Objects

Operating Systems: UNIX, Windows XP/Vista, Linux

PROFESSIONAL EXPERIENCE:

Confidential

Sr ETL/ Informatica Developer

Responsibilities:

• Collected requirements from Business Users analyzed and prepared the technical specifications.
• Developed rules and Mapplets that are commonly used in different mappings.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner and Stored procedure transformations.
• Created new mappings and enhancements to the old mappings according to changes or additions to the Business logic.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Implemented SCD1, SCD2 type maps to capture new changes and to maintain the historic data.
• Worked on extract and load type of mappings.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Developed Unix shell scripts to schedule Informatica sessions.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Created documents that have the detail explanation of the mappings, test cases and the expected results and the actual results.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Responsible for Performance Tuning at the Mapping Level and Session level.
• Used Debugger to troubleshoot the mappings.
• Responsible for migration of the work from Dev environment to testing environment.
• Performed unit testing, knowledge transfer and mentored other team members.
• Experience in utilizing the Teradata tools MLOAD, TPUMP, FAST EXPORT and FAST LOADs to load the EDW in an effective way.
• Responsible for code Migration from development to System test and Production environments.
• Worked on Informatica Data Quality to resolve customers related issues.
• Worked on Informatica Power Exchange Real time Change Data Capture (CDC) and Informatica Power Exchange Data maps against IMS.
• Participating in the Architecture council which is responsible for architectural decisions across the EDW.
• Partnering with Client ETL lead, ETL Architect, DW Architect and subject matter experts SME(s) to refine design to support the application requirements
• Formulated the Development standards / Checklists to develop the best ETLs.
• Actively involved in upgrade of Informatica Repository, Teradata and SQL server.
• Supporting Production schedule 24x7 consisting of 2,500 jobs for Informatica and SSAS.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Design and development of UNIX Shell Scripts to handle pre and post session processes and also for validating the incoming files.
• Developing the unit test case document and performed various kinds of testing like unit testing, regression testingand system test in Dev, QA environments before deployment.
• Scheduling the control-M jobs using Tivoli.
• Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Developed Test Strategy document, Test schedule, Test plan and Test cases for Application development projects.
• Ensure IT management and business stakeholders are kept fully updated on progress of critical issues.
• Escalate issues and remediation steps effectively and in a timely manner.
• Coordinate with vendors to troubleshoot and resolve issues.
• Participated in the full development life cycle within the reporting framework, from developing business intelligence requirements to QA and production deployment.

Environment: Informatica PowerCenter 10.6, IDQ, Teradata, UNIX, AIX PL/SQL, Windows 7, SQL Developer 2005, Autosys, Business Objects, IBM Mainframe, IBM DB2, IMS, VSAM, CICS, REXX, Change man, File-AID,xpeditor, QMF, SPUFI, ZEKE

Confidential

Sr. ETL/Informatica Developer

Responsibilities:

• Used ETL tools Informatica 8.1 to extract data from source systems, cleanse Transform, and Load data into databases.
• Developed mappings using Power Center -Designer for data transformation as per the technical requirements
• Designed mappings for different subject area CLAIMS, DENIED CLAIMS, PROCEUDRE, PROVIDER, REFERENCE, MEMBER, WMS
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformations
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Used Update Strategy DD INSERT, DD UPDATE, DD DELETE and DD REJECT to insert, update, delete and reject items based on the requirement.
• Implemented slowly changing dimension (SCD) for accessing the full history of Customer and transactions of customer. Implement Type I, II, and III changes in slowly changing dimension tables.
• Worked extensively with Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Created mapping using TERADATA, DB2 sources
• Used Reusable Transformations and Reusable Mapplets for different validations
• Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse.
• Setting up batches and sessions to schedule the loads at required frequency using Power Center server manager
• Involved in Version control of the jobs to keep track of the changes in the Development Environment.
• Designed views and materialized views to create accumulated data based on the detail facts the data
• Extensively worked on UNIT TESTING and created different unit test case documents for different subject areas.
• Designed work flows, that are used to run a set of maps together one after the other, the results such as the execution time, start time, end time and status are stored in a run time repository which can be accessed by other users
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Used debugger to test the mapping and fixed the bugs
• Developed UNIX shell scripts to schedule the jobs for running
• Tuned and optimized mappings to reduce ETL run times thereby ensuring the mappings ran within the designated load window.
• Co-ordinate with QA and BI reporting teams for any data related issues.

Environment: Informatica power center8.1, SQL Server 2008/2005, Oracle 10g, PL/SQL, Teradata, Teradata, UNIX, Windows 7, SQL Developer 2005, Sun Solaris.

Confidential, Austin, TX

ETL/Informatica Developer

Responsibilities:

• Verified the Online Services application to ensure that the requirements, artifact from each phase, and the final product--are complete and correct.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality
• Performed the Unit and functional testing which validate the data is mapped correctly which provides a qualitative check of overall data flow up and deposited correctly in Target Tables
• Tested the application for web functionality, and verified the online modules for broken links.
• Performed SQL validation to verify the data extracts and record counts in the database tables.
• Designed policies, standards and procedures for testing life cycle for the data warehouse and datamarts.
• Performed usability testing frequently to ensure continuous availability of online services to personal clients.
• Attended the Requirements reviews, Design reviews, Code reviews to understand the overall process flow and Source to Target Mappings.
• TOAD is used to test various ETL process flow graphs to meet the Business rules and Technical Requirements.
• Writing SQL Queries to retrieve data from data base.
• Divided the graphs into various phases and used checkpoints to avoid Dead locks.
• Extensively worked on debugging ETL process graphs.
• Used Rational ClearCase to maintain the versioning and change management for the test document repository.
• Developed and tested transformation functions and record formats for various input data files.
• Prepared test data to verify the functionality of the Informatica.
• Performed Data validation to verify the data extracts and record counts in the database tables.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.
• Tested customized and OBIEE reports with Metrics and Filters for Business analysis using Desktop intelligence with features of Drilling options drill up, drill down and drill anywhere .
• Participated in weekly status meetings, conducted walkthroughs, documented proceedings, and mentored new team members in test documentation and test case execution.

Environment: HP Quality center 8.0/9.0, HP Exstream, Oracle 9i/10g, PL\SQL,Pentaho, OBIEE 10.1.3, SQL server SSIS (2005), SQL server SSRS (2005),Cognos,Data Stage,DatMarts, Informatica 8.1, Windows 2000,Linux,Tibco, Wesbphere,SQL, SQL Plus, UNIX, Rational ClearCase.

Confidential

ETL/Informatica Developer

Responsibilities:

• Extensively involved to implement customer data mart and also data ware house.
• Analyzed the source data coming from Oracle, SQL server, and flat files.
• Extracted data from different source systems like Oracle, SQL server, flat file.
• Worked with Star Schema and Snow flake schema for the data warehouse.
• Extensively used Informatica Power center for extracting, transforming and loading into different databases.
• Designed, developed and tested the different Mappings according to Requirements.
• Analyzed the load dependencies and scheduled the workflows accordingly to avoid the loading conflict issues.
• Analyzed Session Log files in case the session fails in order to resolve errors in mapping or session configurations.
• Developed UNIX shell scripts as part of the ETL process for scheduling.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Created database objects like Tables, Indexes.
• Responsible for solving the testing issues.

Environment: Informatica PowerCenter 8.1, Oracle 9i, SQL Server 2000, SQL, PL/SQL, SQL* Loader, UNIX Shell Script.