SUMMARY

• Senior ETL Developer with 8+ years of IT experience and has portrayed skills in analysis, designing custom solutions, implementation and development of Data warehouses using Informatica, trouble - shooting and testing using ETL testing tools.
• Strong background in Database development and Data warehousing usingInformaticaPower Center 9.x/8.x/7.x,Informatica Data Quality (IDQ) 9.x/8.x and Informatica MDM(Master Data Management) 9.x.
• Developed complex mappings inInformaticausing different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Expression, Union, Stored Procedure transformation etc.
• Hands-on experience withInformaticaData Quality toolset and proficiency inIDQ development around data profiling, cleansing, parsing, standardization, validation, matching and data quality exception monitoring and handling.
• Experience working onInformaticaMDMin design, develop, test and review & optimizeInformatica MDM(Siperian) and IDD Applications.
• Experience in theInformaticaData Director (IDD) tool for creating Tasks and writing User Exit functions.
• Proficiency asInformaticaAdministratorto setup newInformaticaenvironments and Upgrade existing Informaticaenvironments to new versions.
• Hands on experience with Creating folders, Groups, Roles, Users in Admin console and granting them permissions.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Strong technical knowledge on Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension, Physical and Logical Data Modeling.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC (change data capture) and designed the automation ofInformaticavalidation, export and import utility.
• Expertise in working with relational databases such as Oracle, SQL Server, DB2-UDB and MS Access.
• Working level experience with ETL development and implementation using IBM DataStage.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using Oracle PL/SQL and TSQL.
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Worked on the JMS Message Queues and Web Services usingInformatica.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle 12c/11g/10g/9i, MS SQL Server, DB2, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Expert in all phases of Software development life cycle(SDLC) - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.

TECHNICAL SKILLS

Operating System: Windows 10/8/ 7/ Vista/ XP, Linux/Unix, AIX

ETL Tool: Informatica Power Center 6.x/7.x/8.x/9.x, Power Exchange, Informatica IDQ & MDM, ODI (Oracle Data Integrator), SSIS, Power center DT studio, IBM DataStage 11.x/10.x/8.x, Oracle E-Business Suite Financials

Databases: Oracle 12c/11g/10g/9i/8i/8.0/7.x, SQL Server, IBM DB2 UDB 8.0/7.0, DB2/400, MS Access, Siebel EIM Tables, Flat File Systems, XML Files.

Programming languages: PL/SQL, UNIX shell scripting, Java

Data modeling: Dimensional Data modeling- Star schema, Facts & Dimensions using CA Erwin, ER/Studio etc.

Scheduling Tools: Autosys, Crontab, Control-M

Testing Tools: Load Runner, Quality Center

Other Utilities: SQL Developer, PL/SQL Developer, TOAD, SQL*Loader, SQL*Plus

Version Control Software: SVN,IBM Rational Clear Case/RTC

PROFESSIONAL EXPERIENCE

Confidential, Portland, OR

Senior ETL Developer

Responsibilities:

