PROFESSIONAL SUMMARY:

• Over 8 years of experience in Information Technology with a strong background in Database development and Data warehouse and ETL process using Informatica Power Center 9.6/9.1/8.x/7.x/6.x/5.x.
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, Sybase, COBOL files, XML Files and Worked on integrating data from flat files like fixed width and delimited.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Experience with slowly changing dimension methodology and slowly growing targets methodologies.
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Experience in diversified fields in Data Warehousing. Worked on various projects involving Data warehousing using Informatica Power Center 7.1 and Power Center 9.1/8.1.6 (Workflow Manager, Workflow Monitor, Server Manager, Source Analyzer, Warehouse Designer, Mapping Designer, and Mapplet Designer & Transformation Developer).
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions.
• Strong analytical and problem solving skills with the ability to quickly adapt to new environments and learn new technologies.
• Maintained summaries or aggregates on data using Materialized Views.
• Expertise in Analyzing system specifications and Business requirements.
• Involved in various stages of Analysis, Design, Development, Testing, and Implementation of application development process.
• Experienced in Database Design, Data Modeling, Migration, and Systems Architecture, Planning, Testing Query Optimization and Trouble Shooting.
• Extensive experience in creating new reports and customization of existing Reports, Forms and PL/SQL Procedures in Oracle Applications.
• Extensive experience in writing data conversion scripts for migrating legacy data into Oracle Applications using SQL*Loader and PL/SQL.
• Excellent communication skills.

TECHNICAL SKILLS:

Operating Systems: Windows 2008/2007/2005/ NT/XP, UNIX, MS-DOS

ETL Tools: Informatica Power Center 9.6/9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server)

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2 v8.1, Teradata 13.0/14.0.

Data Modeling tools: Erwin, MS Visio

Languages: SQL, PL/SQL, UNIX, Shell scripts, C++, SOAP UI, JSP, Web Services, Java Script, HTML, Eclipse

Scheduling Tools: Autosys, Control-M, TWS

Testing Tools: Quality Center, Clear case.

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Sr. ETL Informatica Developer

Responsibilities:

• Understood the Business point of view to implement coding using Informatica Power Center 9.6/9.1
• Extensively used Informatica Power Center 9.6/9.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Involved in design and development of complex ETL coding in an optimized manner.
• Have created / developed different types of profiles like Column level profiling, Summary profiles, drill down profiles, Score cards, reports etc using IDE.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Optimized performance by tuning the Informatica ETL code as well as SQL
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update Strategy, Sorter, XML, Lookup, Aggregator, Joiner and Stored Procedure transformations in the mapping.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Written Queries, procedures, created Indexes, primary keys and data bases testing.
• Defects were tracked, reviewed and analyzed.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Implemented Error Rejection process to load bad/invalid records into a separate reject table.
• Informatica Extensively Worked in Processing Structured and Unstructured data.
• Informatica Data Transformation supports transformations and mappings, via XML
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command and Decision.
• Documenting Enterprise Business Intelligence solutions.
• Gathering data requirements and co originates with business users
• Analyze the different data sources and identifying the relationships
• Involved in creating logical data models
• Created and scheduled sessions, jobs based on demand, run on time and run only once using Workflow Manager.
• Created parameter files to Dev, Test and Prod environments.
• Created Perl Scripts and called in Pre session and Post session commands.
• Involved in various testing activities like database testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Used Teradata utilities Fastload, multiload, tpump to load data
• Wrote BTEQ scripts to transform data
• Wrote Fastexport scripts to export data
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL
• ExtensiveUnix Shell Scriptingknowledge.
• ETL process performed using Informatica and the DB used are Oracle and Teradata.
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc
• Identified and debugged the errors before deploying and worked on migration of the maps and workflows from development to UAT and from UAT to Production.

Environment: Informatica Power Center 9.6/9.1, Oracle 11g, Flat Files, TOAD, Teradata, Autosys,Windows XP, UNIX,Web Services

Confidential, Palo Alto, CA

Sr. ETL Informatica Consultant

Responsibilities:

• Designed data structures for storage and programmed logic for data flow between the various stages of toll transaction processing.
• Attended multiple requirement gathering sessions with source system teams and business users.
• Maintained and tracked weekly status call with team and finished the deliveries within given timeline.
• Developed mappings to extract data from SQL Server, Oracle, Flat files, XML files, and loaded into Data warehouse using the Mapping Designer.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Experienced with InformaticaPowerExchange for Loading/Retrieving data from mainframe systems.
• Understanding & Working knowledge of InformaticaCDC (Change Data Capture).
• ExtensiveUnix Shell Scriptingknowledge.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD.
• Developed various Stored Procedures, Functions, Packages and Materialized views for ETL needs.
• Developed unit test plans for each scenario and programmed for data validation and proper error handling to manage the transactions without any data loopholes.
• Responsible for tuning the Informatica Mappings and Sessions for optimum performance.
• Enhancing the system with change requests and fault fixes delivery.
• Responsible for loading the flat files into Oracle database by using SQL* Loader and Informatica.
• Documenting Enterprise Business Intelligence solutions.
• Gathering data requirements and co originates with business users
• Analyze the different data sources and identifying the relationships
• Involved in creating logical data models
• Database performance by optimizing back end queries, pl/sql tuning and implementing performance improvements by analyzing indexes, table partition, parallelism etc
• Documentation of all changes made to enhance the code for new requirements.
• Used external tables to manipulate data obtained on monthly basis for vehicle information before loading them into the tables.
• Utilized Quest tool (Toad 8.0) for database monitoring and tuning.
• Involved in writing complex report SQL queries, oracle forms and oracle reports solutions.
• Involved in post production support activities.

Environment: Informatica 8.6, Erwin 7.1, Oracle 11g, PL/SQL developer, SQL*PLUS, SQL, SQL*Loader, Toad, ER-Studio, UNIX, CVS, HTML, XML.

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica Power Center created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Analyzed, identified, fixed bad data and imported data fromSalesforce - CRM to Oracle. Upstream data integration and migration processes in predefined schemas.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager. Informatica Web-services and web-portal applications.
• This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Environment: Informatica Power Center Designer 7.1, Informatica Repository Manager, Oracle10g/9i,DB2 6.1, Erwin, TOAD, SAP Version: 3.1.H,Unix- SunOS, PL/SQL,SQL Developer

Confidential, Hartford, CT

Informatica Developer

Responsibilities:

• Involved in requirements gathering and analysis for the entire application.
• Involved in complete SDLC of the application.
• Designed and Implemented the Extraction, Transformation, and Load (ETL) techniques built using Informatica, SQL, PL/SQL and Unix Shell Scripting.
• Developed various Stored Procedures, Functions, Packages and Materialized views for ETL needs.
• Outbound claims file (834 HIPAA).
• Informatica Extensively Worked in Processing Structured and Unstructured data.
• Informatica Data Transformation supports transformations and mappings, via XML, of most healthcare industry standards including HIPAA 275,277
• Incorporated various transformations, Lookups, Expressions, Routers, Sequence generators, mapplets, dynamic lookups and reusable transformations in ETL maps
• ETL performance (Data base and ETL jobs) by optimizing back end queries, by implementing techniques like index drop and re-create, table partition, parallelism etc
• Performed Database/ETL migrations from Dev environment to Test/Training/UAT/Staging and PROD environments

Environment: Oracle 10g, PL/SQL Developer, SQL*PLUS, SQL, T-SQL, Pro*C, SQL*Loader, Toad, ER-Studio, UNIX, Informatica 7.1

Confidential

PL/SQL Developer

Responsibilities:

• Requirements gathering from users designing the database.
• Functional specs review and created technical specs documents.
• Created Platform independent schema structure so that the product data can be implemented in any database.
• Used Internationalization and Localization techniques in designing data structure so that it can be adapted to various languages and regions without engineering changes.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Developed Ab Initio graphs to manipulate the logs and load the data into the Oracle databases.
• Developed re-usable graphs for data extraction and scrubbing for various transformation processes
• Involved in Unit Testing the Ab Initio graphs and quality assurance and bug fixing.