SUMMARY

• 9 Years of IT Experience in Software Design, Development, Testing and Deployment using SDLC life cycle.
• Having good experience in designing and implementing the Data Warehouse applications, mainly Transformation processes using ETL tool Informatica Power Center 9.6/9.1/8.6/ 8.1 , DMExpress.
• Experience in various phases of IT projects Software Development Life Cycle (SDLC) such as analysis, design, coding, testing and deployment.
• Extensively used Informatica for ETL purposes on various sources and targets like Flat files, Oracle 10g, SQL Server 2012, sales force and DB2.
• Extensively used DMExpress tool to migrate the workflows developed in Informatica in to DMExpress.
• Extensive hands - on expertise using Informatica Power Center with strong business understanding (domains) of Insurance, Automotives, Healthcare, Banking and financial services.
• Extensively worked with various components of the Informatica Power Center - Power Center Designer (Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation developer), Repository Manager, Workflow Manager, and Workflow Monitor to create mappings, tasks and workflows for the extraction of data from various source systems to targets.
• Experience in implementing complex business rules by creating re-usable transformations, and robust mappings/mapplets using different transformations like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure and Normalizer etc.
• Proficient in full life cycle development of Data Warehousing, ETL strategies, reporting and hands-on experience in Performance Tuning of sources, targets, transformations, mappings, sessions & Index Usage, Aggregate Tables, Load strategies & commit intervals.
• Extensive experience in integrating data from various Heterogeneous sources like Relational databases (Oracle, SQL Server), Flat Files (Fixed Width and Delimited) into Data Warehouse and Data Mart.
• Extensively worked on Development, Enhancement and migration projects.
• Experience in PL/SQL Programming (Stored procedures, Triggers, Functions and Packages) and UNIX shell scripting.
• Good experience in documenting the ETL process flow for better maintenance & analyzing the process flow.
• Good knowledge in administration tasks including importing/exporting Informatica objects, versioning to maintain objects history.
• Developed complex mappings, SCD type-I and Type-II mappings in Informatica to load the data from various sources using different transformations & created mapplets for reusable purposes.
• Strong in Data warehousing concepts, dimensional Star Schema, Snowflakes Schema methodologies.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x, Informatica Power Exchange, DMExpress 6.9

Data Modeling Tool: Dimensional Data Modeling using Star Schema Modeling, Snowflake Modeling, Fact tables and Dimensions Tables, Physical & Logical Data Modeling, Visio tool, ERWIN 4.0

Databases: Oracle 10g/9i, DB2 9.5, SQL Server 2012/2008

Languages: SQL, PL/SQL, UNIX Shell Script, C, C++

Development Tools: SQL *Plus, TOAD, SQL Developer, Putty, HP Quality Center SQL Server management studio

Scheduling Tools: Tivoli, Autosys, Control M, Informatica Scheduler

Operating Systems: Windows XP/NT/2008, UNIX

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr. Informatica Consultant

Responsibilities:

• Proficient in understanding business processes/requirements and translating them into technical requirements
• Understanding the Business Requirements and Develop an ETL process to load data from source to target.
• Created ETL mappings using Informatica Power Center to move Data from sources like flat files, databases, loaded into Oracle, SqlServer.
• Created ETL mappings & Mapplets for various layer of data loads like Staging, DWH, Data Mart.
• Reviewed the mappings, sessions and workflows for ETL standards.
• Involved in review of detailed Design document, LLD, HLD & Unit Testing of Code.
• Prepared Unit Test/ Assembly Test cases and executed unit test cases successfully
• Created the sample Files for SIT and Tested in SIT Environment.
• Supported during QA/UAT/PROD deployments and bug fixes.
• Involved in code Reviews as per ETL/Informatica standards.
• Monitoring ETL loads using Tivoli.
• Used PMCMD, and UNIX shell scripts for workflow automation.
• Parameterized the mappings and increased the re-usability
• Created and defined DDL’s for the tables at staging area.
• Used code debugging at mapping level and did enhancements.
• Maintained the Defect Tracking and fixed the Defects.
• Responsible for creating shared & reusable objects in Informatica shared folder and update the objects with the new requirements and changes.
• Setting up and coordinating meeting with Offshore and business users.
• Provide end to end Knowledge Transfer to Offshore team.
• Scheduled daily status and weekly status meetings with offshore and client.
• Provide end to end Knowledge Transfer to Offshore team.