• Involved in the integration of MCMC as a Community Connect partner and assisted with the necessary ETL, Oracle PL/SQL development and query tuning to remediate Data Warehouse ETL code and implement data level security in the Confidential Epic clarity Data Warehouse environment.
• Performed scoping and estimating on Data Warehouse related development activities including updating Oracle PL/SQL code, database objects such as views, tuning queries and defining VPD (Virtual Private Database) rules.
• Actively participated in the project design, development, testing and implementation of the Oracle VPD rules in the Confidential Clarity database to secure and partition the healthcare data between Confidential and MCMC.
• Designed the VPD rules against the Confidential data without the need to update the existing ETL code.
• Filtered the Confidential only data into the downstream OHSUDW by designing the security filters using the Oracle VPD.
• Developed various Mappings, Mapplets and Transformations for migration of data from various existing systems to the Confidential Data Warehouse usingInformaticaPower Center Designer.
• Built Repositories usingInformaticaPowerCenter Repository Manager to store Source, Target, Transformations, Mapplets and Mappings Meta Data Information.
• CreatedInformaticamappings with SQL, PL/SQL procedures and Functions to build business rules to load data.
• Assisted with the development of views in the MS SQL Server Epic Cogito Data Warehouse to secure Confidential and MCMC data.
• Created complex functions, stored procedures, triggers, packages and DBMS Scheduler jobs using PL/SQL Developer.
• Extensively involved in the SQL query tuning of the existing stored procedures, complex views and materialized views to improve the data warehouse incremental and full load times.
• Involved in the additional database developmental efforts for the Confidential data warehouse star schema.
• Worked with and developed testing scripts for Team leads, QA and Business Team to ensure the Quality of the applications and accuracy of data by unit testing and system integration testing.
• Developed the test execution plans and test cases in QA and extensively tested the security filters before implementing them in Production.
• Worked closely with fellow IT staff and project management to develop, test and document systems and processes.
• Interacted and worked directly with customers, team members and analysts on project and support issues.
• Performed tuning of Informatica sessions in Target, Source, Mappings and Session areas.
• Involved in the performance tuning of the existing ETL process code after applying the VPD security filters to minimize the impact of the OHSUDW ETL performance and to make sure the data was available for reporting as per the requirements.
• Facilitated communication upward and across project teams. Followed change management and problem management processes.
• Responsible for detailed technical analysis to assure the availability and accuracy of data processed by the BIMD ETL or contained in the BIMD supported Confidential data warehouses and systems.
• Roles included availability for rotation through an afterhours on-call support model for upgrades, project go lives and to provide ongoing support of new systems that had 24x7 support agreements. This included a broad knowledge of the Confidential BI systems and workflows.

Environment: Informatica Powercenter 9.5/9.6, Oracle 12c/11g, Microsoft SQL Server 2012, PL/SQL Developer, SQL*Plus, SQL*Loader, Cognos, Epic Hyperspace, Windows, UNIX.

Confidential, Tampa FL

Senior ETL Developer

Responsibilities:

• Studied and understood the warehouses, sources, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing. Involved in functional design reviews and lead technical design reviews.
• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.
• Study of detailed requirement of end users of system & their expectations from Applications.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Business process re-engineering to optimize the IT resource utilization.
• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, COBOL files & XML Files.
• Responsible for Power Center and Power Exchange installations, configuring Power Center Domain, nodes, Grids and Create Different services in the Domain.
• Created Users, Groups, Roles and grant privileges to the users. Create folders, Relational and Application connections and configure the ODBC connectivity.
• UpgradedInformaticapower center 9.1 to version 9.5 on Linux servers.
• Involved in Software upgrades plan and manageInformaticasoftware patching and upgrades.
• Implemented Land Process for loading the customer Data Set intoInformaticaMDMfrom various source systems.
• Involved in designingMDMdata model and created base objects, mappings, defined trust setting for sources, customized user exists, customized IDD applications.
• UtilizedInformaticaIDQAnalysis and Developer Tool to determine the data quality issues for the MDMdata.
• Designed and developed mappings to extract, cleanse, transform and load into target tables using differentIDQtransformations.
• Identify the flow of information, analyzing the existing systems, evaluating alternatives and choosing the "most appropriate" alternative.
• Understand the components of a data quality plan. Make informed choices between sources data cleansing and target data cleansing.
• Transformed data from various sources like excel and text files in to reporting database to design most analytical reporting system.
• Initiate the data modeling sessions, to design and build/append appropriate data mart models to support the reporting needs of applications.
• Change Data Capture using the Power Exchange.
• Used features like email notifications, scripts and variables for ETL process using Informatica Power Center.
• Involved in Data Extraction from Oracle and Flat Files using SQL Loader Designed and developed mappings using Informatica Power Center.
• Developed slowly changed dimensions (SCD) Type 2 for loading data into Dimensions and Facts.
• Involved in Data Extraction from Oracle and Flat Files, XML Files using SQL Loader, Freehand SQL.
• Using Toad to increase User productivity and application code quality while providing an interactive community to support the user experience.
• Created the Test cases and Captured Unit test Results.
• Good experience in writing shell scripts in Unix Environment.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 9i/10g.
• Developed and tested all the informatica mappings, sessions and workflows - involving several Tasks.
• Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogs into Frame Work Manager.
• Involved Conducted and participated in process improvement discussions and recommending possible outcomes and focused on production application stability and enhancements.

