SUMMARY:

• 7 years of IT experience in Analysis, Design, Development, Testing, Implementation and Support of Data Integration, Data Migration and Data Quality Projects using Informatica PowerCenter, Data Quality software tools.
• Extensive experience in ETL (Extraction, Transformation and Loading) of data using Informatica PowerCenter from heterogeneous sources like Flat files (Fixed width, delimited), XML files, Relational databases.
• Extensive knowledge in SDLC (Software Development Life Cycle) and executed projects in Waterfall and Agile methodologies.
• Strong understanding of Dimensional Modeling, Star, Snowflake Schema, OLAP and DW concepts.
• Extensive knowledge in RDBMS concepts and Relational and Dimensional Data modeling.
• Worked closely with the data stewards to get data quality project requirements.
• Experienced in understanding the Project scope, Dependencies, Risks and provide estimations.
• Created complex mappings using transformations like Source qualifier, Expression, Aggregator, Joiner, Lookup, Normalizer, SQL, Union, Update Strategy, Filter, Router, XML transformation.
• Expertise in analyzing the source data systems for better understanding the business requirements, designing optimal ETL design.
• Developed technical specifications of the ETL process flow, High level and Low - Level Design and Source to Target mapping documents.
• Strong experience in handling Slowly Changing Dimensions (SCD).
• Strong experience in designing and developing mappings to extract data from different sources including flat files and XML.
• Experience with Informatica Advanced Techniques - pushdown optimization, session partitioning.
• Extensively involved in creating reusable objects to standardize Informatica code and to bring down the development and testing efforts.
• Worked on different tasks in Workflows like sessions, events raise, event wait, e-mail, command, worklets and scheduling of the workflow.
• Extensively involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks at Source, Transformations, Target layers.
• Independently perform complex troubleshooting, root-cause analysis and provide solution to fix defects.
• Experienced in writing SQL queries using OLAP functions to improve the performance of the queries.
• Experienced in creating and using Stored Procedures, Functions, Views and Materialized views.
• Generated warning and Error reports and shared with Business users to further analysis.
• Extensively involved in generating automated alerts to Business users and Email notifications as per Business requirement.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative.

TECHNICAL SKILLS:

ETL Tools: Power Center 9.6.1/9.5/9.1/8.6/8.1/7.1 , Informatica Power Exchange, Metadata Manager, Informatica Data Quality (IDQ), Informatica Data Explorer (IDE), SSIS, Salesforce, DataStage, etc.

Database Tools: SQL Server Management Studio (2008), Oracle SQL Developer (3.0), Toad 11.6 (Oracle), DB2, Teradata, AQT v10/v9 (Advanced query tool) (Oracle/Netezza), DB Artisan 9.0 (Sybase), SQL Browser (Oracle Sybase), Visio, ERWIN

Reporting Tools: Business Objects XIR2/6.1/5.0, QlikView, OBIEE, MicroStrategy, Oracle Analytics, etc.

Operating Systems: Windows Server 2008/2003, Windows 7/XP/98/95

Informatica Scheduler, Maestro, Control: M, UC4

Web Technologies: HTML, XML

Languages: C, C++, SQL, XML

PROFESSIONAL EXPERIENCE:

Sr Informatica Developer

Confidential

Responsibilities:

• Involved in full Software Development Life Cycle (SDLC) - Business Requirements Analysis, preparation of Technical Design documents, Data Analysis, Logical and Physical database design, Coding, Testing, Implementing, and deploying to business users.
• Documented user requirements translated requirements into system solutions and developed implementation plan and schedule.
• Extracted data from relational databases to Flat Files.
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and convert into DPP System.
• Developed data Mappings, Transformations between source systems.
• Used debugger to test the mapping and fixed the bugs.
• Created sessions, sequential and concurrent batches for proper execution of mappings using server manager.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target-based commit interval.
• Responsible to design, develop and test the software (Informatica) to maintain the data marts (Extract data, Transform data, Load data).
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Included data from different sources like Oracle Stored Procedures and Personal data files in the same report.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.
• Responsible for managing Data Modeling, physical and logical databases
• Check in Logical Database in ER Studio and Physical in Star Team to manage compatibility.
• Designed, developed, implemented and maintained Informatica PowerCenter and IDQ 8.6.1 application for matching and merging process.
• Used scheduling tools to create new jobs and job dependencies are setup with different Autosys cycles.
• Experienced in writing SQL queries for retrieving information from the database based on the requirement.
• Working on different tasks in Workflows like sessions, events raise, event wait, e-mail, command, worklets and scheduling of the workflow.
• Strong experience in designing and developing mappings to extract data from different sources including flat files and XML
• Worked with the offshore team and supervised on their development activity.
• Reviewed code and confirmed it was compatible to standard programming practice.
• Conducted Knowledge transfer sessions about the project to the team and managed the project by providing reviews on it.
• Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy transformations.

Environment: Informatica Power center 10.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Mapplets, Mappings, Workflows, Sessions, Reusable Transformations), Control Center.

Informatica Developer

Confidential, Dallas, TX

Responsibilities:

• Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectation.
• Used Informatica PowerCenter features extensively in migrating data from OLTP to Enterprise Data warehouse.
• Extensively used Erwin for Logical and Physical data modeling and designed Star Schemas.
• Extracted data from different sources like Oracle, flat files, XML, DB2 and SQL Server loaded into DWH.
• Created complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter.
• Used Informatica PowerCenter for extraction, loading and transformation (ETL) of data in the data warehouse.
• Handle slowly changing dimensions based on the business requirements.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings
• Involved in creation of Repositories, Folders, Users and Deployment Groups
• Involved in scheduling the Informatica workflows using Autosys
• Migrated mappings, sessions, and workflows from development to testing and then to Production environments
• Involved in Performance tuning for sources, targets, mappings and sessions
• Performed unit testing on the Informatica code by running it in the Debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum performance
• Wrote PL/SQL stored procedures & triggers, cursors for implementing business rules and transformations
• Worked extensively with different caches such as Index cache, Data cache and Lookup cache (Static, Dynamic, and Persistent)
• Created deployment groups, migrated the code into different environments
• Worked closely with reporting team to generate various reports