Environment: Informatica Power Center 9.6, SQL Server 2012, Flat Files, Power Exchange, HP Quality Center, Tivoli.

Confidential, Minneapolis, MN

Sr. Informatica Consultant

Responsibilities:

• Extensively involved in all phases of Project life cycle right from Requirements Gathering to Testing etc.
• Coordinated with Client SMEs and offshore team to get the requirements and get the code delivered in timely manner and with high quality and performance.
• Worked on coming up with templates for Source to Target Document, ETL Detail Design Document, Unit Test Plan, Code review checklist, Migration Check List and Production Handoff document.
• Developed and scheduled Workflows using task developer & workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Rank, Sequence Generator, Update Strategy for data integration.
• UsedInformaticaPower Exchange for loading/retrieving data from mainframe systems.
• Involved in peer reviews of the code to ensure all the standards are implemented and tuned mappings in order to bring down the run time by using Informatica partitioning if needed.
• Performed thorough Unit testing & Integration testing using sample data from PROD, once the code is reviewed and met the standards, promoted to higher environments.
• Supported in UAT testing & fixed the defects and thoroughly tested them back & promoted to UAT for further testing.
• Responsible for migration and deployment of folder or mappings and sessions from development to QA environment.
• We constantly monitored the cycle run times and looked into the long running jobs and did performance tuning in order to meet the SLAs.
• Scheduled & ran Extraction-Load process & monitored tasks/workflows using the Workflow Manager and Workflow Monitor.
• Troubleshoot problems by checking sessions/error logs in the Workflow Monitor and also used debugger in Mapping Designer to debug complex mappings.
• Used the client tools (Ivalidator, dbView and db compare) to validate the informatica objects and compare the source and target data.
• Maintained all standards & implemented the best practices in our development process.
• Scheduled and Monitored the ETL jobs using Autosys.

Environment: Informatica Power Center 9.6, Informatica Power Exchange, Mainframe, DB2, SQL Server 2012, Cognos, HP Quality Center, Autosys.

Confidential, Denver, CO

Sr. Informatica Consultant

Responsibilities:

• Understand the Business Requirements in depth.
• Analyze the requirements of the business users by using ETL Specifications.
• Developed Entity Level, High level & Detail design documents based on requirement documents.
• Understanding the Business Requirements and Develop an ETL process to load data from source to target.
• Worked with Source Analyzer, Target Designer, Transformation developer, mapping designer, Mapplet designer, Workflow Manager and Workflow Monitor.
• Developed Informatica Mappings and Sessions based on business user requirements and business rules to migrate data from source reports & Oracle tables to flat files.
• Did performance tuning at source, transformation, target, and workflow levels.
• Parameterized the mappings and increased the re-usability.
• Used the transformations such as the Source Qualifier, Aggregator, Expression, Lookup, Sequence Generator, Normalizer, Union, Filter and Update strategy.
• Debug the mappings in Informatica Designer tool to test and fix errors in the mappings.
• Created PL/SQL procedures to enable and disable the users while running the jobs and to load the data in control tables.
• Tuned the SQL queries used in the SQL override, Lookup Override of the Source Qualifier and Lookup transformations.
• Understand the existing complex unix shell scripts and do the required changes as per the requirements.
• Prepared the assembly test cases to perform the testing at E1 environment and involved in SIT and UAT.
• Created RFCs & worked with BIDW admin team on Migration between Development, Test and Production Repositories.
• Monitoring execution of implemented job in production during the warranty period and fix the identified issues.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.