Environment: Informatica Power Center 9.5/9.1/8.6, Informatica MDM, IDD, IDQ, Oracle 10g/9i, Microsoft SQL Server 2008, PL/SQL, Test Director, Erwin, TOAD, SQL*Plus, SQL*Loader, Autosys, Windows, UNIX.

Confidential, Dallas TX

Senior ETL Developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Responsible for creating repository users, user groups, giving privileges to the users, granting users with access to the repository folders.
• Experienced in creating and maintaining the entity objects, hierarchies, entity types, relationship objects and relationship types using Hierarchy tool to enable Hierarchy Manager (HM) inMDMHUB implementation andInformaticaData Director (IDD).
• Worked on data cleansing using the cleanse functions inInformaticaMDM.
• Built the Physical Data Objects and developed various mapping, mapplets/rules using the InformaticaData Quality (IDQ) based on requirements to profile, validate and cleanse the data.
• Worked withInformaticaIDQto determine Data Quality issues and Remediation process for bad data.
• Extensively used Unix Scripting, Scheduled PMCMD and PMREP to interact withInformatica Server from command mode.
• Installed and ConfiguredInformaticaPower Center on Client and Server Machines and Configure InformaticaServer and Registered Servers.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices.

Environment: ODI,InformaticaPower Center 8.x/9.x, Informatica MDM, IDQ, IDD, Microsoft SQL Server, SSIS, Oracle, FTP, SQL Plus, Flat File systems.

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Implemented business plan based on required technical and business needs.
• Involved in enhancing of some of the existing mappings and creating new mappings to suite their customized needs.
• Involved in Creating sessions and workflows, and scheduling to load the data from DB2, Oracle tables into the DB2 targets.
• Developed and executed UNIX scripts as pre/post-session commands to schedule loads, archive files etc.
• Involved in Security administration, managedInformaticausers and roles in order to enforce data security, while making sure all users have the necessary access to perform their tasks.
• Worked on troubleshooting, performance tuning, performance monitoring and enhancement of Informatica jobs.
• Worked with the DBA to improveInformaticasession performance and query performance by collecting statistics and defining relevant indexes on target tables.
• Involved inInformaticaissue resolution, folder migration and Administration.
• Used Informatica reusability at various levels of development.
• Created source to target mapping and job design documents from staging area to Data Warehouse.
• Implemented slowly changing dimension methodology for accessing the full history of members and claims.
• Designed the Data Acquisition, Transformation, and Data Cleansing approach for theMDM implementation.
• Experienced hands on working knowledge inInformaticaMDMHub Match and Merge Rules, Batch Jobs and Batch Groups.
• Worked onInformaticaData Quality (IDQ) toolkit, analysis, data cleansing, data matching, data conversion, address standardization, exception handling, reporting and monitoring capabilities of IDQ.
• Experienced in Management of Bad and Duplicate Records usingInformaticadata Quality and InformaticaAnalyst.
• Worked on the development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports in Order to Cash, Procure to Pay Cycles touching various modules such as INV, OM, SHIPPING, AR, PO and AP.
• Provided production support and performed enhancement on existing multiple projects.
• Involved in Unit testing, System Testing and UAT.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: InformaticaPower Center 8.1, 8.5.1 & 8.6.1, MDM, Informatica IDQ, Microsoft SQL Server,DB2, Oracle, SSIS, Oracle Applications R12, Reports 9i/10g, Forms 9i/10g, FTP, SQL Plus, Flat File systems.

Confidential, Los Angeles, CA

ETL Developer

Responsibilities:

• Analysed the ESM & CHORUS Feed thoroughly before loading the data into ODH
• Responsible for loading static data from ESM & CHORUS into ODH, which then, allows ODH to do necessary data mapping
• Actively participated in analysis of ISTAR & DOLPHIN data feed via ODH
• Responsible to generate position & margin feed of ISTAR & DOLPHIN systems from ODH & send them to TDB
• Involved in gathering requirements and created design documents and mapping documents.
• Involved in Creating sessions and workflows, and scheduling to load the data from Siebel tables into the DB2 targets.
• Developed and executed UNIX scripts as pre/post-session commands to schedule loads, archive files etc.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Worked in Power Exchange to connect to various heterogeneous databases and created mappings accordingly.
• Experience on handling slowly changing dimensions to maintain complete history.
• Fine-tuned existingInformaticamaps for performance optimization.
• Used the Administration Console to perform repository functions, such as creating, copying, backing up, and restoring repositories in Informatica Power center 7.1.3
• Involved in upgrade activities of Informatica application from Powercenter 7.1.3 to 8.6.1.
• Involved in Unit testing, System Testing and UAT.

Environment: InformaticaPower Center 7.1.3 & 8.61.AIX 5.2/5.3, DB2, Siebel Tables, FTP, SQL Plus, Flat File systems, MY SQL

Confidential, New York, NY

ETL Developer

Responsibilities:

• Understanding and analyzing new and changing business requirements for adding new source systems and their impact on the CFS design. Proposing enhancements and changes to the technical and business solution to meet the new requirements.
• Estimated Efforts accurately & actively worked with PM’s in completing the project plan
• Involved in discussion with CFS SME’s to finalize the design of integrating the new source systems in CFS platform. Managed the Design of taxonomy logic for few source systems
• Involved in gathering requirements and created design documents and mapping documents.
• Involved in design, development and modification of ETL mappings and stored procedures in an optimized manner. Involved in Unit Testing and System Testing stages.
• Load operational data from Oracle, SQL Server, flat files, Excel Worksheets into various data marts.
• Fine-tuned existingInformaticamaps for performance optimization.
• Design complex mappings involving constraint based loading, target load order.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Worked on bug fixes on existingInformaticaMappings to produce correct output.

Environment: InformaticaPower Center 8.5.1, Oracle 9i, MS SQL Server 2005, Oracle, windows, Mainframes, AS400, EFT, FTP, SQL Plus.

Confidential, Hartford, CT

ETL Developer

Responsibilities:

• Involved in Requirement Analysis, ETL Design & Development, Maintenance and Testing and Quality activities of the project.
• Actively participated in all Design Discussions and prepared Design documents (HLD & LLD) for certain Load Stages. Trained offshore team members with Exceed Product & Auto insurance business Knowledge
• Created the environment for Staging area, loading the Staging area with data from multiple sources.
• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.
• Created various batch Scripts for scheduling various data cleansing scripts and loading process.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Extensively used Joins, Triggers, Stored Procedures and Functions in Interaction with backend database using PL/SQL.
• Stored reformatted data from relational, flat file, XML files using Informatica (ETL).
• Performance tuningby optimizing the sources targets mappings and sessions.
• Tested mappings and sessions using various test cases in the test plans.

Environment: InformaticaPower Center 7.x, Oracle 9i, DB2, Oracle, windows, Mainframes, AS400, ESP Scheduler, SQL Plus.

Confidential, Newark, NJ

ETL Developer

Responsibilities:

• Involved in preparing ETL and Reporting Design Documents.
• Created the Informatica Mappings, Sessions and Batches, ensuring the Business Rules and Data Validation.
• Designed and developed the data transformations for source system data extraction; data staging, movement and aggregation; information and analytics delivery; and data quality handling, system testing, performance tuning.
• Created PL/SQL Stored procedures, which are to be used in Informatica mappings.
• Developed Unix shell scripts to Pre-process the files.
• Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy.
• Involved Unit testing the mappings and sessions.
• Maintained the documentation for errors occurred.
• Involved in Production Support Activities.

Environment: InformaticaPower Center 7.x, Oracle 9i, DB2, Oracle, windows, Mainframes, AS400, ESP Scheduler, SQL Plus.