SUMMARY

• 6 Years of experience in Information Technology as Informatica Developer with strong background in ETL Data warehousing experienced using Informatica Power Center.
• Experience in analysis of different systems for system study and data warehouse implementations.
• Experienced in Data Warehousing, Data Analysis, Data modeling, ETL, Reporting, Development, Maintenance, Testing and Documentation.
• Experienced in OLTP/OLAP Systems and Data model Schemas like Star schema, Snowflake schema and multidimensional modeling.
• Hands on experience with Data Profiling/Data Quality using Informatica Developer, BDM toolset
• Extensive experience in implementation of Informatica Power Center components like Source Analyzer, Target Designer, Mapping/Mapplet/ Transformation Designer, Workflow Manager/ Workflow Monitor.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, SQL transformation, Data masking, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and Transaction Control transformations.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.
• Experience in integration of various data sources like SQL Server, Oracle, Teradata, Flat Files and XML files.
• Experience in developing XML/XSD/XSLT as a part of Source XML files for Informatica and also input XML for Web service Call.
• Experienced in loadingdata, troubleshooting, Debugging, mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine - tuned transformations to make them more efficient in terms of session performance.
• Strong experience in writing UNIX shell scripts and Python scripting for data file validation and working with Informatica components in Unix environment
• Strong experience with Database objects, writing stored procedures, functions, triggers, DDL, DML SQL query performance tuning using Oracle 11g/10g/9i/8i, PL/SQL, PostGre SQL,SQL*Plus, SQL*Loader
• Experience in PL/SQL development and SQL Query Tuning by analyzing Explain Plan for better performance.
• Proficient knowledge and hands-on experience in building Data Warehouses, Data Marts, Data Integration, Operational Data Stores and ETL processes.
• Familiarity with Informatica Administration like User Management, Folders / Project Management
• Experience in tuning Informatica Mappings and Sessions for optimum performance.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Expert in implementing business rules by creating Re-Usable Transformations like Mapplets and Mappings
• Proficient in using Informatica Repository Manager to create & schedule sessions and batches.
• Good experience in Scheduling ETL Jobs tool like Python scripting,Autosys, Cron tab and Control M
• Extensive knowledge ofNormalizationandRelational Database Management Systems.
• Hands on experience on various SQL Server Services like Integration Services (SSIS)
• Production support, handling new enhancements and customer support.
• Experience using GIT and the Git Flow workflow.
• Experience in AWS (Amazon Web Services), S3 Bucket and Redshift (AWS RelationalDatabase).
• Exceptionally well organized, strong work ethics and willingness to work hard to achieve employer objectives.

TECHNICAL SKILLS

ETL Tool: Informatica Power Center Tools (10.x or 9.x), Informatica BDM 10.2

Databases: Oracle 11g/ 10g/9i, SQL Server 2008/2005,Teradata,Post gre sql,DB2.

BI Tools: TABLEAU 9.2

Modeling: Erwin, Oracle Data Modeler, TOAD, SQL*PLUS, DB2 Visualizer.

Languages: SQL, PL/SQL. UNIX, Shell scripts,Python

OS: Windows 2008/2007/2005/ NT/XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Informatica Developer

Responsibilities:

• Analyzing requirements based on the existing functionalities and discussing the business solutions with Confidential Inc. business team, resolving existing problems and improving the application stability.
• Participating in scrum meetings with Confidential and translate the client requirements into highly specified project briefs.
• Work with business teams who will send data to EDWARD to gather requirement on any enhancement or new development needed on EDWARD.
• Work with enterprise architects to come up with data flow design from source to data warehouse.
• Provide support for System Integration Testing and User Acceptance testing.
• Perform RTB (Run the Business) activities, such as fixing all the issues and bugs that may come up during the production phase. This also includes helping the application users in understanding the application and setting up the environment for them to make the application up and running.
• Providing solutions for improving the clients business and processes.
• Gathering the requirements by directly interacting with the business team and estimating the effort required for each task.
• Identifying and developing the reusable modules and templates, this will help in improving the productivity of the team.
• Ensuring that the team has the required technical expertise to execute the project. This involves the identification of key technical areas related to the project and conducting training sessions to plug any gaps.
• Discussing business solutions with Confidential business team, resolving existing problems and improving the application stability.
• Coordinating with business clients, supporting the application and implementing the process as per specifications provided.
• Performing requirements gathering and analysis, estimating time required for project completion,preparing schedules, design documentation, design reviews and development, testing and deployment of application enhancements, as well as project planning.
• Reviewing work products and deploying it in the test environment and initiating the process of user acceptance testing. It includes fixing of bugs and technical errors that may come up during this phase.
• Supporting the system components during system testing, integration testing and during promotion of these components to production environment.
• Providing trainings to business folks and end users on the application and documenting the learning.
• Identifying the areas of system enhancements and submitting proposals for them.
• Support batch cycles and fix abends in production, UAT and break-fix environments
• Provides Lights On support which includes working on Incident tickets, small enhancements which needs quick turn around, maintenance of the system, performance & system improvement related activities.
• Support of Scalability initiatives.

