SUMMARY

• Over 7 years of experience in Analysis, Development and Maintenance of Business Intelligence solutions using Informatica Power Center 9.x/8.x/7.x/6.x.
• Good Understanding of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake and Operational Data store (ODS)
• Developed various mappings using different transformations like Source Qualifier, Expression, Filter, Joiner, Router, Union, Unconnected / Connected Lookups and Aggregator.
• Experience in developing Sessions/tasks, Worklets, and Workflows using Workflow Manager Tools - Task Developer, Workflow and Worklets Designer.
• Experience in identifying Bottlenecks in ETL Processes and Performance tuning of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.
• Worked with Oracle Stored Procedures, Functions Cursors, Indexes and Triggers and involved in Query Optimization.
• Experience on Create, update and maintain project documents including business requirements, functional and non-functional requirements, functional design, data mapping.
• Resolving data issues, complete unit testing and complete system documentation for ETL processes.
• Ensure smooth transition of work to offshore team. Transfer ETL requirements and ensure timely completion of deliverables with offshore.
• Strong working experience with Scheduling tools like Maestro, Autosys.
• Supports and enhances existing Informatica environment and develops new, complex ETL processes to support additional design, development and deployment of the new Telematics capabilities.
• Communicate with business users to collect and understand requirements, socialize ideas among peers, and document work product
• Perform peer document reviews and code reviews to ensure adherence to user requirements as well as applicable standards and conventions.
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.

TECHNICAL SKILLS

ETL Tools: Informatica Power center, DataStage.7.5/7.1, SQL*Loader, Bulk Loader, SQL Server.

Reporting Tools: Business Objects XI r3.1 and Cognos, MS SQL Server ReportingServices, Crystal Reports

Databases: Oracle, SQL Server, Teradata, Sybase, DB2 UDB, MySQL

Data Modeling / OtherTools: ERWIN 4.2/4.0/3.5.2 , Toad, SQL * Plus, SQL Developer, SQL Navigator 5.5, Control - M, Autosys, Secure FTP (SSH), Maestro Scheduling Tool

Programming Skills: Perl, C, C++, SQL, PL/SQL, Pascal, and FORTRAN. COBOL

Scripting Languages: UNIX Shell Scripting, JCL

Operating Systems: UNIX (Sun Solaris 2.x, HP/UX), MVS, Windows, IBM AIX 4.2

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale,CA

Sr.ETL Informatica Developer

Responsibilities:

• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, COBOL files & XML Files.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter.
• Developed slowly changed dimensions (SCD) Type 2 for loading data into Dimensions and Facts.
• Performed operational support and maintenance of ETL bug fixes and defects.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Migration of code between the Environments and maintaining the code backups.
• Created the Test cases and Captured Unit test Results.
• Designed mappings from the scratch and also did performance tuning of the mappings that were previously implemented.
• Migrating mappings, workflows and parameter files from development to production.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Maintained the target database in the production and testing environments.
• Implemented Logical /Physical design of database schemas and business processes though Erwin.
• Developing information systems through investigation, analysis, design, implementation and maintenance with SDLC.
• Implemented complex views, procedures, functions, packages and triggers in PL/SQL.
• Designed and developed Unix Shell Scripts, FTP, sending files to source directory & managing session files
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Developed PL/SQL code at the database level for the new objects.

Environment: Informatica Power Center 9.5.1, Oracle 11g/9i,PL/SQL,Flat files, XML, MS AccessWeb services, Unix, Toad.

Confidential, Durham, NC

ETL Informatica Developer

Responsibilities:

• Involved in full life cycle design and development of Data warehouse.
• Interacted with business analysts, data architects and application developer to develop a data model.
• Prepared the required application design documents based on functionality required.
• Created logical and physical data models
• Worked with Designer tools like Source Analyzer, Target designer, Mapping designer, Mapplets designer, Transformation Developer.
• Designed and developed mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator, Web services Consumer, XML Generator Transformations.
• Extensively working on developing Continuous Change Data (CDC).
• Design and build data model and structures for OBIEE Logical Layer
• Involved in migration of mappings and sessions from DEV to TEST and production repositories
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Optimized the existing applications at the mapping level, session level and database level for a better performance.
• Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Created Stored Procedures to transform the Data and worked extensively in SQL
• Performed batch job scheduling through Maestro Scheduling tool.
• Performed data quality analysis to validate the input data based on the cleansing rules.
• Used Parameter Files defining variable values for mapping parameters and variables.
• Created FTP scripts and Conversion scripts to convert data into flat files to be used for Informatica sessions.
• Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
• Designed and developed UNIX Shell scripts for creating, dropping tables which are used for scheduling the jobs.

Environment: Informatica Power Center 9.x, SQL, MS SQL Server 2008, Erwin, Maestro Scheduling, UNIX.

Confidential, Bloomington, IL

Informatica Developer

Responsibilities:

• Involved in complete SDLC (System Development Life Cycle)
• Developed performance utilization charts, optimized and tuned SQL and designed physical databases. Assisted developers with Teradata load utilities and SQL.
• Converted batch jobs with BULKLOAD utility to TPUMP utilityin Teradata.
• Researched Sources and identified necessary Business Components for Analysis.
• Gathered the required information from the users.
• Interacted with different system groups for analysis of systems.
• Created tables, views in Teradata, according to the requirements..
• Created proper PI taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Implemented slowly changing dimensions methodology to keep track of historical data.
• Used Teradata utilities like MultiLoad, Tpump, and Fast Load to load data into Teradata data warehouse from Oracle and DB2 databases.
• Wrote appropriate code in the conversions as per the Business Logic using BTeq scripts.
• Loaded the data into the Teradata database using Load utilities like (Fast Export, Fast Load, MultiLoad, and Tpump).
• Automated the job scheduling using Maestro Scheduling tool.
• Solved Various Defects in Set of wrapper Scripts which executed the Teradata BTEQ, MLOAD, FLOAD utilities and Unix Shell scripts.
• Played a major role in setting up different regions - Testing, Integration, Performance, Break fix and Production environment with the Wrapper scripts and setup and folder structure for Teradata scripts to run in UNIX environment.
• Assisted in Batch processes using Fast Load, BTEQ, UNIX Shell and Teradata SQL to transfer cleanup and summarize data.
• Understanding BRD, Data required document and mapping documents.
• Creation of Data bases and users Space and User maintenance on dev machine.
• Designing the ETLs and conducting review meets Involvement in implementation of BTEQ and Bulk load jobs
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Created BTEQ scripts to extract data from warehouse for downstream applications.
• Worked on Teradata Query man to validate the data in warehouse for sanity check.
• Scheduled jobs for batch processing using Maestro Scheduler.
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
• Developed unit test plans and involved in system testing.

Environment: Informatica Power Center 8.1, Teradata12, Oracle 10g, SQL server 2008, PL/SQL, SQL* Loader, Maestro, UNIX Shell Scripting, UNIX AIX.

Confidential, Buffalo, NY

ETL Informatica Developer

Responsibilities:

• Interacted with business team to understand business needs and to gather requirements.
• Prepared requirements document in order to achieve business goals and to meet end user expectations.
• Created Mapping document from Source to stage and Stage to target mapping.
• Involved in creating data models using Erwin.
• Worked with Designer tools like Source Analyzer, Target designer, Mapping designer, Mapplets designer, Transformation Developer.
• Designed Mappings by including the logic of restart.
• Created source and Target Definitions, Reusable transformations, Mapplets and Worklets.
• Created Mappings and used transformations like Source Qualifier, Filter, Update Strategy, Lookup, Expression, Router, Joiner, Normalizer, Aggregator Sequence Generator and Address validator.
• Involved in tuning the mappings, sessions and the Source Qualifier query.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Manage all technical aspects of the ETL mapping process with other team members
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Performed Unit testing and created Unix Shell Scripts and provided on call support.
• Preparation of UTP (Unit Test Plan) with all required validations and test cases.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center
• Actively participated in Scrum Meetings.
• Worked on PL/SQL, Functions and Procedures.
• Developed and modified UNIX shell scripts as part of the ETL process.
• Participated in discussions with the team members on Prod issues and resolved.
• Monitoring the Data Quality, Generating weekly/monthly/yearly statistics reports on production processes - success / failure rates for causal analysis as maintenance part and Enhancing exiting production ETL scripts.
• 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.
• Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
• Created Unix Shell Scripts to automate sessions and cleansing the source data.
• Implemented pipeline partitioning concepts like Hash-key, Round-Robin, Key-Range, Pass Through techniques in mapping transformations

Environment: Informatica Power Center 8.6.1, Oracle 11g, TOAD, SQL Server, Erwin, UNIX.

Confidential, Charlottesville, VA

ETL/Informatica Developer

Responsibilities:

• Responsible for Business analysis and requirements gathering from the Business users.
• Involved in Designing Logical and Physical Data model using Erwin Tool.
• Involved in creating the design and Mapping specifications for the ETL process based on Functional specifications.
• Worked with Informatica power center client tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Designer tools like Source Analyzer, Target designer, Mapping Designer, Mapplets Designer and Transformation Developer.
• Developed mappings using Informatica Power Center Designer to transform and load the data from source systems to Staging and Staging to target database.
• Worked on various types of transformations like Expression, Joiner, and Update strategy, Aggregator, Filter, Lookup and Router.
• Involved in designing, developing and testing of the ETL strategy to populate data from various source systems (Oracle,Teradata, flat files, SQL Server) feeds using Informatica.
• Created Mapplets to reduce the development time and complexity of mappings and better maintenance.
• Developed staging jobs where in using data from different source formatted, Cleaned, Summarized, aggregated and transformed into data warehouse.
• Developed ETL design for initial and incremental loads.
• Implemented performance tuning logic on Targets, Sources, Mappings, Sessions to provide maximum efficiency and performance.
• Identifying and Removing Bottlenecks in order to improve the performance of Mappings and Workflows.
• Created stored procedures for dropping and recreating indexes on target tables.
• Involved in Enhancements and Maintenance activities of the data warehouse including performance tuning.
• Created various tasks like sessions, decision, timer & control to design the workflows based on dependencies.

Environment: Informatica Power Center 7.1.3, SQL Server 2005/2008, Oracle 10g, PVCS, Erwin 4.0, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Responsible for the creating stored procedures and database triggers.
• Wrote SQL scripts to create staging tables and developed SQL*Loader control files to load the data from data files into the staging tables.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• I was responsible for system design and development in Power Builder and Oracle.
• Tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment.
• Extensively used cursors, procedures, functions, packages and UNIX Shell scripting to migrating data from oracle database to flat files.
• Created source to target mappings using Informatica.
• Short term assignment to assist Oracle in a data clean up and conversion / migration task using Oracle Warehouse Builder 10G Rel. 2, to migrate mainframe legacy to Oracle eBusiness Suite.
• Effectively utilized new features of OWB to perform Data Profiling, resulting in significant data cleansing.

Environment: Informatica, Oracle9i, SQL, PL.SQL, TOAD, Erwin, UNIX, Windows.