Environment: Informatica Powercenter9.1.0, Informatica Power Exchange, Informatica IDQ, Windows XP, TOAD, Oracle SQL, PL/SQL, Oracle11g/9i and SQL Server.

Informatica Developer

Confidential, Long Beach, CA

Responsibilities:

• Interacted with business users and business analyst to understand reporting requirements and understanding the mapping documentation.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Used Informatica to develop objects for extracting, cleaning, transforming and loading data into data warehouse.
• Perform System Analysis and Requirement Analysis, design and write technical documents and test plans.
• Configured session properties and target options for better performance.
• Schedule and run Extraction and Load process and monitor sessions by using Informatica Server Manager.
• Worked with Management for creating the requirements and estimates on the Project.
• Assisted Business Analyst with drafting the requirements, implementing design and development of various components of ETL for various applications.
• Planning and Requirement analysis for large scale Centralized Wealth Data Warehouse.
• Coordinated with DBA in creating and managing tables, indexes, tablespaces and data quality checks.
• Check and Tune the performance of application for optimum system performance.
• Created Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Developed Test Scripts, Test Cases to perform Unit Testing, System Testing.
• Communicate with business users to understand their problem if required and send workaround to solve the issue and find the root cause and advice if required any enhancement.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle.
• Maintain and enhance the application to meet all the required business needs, mainly to optimize the supply vendors cost.
• Developed various Informatica Workflows to load the data from various upstream systems using different methodologies i.e. trigger based pull, direct pull & file-based push.
• Published the records to downstream applications with help of ETL power center with the help of message queue.
• Worked with high volumes of datasets from various sources like DB2, text files, and relational tables.
• Design and develop mappings, sessions and workflow as per the requirement and standards.
• Created various AutoSys jobs for the scheduling of the underlying ETL flows.
• Used Informatica debugger in finding out bugs in existing mappings by analyzing data flow and evaluating transformations and done unit testing for the individual developed mappings.
• Responsible for making changes in the existing configuration wherever required, making customizations according to the business requirements, testing and successfully moving the changes into production.

Environment: Informatica PowerCenter Designer 9.5/8.6, Informatica Repository Manager, Oracle10g/9i, DB2 6.1, Erwin, TOAD, Unix- SunOS, PL/SQL, SQL Developer, Teradata.

Informatica developer

Confidential

Responsibilities:

• Analyze the business requirements and framing the Business Logic for the ETL Process and maintained the ETL process using Informatica Power Center.
• Design and develop PL/SQL packages, stored procedure, tables, views, indexes and functions. Experience dealing with partitioned tables and automating the process of partition drop and create in oracle database.
• Analyze Session log files to resolve error in mapping and identified bottlenecks and tuned them for optimal performance.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator.
• Develop an ETL Informatica mapping to load data into staging area. Extracted from Mainframe files and databases and loaded into Oracle 11g target database.
• Create workflows and work lets for Informatica Mappings.
• Work on SQL coding for overriding for generated SQL query in Informatica.
• Involve in Unit testing for the validity of the data from different data sources.
• Involve in migrating the ETL application from development environment to testing environment.
• Perform data validation in the target tables using complex SQLs to make sure all the modules are integrated correctly.
• Perform Data Conversion/Data migration using Informatica PowerCenter.
• Involve in performance tuning for better data migration process.
• Create UNIX shell scripts for Informatica pre/post session operations.
• Document and present the production/support documents for the components developed, when handing-over the application to the production support team.
• Worked with XML targets for the data coming from SQL server source.
• Query tuning and SQL Query override used in Source Qualifier transformation to pull historical data from database not earlier than the given date i.e. the change data capture (CDC).
• Parameterized the whole process by using the parameter file for the variables.
• Imported xsd file to create the xml target and create the Hierarchical Relationship and normalized views.
• Configure and setup a secure FTP connection to the vendor using the Informatica Managed File transfer software.
• Created Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Created complex Shell scripts for various set of actions that would automate the process of executing the actions like validating the presence of indicator files.
• Involved in Unit testing and system integration testing (SIT) of the projects.
• Assist the team members with the mappings developed as part of knowledge transfer.
• Implemented the logic by using HTTP transformation to query the web server.

Environment: Informatica PowerCenter 10.1

Informatica Developer

Confidential

Responsibilities:

• Analyze project plan to gather the business requirement.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Extract data from flat files, Oracle, SQL Plus, MS SQL Server 2008 and to load the data into the target database.
• Extensively used Informatica Power Center 7.1 an ETL tool to extract, transform and load data from remote sources to DW.
• Created Complex mappings using transformation like Filter, Expression, Joiner, Aggregator, Router and Stored Procedure transformations for populating target table in efficient manner.
• Developed complex joins in the mappings to process data from different sources.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors of target data load.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Performed unit testing of Informatica sessions, batches and the target Data.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Designed and developed UNIX shell scripts as part of the pre-session and post-session command to automate the process of loading, pulling, renaming and pushing data from and to different servers.
• Designed and developed SQL, PL/SQL and UNIX shell scripts.

Environment: Informatica Power Center Designer 7, Oracle 9.x/10g, Flat Files, UNIX, MS SQL Server 2008, SQL, PL/SQL, and SQL PLUS