SUMMARY

• Over 8 years of experience in Information Technology including Data Warehouse/Data Mart development using ETL/Informatica Power Center across various industries such as Customer Security, Pharmacetuical,Retail,Telecommunications,Lifesciences.
• Extensive experience in using Informatica Power Center 9.x/8.x to carry out the Extraction, Transformation and Loading process as well as Administering in creating domains, repositories and folder.
• Extensive experience in using Informatica tool for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Experience in all the phases ofData warehouse life cycleinvolving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Extensively worked on Informatica IDQ for data profiling, data enrichment and standardization.
• Hands on experience using Teradata utilities (SQL, BTEQ, Fast Load, Multi Load, Fast Export, TPT), UNIX in developing tools and system applications.
• Expertise in Extraction, Transformation & Loading of data using heterogeneous sources and targets.
• Expertise in creating very detailed design documents.
• Experience with good understanding of the concepts and handling Repository Manager, Designer and Informatica Admin Console.
• Involved in all phases of data warehouse project life cycle. Designed and developed ETL Architecture to load data from various sources like SAP R/3 code, Oracle, Flat files, XML files, Teradata, Netezza and MS SQL Server into Oracle, Teradata, XML, and SQL server targets.
• Hands on experience with mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Aggregator, Joiner, Update Strategy, Java Transformations and Re - usable transformations.
• Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using SCD (Type1/Type2/Type3) loads.
• Extensively created mapplets, reusable transformations, look-ups for better usability.
• Good understanding of relational database management systems like Oracle, Teradata, SQL Server and worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems
• Strong noledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Expert in Oracle 11g/10g, Netezza, SQL Server 2008/2005, SQL, PL/SQL Stored procedures, functions, and exception handling using Toad and PLSQL.
• Worked onPerformance Tuning,identifyingandresolving performance bottlenecksin various levels like sources, targets, mappings and sessions.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklets, Control).
• Experience working in agile methodology and ability to manage change effectively.
• Worked on JIRA\RALLY tools to maintain for the defect tracking.
• Worked on SUB-VERSION tool to maintain the mapping documents.
• Responsible for Team Delivery and Participated in Design Reviews.
• Expertise in defining and documenting ETL Process Flow, Job Execution Sequence, Job Scheduling and Alerting Mechanisms using command line utilities.
• Excellent communication, interpersonal skills and quickly assimilate latest technologies concepts and ideas
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x

Databases & Tools: MS-SQL2005-2008, Oracle11.x/10.x, SQL, Views, Toad, XML, Teradata and Netezza

Job Scheduler: Informatica Scheduler, Control-M 6.3 and Autosys

Operating Systems: Windows 95/98/2000/2003/ NT/XP, UNIX.

Languages: C#, C++, HTML, Java

Other Utilities & Tools: SharePoint, Putty, WinSCP

Version Control: JIRA, Rally

Database Development Tools: Toad, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Carlsbad, CA

Sr.Informatica Power Center Developer/Lead

Responsibilities:

• Worked with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
• Responsible for Data Warehouse Architecture, ETL and coding standards.
• Used Informatica as ETL tool to pull data from source systems/ files, cleanse, transform and load data into databases.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Conducted a series of discussions with team members to convert Business rules into Informatica mappings.
• Created dictionaries using Informatica Data Quality (IDQ) dat was used to cleanse and standardized Data. Worked with Informatica and other consultants to develop IDQ plans to identify possible data issues.
• Extracted data from SAP R/3 and loaded into Oracle Data Warehouse.
• Used Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created Mapplets and used them in different Mappings.
• Developed stored procedure to check source data with warehouse data and if not present, write the records to spool table and used spool table as lookup in transformation.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Documented Cleansing Rules discovered from data cleansing and profiling.
• Managed Scheduling of Tasks to run any time without any operator intervention.
• Leveraged workflow manager for session management, database connection management and scheduling of jobs.
• Created Unix Shell Scripts for Informatica ETL tool to automate sessions and cleansing the source data.
• Experienced in Debugging and Performance tuning of targets, sources, mappings and sessions
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and mapplets.
• Delivered all the projects/assignments within specified timelines.

Environment: Informatica Power Center 9.5, Teradata, SAP R/3, Flat files, Oracle, XML, MS SQL server 2008, Erwin, Winscp.

Confidential, Denver Co

Software Engineering Sr. Analyst

Responsibilities:

• Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• Develop high level and detailed level technical and functional documents consisting of Detailed Design Documentation function test specification with use cases and unit test documents
• Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code
• Handled technical and functional call across the teams.
• Responsible for the Extraction, Transformation and Loading (ETL) Architecture & Standards implementation
• Responsible for offshore Code delivery and review process
• Used Informatica to extract data from Oracle and Flat files to load the data into the Target Table.
• Worked in all phases of Data Integration from heterogeneous sources, legacy systems to Target Database.
• Worked on Informatica Power Center tool - Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager, Informatica Workflow Manager and Workflow Monitor
• Involved in Design Review, code review, test review, and gave valuable suggestions.
• Worked with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Created partitions for parallel processing of data and also worked with DBAs to enhance the data load during production.
• Worked by implementing SCD (Slowly Changing Dimensions) Type 1 and Type 2 .
• Took part in migration of jobs from UIT to SIT and to UAT

