SUMMARY

• 8+ years of IT experience in Analysis, Design, Development, Implementation, Testing, Performance tuning and Production Support of Data Warehousing and Data Integration Solutions using Informatica Power center and Oracle.
• Extensive experience with ETL Informatica PowerCenter 9.x/8.x/7.x, Informatica PowerExchange 9.x/8.x, Informatica Administrator 9.x, Datawarehouse Administration console (DAC) and databases Oracle, SQL Server and Teradata.
• Expert in all phases of Software development life cycle (SDLC) - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance using waterfall and Agile/Scrum methodologies.
• Strong experience with Shell Scripting in UNIX and LINUX, SQL, PL/SQL Coding & scripting.
• Solid experience in Informatica PowerCenter Client tools (including Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables) used in relational, dimensional and multidimensional modeling.
• Created ETL mappings using Informatica PowerCenter to move Data from multiple non-relational sources like Flat files, XML files, Mainframe Files and relational source systems such as Oracle, Teradata, SQL Server and DB2 into a common target area such as Staging, Data Warehouse and Data Marts.
• As an Informatica Administrator, I have good Experience in Informatica Installation, upgrade, User creation and Assign the roles, ETL Code back up, Version Control and ETL Code Migration.
• Good experience with Informatica PowerExchange to read files (GDG, VSAM) from mainframe system.
• Vast experience in Datawarehouse Administration Console (DAC) - creating Tasks, Task groups, Subject areas, Execution plans and scheduling execution plans.
• Hands on Solid experience in Performance Tuning of source, target, mappings, transformations and sessions.
• Experience in Data-warehouse architecture (Conceptual, logical, and physical), defining solutions (Dimensional Modeling) and implementing.
• Well versed with Ralph Kimball and Bill Inmon methodologies. Hands on Experience in building effective Data warehouse and Data Marts.
• In depth knowledge on OBIA product which is from Oracle.
• Excellent experience on implementing Change Data Capture(CDC)techniques and slowly changing Dimensions (SCD)-Type I, II & III.
• Experience in using the Informatica Utilities like Pushdown optimization, Partitions.
• Strong experience in complex PL/SQL procedures, packages, functions, cursors, triggers, views, materialized views.
• Extensive knowledge of Data Modeling, Data Conversions, Data Integration and Data Migration with specialization in Informatica Power Center.
• Played different roles like Developer, Sr. Developer, Module Leader and Onsite Offshore Coordinator.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x, Informatica PowerExchange 9.x/8.x

Administration Tools: Informatica Administrator 9.x, Datawarehouse Administration Console

Databases: Oracle 9i/10g/11g, MS SQL Server 2005/2008, Teradata

Operating Systems: Windows, Unix, IBM-AIX, Linux.

Languages: SQL, PL/SQL, UNIX Shell & Perl Scripting.

Schedulers: Informatica Scheduler.

Database Tools: TOAD, Oracle SQL Developer

Other Tools: Putty, WinScp, Microsoft Visio, MS Office tools

PROFESSIONAL EXPERIENCE

Confidential, Ann Arbor, Michigan

Sr. ETL Informatica Developer & Administrator

Responsibilities:

• Attending Daily scrum calls to discuss what we worked on yesterday, what we will work on today, roadblocks, and issues as this project is following agile process.
• Requirements gathering - Involved in all the discussions with the client during requirements phase.
• Understanding functionality of the existing system.
• Analyzing business requirements and converting the business level requirement into the Technical design specifications.
• Preparing HLD and LLD documents.
• My main responsibility is to analyze, design and develop ETL strategies, resolve issues related to data warehouse.
• As a Technical Lead, I am responsible for performing all the POC’s for any new processes or technologies we are bringing into the application. Have performed many Technical POC’s which went on very well.
• Assigning tasks to offshore team with defined priority by client and then performing unit testing and code review on a regular basis.
• Consumed data from different source systems like Oracle, Teradata and Flat files.
• Implemented SCD-Type1, Type2 to maintain current and history data in Dimension tables.
• Creating tasks, subject areas, execution plans and Scheduling execution plans in DAC.
• Identifying performance issues in the code and tuning it to complete the jobs within the given SLA time.
• Performance tuning at Informatica and database levels depending on the bottlenecks identified with the jobs.
• Have developed PL/SQL procedures, views and Materialized views that are required for an application based on the Requirement.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Working with the testing team to resolve bugs related to day one ETL mappings before production.
• Maintaining ETL release document for every release and migrating the code into higher environments through deployment groups.
• Creating change request before deploying the code into production to get required approvals from business.
• As an Informatica Administrator, I am responsible for creating and managing users, roles and privileges, project related folders and folder security and connections.
• Also deploying the code into higher regions and taking backups on regular basis to recover from major system disasters.
• Managing the complete code deployment (ETL & DAC) process and the post deployment validation in Test, QA, and production environments.
• Successfully migrated Informatica PowerCenter from 9.0.1 to 9.5.1 in all regions (Dev, Test, QA and Prod)
• Maintains ETL and DAC servers and restart the services when it goes down.
• Creating weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Works with production support team when failure occurs to rectify them.

