SUMMARY

• Overall 8+ years of extensive experience with Informatica Power Center in all phases of Data Analysis, Design, Development, Implementation and production support of Data Warehousing applications using Informatica Power Center 9.X/8.X, SQL, PL/SQL, Oracle, Teradata, DB2, SQL - Server, Unix, Power Shell and Mainframes/SAS environments.
• Experience in Informatica Power Center 9.1/8.6/7.1.2 with strong business understanding and knowledge of ETL of data from heterogeneous source systems like Flat files, Excel, XML and Oracle.
• Handled Enterprise Data Warehouse(EDW)/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Highly Proficient in Informatica Designer Components like Source Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Expertise in using Oracle 8i/9i/10g/11g/12c & Teradata and had hands on experience in building advanced relational database objects which uses Oracle 8i/9i/10g/11g/12c, Teradata database.
• STREAM & UPDATE operators) to export and load data to/from different source systems including flat files.
• Strong knowledge in Data Modeling (Relational, dimensional, Star and Snowflake Schema), identifying FACT and Dimensions Tables, Physical and Logical Database design using ERWIN .
• Troubleshooting and problem solving applications with Informatica Debugger and performing code migration from Dev to Test.
• Experience in Slowly Changing Dimensions (Type 1, Type 2 and Type 3), OLAP, Data Reports and Surrogate keys, Normalization/De normalization.
• Designed complex mappings using Source Qualifier, Filter, Normalizer, Aggregator, Router, Update Strategy, Union, Unconnected and Connected Lookups, Joiner, Sorter and Stored Procedure Transformations.
• Developed various Data Documentation Standards and ETL Mapping Documentations.
• Designed Reusable Transformations and Mapplets for better usability and performance.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Knowledge of working with tools like Toad and utilities like SQL* PLUS, SQL Developer.
• Good understanding of IT Mainframe Applications written in JCL, COBOL/SAS and DB2 database tool (SPUFI).
• Expertise in Enterprise Data Warehouse (EDW) SDLC and architecture of ETL, reporting and BI tools.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.
• Extensive experience working in an Agile/Scrum, Waterfall development environment.
• Excellent team member with problem solving, troubleshooting skills and interpersonal skills.
• Worked closely with the business analyst team in order to solve the Problem Tickets, Service Requests.

TECHNICAL SKILLS

ETL: Informatica 9.x/8.x (Power Center)

Databases: Oracle 8i/9i/10g/11g/12c, MS SQL Server 2005/2008, DB2

Operating Systems: Windows 2000/2003/XP/Vista/7.0/8.0, UNIX, Z/OS

Programming Languages: C, C++, Core JAVA, SQL, PL/SQL, Base SAS, COBOL, HTML

Database utilities: SQL*Plus, SQL Developer, TOAD, Teradata SQL Assistant,, MS SQL Server

Data Modeling: ERWIN

Scripting Languages: UNIX Shell Scripting, Power Shell, JCL

Methodologies: E-R Modeling, Star Schema, Snowflake Schema

Scheduling Tool: Autosys

PROFESSIONAL EXPERIENCE

Confidential, Sacramento, CA

Sr ETL Informatica Developer

Responsibilities:

• Involved in identifying the source and source datavalidation,developing particular logic and transformation as per the requirement and creating mappings and loading the data.
• Designedthe ETL processes using Informaticato load data from Flat Files, XML Files, Excel files and used Power exchange for mainframe sourcesto Oracle Staging area.
• Designed and customized data models for EDW from multiple sources on real time
• Involved in design and development complex ETL mappings and stored procedures. Designed and developed Informatica mappings for data loads, business rules development and data cleansing.
• Debugged mappings by creating logic that assigns a severity level to each error,and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Worked onSource Analyzer, Data warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer and Repository Manager.
• Extensively worked on the performance tuning of theInformatica PowerCenter Mappings as well as the tuning of the sessions.
• Created Detail design documents and Technical design specification documents for ETL Process based on the Business Requirements.
• Extensively used Transformations likeAggregator, Joiner, Expression, Filter, Update, Lookup, Sorter and Stored Procedure transformations
• Tested all the mappings developed and checked the data transformations.
• Improved session performancewith pipeline partitioning and increasing block size, data cache size, sequence buffer length and targetbased commit interval.
• Worked extensively on Informatica to extract data from flat files and Oracle, and to load the data into the target database.
• Worked on Informatica Power Centerfor (ETL) extraction, transformation and loading data from heterogeneous source systems
• Extensively worked onInformatica client tools like Designer, Workflow Manager, and Workflow Monitor and Repository Manager.
• Created Stored Procedures for data transformation.
• Created Tasks, Workflows, Worklets to move the data at specific intervals on demand using Workflow Manager and Workflow Monitor.
• Created complex mappings using Aggregator, Expression,Joiner, XML transformations, Union Transformation, SQL Transformation,complex lookups, Stored Procedures, Update Strategy, PDO and others.
• Used Informaticaas a Data Cleansing tool to correct the data before loading into the staging area.
• Developed scenarios for Unit, System Integration testing to ensure that all the components work correctly when integrated.
• Developed UNIX shell scripts to manipulate the data.
• Solving day-to-day problems, giving support to the Business Users.
• Worked closelywithBusiness QA team during the testing phase andfixed bugs that were reported.
• Involved in Production Support in a 24/7 environment and troubleshooting data quality and integrity issues.
• Created reusable transformations and mapplets in the designer using transformation developer and mapplet designer tools.
• Implemented Performance Tuning Logics wherever possible to provide maximum efficiency and performance.
• The team followed an Agile/Scrum development methodology, so I performed development on user and technical stories in an iterative fashion.

