Summary:

• Good experience in first logic, normalization for database designs purpose.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows in all versions of Informatica.
• Worked on Teradata queries, Macros, Procedures and Tuning queries.
• Extensively worked on Teradata queries and Utilities BTEQ, MLOAD, FLOAD, FEXPORT, TPUMP.
• Solid Expertise in Oracle Stored Procedures, Triggers, Index, Table Partitions and experienced in Loading data into targets like Flat files, xml files, oracle,DB2, SQL Server into Data Warehouse/Data Marts using Informatica.
• Expertise in Data warehouse, Data mart, OLAP, ROLAP, MOLAP, OLTP and Dimensional Data Modeling of Star, Snowflake and Star join Snowflake Schema modeling.
• Around 8 years of Strong Data Warehousing experience of ETL using Informatica PowerCenter 9.5/9.1/8.x/7.1 and Informatica PowerExchange 9.1/8.6/8.1.
• IT Professional with 8 plus years of Experience in the Business Requirements Analysis, DatawareHouse Design, Data Modeling, Development, Implementations and Testing of software systems in various verticals such as Financial, Retail, Insurance industries.
• Extensively worked on Data warehouse Design and created Logical and Physical Data Model using MS Visio and ERWIN.
• Developed Design Documentation for all development efforts.
• Implemented Informatica ETL methodology for designing and developing extraction, transformation and load processes.
• Worked on designing and development of CDC real time and batch processing using Informatica Power Exchange.
• Received Customer Appreciation Certification for successfully delivering the projects without any defects within scheduled time.
• Good knowledge in extracting data from Flat Files, Unstructured data, xml formats and PDF format files and transforming and loading into Oracle database, flat file JMS Queue, COBOL files and vice versa.
• Developed UNIX Shell Scripts to ensure successful execution of the ETL processes.
• Experience in Unit testing, System testing while moving the code from development to production.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Sr Informatica Developer

Project Description: Confidential is an American software company that develops financial and tax preparation software and related services for small businesses, accountants and individuals.

Project Role:

• Involved with Business Analysis, requirement gathering designing Logical/Physical Data Models.
• Extensively worked on Data warehouse design and created Logical and Physical Data Model using MS Visio and ERWIN.
• Created complex mappings using different transformations like Filter, Router, Connected Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Union, Expression and Aggregator transformations to pipeline data to extract data from various databases, Flat files and load into Data Mart using the Designer tool. Also, made use of variables and parameters.
• Used Informatica Workflow Manager for Creating, Running Sessions and scheduling them to run at specified time.
• Involved in designing real-time informatica mappings and workflows.
• Created Scripts for pmcmd commands, restart deadlock workflow, space check and dependency scripts
• Created reusable transformations mapplets and used them in various mappings.
• Created PL-SQL procedures to detect CDC methodologies and developed Slowly Changing Dimension for Type 1 and Type 2.
• Created Indexes, primary keys and checked other performance tuning at database level.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows. Worked with Change data capture option to enhance business agility.
• Developed Oracle Stored Procedures, Package, Function and Trigger. Performed fine Tuning of SQL PL/SQL stored procedures.
• Performed Unit testing by comparing the source and target data.
• Created Teradata utilities like BTEQ, MLOAD, FLOAD, TPUMP.
• Created Web Services Source, Target and mappings for sending and receiving message from portal.
• Extensively worked on XML source and target. Worked on XML parser and generator.
• Created MQ sources and target and configured workflows to retrieved message and send messages.

Project Environment: Informatica Power center 9.5/9.0.1, Power Exchange 9.0.1/9.5, Oracle 11g, DB2, TOAD, PL/SQL Developer, SQL Loader, Erwin r7.1, SQL, PL/SQL, UNIX Shell Scripts, AIX, Teradata 13, Autosys.

Confidential

Sr Informatica Developer

Project Description: AstraZeneca is global innovation-driven biopharmaceutical company specializing in the discovery, development, manufacturing and marketing of prescription medicines that make a meaningful difference in healthcare. AZ developing a data mart for all Medicine research related reporting and initiated the Project RDM. As part of this projects get the details from different source systems and update the RDM Research Data Mart . The data from OLTP systems is extracted and loaded into staging tables, ODS and Data Mart.

Project Role:

• Fast paced project involving understanding the business, current processes and requirements.
• Gathered Requirements from users, translated user inputs into ETL design documents.
• Performed Business Analysis, Designed, Developed, Tested and Implemented Informatica transformations and Workflows for extracting the data from the multiple legacy systems.
• Developed complex mappings using multiple sources and targets in different databases, flat files.
• Used various transformations like unconnected lookup, connected lookup, aggregator, rank, joiner, stored procedure etc.
• Applied performance tuning on targets, sources, mappings, sessions and database to improve system performance.
• Created and Executed UNIX shell scripts and PL/SQL procedures, Pre-session and Post- Session Scripts to ensure timely, accurate processing and ensure balancing of job runs.
• Performed Unit testing of Informatica Mappings, Workflows and Mapplets and tuned them to improve performance.
• Worked with the team to create reusable ETL solutions to achieve enormous improvements.
• Assisted in the process of preparation of documenting Informatica transformation Development Standards.
• Generated Cognos reports to help QA team achieve quick and efficient turnarounds.