Technologies: Informatica PowerCenter 9.5.1/9.0.1 , Informatica Administrator, Datawarehouse Administration Console 10g, Oracle 11g, PL/SQL, Toad for Oracle, Oracle SQL Developer, Putty, JIRA, CA7 scheduling, UNIX shell scripting.

Confidential, Bloomfield, CT

Sr. ETL Informatica Developer

Responsibilities:

• Interaction with Business SME’s on requirement gathering, understanding the business and functional requirements.
• Involved in project planning, development, assign tasks to various team members and tracking their activities.
• Used Informatica for extract, load and transform operations. Participated in design and movement of data from the operational and external environments to the business intelligence environment.
• Designed and developed Informatica mappings to build business rules to load data.
• Extensively worked on Informatica Lookup, Aggregator, Joiner, Expression, Stored Procedure and Update Transformations to implement complex rules and business logic.
• Developed complex Informatica ETL jobs to migrate the data from flat files to database.
• Involved in Project efforts estimation.
• Implemented SCD-Type1, Type2 to maintain current and history data in Dimension tables.
• Preparing the technical specification and design documents.
• Extracted source definitions from databases like oracle, Flat files and Mainframe files into the Power center repository.
• Created copy books and Data maps for mainframe sources using PowerExchange and imported them into Informatica designer.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Importing Source/Target tables from the respective databases and created reusable transformations and mappings using Designer Tool set of Informatica.
• Involved in the Performance Tuning & Preparation of unit test cases.
• Involved in QAT, UAT reviews and deployment activities.
• Co-coordinating with offshore teams for the deliverables.
• Conducting reviews with Business SME’s for the design, Code, Unit Test Plan and cases
• Validated data after database migration from Oracle to Teradata.
• Involved in requirements analysis and design and also source system analysis to derive the business logic, validation of data mappings for enhancement releases.
• Coding Oracle PL/SQL Stored Procedures, Functions and Packages
• Creating and modifying existing workflows in Informatica for new requirements.
• Analyzing the Defect Resolution document for implementation of the requirements.
• Developing database scripts for each release and deploying them using WorkBench.
• Involved in application support until it is completely stable in Production.
• Involvement in code deployment and post production deployment activities.
• Tracking and fixing the defects being raised in previous releases.
• Carrying impact Analysis for the changes made in source system and implementing the required changes in target DW environment.

Technologies: Informatica PowerCenter 9.5.1, PowerExchange 9.5, Oracle 11g, Teradata, Toad for Oracle, Putty, HP ALM, CA7 scheduling, UNIX shell scripts, Ipswitch WS FTP Professional, Harvest version control tool, MS Office tools.

Confidential, NYC, NY

ETL Informatica Developer

Responsibilities:

• Involved in requirements analysis and design and also source system analysis to derive the business logic, validation of data mappings for enhancement releases.
• Responsible for designing the ETL Processes/reports and managing the ETL development efforts in the project.
• Data Extraction, Transformation and Loading from Source to Target using Power Informatica Power center
• Extracted source definitions from databases like oracle and Flat files into the Power center repository.
• Troubleshoot loading failure cases, including database problems.
• Code migration from development to QA and production environments.
• Involved in database testing, writing complex SQL queries to verify the transactions and business logic.
• Extracted data from various source systems like Oracle and flat files as per the requirements and loaded it to SQL Server.
• Consumed data from different non-relational source systems like csv files and XML files.
• Implemented SCD-Type1, Type2 to maintain current and history data in Dimension tables.
• Involved in Unit, Functional, Integration and System testing and preparation review documents for the same.
• Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Importing Source/Target tables from the respective databases and created reusable transformations and mappings using Designer Tool set of Informatica.
• Involved in the Performance Tuning & Preparation of unit test cases
• Resolving if any issues in transformations and mappings.
• Estimating the time lines for implementing the enhancement
• Defect fixes related to current/previous releases.
• Carrying impact Analysis for the changes made in source system and implementing the required changes in target DW environment.

Technologies: Informatica PowerCenter 9.5.1/8.6.1 , MS SQL Server 2008, Oracle, Putty, HP ALM, MS Office, Unix Shell Scripting.