Environment: InformaticaPower Center 9.0.1/ 8.6.1 , Informatica Power Exchange, Oracle 11g/12c, PL SQL (Stored Procedure, Trigger, Packages) and UNIX.

Confidential, Arlington, TX

Sr.ETL Developer

Responsibilities:

• Attended multiple requirement gathering sessions with source system teams and business users.
• Designed data structures for storage and programmed logic for data flow between the various stages of toll transaction processing.
• Maintained and tracked weekly status call with team and finished the deliveries within given timeline.
• Experience in working with Slowly Changing Dimensions and setting up Change Data Capture (CDC) mechanisms.
• Extensively Implemented SCD TYPE 2 Mappings for CDC (Change data capture) in EDW.
• 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.
• Created and modified COBOL copybook to connect source data using Power Exchange Navigator.
• Used Power Exchange Data Change option (CDC) to capture modified records.
• 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.
• Involved in Dimensional modeling (Star Schema) of the Enterprise Data Warehouse (EDW) and used Erwin to design the business process, dimensions and measured facts.
• Responsible for loading the flat files into Oracle database by using SQL* Loader and Informatica.
• 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.
• CreatedInformaticamappings, sessions, workflows and scheduled it throughShellScripts.
• Created different SCD-II mappings using changed data capture (CDC) processes.
• Utilized Quest tool (Toad 8.0) for database monitoring and tuning.
• Involved in writing complex report SQL queries, oracle forms and oracle reports solutions.
• Worked in the Agile/ Scrum development environment with frequently changing requirements.
• Involved in post-production support activities.

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

Confidential, Deerfield, IL

Sr.Informatica Developer

Responsibilities:

• Designed, developed and delivered Data Warehouse solutions as per business requirements.
• Coordination with business users to gather the requirements.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Estimations, planning and tracking of ongoing ETL projects.
• Evaluation of ETL processes to identify areas of improvement. Tuning of Informatica ETL components for optimal load performance.
• Document the source - to target transformation rules for the various data entities by studying the existing batch programs and interviewing the system owners.
• Create data definition documentation for the enterprise including metadata, data flow diagrams, system data flowcharts and source to target mappings.
• Designed and developed ETL Processes based on business rules, job control mechanism using Informatica Power Center.
• Provide technical and analytical support for process improvement initiatives.
• Single point of contact for user’s data questions, any new enhancements in current DWH processes.
• Preparing migration/deployment strategy, rollout and rollback plans, identifying the potential risks involved.
• Weekly, Monthly, Quarterly reporting of ongoing project’s status, challenges and s.

Environment: Informatica Power center 8.6, Oracle 10g/11g, PLSQL, MY-SQL, SQL Developer, Toad, HP Quality center, MS Office, Business Objects XI 3.2, CSV files, Flat Files, and Linux.

Confidential, Irving, Texas

Sr.Informatica Developer

Responsibilities:

• Involved in gathering the business requirements and molding them in to the technical specifications required for the conversions team.
• Designed the target Data Warehouse using Star Schema, Involved in Extraction, Transformation and Loading (ETL) Process.
• Extensively worked over the online tracking system for work-requests, database change request issues, automated UNIX scripts modification issues and various scheduler jobs issues.
• Collection of requirements from business users and analyzed based on the requirements.
• Designed and developed complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications.
• Mappings involved transformations like Expression, Sequence Generator, Joiner, and Update Strategy.
• Created sessions by extensively using ETL methodology for complete processing of data extraction, transformations and loading using Informatica.
• Managed multi source data extraction using Informatica.
• Involved in necessary and knowledge transfer to assigned project members.
• Implemented mapping for slowly changing dimensions (SCD) to maintain current data as well as historical data.
• Created sessions and batches for data movement using Workflow Manager.
• Created reusable Transformations and Mapplets and used them in mappings in case of reuse of the transformations in different mappings.
• Developed and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.
• Extensively worked in the performance tuning of programs, ETL procedures and processes. Error checking and testing of the ETL procedures and programs using Informatica session log.
• Provided end user and production system support, also worked with architecture team to review the Informatica standard documents.
• Worked extensively on Oracle database 10g and flat files as data sources.

Environment: Informatica Power center 8.1/7.5, SQL Developer, Oracle 10g, PLSQL, Jira, MS Office Suite, UNIX Shell Scripting.

Confidential

ETL Developer

Responsibilities:

• Designed ETL mapping based on Existing ETL logic.
• Worked with various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Extensively used ETL to load data from flat files to Oracle.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Made adjustments in Data Model and SQL scripts to create and alter tables.
• Worked extensively on SQL, PL/SQL and UNIX shell scripting.
• Analyzed the source system of ETL Maps.
• Designed and developed the fact/dimension entities.
• Co-ordination with Client Business & Systems team for QA.
• Performed the tuning of ETL SQLs.
• Compared actual results to expected results and suggested changes to mappings owned by others
• Worked on new data model to form the single security master for all the Data Marts and retrofit the existing and new securities in the FACT tables.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used Type 1 and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked as a fully contributing team member with independent planning & execution responsibilities.

Environment: Informatica Power center 7.1.2, Oracle 9i, PLSQL, MY-SQL, SQL Developer, HP Quality center, MS Office, Business Objects XI, and Linux.