SUMMARY

• Over 7 years of professional experience as a software developer in analysis, design, development, testing and implementations of Business Intelligence solutions using Data warehousing and ETL Informatica Power Center.
• Experience in working with different versions of Informatica Power Center such as 9.1/8.x/7.x.
• Working experience on ETL tools includes Admin Console, Repository Manager, Designer, Workflow manager, and Workflow monitor.
• Strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data Warehousing using Windows and UNIX.
• Extensive experience in integrating data from various Heterogeneous sources like Relational database (Oracle, SQL Server, DB2), Flat Files (Fixed Width and Delimited), COBOL files, XML Files and Excel files into Data Warehouse and Data Mart.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads
• Knowledge in implementing and enhancing complex SQL queries, Stored Procedures, packages, functions and triggers.
• Experience in development and designing of ETL methodology for supporting data transformations (DT/Studio).
• Strong experience to the entire Software Development Life Cycle.
• Experienced in Inmon and Kimball Methodology
• Experience in working with business analysts to identify, review and understand requirements and translate them into ETL code.
• Experienced in designing and maintaining UNIX shell scripts.
• Knowledge in using Business Intelligence tools like Cognos, Web Focus.
• Excellent verbal and written communication skills.
• Excellent troubleshooting and debugging skills to understand data inconsistencies.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.x/8.x/7.x (Repository Manager, Designer, Workflow Manager, Admin console, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer,), DT/Studio, Informatica PowerExchange

Methodologies: Dimensional Data Modeling (ERD), Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

Languages: SQL, PL/SQL, C, C++, HTML, XML, Unix shell scripting

Tools: Toad, Erwin, SQL Developer, WebFocus, Cognos, Autosys

Database: Oracle 8i/9i/10g/11g, DB2, MS SQL Server 2003/2005/2008

Operating Systems: Windows 7/Vista/XP/2000/NT/98/95, UNIX, MS DOC

PROFESSIONAL EXPERIENCE

Confidential, Bostan, MA

Sr. Informatica Developer

Responsibilities:

• Major involvement in creating and tuning the mappings, to perform maximum efficiency and performance complete knowledge of session properties in Work flow monitor
• Created update strategy and stored procedure transformations to populate targets based on business requirements.
• Designing and developing based on the methodologies like Inmon and Kimball
• 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.
• Working with DT studio for transformations
• Built - in mapping variable / parameters and created parameter files for imparting flexible runs of sessions / mappings based on changing variable values.
• Working with XML and XML Schema Definitions (XSD)
• Design and developing data warehouse and data marts.
• Designed the ETL processes using Informatica to load data from Flat Files, XML Files and Excel files to Oracle Staging area.
• Designed and developed Mappings with various transformations such as Connected and Unconnected Lookup, XML Source Qualifier, Filter, Joiner, Router, Stored Procedure, Sorter, Expression, Aggregator.
• Used Change Data Capture (CDC) to implement Incremental Data Extraction so that only the modified and new records will be extracted to the destination rather than full extraction
• Worked with Business Analysis team in gathering the requirements and created Functional and ETL specification documents.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Loaded operational data from Oracle, Sql server, flat files, Excel Worksheets into various data marts.
• Implemented Slowly Changing dimension type2 methodology for accessing the full history of accounts and transaction information.
• Used Informatica to create and organize various Metadata types, including legacy Source and Data warehouse Target data definitions and ETL jobs.
• Created Tasks and Workflows using Task Manager and Workflow Designer
• Also developed numerous Stored Procedures, Triggers and common functions using PL/SQL.

Environment: Informatica Power Center 9.1/8.6, Work Flow Manager, Oracle 10g, SQL Server 2008, Oracle, DB2, Erwin, TOAD, XML, UNIX Shell script.

Confidential, St Louis, MO

ETL Consultant

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star and Snowflake Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Used Debugger to test the mappings and fixed the bugs.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 8.6.1, Informatica Power Connect / Power Exchange, Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, ERWIN, Autosys, SQL Server 2005, UNIX, Toad 9.0, Cognos 8.

Confidential, Kansas City, MO

Informatica Developer

Responsibilities:

• Preparing Transformation Specifications for mappings and understand existing File Specifications and design Specifications.
• Worked on Informatica Power Center 8.6.1 - Used Source Analyzer and Warehouse designer to import the source and target database schemas and the Mapping Designer, Mapplets and Transformation Developer to map the sources to the target.
• Developed complex mappings to implement the business rules and logic using Expression, Lookup, Filter, Joiner, Rank, Router, Sequence Generator, Normalizer and Update Strategy transformations and tuned for better performance.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.
• Created mappings to extract, transform & load data from different sources using various Transformations.
• Extracted data from mainframe COBOL files converted to files and MQ Series data to XML format using Informatica PowerExchange.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Performed tuning and optimization on SQL queries using Analyze, Explain Plan and optimizer hints.
• Created and scheduled workflows thereby combining sessions for individual units.
• Dimensional Data modeling after determining the business rules.
• Imported data from various Sources (Oracle, fixed width flat files) transformed and loaded into Targets
• Worked on Informatica Power center to map the source data into the target star schema.
• Created PL/SQL scripts for data transformation in line with program specifications.
• Creating temporary tables and indexes for loading and updating data.
• Assisting the testing team in System Integration Test of the ETL application.

Environment: Informatica Power Center 8.6.1, Informatica Power Exchange, Oracle 10g, Flat files, VSAM, MS Series, SQL*Plus, TOAD, PL/SQL, ERWIN, UNIX.

Confidential, San Diego, CA

Informatica Developer

Responsibilities:

• Involved in designing Source to Target mapping documents and loading strategies as a part of requirements gathering.
• Worked with Kimball's Data Modeling concepts including data modeling, data marts, dimensional modeling, star and snowflake schema, fact aggregation and dimension tables, slowly changing dimensions and surrogate keys.
• Designed the procedures for getting the data from many source systems to Data Warehouse.
• Developed mappings using Mapplets & various sources involving flat files, XML files and Relational tables.
• Extensively used ETL to load Flat files, XML files, Oracle and legacy data as sources and Oracle, Flat files as targets.
• Worked extensively with complex mappings using expressions, aggregators, filters, and lookups.
• Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Involved in writing procedures, functions in PL/SQL.
• Designed and developed UNIX Shell scripts to report job failure alerts.
• Worked with Data Quality group to identify and research data quality issues.
• Coding, Debugging and sorting the time-to-time technical problems.
• Extensive experience in Performance Tuning -Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Involved in Unit testing, System testing and UAT to check data consistency.
• Scheduled Informatica Jobs through Autosys scheduling tool.
• Involved in designing the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) in Oracle as per business requirements using ERWin.
• Extensive experience in Oracle Packages, Stored Procedures, Functions and Database Triggers using PL/SQL.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Supporting daily loads and work with business users to handle rejected data.
• Used shell scripts to pre-process data in UNIX.
• Used version control to check in and checkout versions of objects.
• Worked on SQL tools like TOAD to run SQL Queries to validate the data.

Environment: Informatica Power Center 8.6, Oracle 10g, PL/SQL, DB2 9.0, Autosys, MS SQL Server, Oracle SQL developer, Flat Files, IP Switch, ERWIN, UNIX shell script.

Confidential

ETL Developer

Responsibilities:

• Requirement gathering, analysis and designing technical specifications for the data migration according to the business requirement.
• Developed logical and physical dimensional data models using ERWIN.
• Designed, developed and improved complex ETL structures to extract transform and load data from multiple data sources into data warehouse and other databases based on business requirements.
• Developed complex mappings and SCD Type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router, Stored Procedure, XML and SQL transformations.
• Responsible for testing, modifying, debugging, documenting and implementation of Informatica mappings.
• Performed metadata validation, reconciliation and appropriate error handling in ETL processes.
• Developed test cases and test plans to complete the unit testing. Support System testing.
• Planned and coordinated testing across multiple teams, tracked and reported status, created testing cycle plan, scenarios etc.
• Troubleshoot data issues, validated result sets, recommended and implemented process improvements.
• Responsible for performance tuning in Informatica Power Center at the Target Level, Source level, Mapping Level, Session Level, and System Level.
• Used Informatica Data Explorer (IDE) tools for Data Analysis / Data Profiling and Data Governance.
• Used Informatica Power Exchange for loading/retrieving data from mainframe system.
• Extensively worked with incremental loading using Parameter Files, Mapping Variables and Mapping Parameters.
• Developed user defined functions (UDF) to extract data from flat files
• Developed and modified UNIX shell scripts to meet the requirements after the system modifications andwas also involved in monitoring and maintenance of the batch jobs.

Environment: Informatica Power Center 8.6, Informatica Data Explorer, Power Exchange, Oracle 10g, Toad, PL/SQL, SQL*Plus, DB2, MS SQL Server 2008, Erwin, Windows XP, Unix.

Confidential, Connecticut

Informatica Developer

Responsibilities:

• Participated in Requirement Gathering, Business Analysis and User meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Designed and developed Informatica mappings based on requirements.
• Analysis, Design and Development, testing and implementation of Informatica transformations and workflows for extracting the data from the multiple sources.
• Extensively used Informatica client tools-Designer, workflow manager and workflow monitor.
• Extracted the data from Oracle, DB2, Flat files and load the data in to Teradata database.
• Worked extensively on different types of transformations like Source Qualifier, Expression, Java Transformation, Aggregator, Router, filter, Update strategy, look up, Normalizer, stored procedure.
• Written and modify SQL override in many mappings according to business requirements
• Used mappings parameters and variables for code reusability.
• Identified the performance bottlenecks and tuned Informatica mappings for better performance.
• Tuned Sessions Performance by partitioning the data flow in mappings to improve the performance.
• Checked session and error logs to troubleshoot problems, and also used debugger for problem troubleshooting.
• Assisted reports team to generate reports required for business users.
• Established automatic email notifications to the concerned persons.
• Worked on FTP connections to move the file to remote servers.
• Scheduled workflows for daily, weekly and monthly loads.
• Providing status on a weekly basis to the team.

Environment: Informatica Power Center 8.1/7.3, DB2, Oracle 9i, SQL, PL/SQL, Flat files, COBOL, UNIX Shell Script, Web Focus.

Confidential

Informatica Administrator

Responsibilities:

• Create and manage Users, Groups and Folders. Ensure appropriate privileges are assigned to the different users.
• Debug the sessions by utilizing the logs of the sessions.
• Deployment /Migrations of Repository folders and objects from Development to Test and from Test to Production environment.
• Interact with UNIX and Database Administrators to create and maintain each Power Center instance.
• Independently perform complex troubleshooting, root-cause analysis and solution development.
• Interact with end users to resolve issues with Informatica Power Center entities.
• Coordinate with Informatica support for patches and bug fixes.
• As per Change requests (CR) migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Managing Nodes, Domains, Repository services and Integration services.
• Creation and backup, restore for Informatica Repositories.
• Worked with UNIX / DB2 DBA team related to OS and Database related issues.
• Modified and Tested UNIX Shell scripts and necessary Test plans to ensure the successful execution of the data loading process.
• Monitoring the workflows, sever space availability and CPU Process.

Environment: Informatica Power Center 7.1.3, Oracle 8i, Toad, MS SQL Server 2003, Flat files, UNIX.