SUMMARY:

• Having around 7 years of experience in analyzing, designing, tuning, and developing Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), Informatica 9.x, SSRS
• Experience in Developing Informatica mapping, Sessions and workflows.
• Proficient in using Informatica to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Good understanding of life cycle Implementation for data warehouse.
• Proficiency in gathering business requirements, establishing functional specifications and translating them to design specifications.
• Experience in Data Modeling using Dimensional Data Modeling techniques such as Star Schema, Snowflake Schema.
• Implementing incremental loads and change Data capture.
• Experience in Performance tuning ETL code.
• Hands on experience working with various databases including Oracle and SQL Server.
• Experience in Administration activities like Creating and Managing Repositories, Users, User Groups, Folders and deployment groups.
• Knowledge in using UNIX and writing UNIX shell scripts.
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation.
• Extensive experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reports using SQL Server Reporting Services.
• Excellent in rendering reports, managing subscriptions, creating reports with report builder, report snapshot and report cache.
• Experience in scheduling and deployment of reports and uploading files to a report server catalog from the report manger.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
• Good knowledge of Computer Science theory & strong in modern programming languages.
• A well - organized, goal-oriented, highly motivated and effective team leader/member with excellent analytical, troubleshooting, and problem solving Skill.
• Excellent Verbal & Written Communication skills and strong in Documentation.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS:

Databases: SQL server 2008 R2, SQL Server 2012, MS Excel, Oracle 11g, DB2, Erwin 4.1.

Programming Languages: T-SQL, PL/SQL, C

Operating Systems: Windows 98/2000/2003/ XP/NT/Vista, Windows 2000 Advanced Server, Windows 2003 Enterprise Server, UNIX.

ETL Tools: Informatica PowerCenter 8.x, 9.x

IDE & BI Tools: SQL Server BI Development Studio (BIDS)

PROFESSIONAL EXPERIENCE:

Confidential

Informatica, Oracle Developer, Rockville, MD

Responsibilities:

• Develop appropriate ETL routines and mappings using Informatica based on the requirements and technical design.
• Develops complex applications that combine data from various sources, tailored to specific business needs.
• Coordinate and develop process automation/job scheduling, perform testing and defect analysis.
• Work with Business Intelligence leadership team to develop and enhance ETL development process to meet the needs of the business and reduce risk.
• Participate in design sessions with ETL developers, report developers, DBAs and Business Analysts.
• Participate in and facilitate design, code, unit test review sessions as needed
• Responsible for choosing proper partitioning methods for performance enhancements.
• Involved in unit testing of mappings, mapplets also involved in integration testing and user acceptance testing.
• Scheduling the sessions to extract, transform, and load data in to warehouse database on business requirements. Involved in reviewing and approve existing ETL jobs.
• Created sessions, database connections Responsible for scheduling, monitoring and supporting production ETL jobs.
• Involved in writing shell scripts for load data and process data.
• Involved in writing shell scripts to schedule, automate the ETL jobs.
• Used Parameter files in mappings and sessions
• Involved in creating and managing repositories.
• Involved in unit, integration and user acceptance testing of ETL Applications.

Environment: - Informatica Power Center 9.6.1, Oracle 11g, UNIX, Autosys, SQL Server 2012

Confidential

Informatica, Oracle Developer, Minneapolis, MN

Responsibilities:

• Interact with business users and System analysts to conform data sources into target tables. Conducted peer design reviews.
• Worked with heterogeneous sources from various channels like Oracle, SQL Server, DB2, flat files.
• Created complex and robust mappings and mapplets.
• Used different transformations such as Joiner, Look-up, Rank, Expressions, Aggregator and Sequence Generator
• Involved in Fine-tuning SQL overrides for performance Enhancements.
• Extensively used ETL Tool Informatica to load data from Flat Files, Mainframe Files and DB2 and developed reusable Mapplets and Transformations and designed data Mappings between source systems and warehouse components using Mapping Designer.
• Responsible for choosing proper partitioning methods for performance enhancements.
• Involved in unit testing of mappings, mapplets also involved in integration testing and user acceptance testing.
• Scheduling the sessions to extract, transform, and load data in to warehouse database on business requirements. Involved in reviewing and approve existing ETL jobs.
• Created sessions, database connections Responsible for scheduling, monitoring and supporting production ETL jobs.
• Involved in writing shell scripts for load data and process data.
• Involved in writing shell scripts to schedule, automate the ETL jobs.
• Used Parameter files in mappings and sessions
• Involved in creating and managing repositories.
• Involved in unit, integration and user acceptance testing of ETL Applications.