Environment: Informatica Power Center 9.1, Oracle SQL, PL/SQL, Unix Shell Scripting, HP Quality Center, Cognos 10, Control M.

Confidential, Nashville, TN

Sr. Informatica Consultant

Responsibilities:

• Understanding the requirements and translating them into technical requirements.
• Interacting with the onsite coordinators for getting business requirements on daily basis
• Preparing Mapping spec based on Implementation Guide and Companion Guide
• Designed and developed ETL mappings using various transformations.
• Developed particular logic and transformation as per the requirement, created mappings and loaded the data into different targets.
• Extracted the flat files data, Oracle Dimensional data using Informatica and loaded to the staging area.
• Developed Informatica Mappings, lookups, reusable objects, Sessions as per the Business rules
• Created Reusable Transformations and Mapplets, used them in Mappings to develop the business logic for transforming source data into target.
• Created Workflows and Tasks to schedule the loads at required frequency using Workflow Manager.
• Developed multiple Workflows using work flow manager for initial loading.
• Optimized performance of the mappings by optimizing sources, targets & transformations. to and from the Source systems, to schedule weekly and monthly loads/jobs
• Involved in Migrating & converting of Informatica mappings into Syncsort DMExpress Jobs.
• Unit Testing of DMExpress jobs.
• Migrated the Unit tested DMExpress job to QA environment for QA testing.
• Re-work on defects logged by QA team and re-migrate it to QA environment until the code is QA passed.
• Once QA passed, migrated DMExpress jobs to Pre-Prod environment for parallel processing with Informatica for 2 months.
• Once confirmed from UAT, we have migrated the jobs to Production environment.
• Provide active support post production.
• Involved in unit testing, & preparing the unit test cases.
• Assisted team working on UNIX shell scripts to automate the data transfer (FTP) process Used SQL tools like TOAD to run SQL queries and validate the data loaded into the target tables.

Environment: Informatica Power Center 9.1, DMExpress, Informatica Power Exchange, Oracle, Flat File, DB2 9.5, UNIX Shell Scripting, Informatica Scheduler, Quality Center 10

Confidential, Phoenix, AZ

ETL Developer

Responsibilities:

• Understanding the Business Requirements and Develop an ETL process to load data from source to target.
• Extensively used Informatica power center for loading the data from sources involving flat files to target as relational table.
• Mainly involved in ETL developing to Extract, Transform and Load the data into Target.
• Creation of sessions for mapping and validate the session.
• Created mappings in Data quality & imported in power center as Mapplet for Data quality.
• Migration between Development, Test and Production Repositories.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Did unit testing and development testing at ETL level in my mappings.
• Preparing Minutes of Meeting with Client.
• Prepare the Design Document and review the documents.
• Review the Test case documents and load to the QC

Environment: Informatica Power center 8.6, Informatica Data Quality, MQ series, Mainframe, Share point, UNIX, DB2

Confidential, Annapolis, MD

ETL Developer

Responsibilities:

• Understand the Business Requirements in depth.
• Analyze the requirements of the business users by using ETL Specifications.
• Developed Designs both at HLD and LLD for the ETL solutions Proposed.
• Developed the mappings, mapplets, sessions and workflows.
• Imported required target tables into target designer.
• Constructed ETL Logic for Staging Database using full loading.
• Constructed ETL Logic for Dimension tables using SCD 1 and SCD 2 from delta loading.
• Constructed ETL Logic for Fact tables and Aggregate tables using incremental loading.
• Perform Unit testing to ensure that the code is working properly.
• Used SQL queries and PL/SQL stored procedure for database programming.
• Performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Perform Integration testing of the module after integrating all the data marts
• Perform Migration from one environment to another environment across the repositories.
• Involved in production support activities.

Environment: Informatica 8.6.1, Oracle SQL, PL/SQL, Control M, TOAD, HP Quality Center, Cognos.