SUMMARY:

• Eight (8) years of Technical and Functional experience in Data - warehouse implementations using Informatica PowerCenter 9.x/8.x, Oracle 11g/10g, Netezza, MS SQL Server 2012/2008.
• Extensive experience in Informatica PowerCenter in all phases of Analysis, Design, Development, Implementation and support of data-warehousing applications.
• Expert in Database skills using SQL, PL/SQL Developer for debugging applications.
• Strong knowledge in Data warehousing concepts, dimensional modeling Star Schema and Snowflakes Schema, Fact and Dimensional tables.
• Extensively worked on Transformations such as Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Experience in working with business analysts to identify study and understand requirements and translated them into ETL code in Requirement Analysis phase.
• Proficient in using Informatica workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions.
• Experience in documenting High Level and Low Level Design, Source to Target Mapping (STM), Macro and Micro Documents, Unit test plan, Unit test cases and Code Migration Report.
• Experience with industry standard methodologies like waterfall, Agile within the software development life cycle.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Experience in writing various ETL procedures in order to load data from different sources like Oracle 10g, DB2, XML Files, Flat Files, MS SQL Server and MS Access into Data marts, Data warehouse using Informatica Power Center.
• Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklets, Control).
• Worked on performance tuning, identifying and resolving various performance bottlenecks at various levels like sources, mapping and sessions.
• Extensive experience in writing UNIX scripts and also automation of the ETL processes using UNIX shell scripting.
• Extensive experience on working with scheduling tools like SAS Management console, Crontab and lsfadmin tools.
• Expert in debugging, troubleshooting, monitoring, and performance tuning of Sources, Mappings, targets and sessions.
• Quick learner, excellent team player Possess good interpersonal, presentation and development skills with strong analytical and problem solving approach

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.x/8.x (PowerCenter Repository, Informatica Designer, Workflow manager, Workflow monitor), Power Exchange, Developer (IDQ) and Analyst (IDE), Informatica Cloud

BI & Reporting: Business Objects Xi R3, Crystal Reports, SSRS

Data Modeling: Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Data Quality, Entities, Attributes, ER Diagrams

Databases: Oracle 11g/10g, MS SQL Server 2012/2008, Teradata V2R6/V2R5, MS access, DB2

Job Scheduling & other tools: SQL plus, PL/SQL Developer, Toad, SQL* Loader, Teradata SQL assistant 7.1, lsfadmin, Crontab, Control-M

Environment: s:UNIX (Sun Solaris, AIX), Windows 2000/NT/XP/VISTA/7, 8 Windows server 2008, Windows NT

Languages: PL/SQL, SQL, XML, HTML, Data Structures, UNIX Shell Script

Office Applications: MS Office 2003/ 2007/2013

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, IN

Sr. Informatica Developer

Responsibilities:

• Understanding the business rules provided to design and develop mapping for the ETL.
• Involved in complete understanding of business requirement and involved in analyzing, Data profiling the sources to load in Oracle warehouse.
• Involved in working with different sources like Flatfiles (both delimited and fixed width), Oracle and XML.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Created Source to Target Mapping Documents as per requirement.
• Responsible for working with DBA in order to calculate the estimated space required for each Source System depending on the requirement.
• Involved in working with 4-5 Source Systems in order to load them to build EDW environment.
• Used UNIX environment in order to run the batches where the jobs are grouped based on the requirement.
• Involved in basic testing required before migrating the objects to QA/UAT environment.
• Performed testing both in UNIX and also ORACLE level based on requirement. Also provided production support by monitoring the processes running daily
• Involved in performing Reconciliation based on the Source and Target.
• Created and scheduled Workflows using Informatica workflow manager.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Datasets.
• Implemented SCD type2 using product serial number as per requirement.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Responsible for Error Handling in Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Scheduled automatic workflows using Toad Scheduler
• Worked on handling performance issues, Troubleshooting of Informatica Mappings, evaluating current logic for tuning possibilities.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Responsible for creating production support documentation.
• Coordinate with business team, get the requirements from them and then coordinate with the team to get the work done, keeping timeline in mind.
• Involved in team weekly and by monthly status meetings.