Environment: Informatica Power Center 9.6.0/10.1, Informatica BDM 10.2,Oracle, Teradata,Post gre Sql,Unix Shell Scripting,Python scripting, Red hat Linux, HP Service Manager, Power Exchange .Net, Oracle 12c, Subversion, Control-M

Confidential, Farmington Hills, MI

Informatica Developer

Responsibilities:

• Effectively worked on Agile methodology for quick responses to change and continuous development.
• Developed Technical design documents (TDD) from user requirements and functional requirements documents (FRD).
• Created Design Documents for source to target mappings. Developed mappings to send files daily to AWS.
• Involved in implementing change management process while fixing the existing code to enhance the code or bug fixing.
• Modified existing mappings to accommodate new business requirements due to single instance impact at the source.
• Worked on Data Conversion and Data Analysis.
• Troubleshooting the issues in Informatica.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Worked with Oracle SQL for storing, retrieving, and managing document-oriented, or semi structured data.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions (this led to better session performance).
• Improve availability and timeliness of test environments.
• Involved in extracting data (CSV Files) from Mainframes and loaded into Oracle target tables using PowerCenter workflows.
• Performed ETL configuration and troubleshooting.
• Worked with PowerExchange for mainframe to simplify mergers, acquisitions, and reorganizations to integrate, migrate the mainframe data rapidly.
• Worked with Security Analyst to upload the UNIX script into Dynamic Password Lookup tool to securely access the application credentials.
• Used ODS for integrating disparate data from multiple sources for business operations, analysis and reporting.
• Used Informatica Power Exchange for Mainframes to access, integrate and mainframe-based enterprise data to Oracle target database using Power Center.
• Worked with Oracle ERP application for managing accounting, procurement, and projects throughout the organization.
• Involved in Agile process for continuous attention to technical excellence and good design.
• Worked with different transformations in Informatica Power Center to apply business logic.
• Created mappings in PowerCenter to migrate data from Flat files, Sybase to data warehouse.
• Used DB2 Load utility to load the data from FDW table into the file.
• Managed ETL Domain/Repository/Integrations services and workflows (Stop/Start) whenever the database servers are bounced.
• Used Oracle ERP software with integrated cloud applications to deliver the functionality, analytics, security, and collaboration tools for the business needs.
• Worked with ODS can for data scrubbing, resolve for redundancy and checked for compliance with the business rules.
• Worked with DBA to create the derived tables required for ETL development.
• Used UNIX Shell Scripting on Linux platforms to automate the loading process and to generate restart tokens for cold starting the workflows.
• Created Sessions and Workflows to carry out the ETL process, configured sessions and connection parameters using Power Center Tool.
• Extensively used UNIX commands to check the processes, view logs and troubleshoot the issues.
• Used UNIX scripts to load the initial/incremental SQL into the file and then load into FDW table.
• Worked closely with Unix SAs for troubleshooting OS related issues with applications and servers maintenance activities.
• Involved in Data migration, extraction, Data cleansing and Data Staging of operational sources using ETL processes.
• Used control-M tool for automating and scheduling the ETL workflows.
• Worked with different teams to troubleshoot the workflows/control-M jobs failures due to DB and network issues.
• Informatica application administration that include creating users, connections, folders and managing privileges on them
• Configuration of LDAP and Native authentication of application
• Deployment of Informatica code using export/import and deployment group methods
• Automate deployments and other application administration activities and build a self service model to perform these activities
• Govern standards and best practices and enforce them during change review and approval process
• Manage change controls across different platforms
• Work with Informatica technical support to identify the root cause/ fix on issues which cause deployment failures and build strategic policies/methods to mitigate them in future
• Experience with Performance Tuning methods, Partitioning and Pushdown Optimization in Informatica with large volumes of data load
• Developed Unit test cases and Unit test plans to check data is correctly loading.

Environment: Informatica Power Center 9.6.0, 10.1, IBM-AIX, Oracle, Unix Shell Scripting, Red hat Linux, HP Service Manager, Power Exchange .Net, Oracle 12c, Subversion, Control-M

Confidential

