Professional Summary:

• About 7 years of experience in Information Technology including Data Warehouse/Data Mart development using ETL/Informatica Power Center.
• Worked on various domains including Insurance, Finance, Health, Pharmaceutical and Retail.
• Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support.
• Worked in various Heterogeneous Source Systems like Oracle, DB2 UDB, Teradata, MS SQL Server, Flat files and Legacy systems.
• Practical understanding of the Data modeling Dimensional Relational concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Good understanding of views, Synonyms, Indexes, Joins and Sub-Queries. Extensively used Cursors and Ref Cursors.
• Expertise in creating very detailed design documents and performing Proof of Concepts POC .
• Extensively created mapplets, common functions, reusable transformations, look-ups for better usability.
• Experience in Performance tuning of ETL process. Reduced the execution time for huge volumes of data for a company merger projects.
• Providing the right level of data quality management for the appropriate business user.
• Experience in Dataflux and informaticaData explorer IDE /Informatica Data Quality IDQ tools for data Analysis / Data Profiling and Data governance and Data Quality using First Logic.
• Worked with Informatica Server and Client tools, experience in the Data Analysis, Design, Development, Implementation, Testing, Production Support of Database/Data warehousing, Legacy for various industries using DataModeling, Data Extraction, Data Transformation and Data Loading.
• Extensive experience in Tuning and scaling the procedures for better performance by running explain plan and using different approaches like hint and bulkload.
• Used Power Exchange to integrate the sources like Mainframe MVS, VSAM, GDG, DB2 and XML files.
• Extensively used SQL, PL/SQL in writing StoredProcedures, Functions, Packages and Triggers.
• Experience in using Exception Handling strategies to capture errors and referential integrity constraints of records during loading processes to notify the exception records to the source team.
• Experience in UNIX shell scripting, job scheduling and communicating with server using pmcmd.
• Experienced with Teradata utilities FastLoad, MultiLoad, BTEQ scripting, FastExport, SQL Assistant.
• Delivered all the projects/assignments within specified timelines.
• Worked on SAP Business Objects enterprise information management EIM solutions providing comprehensive information management functionality that can help you deliver integrated, accurate, and timely data both structured and unstructured across the enterprise.
• Participating in problem solving and troubleshooting for the applications implemented with ODI.
• Worked on managing Transaction Data and Reference Data.
• Knowledge of prebuild OBIEE Dashboard, RPD Metadata Process.
• Effectively communicate with business, projectmanager and team members.
• Responsible for Team Delivery and Participated in Design Reviews.
• Guided team members to deliver their task.
• Assisted Project Manager in estimation and planning.
• Strong ability to work within a demanding and aggressive project schedules and environments.

TECHNICAL SKILLS:

• ETL Tools Informatica Power Center 6.x/7.x/8.1/8.6.1/9.0.1 Source Analyzer, Mapping Designer, Workflow Monitor, Workflow Manager, Power Connects for ERP and Mainframes, Power Plugs , Power Exchange, Power Connect. IBM InfosphereDataStage 8.5 Designer, Director, Administrator ,
• OLAP/DSS Tools Business Objects XI r2/6.5.1
• Databases Oracle 8i/9i/10g/11g, DB2, MS SQL Server 2005/2000Teradata v2r12/v2r6/v2r5
• Others TOAD, PL/SQL Developer, Perl,SQL-Navigator,TestDirector, WinRunner
• Database Skills Stored Procedures, Database Triggers and packages
• Data Modeling Tools Physical and Logical Data Modeling using ERWIN 3.5/4.5/7.x
• Languages C, C , UNIX shell scripts, XML, HTML
• Operating Systems Windows NT/ 2000/2003, AIX, Sun Solaris, LINUX, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL Developer

Responsibilities:

• Collaborated with Business analysts for requirements gathering, business analysis and designing of the Enterprise Data warehouse
• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like DB2, COBOL Copy Books, MS SQL Server,Oracle, flat files, XML files and loading into Staging and Data Ware House Star Schema.
• Involved in massive data cleansing prior to data staging.
• Designed SCD Type 1 and Type 2 mappings
• Used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Design and Development of ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Converted MS SQL Server SSIS Packages logic into Informatica mappings.
• Created complex mappings with shared objects/Reusable Transformations/Mapplets using mapping/mappletParameters/Variables.
• Configured workflows with Email Task, which would send mail with session, log for Failure of a sessions and for Target Failed Rows.
• Used Server Manager to create schedules and monitor sessions. And to send the error messages to the concerned personal in case of process failures.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre Post Session SQL Script to meet business logic.
• Used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL, PL/SQL for various needs of the transformations while loading the data into SQL Server database.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Developed Unix Scripts to extract the data from Oracle, SQLServer and load into SQL Server database.
• Scheduled Informatica workflows to run at regular intervals.
• Used SQL tools like Query Analyzer and TOAD to run SQL queries and validate the data.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Designed and developed the logic for handling slowly changing dimension table's load by flagging the record using update strategy for populating the desired.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in Unit testing, User AcceptanceTesting to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Performed numerous ad-hoc requests, financial reports involving SQL scripts, UNIX, SAS, TOAD.
• Programming client side scripts to deliver more dynamic and customized content to the Internet browsers.

Environment:Informatica Power Center 9.0.1, Oracle 11g,DB2, MS SQL Server2008, SQL, PL/SQL, T-SQL,SQL Plus, TOAD, Erwin, Unix.

Confidential

Sr. ETL Developer

Responsibilities

• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Involved in Dimensional modeling to Design and develop STAR Schema, Using ER-win to design Fact and Dimension Tables.
• Analyzing the source data coming from different sources and working with business users and developers to develop the Model.
• Worked with MLOAD, FASTLOAD, TPUMP and BTEQ utilities of Teradata for faster loading and to improve the performance.
• Creation of customized MLOAD scripts on UNIX platform for Teradata loads
• Written several Teradata BTEQ scripts to implement the business logic.
• Created Test tables and worktables on development and production on Teradata.
• Worked extensively with the Teradata Quarryman to interface with the Teradata.
• Developed views on departmental and claims engine database to get the required data.
• Developed application views in Teradata and using expression and router implemented the Change Data Capture CDC process.
• Involved in source data profiling source system analysis.
• Involved in designing the Logical and Physical data models for the data warehouse
• Developed SQL code for data validations and data computation process on source DB2 transaction system and on target warehouse
• Involved in massive data cleansing prior to data staging.
• Developed shell scripts, cron jobs for job execution and automation on server side.
• Define strategy for ETL processes, procedures and operations
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Administrated users and user profiles and maintained the repository server.
• Tuning the complex mappings based on source, target and mapping, session level
• Extensively used pmcmdcommandson command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files
• Extensively used transformations like lookup, router, Aggregator, sequence generator, filter, update strategy, joiner.
• Handled slowly changing dimensions of Type1/ Type 2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
• Document the process for further maintenance and support.

Environment: Informatica Power Center8.5.1/7.1.4,Teradata v2r12, Business Object XI, Oracle 10g, MS SQL Server , Toad, PL/SQL, SQL, XML

Confidential

Sr. ETL Developer

Responsibilities:

• Involved in gathering of business scope and technical requirements and written technical specifications.
• Involved in all phases of software development life cycle SDLC in RUP framework.
• Fine-tuned existing Informatica maps for performance optimization.
• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up connected and unconnected , Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Involved in massive data cleansing and data profiling of the production data load.
• Created synonyms for copies of time dimensions, used the sequence generator transformation type to create sequences for generalized dimension keys, stored procedure transformation type for encoding and decoding functions and Lookup transformation to identify slowly changing dimensions.
• Created FTP scripts to transfer data from consumer systems to HCA systems, and Conversion scripts to convert data into flat files to be used for Informatica sessions.
• Worked on Informatica tool Source Analyzer, Data warehousing designer, Mapping Designer Mapplet and Transformations.
• Involved in capturing slowly changing dimensions including type-I, type-II, and type-III.
• Used ready wizards in Informatica to capture and implement SCD Type-II Changing Data and tuned it requirement.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Extensively used ETL to load data from flat files excel/access , Teradata database.
• Load balancing of ETL processes, database performance tuning and Capacity monitoring.
• Involved in the Unit testing, Event Thread testing and System testing of the individual.
• Analyzed existing system and developed business documentation on changes required.
• Develop and execute load scripts using Teradata client utilities MULTILOAD, FASTLOAD and BTEQ.
• Written JCL scripts and created stored procedures in TERADATA SQL Assistant.
• Made adjustments in Data Model and SQL scripts to create and alter tables.
• Scheduled and monitored automated weekly jobs under UNIX environment.
• Extensively involved in testing the system from beginning to end to ensure the quality of the adjustments made to oblige the source system up-gradation.
• Involved in tracking and reporting defects using Clear Quest and was also responsible for communicating the status to the team in bug meetings.
• Worked with many existing Informatica Mappings to produce correct output.
• Made use of Server Manager to create and monitor sessions and batches.
• Efficient Documentation was generated for all mappings and workflows.