Confidential, Richmond, VA

ETL Informatica Developer

Responsibilities:

• Requirement Gathering - Involved in all the discussions with the client and onsite coordinator during requirements phase.
• Understanding functionality of the existing system.
• Analyzing business requirements.
• Day to day interaction with business for the requirements and Q&A.
• Developing the code as per given STM and doing code review of other team members.
• Implemented SCD-Type1, Type2 to maintain current and history data in Dimension tables.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Created copy books and Data maps for mainframe sources using PowerExchange and imported them into Informatica designer.
• Performing unit testing for the designed code.
• Preparing design documents and unit test script for the designed code.
• Maintaining daily tasks tracker sheet with all the task details and its status.
• Identifying performance issues on the code which are performing badly and tune them to complete the jobs within the given SLA time.
• Designing CA7 job templates for scheduling the jobs in production environments.
• Preparing code migration documents and migrating the code to higher environments using Harvest.
• Working with the testing team to resolve bugs related to day one ETL mappings before production.
• Developing/modifying the production support guide as per the latest code.
• Monitoring the jobs in production and updates support tracker sheet on a daily basis with required details.

Technologies: Informatica PowerCenter 8.6.1, Informatica PowerExchange 8.6, Oracle 10g, Toad for Oracle, Putty, HP ALM, CA7 scheduling, UNIX shell scripts, Ipswitch WS FTP Professional, Harvest, MS Office.

Confidential, Bloomington IL

ETL Production Support

Responsibilities:

• Analyzed the existing systems and made Feasibility Study.
• Wrote and reviewed documents like User Data Sheet (UDS), Functional Specifications (FS), and ETL Specifications.
• Established standard code migration process.
• Extracted data from a wide variety of Sources like Flat files, XML files, Relational Databases (Oracle, SQL Server).
• Involved in creation of Informatica mappings to build business rules to load data using transformations like Source Qualifier, Expression, Aggregator, Lookup, Filter, Router, Update Strategy, Normalizer, Stored procedure, and Sequence generator transformations.
• Developed transformation logic to cleanse the source data for inconsistencies in source to staging area mappings.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads.
• Developed slowly changing dimension mappings (Type 1 & Type 2).
• Defined Target Load Order Plan for loading data into Target Tables.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.
• Created UNIX shell scripts to handle pre and post session tasks, and to ftp files on to Informatica server.
• Created and tested shell scripts to automate Job scheduling by using commands like pmcmd.
• Involved in different phases of testing like Unit, Functional, Integration and System testing.
• Creation of Review documents for specification document and test cases.
• Performance tuning of targets, sources, mappings and sessions.
• Troubleshoot loading failure cases, including database problems.
• Code migration from development to QA and production environments.
• Knowledge working with web services transformations in Informatica.
• Knowledge working with SOAP, WSDL files.
• Resolving production issues.
• Developed and tested stored procedures, functions and packages in PL/SQL.
• Involved in database testing, writing complex SQL queries to verify the transactions and business logic like identifying the duplicate rows by using SQL Developer and PL/SQL Developer.

Technologies: Informatica Power Center v9.1.0,Windows-XP (Client), Oracle 11g, SQL Server 2008 R2, Informatica servers on Unix, SQL Developer, PL/SQL Developer, SSH (Secure Shell), Textpad, UltraEdit.

Confidential, NJ

Database Developer

Responsibilities:

• Participated in business requirement walk through, design walk through and analyzed Business requirements.
• Performed Verification, Validation, and Transformations on the Input data before loading into target database.
• Involved in designing the process flow for extracting the data across various systems.
• Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, Mapplets, connected and unconnected stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers.
• Extensively used ETL processes to load data from various source systems such as SQL Server, Teradata and Flat Files, XML files into target system SQL Server by applying business logic on transformation mapping for inserting and updating records when loaded.
• Using the Power Exchange for Change Data capture (CDC) option to capture the data whenever the inserts, updates, and deletes underlying these events as soon as they occur and transfer in to multiple targets without intermediate queues or staging tables
• Extensively used Informatica Workflow Manager and Workflow Monitor to develop, manage and monitor workflows and sessions.
• Used the database partitioning and Informatica partitioning for better performance when working with the huge data.
• Responsible to design, develop and unit test the mappings.
• Migration from DEV to QA using Repository Manager.
• Performed Unit and Integration Testing and validates results with Business Analyst and end users.
• Documented each stage of the project and attended status meeting every week.

Technologies: Informatica 8.6, Erwin 4.0, SQL Server 2008 R2, Oracle 11g, SQL, PL/SQL, Toad, Teradata.