Environment: Informatica Power Center 9.5.1, Oracle 11g, PL/SQL, TOAD, UNIX Shell Scripts

Confidential, Redmond, WA

Informatica Developer

Responsibilities:

• Handled large amount of data usually in millions per day.
• Handled live data which usually come in millions depending on number of customers.
• Designed a system which accepts the requests based on certain flags and created an extract for handling such requests.
• Stored the customers data in a dimension table and a fact table will be incrementally loaded.
• Worked with dynamic SQL transformation which involves lot of joins on fact and dimension tables.
• Used pre SQL of source qualifier which involves handling many SQL queries.
• Worked on Mapping and workflow variables and also how to use the mapping variables in workflow and vice versa.
• Used lot of functions like set variable function in order to assign the incoming values to mapping variables.
• Created mappings in such a way where we connect all the mappings using mapping and workflow variables which are part of a single workflow.
• Used pre session success variable assignment and also post session success variable assignment at non reusable session task in order to pass the workflow variables to mapping and vice versa.
• Created UNIX scripts in order to schedule or un-schedule the workflows based on requirement.
• Created concurrent workflow which will be called form a different workflow using command task.
• Worked on continuous scheduling of informatica workflow.
• Used decision task, assignment task, email task based on requirement.
• Created parameter files at workflow level and also merged both of the parameter files used at workflow and session level.
• Created unit test cases and also documented all of them
• Used lookup transformation where I wrote a lookup override in order to divide the comma separated values into multiple rows by using CONNECT clause in oracle.
• Used oracle minus queries in order to compare the data between two schemas.
• Create a Mapplet which can be reused across two mappings and functions to give a different output based on incoming data.
• Used transactional control transformation in order to generate dynamic files at mapping level.
• Used an approach to calculate the dynamic files by dividing with timestamp at session level.
• Worked on performance tuning where we increase the throughput by switching from SQL transformation and using the same query in source qualifier.
• Used parallel hint clause for increasing performance which divides across 16 CPU’s to run an oracle query which has multiple joins.
• Worked on informatica dynamic partitions which can be used for loading large amount of history data.
• Worked on calling the same workflow multiple times until a condition is satisfied which is handled in UNIX script.
• Involved in code migration from development to integration testing, Staging and finally to Production Environment.
• Prepared documentation required to migrate all the objects across different environments.

Environment: Informatica Power Center 9.1, Oracle 11g, PL/SQL, UNIX Shell Scripts, windows XP

Confidential, Pittsburgh, PA

ETL Developer

Responsibilities:

• Interacted with the Business Analysts to understand the business & gather technical requirements.
• Interacted with Architect to understand the High level Design.
• Helped in creation of mapping specs for better code processing.
• Abstracted relational and delimited text file to local environment and developed the code in Dev environment.
• Checking the file formats for the source flat files using UNIX shell scripts thereby ensuring input file formats are same as specified.
• Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy, Sequence generator and Java Transformation.
• Created Mapplet for error handling process to deal with null records.
• Developed code for landing environment and then for staging and finally developed Incremental load populate the target tables for atomic model.
• Developed code to move data to MDM environment and finally loaded target tables using truncate load.
• Used DTStudio for B2B exchange of HL7 messages to our source landing.
• Worked on PowerCenter real time edition to run the Real time workflows.
• Configure session properties for real time workflows.
• Loaded Historical data for specific period of time to the Atomic model.
• Developed code for backload and Incremental load.
• Extracted HL7 messages from queues.
• From atomic model loaded the Normalized model with the help of OHADI.
• This normalized model was used as a staging area for the dimensional model which was Netezza based data-warehouse.
• Worked on Aginity workbench to process all the relational objects of Netezza.
• Data analysis and Datatype analysis was done on Aginity workbench for Netezza objects.
• Created mappings to load backload and clean data to Netezza staging environment.
• Used SCD type 1 to load dimension tables in Netezza and finally Fact tables of Data-warehouse.
• Used truncate load to load Netezza tables.
• Created Netezza SQL Scripts to test the table loaded correctly.
• Created Reusable sessions in Task Developer.
• Used Informatica scheduler to run the workflows in Dev Environment.
• Worked on Informatica Power Center tool - Source Analyzer, Mapping Designer and Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used SQL Developer to check if data is properly loaded into target systems by writing SQL Queries.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Used Debugger in troubleshooting the existing mapping.
• Performed Unit test and Integration test for the process created in Informatica and all the test cases were well documented for process improvements.
• Created test scripts and Unit test plan documents.
• Created Deployment Document forMigration of code from Dev to Test and from Test to Production environment.
• Involved with testing team to test the code and Fix the code