Environment: Informatica Power Center 8.5.1,Custom programming using Perl, IMS Data Xponent, XponentPlantrak, PlanTrak, Rx Data , Teradata V2R6, Oracle 10g, MS SQL Server 2005/2000, RTMS, HP UNIX Shell Scripting, PL/SQL, Syncsort for UNIX, Rational Clear Quest, Windows 2000, HP-UX.

Confidential

Sr. ETL Developer

Responsibilities:

• Analyzed existing system prepared and presented an Impact Analysis Document.
• Actively participated in the design, development and implementations of the Enterprise Data Warehouse EDW process and Data mart.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Configured the Repositories.
• Developed various mappings by using reusable transformations.
• Executed the workflow using pmcmd command in UNIX.
• Improved the mapping performance using SQL overrides.
• Created Mapplets and used them in different mappings.
• Used Debugger to test the data flow and fix the mappings.
• Implemented Error data validations using Error handling strategy techniques.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Implemented all the ETL Architecture standards for the new technology Teradata
• Post-Production support to monitor jobs in new environment.
• Developed mappings, sessions and workflows for the new ETL process followed with Quality standards.
• Responsible for QA migration and Production Deployment.
• Used various transformations for data Manipulation.
• Most of the transformations were used like Source Qualifier, Aggregator, Filter, Expression, and Unconnected and connected Lookups, Update Strategy and Normalizer.
• Developed and implemented the long term IT goals and strategies.
• Participate in the rotation of 24/7 supports.

Environment:Informatica Power Center 7.1.2, Oracle 8i, Flat files, SQL server 2005, Analytics Server 3.1.2, Business Objects 6.0, Shell / Perl Script, Sun Solaris OS, PL/SQL, Toad 7.0, Erwin 3.5.2.

Confidential

Sr. ETL Developer

Responsibilities

• Extensively worked on Informatica Power Center 6x tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets Designer, Transformation Developer and Workflow Manager.
• Various Mappings were developed using Designer that involved different transformations like Update Strategy transformation, Lookup transformation, Aggregator transformation, and Stored Procedure transformation, Expression Transformation.
• Created reusable transformation and mapplet based on the business rules to easy the development process and responsible for document the changes.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Written Scripts to achieve the files and to maintain same naming for the files coming from different machines and also to update parameter file.
• Used Debugger to test the data flow and fix the mappings.
• Different Performance Tuning techniques were implemented to optimize data load.
• Data Quality Analysis to determine cleansing requirements.
• Developed test cases for system integration testing
• Updated change request documents for review and approval, in response to modification requests.

Environment: Informatica Power Center 6.2, Oracle 8i, Business Objects 6.5, DB2, Flat Files, XML, Unix.

Confidential

Data Warehouse Developer

Responsibilities:

• Developed and supported the Extraction, Transformation, and load process ETL for data migration using Informatica power center.
• Responsible for developing Source to Target Mappings.
• Extensively used Informatica Client tools- Source Analyzer, Warehouse Designer, Mapping Designer.
• Developed Informatica mappings for data extraction and loading worked with Expression, Lookup, Filter and Sequence generator and Aggregator Transformations to load the data from source to target.
• Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation.
• Developed mappings, sessions for relation and flat source and targets.
• Imported data from various source Oracle, Flat file, XML and transformed and loaded into targets using Informatica.
• Created and scheduled Session, jobs based on demand, run on time
• Monitored Workflows and Sessions
• Involved in developing Ad-hoc reports using Business Objects.
• Identified the facts and dimensions and designed the relevant dimension and fact tables.

Environment:Informatica 6.2, Business Objects, Oracle 8i, Erwin 4.0, PL/SQL, UNIX and Windows NT.