Informatica Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on business rules.
• Used Informatica Power Centre 9.5.1.for extraction, loading and transformation (ETL) of data in the data mart.
• Participated in the review meetings with functional team to signoff the Technical Design document.
• Involved in Design, Analysis, Implementation, Testing and support of ETL processes
• Worked with InformaticaData Quality 9.6 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities ofIDQ 9.6.
• Validated the following HIPAAEDI transactions as 837(Health Care Claims orEncounters), 835(Health Care Claims payment/Remittance), 270/271 (Eligibility request/Response) and 834(Enrollment/Disenrollment to a health plan) by developing mappings.
• DevelopedIDQ mappings using various transformations like Labeler, Standardization, Case Converter, Match and Address validation Transformation.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica Power Center.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter, Normalizer and Sequence Generator transformations.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Worked with complex mappings having an average of 15 transformations.
• Coded PL/SQL stored procedures and successfully used them in the mappings.
• Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process and also to schedule the automatic execution of workflows.
• Scheduled the Jobs by using Informatica scheduler & Jobtrac
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning at various levels like mapping level, session level, and database level.
• Provided production support by monitoring the processes running daily.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Coordinating with the Offshore team and directly interacting with the client for clarifications & resolutions
• Introduced and created many project related documents for future use/reference.
• Designed and developed ETL Mappingsto extract data from Flat files and Oracle to load the data into the target database.
• Developing several complex mappings in Informatica a variety of Power center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power Center.
• Created complex calculations, various prompts, conditional formatting and conditional blocking etc., accordingly.
• Ran the workflows on a daily and weekly basis using workflow monitor.

Environment: Informatica Power Center 9.5, Oracle 11g,T-SQL, Data Marts, Erwin Data Modeler 4.1, Agile Methodology, FTP, MS-Excel, Ms-Access, UNIX Shell Scripting, Data Modeling, PL/SQL, Autosys.

Confidential

Informatica Developer

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Creating the design and technical specifications for the ETL process of the project.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Worked onInformatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping &Mapplet Designer and TransformationDeveloper.
• Developed complex mappings usingInformatica Power Center Designer to transform and load data.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Aggregator, Filter, and Lookup.
• Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Implemented complex mappings such as Slowly Changing Dimensions.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Built in mapping variable/parameters and created parameter files for imparting flexible runs of workflows based on changing variable values.
• Designed and Developed pre-session, post-session routines forInformatica sessions to drop and recreate indexes and key constraints for bulk loading.
• Maintain Development, Test and Production mapping migration Using Repository Manager.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Used workflow manager for session management, databaseconnectionmanagement and scheduling of jobs.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.

Environment: Informatica Power Center 9.1.0,Oracle 11g, Erwin - 4.0, TOAD 9.x, Shell Scripting, Oracle SQL *Loader, PL/SQL, UNIX, Windows-XP.

Confidential

Informatica Developer

Responsibilities:

• Analyzing the source data and working with business users for requirements/design/development.
• Used Informatica Power Exchange for Change Data Capture in Source Tables.
• Extracted data from Oracle Sources and loaded them into Stage tables in SQL Server.
• Applied business logic with transformation rules in Power Center to load in to SQL Server Warehouse.
• Developed Design documents and Mapping documents.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer.
• Created reusable transformations and mapplets and used them in mappings.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Wrote many SQL/PLSQL scripts to verify data in the DB.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Stored Procedure.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Created deployment groups, migrated the code into different environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Provided support to develop the entire warehouse architecture and plan the ETL process.

Environment: Informatica Power Center 8.5.1, Oracle 10g, and UNIX.

Confidential

Informatica Developer

Responsibilities:

• Designed and created Mappings, Sessions and Workflows using Informatica Power Center
• Developed the ETL processes to handle complex business logic for high volume data loads using various transformations such as Aggregator, Sorter, Filter, Normalizer, SQL Transformation, Lookup, Joiner, Router, Union etc.
• Processes to generate Daily, Weekly and Monthly data extracts were developed and the data files were sent across to the downstream applications.
• Used Source Qualifier & Lookup SQL overrides, Persistent caches, Incremental Aggregation etc for better performance.
• Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Defined and used Mapping Parameters and Parameter files to provide values dynamically at session run time.
• Created sessions to use pre & post session SQL commands to drop & create indexes on tables for better performance.
• Used Event wait Task, Control Task, Email Tasks, Command Tasks and Link conditions in workflows.
• Write PL/SQL procedures which are called from Stored Procedure transformation to perform database actions such as truncate the target before load, delete records based on a condition, rename the tables etc.
• Created & modified Unix Shell scripts.
• Provided data loads for QA testing and worked on resolving the defects.
• Performed Informatica code migrations.

Environment: Informatica Power Center 8.1.1, Oracle 9i, SQL Server 2005, UNIX