SUMMARY

• About 7 years of IT experience in Data warehousing with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems.
• Experienced in all phases of software development life cycle - Data Analysis, Data Modeling and designing, Development, Testing, Implementation, Documentation, Maintenance and Support.
• Hands on experience in ETL tool Informatica Power Center in analyzing, designing and developing ETL processes for Data Warehousing projects using Informatica Power Center (9.x/8.x/7.x/6.x).
• Developed Complex mappings from varied transformation logic like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Server Manager.
• Experienced in identifying Bottlenecks in ETL Processes, improving the Performance of the production loads and data access using Database Tuning, Index Usage.
• Experience in creating Reusable tasks (Sessions, Commands and Email) and Non Reusable tasks (Decision, Timer, Assignment, Worklets, and Control)/or handling.
• Experience in performance tuning of sources, targets, mappings and sessions.
• Expertise in dealing with methodologies like Data loading and SCDI, SCDII and SCDIII.
• Experience on working with BI team on bringing the new tables or new attributes into Data Warehouse for reporting purpose.
• Experience with relational databases such as Oracle and SQL-Server.
• Worked with various SQL Editors such as TOAD, SQL Plus, and Query Analyzer.
• Expertise in UNIX shell scripting and automation of workflows. Experience in monitoring, maintaining and optimizing database and ETL processes.
• Excellent technical and professional client interaction skills. Interacted with both Technical, functional across different phases of the project life cycle.

TECHNICAL SKILLS

Operating System: UNIX(IBM AIX), Windows XP/Vista

RDBMS: SQL Server, Oracle 8i/9i/10g, Teradata, DB2

ETL: Informatica Power Center 9.0x/8.x/7.x/6.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Monitor and Informatica Server) ETL, Metadata, Datamart, FACT & Dimensions tables.

Methodologies: Star Schema, Snowflake Schema

Programming Languages: SQL, PL/SQL

Other: TOAD, MS Excel, Word and PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, San Ramon, CA

Sr. Informatica Developer

Environment: Informatica Power Center 9.5.1, Informatica Data Quality, Oracle, UNIX.

Responsibilities:

• Working on building new data warehouse for customer data information.
• Experienced working with team leads, Interfaced with business analysts and end users.
• Interacted with Business Analyst to gather requirements and translated them into ETL technical specifications.
• Worked with data modelers to understand financial data model and provide suggestions to the logical and physical data model.
• Involved in data quality profiling, design, development, unit testing and deployments of ETL Informatica components.
• Document unit test cases and provide QA support to make testers understand the business rules and code implemented in Informatica.
• Extracted data from various sources like XML files, flat files, RDBMS loaded into target data warehouse Oracle.
• Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Router, Sorter, Expression, Normalizer, Sequence Generator and Update Strategy, data standardization, address validator etc.
• Implemented SCD Type 1 and SCD Type 2 for loading data into data warehouse dimension tables.
• Implemented error handling for invalid and rejected rows by loading them into error tables.
• Involved in Performance Tuning of ETL code by addressing various issues during extraction, transformation and loading of data.
• Analyzed the source fields and wrote SQL queries for field to field validation by referring source to target mapping document.
• Involved in writing SQL queries to validate the data on the target database according to source to target mapping document.
• Worked with Support team to migrate the ETL code to Production servers from development servers by creating a mapping document and Request for Change (RFC) of the process.
• Involved in Knowledge Transfer sessions to Support team after completion of UAT signoff.
• Handled Production issues and monitored Informatica workflows in production.
• Extensively worked on batch frame work to run all Informatica job scheduling.

Confidential, Los Angeles, CA

ETL Developer

Environment: Informatica Power Center, Netezza, Oracle, SQL Server, Micro Strategy, Omniture analytics tool, Amazon web services.

Responsibilities:

• Involved in gathering the business requirements from the team and from the end users.
• Involved with data model team to design and build relationships between different entities.
• Involved in coding, testing, implementing, debugging and documenting the complex programs.
• Involved in documenting High Level Design, Low level Design, STM's, Unit test plan, Unit test cases and Deployment document
• Ensures that all the standard requirements have been met and is involved in performing the technical analysis.
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Performed unit testing at various levels of the ETL.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
• Debugged the sessions by utilizing the session logs.
• Perform investigations and make appropriate suggestions on various services and to meet the development efforts
• Reviewing documentation, peer code and conducting code walkthrough with customer and getting sign-off
• Involved in gathering requirements and designing data mart entities and data warehouse.
• Resolving issues and providing on-call support regarding production system
• Working with system supporters, developers and DBAs in automating and evaluating applications
• Implementing best practices to ensure optimal performance
• Prepared codes for all modules according to require specification and client requirements and prepare all required test plans.
• Involved in all production issues and inquiries and provided efficient resolution for same.

Confidential, Irving, TX

Informatica Developer

Responsibilities:

• ETL processes using Informatica to load data from heterogeneous sources to target Teradata Warehouse.
• 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 DataMart.
• Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica PowerCenter.
• Worked with IDQ to ensure accurate Address matching/cleansing and data quality for all source data types.
• Defined Data Quality standardization & cleansing rules using Informatica Data Quality (IDQ) discovered from the profile results.
• Performed Data Quality checks, cleansed the incoming data feeds and profiled the source systems data as per business rules using IDQ.
• Extensively used Informatica Data Quality transformations - Parser, Standardizer, Match, Merge, Address Validator, Case Converter, and Classifier.
• Created different types of profiles like Column level profiling, Summary profiles, drill down etc. using IDE.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD.
• Used Debugger to test the data flow and fix the mappings.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules for adhoc data.
• Performed Unit testing and System Testing.
• Prepared Test Cases and upload into Quality Center.
• Involved in performance tuning of the Informatica mapping and identifying the bottlenecks.
• Worked on Debugging and Troubleshooting of the Informatica application. For debugging utilized Informatica debugger.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Extracting data from various sources across the organization (Oracle, SQL Server and Flat files) and loading into staging area.
• Worked on Teradata SQL Assistant, Teradata view point and BTEQ scripts.