Environment: Informatica Power Center 9.1, Teradata, Oracle 9i, TOAD, Erwin, XML, UNIX.

Confidential

Data Specialist

Responsibilities:

• Prepared the required application design documents based on functionality required
• Designed the ETL processes using Informatica to load data from Netezza and Flat Files to staging database and from staging to the target database.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Involved in migration of mappings and sessions from development repository to production repository
• Extensively used Informatica and created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Involved in cleansing and extraction of data and defined quality process for the warehouse.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions, index cache to manage very large volume of data.
• Used Update Strategies for cleansing, updating and adding data to the existing processes in the warehouse.
• Defects are logged and change requests are submitted using defects module of Test Director using HP Quality Center
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.
• Performed data validation, reconciliation and error handling in the load process. Test data to ensure data is masked.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in migrating objects from DEV to QA and testing them and then promoting to Production
• Involved in production support working with various tickets created while the users working to retrieve the database.

Environment: Informatica 9.x, UNIX, Teradata, Netezza, Winscp, TOAD, Putty, XML

Confidential, Indianapolis

Data Specialist

Responsibilities:

• Created detailed Technical specifications for the ETL processes.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Used Informatica as ETL tool to pull data from source systems/ files, cleanse, transform and load data into databases.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Developed the Informatica mappings using various transformations, Sessions and Workflows. SQL Server was the target database, Source database is a combination of Flat files, Oracle tables, People Soft, Excel files, CSV files etc.
• Worked with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Responsible for Unit Testing, Integration Testing and halped with User Acceptance Testing.
• Involved with the DBA in performance tuning of the Informatica sessions and workflows. Created the reusable transformations for better performance.
• Optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and mapplets.
• Involved with the DBA in performance tuning of the Informatica sessions and workflows. Created the reusable transformations for better performance
• Involved in writing UNIX shell scripts for Informatics ETL tool to run the Sessions.
• Fixing and tracking mapping defects and implementing with enhancements.
• Managing post production issues and delivering task/projects within specific timeline.
• Involved in the mirroring of the staging environment to production.
• Collaborated with teams for migration and Production Deployment activities.
• Scheduling Informatica jobs and implementing dependencies if necessary using Tidal Scheduler.
• Responsible for performing SQL query optimization using Hints, Indexes and Explain plan.
• Played a Vital role in requirement gathering, preparation of engineering gathering requirement specification.
• Managed production issues and delivered all assignments/projects within specified time lines.
• Worked on all phases of multiple projects from initial concept through research and development, implementation, QA, to live production, by strict adherence to project timelines.

Environment: Informatica Power Center 8.1, Teradata, Netezza.

Confidential, Groton, CT

Data Specialist

Responsibilities:

• Analyzed the business requirements, design documents & whole life cycle of the project
• ETL Developing in agile methodology environment with daily scrums and two week sprints.
• Prepared Unit test scenarios, test scripts for testing the data from source, staging, data warehouse and data mart and loaded them into Quality center.
• Design and map to understand the scope and review Level 2 architecture, High Level Designs, Functional Spec, and Assembly Docs, Mapping Spec provided by project team.
• Extensively worked with Teradata utilities likeBTEQ, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Strong experience in Creating Database Objects such asTables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata.
• Designed & coded the ETL requirements for projects - Confidential prism phase2.
• Worked on BTEQ Utility for the insert/update/delete.
• Designed Star Schema with fact tables & dimension tables, developed Informatica Mappings to extract data from data mart.
• Mapplets & Reusable Transformations were used to prevent redundancy of usage & maintainability.
• Worked on the performance issues at various levels such as target, sessions, mappings & sources, identifying performance bottlenecks, troubleshooting issues & resolving the same in the fastest timeframe possible

Environment: Informatica Power Center 8.x(Designer, Workflow Manager, Workflow monitor, Repository Manager), Teradata, Autosys

Confidential, Groton, CT

Data Specialist

Responsibilities:

• Involved in Requirement gathering, Data analysis, Design, and Implementation of the application.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Extracted sources from flat-files, oracle and load them into Teradata.
• Extensively worked with Teradata utilities likeBTEQ, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Strong experience in Creating Database Objects such asTables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata.
• Designed & coded the ETL requirements for projects - Confidential prism phase2.
• Worked on BTEQ Utility for the insert/update/delete.
• Implemented Slowly Changing Dimensions (Type 1 &2).

Environment: Informatica Power Centre 8.x., Teradata, Autosys

Confidential, SanJose

Software Engineer Level 2

Responsibilities:

• Involved in requirement gathering and created requirement specification to ensure functional correctness, accuracy, functional completeness and usability.
• Created, designed, and implemented specifications and developed ETL processes to support the development and implementation of data warehouse projects using Informatica.
• Designed and developed Informatica Mappings to load data from Source systems to Data Mart.
• Involved in research and design of the business.
• Interacted with users to design the architecture of ETL mappings and developed them.
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Worked extensively on transformations such as Lookup, Aggregator, Expression, Joiner, Filter, Rank, Update Strategy, and Sequence Generator and performed performance tuning of ETL process.

Environment: Informatica Power Centre 8.x., Windows, Oracle