Environment: - Informatica Power Center 9.6.1, Oracle 11g, UNIX, Autosys, SQL Server 2012

Confidential

Informatica, Oracle Developer, Minneapolis, MN

Responsibilities:

• Interact with business users and middleware team to conform data sources
• Created complex and robust mappings and mapplets.
• Used different transformations such as Joiner, Look-up, Rank, Expressions, Aggregator and Sequence Generator
• Involved in Fine-tuning SQL overrides for performance Enhancements.
• Extensively used ETL Tool Informatica to load data from Flat Files, Mainframe Files and DB2 and developed reusable Mapplets and Transformations and designed data Mappings between source systems and warehouse components using Mapping Designer.
• Responsible for choosing proper partitioning methods for performance enhancements.
• Involved in unit testing of mappings, mapplets also involved in integration testing and user acceptance testing.
• Scheduling the sessions to extract, transform, and load data in to warehouse database on business requirements. Involved in reviewing and approve existing ETL jobs.
• Created sessions, database connections and batches using Informatica server manager. Responsible for scheduling, monitoring and supporting production ETL jobs.
• Involved in writing shell scripts for load data and process data.
• Involved in writing shell scripts to schedule, automate the ETL jobs.
• Scheduled and monitored transformation processes using Informatica server manager.
• Used Parameter files in mappings and sessions
• Involved in creating and managing repositories.
• Involved in creating Ad-hoc and summarized reports.
• Involved in unit, integration and user acceptance testing of ETL Applications.

Environment: - Informatica Power Center 9.5, Oracle 11g, UNIX, Autosys, Erwin

Confidential

Informatica, Oracle Developer, Eagan, MN

Responsibilities:

• Involved in developing mappings to populate data from various Source Systems like flat files, SQL Server, Oracle to the single data warehouse
• Experience in using Mapping Parameters/Variables and Parameter files for connections to different databases
• Extensively worked with SQL Querying tool namely, Rapid SQL for unit testing, creating DDL scripts etc
• Created reusable Transformations, User-defined Functions, Mapplets and Sessions
• Highly adaptive with Version Control environment in DEV, QA and UAT environment
• Highly involved in creating Type1 and Type2 Slowly Changing Dimension Mappings using Informatica PowerCenter Designer ver. 9.0.1
• Used PL/SQL scripts to drop and create columns on the Target tables for Oracle
• Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Stored Procedure, Router, Sorter, Rank, Update Strategy, Expression, Router and Normalizer
• Worked with Informatica Shortcuts in order to maintain the consistencies in the Sources and Targets throughout the Informatica Mappings
• Using Informatica Power Exchange to connect to Main Frame data sources.
• Worked with Informatica Debugger in order to debug the mapping and session and to find the bottlenecks in the mappings
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions
• Created and Executed workflows and Worklets using Workflow Manager to load the data into the Target Database
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters

Environment: - Informatica Power Center 9.1, Oracle 11g, UNIX, Autosys, DB2

Confidential

Team Member

Responsibilities:

• Developing mappings in Informatica.
• Loading Data to Staging Area.
• Loading Data to Data warehouse from staging.
• Tuning mappings and workflows to improve system performance.
• Designing Informatica Design Doc.
• Designing and developing unit test cases.

Environment: - Informatica Power Center 8.5, Oracle 10g, UNIX, DB2, Control M

Confidential

Team Member

Responsibilities:

• Developing mappings in Informatica.
• Loading Data to Staging Area.
• Loading Data to Data warehouse from staging.
• Tuning mappings and workflows to improve system performance.
• Designing Informatica Design Doc.
• Designing and developing unit test cases.

Environment: - Informatica Power Center 8.1, Oracle 10g, UNIX, Sql Server 2008, Autosys