Environment: Informatica PowerCenter 9.1, Informatica PowerCenter Real Time Edition, B2B DT studio, MDM, Oracle 11g, SQL developer, Putty, WinSCP, Unix shell scripting, PL/SQL, Netezza, Aginity workbench

Confidential, Dallas, TX

ETL Informatica Developer

Responsibilities:

• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Prepared the DDL's for the staging/work tables and coordinated with DBA for creating the development environment and data models.
• Worked with Power Center Designer tools in developing mappings to extract and load the data from XML files into different FlatFile formats
• Worked on Informatica Power Center tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
• Designed and Developed mappings by using Lookup, Expression, Filter, Update Strategy, Aggregator, Router transformations to implement requirement logics while coding a Mapping.
• Developed Error handling & data quality checks in Informatica mappings.
• Schedule and run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
• Used Workflow Manager for creating workflows, work lets, email and command tasks.
• Used Informatica features to implement Type II changes in slowly changing dimension (SCD) tables.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.

Environment: Informatica Power Center 8.6.1, Oracle10g, Flat files, Shell

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Involved from initial stage of the requirement gathering to understand business requirements subjected to business.
• Created new mappings and also modifications in already existing mappings as per the new business rules.
• Analyzed the business requirements and suggested changes to the design accordingly.
• Prepared ETL Specifications to help in developing various mappings.
• Used different transformations such as Expression, Source Qualifier, Lookup, Filter, Update Strategy, aggregate, Router, Sequence generator and Joiner in order to create mappings.
• Created sessions and Workflows for the mappings.
• Documented the mapping process and the process that can be used in order to facilitate future development.
• Interacted with user for his requirements and also involved in various document preparation such as integration test plan, Unit test plan, Deployment Instructions, Roll Back Plans and Production Move Check lists etc.
• Modifying the queries for performance improvement.
• Involved in performance improvement in informatica.
• Involved in running the loads to the data warehouse involving different environments.

Environment: Informatica Power Center 8.1, Oracle 11g, TIVOLI

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQLstored procedures, functions, packages, and triggers to implement business rules into the application
• Data loading and data migration - Used SQL* Loader and API's to load data from CSV file into temporary table and developed PL/SQLprograms and packages to carry validation based on the end user requirements and load data from temporary table into base tables
• Designed and conceptualized the extraction strategies and methodologies for data integrity
• Developed PL/SQL Developed and designed user interface using Oracle Forms, which was integrated with menus, tabbed canvas and reports.
• Optimized critical queries to eliminate Full Table scans reduce Disk I/O and Sorts.
• Extensively worked on Performance tuning by using Explain plan, Tkprof method and various hints
• Created complex cursors, ref-cursors, views and Modified existing stored procedures, functions, and packages.
• Extensively used Explicit Cursors in stored procedures.
• Responsible for coding, debugging, and trouble-shooting.
• Involved in taking backups and exports, FTP in UNIX environment.
• Planned version control of production source code using Control Version System (CVS).
• Used MASETRO to invoke Shell Scripts.
• Participated in unit testing and prepared unit test documents.
• Involved in supporting/fixing post production defect fixes.
• Attended Design meetings, code review and test review meetings.
• Interacted and communicated with team members to solve/resolve issues.

Environment: Oracle10g, PL/SQLDeveloper,SQL*PLUS and TOAD