SUMMARY

• Around 7 years of IT experience in developing and designing of ETL methodology for supporting data transformations using Informatica Power Center 7.x/8.x/9.x
• Working Knowledge on different data sources as Flat Files, Cobol Files, Oracle, SQL Server, DB2 and XML
• Designed and developed complex mappings, from varied transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more
• Involved in all phases and complete life cycle of the Datawarehouse/ETL project i.e. Data modeling, Designing ETL strategies, Development, Testing, Validation of test ETL scripts, Implementation and Production Support
• Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions
• Having sound knowledge in OLAP & Multi - Dimensional Data Modeling. Designing star- schema / snowflake schemas, Data Marts, Data Mining, Data quality Analysis, Data Integration and Slowly Changing Dimensions (SCD)
• Extensively worked on transformations, creation of Worklets, Mapplets, reusable transformations, usage of parameter files, edit rules and validation of business rules
• Experience in automating of the ETL processes for migration
• Experience in Relational Database concepts
• Multi Environment working experience - UNIX, Windows
• Excellent problem solving skills with a strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure

TECHNICAL SKILLS

ETL: Informatica PowerCenter 9.x/8.x/7.x, Sagent Data Flow 5.5.1

Tools: SQL*PLUS, PL/SQL Developer, TOAD, WinSQL, Control-M Scheduler, Cybermation Workload Automation, PuTTy, MS Office

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

Databases: Oracle 9i/10g/11g, MS SQL Server 2000/2005, MS Access

Operating Systems: Windows 7/Vista/XP/2003/2000/NT,UNIX

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

ETL Lead Developer

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop data models, requirements document, and ETL specifications
• Prepared ETL design specification documents with information on implementation of business logic
• Worked with Target XSD’s in order to generate the output XML files
• Extracted data from DB2 source tables, loaded them in SQL Server Intermediate Data Store tables for Auditing purposes before loading them to XML target files
• Extensively used transformations like Joiner, Expression, Connected/Unconnected lookups, and Filter, Aggregator, Rank, Update, Router and Sequence generator
• Generated Informatica parameters and variables effectively through scripts for developing mappings
• Responsible for developing Mapplets to implement the reusable logic
• Maintained and modified mappings as per changing reporting requirements
• Prepared Unit test case document and System Test case document
• Responsible for designing, developing and implementing the incremental load strategy, full load and disaster recovery
• Involved in the code migration from Development to UAT and Production
• Scheduled the jobs using Cybermation Workload Automation tool
• Involved in FTP of data from Target path to Edge Server location
• Responsible for troubleshooting the informatica tasks and performance related issues and data issues using the session logs and debugger

Environment: Informatica Power Center 9.5.1, DB2, SQL Server, XML, WinSQL, UNIX, Cybermation Workload Automation, PuTTy 0.58, Windows XP/7

Confidential, Columbus, OH

ETL Developer

Responsibilities:

• Worked with the customers and business analysts for requirements gathering
• Developed the detailed design document of the required data warehouse system
• Designed and developed Informatica mappings to extract data from Oracle source system to staging and from staging to target
• Used Parameter files to manage the relational connection in different environments
• Developed the test cases with the client for his business requirements
• Performed Unit test and Integration test for the process created in Informatica and all the test cases were well documented for process improvements
• Monitored the database usage and the ETL mappings so as to complete and refresh the datawarehouse within the time frame
• Implemented Informatica best tuning techniques to increase the performance of the process

Environment: Informatica Power Center 9.1, Oracle 11g, PL/SQL Developer, TOAD, UNIX, PuTTy 0.58, Windows XP

Confidential, Columbus, OH

ETL Developer

Responsibilities:

• Involved In Design Specifications and Technical Sessions
• Involved in documentation and presentation of the methodology to the client
• Created Informatica ETL mappings that transfer data from Oracle to flat file targets
• Developed complex mapping logic using various transformations like Expression, Lookups, Joiner, Filter, Sorter, Router
• Created re-useable sessions, worklets, workflows for the mapping to run based on the business requirements
• Used Parameter files to manage the relational connection in different environments.
• Tuned SQL Queries in Source qualifier Transformation for better performance
• Created UNIX shell scripts for scheduling and file processing
• Responsible for Migrating the Informatica mappings form lower environment (Development) to higher environment.
• Involved in Unit and Integration testing in lower/higher environments. Also responsible for post validation and provide validation scripts.
• Prepared data validation documents.

Environment: Informatica Power Center 9.1, Oracle 11g, PL/SQL Developer, TOAD, UNIX, PuTTy 0.58, Windows XP

Confidential, Columbus, OH

ETL Developer

Responsibilities:

• Created Technical design document based on business requirement
• Analyzed the data to be able to identify the data quality issues and validated test cases
• Prepared ETL standards, naming conventions and wrote ETL flow documentation
• Created Informatica ETL mappings that transfer data from COBOL source systems to Oracle Database.
• Created mappings using transformations likeSource Qualifier, Aggregator, Expression, Lookup, Router, Filter
• UsedParameter filesto define values for parameters and variables used in a mappings
• Used workflow manager to create workflows, sessions, and also used various tasks like command task
• Prepared unit test cases to meet the business requirements and performed unit testing of mappings.
• Provided SQL scripts to validate source to target validations
• Migrated the code from DevelopmentàTestingàUATàProduction
• Efficient Documentation was done for all phases like Analysis, design, development, and testing

Environment: Informatica Power Center 9.0, Oracle 11g, COBOL, PL/SQL Developer, TOAD, UNIX, PuTTy 0.58, Windows XP

Confidential, Columbus, OH

ETL Developer

Responsibilities:

• Interacted with the business in business analysis and technical design sessions with business to develop requirements document and ETL specifications
• Created Functional document and Technical design document based on business requirement
• Involved in presentation of the methodology to the client
• Analyzed the data to be able to identify the data quality issues and validated test cases
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging area, prepared ETL standards, naming conventions and wrote ETL flow documentation
• Extracted the data from flat files into Oracle database. SFTP process was developed to access the data from source system
• Used update strategy transformation to effectively migrate data from source to target.
• Created mappings using transformations likeSource Qualifier, Expression, Lookup, Filter, Update Strategy, Joiner
• Used workflow manager to create workflows, sessions, and also used various tasks like command tasks
• Create workflows based on dependencies in Informatica for the code changes.
• Coordinated with system operators to schedule batch jobs in Control-M scheduler.
• Unit test the Data Mappings and Workflows and validate the data loaded into database.

Environment: Informatica Power Center 9.0, Oracle 11g, SFTP, PL/SQL Developer, TOAD, UNIX, Control-M Scheduler, PuTTy 0.58, Windows XP

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications
• Analyzed the impact of changes on the existing systems
• Analyzed the data to be able to identify the data quality issues and validated test cases
• Prepared ETL standards, naming conventions and wrote ETL flow documentation
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging area
• Importing source and target tables from their respective databases
• Created mappings using transformations likeSource Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Union and Normalizer
• UsedParameter filesto define values for parameters and variables used in a mappings
• Used workflow manager to create workflows, sessions, and also used various tasks like command
• Involved inPerformance tuningat various levels including Target, Source, and Mapping.
• Prepared unit test cases to meet the business requirements and performed unit testing of mappings.
• Provided SQL scripts to validate source to target validations
• Seamlessly migrated the code from DevelopmentàTestingàUATàProduction
• Worked on Informatica Debugger to identify root cause and do data fix. Also provided recovery plan for data loss
• Perform ETL Administrator jobs like maintaining Folder/User level Privileges Scheduling Jobs based on target system dependencies
• Worked on on-shore off-shore model being the only Datawarehouse developer on-shore
• Provided knowledge transfer and technical support in the production environment and hands-on mentoring in the use of Informatica.
• Efficient Documentation was done for all phases like Analysis, design, development, testing and maintenance
• Responsible for the assignment of tasks for the team members, communicating with the clients for creation of Metrics reports, weekly status reports, preparation of project plan and quality related documents & migration documents etc

