SUMMARY

• 7+ years of Experience in Project Life cycle activities on Development, Implementation, and Maintenance of Data Warehouse and Data Integration Applications
• Expertise in design and development of medium to high complexity ETL mappings to support large data volume movement using Informatica Power Center 9.5.1 9.6.1/9.1/8. x/7.x.
• Extensive experience with ETL tools Informatica Power Center/Power Mart 9.5/9.1/8.6/7.1/6.1 Power Exchange 8.6.1/8.1/7.1 in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, configuring the Informatica Server and scheduling the Workflows and sessions
• Four years of experience working with Informatica Power Exchange.
• Expertise in integration of various data sources like SQL Server 2012/2008, Oracle 11g/10g/9i 13/12/V2r5, XML, Flat files, DB2 9.8/10.1 using ETL Tools.
• Strong Experience in designing and developing complex mappings applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter, joiner, sorter transformations.
• Solid experience in implementing SCD TYPE I and TYPE II, working with Mapping Parameters and Variables.
• Expertise in creating mapping Parameters, Variables and Reusable Tasks (Sessions, Command, Email).
• Implemented Pre - Session and Post-Session shell scripting to run workflows using pmcmd command.
• Understanding and Implementation experience on Informatica CDC (Change Data Capture)
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Extensive experience in database languages SQL and PL/SQL which includes writing Triggers, Stored Procedures, Functions, Views and Cursors
• Worked on the migration of code from one environment to another and also worked on all phases of deployment.
• Experience in implementing the Informatica best practices throughout the development cycle.
• Experience with Informatica Advanced Techniques - Dynamic Caching, Memory Management, Parallel Processing to increase Performance throughput.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings and sessions
• Expert in SQL*Loader data loading with Data Warehousing experiences
• Expertise in defining Workflows and Tasks, Monitoring Sessions, load scheduling and automation of Informatica workflow batches using Informatica scheduler, Control-M, DAC and shell scripting.
• Development and Testing of Data warehouses using ETL Logic
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments
• Involved in Technical Documentation, Unit test, Integration test, UAT and writing the test plan.
• Excellent team player and self-starter with good ability to work independently and possess good analytical, problem solving and logical skills.
• Excellent interpersonal and communication skills, and good experience in working with senior level management, business associates and developers across multiple disciplines.

TECHNICAL SKILLS

ETL tools: Informatica 9.62/9.6.1/9.1/8.6.1 (Power Center) 6.x, Informatica Power Exchange, Informatica B2B Data Exchange, Informatica power Connect, IDQ, IDE, metadata Manger

Database: ORACLE 12c/1gr2/10x/9i/8i/7i, IBM BD2 UDB10.1/9.7, Teradata v2r5/v2r6, MS SQL Server 2000/2005/2008/2008 R2/2012, Ms-Access, Sybase.

Reporting Tools: Business Objects Xlr2/r 1/6.5/6.1/5.1 , Congnos Reportnet, Cognos 8, SSRS, SAS

Operating System: MS Windows 2000/NT/98/XP, LINIX6.6, UNIX, MSDOS, Sun Solaris

Programming: C, C++, Visual Basic, T-SQL, PL/SQL, XML, JAVA

Software: MS Project, MS Word 97/2000, MS Excel 97/2000, MS Office, MS PowerPoint

Data Utilities: SQl*Plus, Stored Procedures, Functions, Exception handling.

Data Modelling tools/Methodology: MS Visio, ERWIN 4.x/3.x, Ralph-Kimball Methodology, Bill-Inmon Methodology, Star schema, flake schema, extended star schema, physical and logical modelling.

PROFESSIONAL EXPERIENCE

Confidential - Columbus, Ohio

Sr. Informatica Developer

Responsibilities:

• Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Analyzed the system for the functionality required as per the requirements and created System Requirement Specification document (Functional Requirement Document).
• Involved in the development of the conceptual, logical and physical data model of the star schema using ERWIN
• Used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Designed and developed daily audit and daily/weekly reconcile process ensuring the data quality of the Data warehouse.
• Extracted data from various sources like Flat Files,SQL server 2008, Oracle 11g, and relational databases
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Administrating User Privileges, Groups and Folders which includes creation, update and deletion.
• Migration of New and Changed Informatica objects across the environments using Folder to Folder and Deployment Group methods.
• Used SCD2 to populate the data in a generic way. Single mapping is used to load multiple tables data
• Involved in the development of Data Mart and populating the data marts using Informatica.
• Written SQL override queries in source analyzer to customize mappings
• Developed UNIX shell scripts using PMCMD utility and scheduled ETL loads using ControlM.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Involved in the administration of the Informatica Repository and also in the design and architecture of multiple repositories to support multiple application development areas.
• Involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures

Environment: Informatica Power Center 9.5/9.1, Informatica Power Exchange 8.6, Oracle 11i/10g, SQL server 2008, Flat Files, SQL, PL/SQL, Erwin r 7, Control M, TOAD, UNIX Shell Scripting, Windows XP

Confidential - Columbus, Ohio

Sr. Informatica Developer

Responsibilities:

• Responsible for requirement gathering, data Analysis, user meetings, discussing the issues to resolved and translated the user inputs into ETL design documents.
• Worked with Informaticapowercenter 8.5 tools like Designer, Workflow Manager, Repository Manager, source analyzer, warehouse designer, mapping & mapplet designer and Transformation developer.
• Developed Informatica mappingsusing source qualifier, joiner, Lookups (connected and unconnected), expression, filter, router, and aggregator, sorter, update strategy and normalizer transformations.
• Involved in making the changes to the existing data models to accommodate the new requirements.
• Responsible for finetuning the ETL code and sessions which include fine tuning lookup overrides and SQL override queries, implementing the Delta logic (Change data Capture) to speed up the session runs.
• Responsible for Optimizing the ETL loads and also redesigning ETL Interfaces which were not providing the accurate data for the business.
• Worked with mapping parameters and variables, session parameters, pmcmd commands, email tasks.
• Responsible for fixing PLSQL procedures for getting the accurate data.
• Worked with SQL override, Lookup override, Lookup caches, Index and Data caches while designing the mappings Worked with TOAD SQL*Loader for loading the data from external files into RDBMS tables.
• Fine-tuned the SQLqueries using Explain Plan and Tkprof.
• Handled Informaticaadministration work like migrating the code, creation of users, creating folders, Worked with Shortcuts across shared and non-shared folders
• Written Autosys Jil scripts for scheduling the workflows.
• Responsible for reconciliation of the loaded data to see whether it is according to the business needs
• Created and executed unit testplans based on system and validation requirements.Worked closely with Business during the testing phase and fixed bugs that were reported.

Environment: Informatica Power Center, Programming: VB, Java, C, Pro*C, SQL/SQR, PLSQL, C++

Confidential -Austin, TX

Sr. Informatica Developer

Responsibilities:

• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Designed Informatica mappings by translating the business requirements.
• Worked with Business analysts and DBAs for requirements gathering, business analysis and designing of the data warehouse.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed mappings for customers, Investments and Risk analysis.
• Assisted in adding Physical conceptual data model using Erwin.
• Developed reusable Transformations.
• Widely used Informatica client tools -- Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Responsible for fine tuning the ETL code and sessions which include fine tuning lookup overrides and SQL override queries, implementing the Delta logic (Change data Capture) to speed up the session runs.
• Knowledge of setting up and tuning User Exitprocesses.
• Involved in the process design documentation of the DW Dimensional Upgrades.
• Installed and documented the InformaticaPowerCenter setup on multiple environments.
• Experience in handling support cases and enhancement with Informatica support and product management team.
• Coordinate with different teams for support and deployments.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Performed extensive bulkloading into the target using Oracle SQL Loader.
• Extensive performancetuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Used workflowmanager for session management, database connection management and scheduling of jobs.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.

Environment: Informatica Power Center 7.0/6.2 (Power Center Repository Manager, Designer, WorkflowManager, and Workflow Monitor), Oracle 9i, TOAD, Erwin 4.0, PL/SQL, UNIX (Sun Solaris)

Confidential - Washington, D.C

Informatica Developer

Responsibilities:

• Gathered business requirements from Business Analyst.
• Designed and implemented appropriate ETLmappings to extract and transform data from various sources to meet requirements.
• Installed and configured the InformaticaClienttools.
• Designed and developed InformaticaETLmappings to extract master and transformational data from heterogeneous data feeds and load.
• Worked on loading of data several flatfiles to XML Targets.
• Created the environment for staging area, loading the staging area with data from multiple sources.
• Designed the procedures for getting the data from all systems to DataWarehousingSystem.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Created UNIXshellscripts for Informatica ETL tool to automatesessions.
• Used Workflow manager for session management, database connection management and scheduling of jobs.
• Debugged mappings for failed sessions.

Environment: Informatica Power center 5.1.2/7.7, Erwin, 4.5, Oracle 9i, Windows NT, Flat files, SQL, Relational tools,Clear case, UNIX (HP-UX, Sun Solaris, AIX) and UNIX shell Scripts.

Confidential

Informatica Developer

Responsibilities:

• Participated in building of the DataWarehouse, which includes the design of DataMart using StarSchema.
• Worked extensively on different types of transformations like sorter, Expressions, filter, Aggregate, Rank, Lookup, Stored Procedures, Sequence generator and Joiner.
• Integrated various sources in to the Staging area in Data warehouse for Integrating and Cleansing data.
• Used Incremental Aggregation to apply the captured changes from the source to aggregate target tables in a session
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Scheduled workflows within Informatica using Informatica scheduler.
• Created worklets to reuse a set of workflow logic in several workflows
• Used PMREP program in interactive and command line mode to perform repository tasks
• Performed partitioning of sessions for concurrent processing.
• Used Crontab to schedule and automate the session running process
• Handling Versioning of the mappings, shell scripts and workflows using PVCS
• Involved in upgrading of Informatica PowerCenter 5.1 to 6.1 version and validated mappings and workflows

Environment: Informatica Power Center 5.1/6.1, Oracle 8.17, Business Objects 5.1, Web Intelligence 2.6, PL/SQL, SQL*Plus, TOAD, Windows 2K, UNIX.