Project Environment: Informatica PowerCenter 8.6, Informatica PowerExchange 8.6, PL/SQL, Oracle 10g, TOAD, Tidal, Windows 2000, SQL Server 2008, Tidal, Cognos, LINUX, Business Object XI.

Confidential

Informatica Developer

Project Description: Magellan Health Services is a specialty health care management company that delivers innovative solutions in collaboration with health plans, corporations and government agencies and their members nationwide. MHS is specialized in managing behavioral health care, diagnostic imaging, specialty pharmaceutical services and providing pharmacy benefits administration. At this client, worked on Radiology project where data customer's information from various clients affiliated to MHS are loaded into centralized Data Mart. At this client, worked on Radiology project where data customer's information from various clients affiliated to MHS are loaded into centralized Data Mart.

Project Role:

• Requirement gathering and Business Analysis. Involved in data modeling and created LDM and PDM.
• Participated and coordinated in onsite-offshore meetings.
• Worked on various HIPAAterms functionalities.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Developed various Sessions, Batches for all Mappings for loading from verious sources like flat files, tables, XMLs and csv file to Target tables.
• Created complex mappings using Unconnected, Lookup, and Aggregate transformations for populating target table in efficient manner.
• Worked on performance tuning for ETL processes.
• Maintaining source definitions, transformation rules and targets definitions using Informatica Repository Manager.
• Used ETL to extract and load data from GlobalRepositories, Folders, Permission and user using repository manger.
• Used shell Scripting and Scheduled pmcmd to interact with Informatica Server from command mode.
• Translated business requirement to technical specifications and developed Informatica mapping/Workflows.
• Used PL-SQL procedures to detect CDC methodologies and developed Slowly Changing Dimension for Type 1 and Type 2.
• Created Indexes, primary keys and checked other performance tuning at data base level.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Developed Oracle PL/SQL Stored Procedures. Performance and fine Tuning of SQL PL/SQL stored procedures.
• Performed Unit testing by comparing the source and target data.
• Loaded data to Staging area using Terdata FLOAD utilities. Created BTEQ Script for ETL processing.

Project Environment: Informatica PowerCenter 8.6, Power Exchange 8.6, Oracle 10g, TOAD, PL/SQL Developer, SQL Loader, Erwin r7.1, SQL, PL/SQL, UNIX Shell Scripts, Linux, Teradata V2R6.

Confidential

ETL/Database Developer

Project Description: The Promotion Measurement Module will enable users to evaluate the effectiveness of promotion decisions in a graphical, easy to read scorecard format. It will help to understand the total impact on the category, brand, and enterprise taking into account overall cannibalization and affinity measures. This level of decision support will help to drive sustainable improvements in financial performance.

Project Role:

• Design and Unit test different Modules and Applications.
• Worked on the Master test plan and test cases.
• Worked on integration testing.
• Physical and logical data modeling using ERWIN.
• Wrote triggers and stored procedures in PL/SQL.
• Involved in the requirement gathering and analysis in support of data warehousing efforts.
• Involved in Designing the Data warehouse using Informatica ETL tool.
• Performing unit testing on the data and reports validation.
• Wrote re-usable mapplets to create Error handling routines.
• Performance tune ETL code and SQL Query.

Project Environment: Informatica Power center 7.1, UNIX, Oracle 10g, TOAD, SQL plus, SQL Loader, MS Office, AIX, ESP, Business Objects.

Confidential

Database Developer

Project Description: Financial Accounting System was developed to handle all types of deposits, deposited in various schemes. The system's primary responsibilities were to give current information of details of customers, details of deposits, cash status and credit information to the administrative division and also to give details of deposits to the customers.

Project Role:

• Collaborated with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts.
• Analyzed the data from various sources such as PeopleSoft, AVR, etc. to maintain consistency and performed validation.
• Extensively used Informatica Client tools Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Workflow Manager.
• Developed various mappings using Aggregator, Lookup and Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator.
• Created Complex Mappings which involved SCDs to implement Business Logic and capturing the deleted records in the source systems.
• Developed PL/SQL stored procedures for database updates and to create the necessary indexes in the target tables.
• Created PL/SQL packages and stored procedures to load data from various sources to staging area.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Wrote UNIX shell scripts to work with flat files to define parameter files and to create pre and post session commands.
• Used Debugger in troubleshooting the existing mappings.

Project Environment: Informatica Power center 7.1/6.2, UNIX, Oracle 9i, TOAD, SQL plus, SQL Loader, MS Office, Linux, Autosys.