Environment: Informatica PowerCenter 8.6/9.1, Oracle 11g, PL/SQL Developer, UNIX, CITRIX, Compass, PuTTy 0.58, Windows XP

Confidential, Detroit, MI

ETL Developer

Responsibilities:

• Interacting with customers to define business needs and translating them to system requirements
• Using PowerCenter Designer to design various plans to extract the data from SQL Server and Oracle
• Assist the ETL architect on the design of star schema, fact and dimension tables required for OLAP and reports in conjunction with ETL team
• Moved projects from development to production servers
• Managing requirements and reports that are requested from customers
• Writing scripts, functions and stored procedures using SQL or Oracle PL/SQL.
• Enhanced existing data model to respond to requirements set forth by the client. Modeled data and developed reporting on SQL Server database
• Develop SQL queries as needed against development and production databases for quick-response ad hoc reporting
• Migrated plans and tasks between repositories
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager
• Taking daily online Backups, weekly off-line Backups and frequent exports
• Troubleshooting and performance tuning which reduced several jobs from several hours to less than one
• Create functional and technical documentation for all reports, outlining processes to create an easily readable roadmap of all procedures for end users
• Create Oracle functions and stored procedures to supply comma-delimited lists and date information
• Performed unit testing at various levels of the ETL.

Environment: Informatica PowerCenter 8.6, Sagent Design Studio 5.5.1, SQL Server 2000, Oracle 10g, Windows XP

Confidential, Quincy, MA

Informatica Developer

Responsibilities:

• Involved In Design Specifications and Technical Sessions
• Involved in documentation and presentation of the methodology to the client
• Worked with Informatica Power Center tools - Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplets and Transformations to define source and target definitions and to create mappings between them
• Primarily involved in the loading of Orders and Sales data marts.
• Created Informatica ETL mappings that transfer data from Oracle and flat file source systems to the SQL Server Data Mart.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Used various tasks like Sessions, commands, Decisions, Timer, Control, Email, Event wait and Event Raise to arrange the tasks in the order and to satisfy business criteria
• Designed reusable components such as transformation, Mapplets, lookups and reusable objects sources and targets for ETL process
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor
• Used Debugger and breakpoints to view and edit transformations output and debug mappings
• Developed mapping to load data in slowly changing dimensions
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well
• Responsible for migrating mappings/workflows from Development to Test and Test to Integration environments.
• Perform the Informatica deployment Export / Import multiple objects, copy folder, copy deployment group from development to production repository using the Informatica repository Manager
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Performed unit testing at various levels of the ETL.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, SQL Server, PL/SQL, SQL*PLUS, Windows XP

Confidential, Reston, VA

Informatica Developer

Responsibilities:

• Attended Subject Matter Experts (SME) meetings for requirements gathering, created analysis/functional specifications. Performed the requirement.
• Designing and customizing data models for Data warehouse supporting data from multiple sources.
• Involved in performance tuning of SQL Queries, Sources, Targets and sessions.
• Prepared ETL design specification documents for developers with information on implementation of business logic. Specified job flow and allocated task and assisted the team.
• Worked Extensively with Expression, Lookup, Joiner, Sorter, Aggregator, Update Strategy, Stored Procedure, and Sequence Generator, Filter, Rank and Router transformations.
• Designed reusable components such as transformation, Mapplets, lookups etc and reusable objects sources and targets (shared folder) for ETL process.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Designed and executed Error and Exception handling processes and used Informatica Debugger for session failures.
• Extensively worked on Informatica tools like - Designer, Workflow Manager, Repository manager and Power Analyzer.
• Created complex mappings and also tuned for better performance.
• Developed UNIX Shell scripts to implement the ETL load and integration management process.

Environment: Informatica 8.6, Oracle 8i & 9i, MS SQL server2000, PL/SQL, Erwin, SQL*Loader, Windows NT, UNIX and SQL*PLUS