SUMMARY

• An accomplished consultant with 7+ years of extensive experience in Data Quality, Data integration, ETL Informatica, Unix Scripting, Data analysis, Data profiling, developing and implementing decision support, Operational Data Store, Data Warehousing and other information management solutions and strategies on various Database platform.
• Extensive IT experience in analyzing, designing and developing for Health care, Finance, Insurance, Pharmaceutical, Automobile sectors and Telecom Verticals.
• 6 + years of experience with Informatica Power Center for data integration and management.
• Extensive experience as a data warehousing expert and ETL developer using Informatica Power Center/Power Mart 9.6/8.6/7.1(repository manager, server manager, mapping designer, Mapplet designer, warehouse designer, transformation developer, workflow manager and workflow monitor).
• Good understanding across all stages of Software Development Life Cycle (SDLC) including Business Requirement analysis, Application designing, Development.
• Experienced in working with database languages such as Oracle 11g, 10g, 9i/8i, MS SQL server, MS Access and PL/SQL stored procedures, functions, packages, database triggers and cursors.
• Proficient in Data Warehousing techniques for Change Data Capture (CDC) and Customer Data Integration (CDI).
• Experienced in PL/SQL data loading, unloading and integration of various data sources like Flat files and Excel.
• Strong experience on workflow manager tools - Task developer, workflow and Work let designer
• Experience in performance tuning and optimization of cache with Informatica.
• Well versed in OLTP/OLAP environment concepts especially with large data sets.
• Proficient in data extraction and data loading with multiple relational databases and flat files into the staging area, ODS, data warehouse and data mart.
• Proficient in data warehouse design concepts and well versed with slowly changing dimension tables.
• Experienced in working with different mappings, business rules, validation, transformation strategies, mapplets, sessions, stored procedures, workflows, importing and exporting of objects from various sources into targets.
• Experienced in creating numerous database objects like tables, indexes, constraints. (checks, primary and foreign key)
• Good knowledge about Ralph Kimball theory and automation of ETL processes with scheduling tools and exception-handling procedures.
• Work closely with the Business Systems & Services teams to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner.
• Experience on Informatica Metadata Manager and Metadata Exchange exhaustively to maintain, design, implement and documentation of Metadata.
• Hands on experience on Informatica Lean and Agile Integration Methodology.
• Worked on resolving data quality issues by standardizing the data arriving from several sources to match the DW format.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6.1/9.1/8.6/7.1/6.5/6.1, Informatica Power Exchange, Informatica IDQ 9.6, Informatica Power Mart 7.1/6.5/6.1, SQL*Loader

OLAP/ BI Tools: Informatica DVO 9.6.0, Cognos7.2 (Power Play Transformer and User) & Informatica Power Analyzer 3.5.

RDBMS: Oracle 7.x/8.x/9i/10g/11g, DB2, MS SQL Server 2012, Teradata 14.10, MS Access 9.0/7.0.

Languages and Packages: C, C++, SQL, PL/SQL, HTML, Microsoft Visual Basic, Unix/Shell Scripts.

Operating System: Unix/Linux, Windows.

ERP Tools: Toad 12.5.1.1/8.5/7.6, MS SQL SERVER Management Studio, PL/SQL-DEVELOPER, MS Office 2015.

PROFESSIONAL EXPERIENCE

Confidential, Irwindale, CA

Sr. ETL Informatica Developer

Responsibilities:

• Responsible for development, support and maintenance of the Enterprise Data Warehouse (EDW) using Informatica Power Center 9.6.1 HF2 and MSSQL Server 2012 in the QA environment.
• Maintenance and support of ETL processes including but not limited to: Development Integration Testing, System Testing, User AcceptanceTesting, End-to-End Testing, and Performance Testing.
• Designing, prototyping, development of existing and new ETLs, and related components along with troubleshooting, analysis, research and resolution using advanced query and PL/SQL TSQL skills.
• Conversion and migration of existing SSIS packages into INFORMATICA mappings which was Interface between salesforce.com and Enterprise Data Warehouse (EDW).
• Designing process flows, deploying and populating staging area objects defining and populating the Enterprise Data Warehouse.
• Extracted the pre-clinical data from various source systems like XML, Excel and Flat files and load into the target clinical research data marts.
• Performed Data Analysis, Data Validation and Data verification using Informatica DVO (Data Validation Option) from raw data to user acceptance.
• Responsible to develop ETL procedures that are consistent across all application and systems and handling the change requests.
• Responsible for migration and deployment of folder or mappings and sessions from development to QA environment.
• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications.
• Working with Systems Administrators & Team Leads in scheduling and implementing software patches and system upgrades through database and Informatica reconfiguration.
• Worked in Service Oriented Architecture (SOA) and familiar with transact oriented data warehouse where data is updated and fetched real time. Worked on change data capture (CDC) while loading Dimensions by implementing SCD type 1 and type 2 from complex data extractions.
• Monitored workflows and collected performance data to maximize the session performance. And resolved memory related issues like DTM buffer size, cache size to optimize session runs.
• Creating Informatica mappings using source filter to collect fresh data for day to day ETL job runs including coding for handling deletion of data at the source.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.

Environment: Informatica Power Center 9.6.1 HF1, Informatica DVO 9.6.0, MS SQL Server 2012, MS SQL Server Management Studio 2008, Toad 12.7

Confidential, Providence, RI

Sr. Informatica Developer

Responsibilities:

• Project involved gathering data from disparate systems for the purpose of reporting and analysis.
• Identifying data quality issues that must be corrected in the source system, for e.g. incomplete names, out of format addresses, unwanted characters etc.
• Identifying issues that can be corrected in ETL processing by applying various transformations and rules.
• Discovering unanticipated business rules and unifying for seamless data profiling.
• Data conversion / Migration project:
• Project involves moving data from a legacy system to a new system.
• Identifying data quality issues that must be handled in the code that moves data from the legacy system to the new system.
• Experienced in improving the data quality by eliminating the redundant data by using Informatica data quality (IDQ 9.6).
• Extensively used Informatica Data Quality (IDQ 9.6) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 9.6.
• Used various transformations in IDQ to cleanse and enrich data using Standardizer, Decision, Exception and Consolidator.
• Analyzed Informatica Data Quality rules for Data Intake process and documented technical defects coordinating with Application DBA to identify Data related issues in UAT and BAT.
• Knowledge of best practices on Process Sequence, Dictionaries, DQ Lifecycles, Naming Convention, Version Control.
• Score Carding design & design patterns, develop confidence factor scoring system, run the Scorecard, edit the Scorecard and Configure Thresholds.
• Setting up sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.
• Responsible for best practices like naming conventions, Error Handling and Responsible for Performance Tuning at the Source, Targets, Transformations, Mappings and Session Level.
• Involved in Unit Testing, System Testing, User Acceptance Testing to check whether the data load into target are accurate which was extracted from different source systems according to the user requirements by generating several SQL test scripts, validating against test cases based on the pre-defined test plans.

Environment: Informatica IDQ 9.6, Informatica Power Center 9.6, Oracle 11gr2 - RAC Clustering, Standby, Data Guard, Toad 12.6

Confidential

ETL Informatica Developer

Responsibilities:

• Collaborated with business analysts and technical team for requirement gathering and business analysis and prepared high level design document to provide an overview of technical design specification system.
• Performing standard IDQ functions including data profiling, data cleansing and address standardization, validation and cleansing using Informatica Data Quality (IDQ) 9.1.
• Usage of data quality (DQ) tooling to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.
• Track and Fix any kind of errors that occur when the users communicate to the database, and also the various issues that originate on the representative’s devises and provide an error free data maintenance to the client both on the backend and front-end.
• Responsible for developing, support and maintenance for the ETL processes using Informatica Power Center.
• Worked extensively with transformations like Lookup, Update Strategy, Expression, Filter, Stored Procedures, Router and Other.
• CreatedMapping Parameters, Mapping VariablesandSession Variables.
• Worked on different task in Workflow like Session, events raise, event wait and decision mail, Command, Work lets, Assignments, Timer and Scheduling of the workflow.
• Responsibilities included design, development and testing the ETL processes of the project.
• Identified bugs in existing mappings by analyzing the pipeline data flow, evaluating transformations and fixing the bugs so that they conform to the business needs and redesign the existing mappings for improving the performance.
• Implemented aggregation logic using expression transformation with in the pipeline to implement the business logic.
• Created theDetail from various sources (Oracle, Flat file, XML) and transformed and loaded into targets using Informatica.
• Design Documentswhich have the ETL technical specificationsfor the givenfunction, overall process flowfor each particular process,Flow diagrams, Mapping spreadsheets, issues,assumptions, configurations,Informaticacode details, shell scriptsetc.
• Most of the transformations were used like the source Qualifier, Aggregators, Connected and Unconnected lookups, Expressions, Filters, Sequence, Router and SQL
• Created data lineage documents for data flow and ETL process based on Informatica mappings to support the project once it implemented in production.
• Monitored workflows and collected performance data to maximize the session performance. And resolved memory related issues like DTM buffer size, cache size to optimize session runs.

Environment: InformaticaPower Center 9.1, IDQ, Toad, UNIX Shell Scripting, Oracle, SQL Server, Flat Files,Mercury Quality Center

Confidential

Informatica Developer

Responsibilities:

• Involved in using Informatica Data Explorer (IDE) for data profiling over metadata and Informatica Data Quality (IDQ 9.1) for data quality measurement.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Update strategy & stored procedure transformation.
• Teamed together with client resources to design the to-be processes, applying standards and facilitating the industry best practices.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Implementation of best practice integration methods based on Informatica framework.
• Responsible for identifying reusable logic to build several Mapplets, utilizing shared folders to in corporate them as shortcuts, which would be used in several mappings.
• Responsible for developing several complex mappings for processing the feeds, re-defined existing and developed E-Mail Tasks in the Workflow Manager for sending successful or failure messages.
• Scheduled several jobs using Tivoli workload scheduler, creating job streams & handling scheduling issues.
• Designed data using target load order and constraint based loading.
• Created Test cases by taking input from Business Analysts and Technical Manager.
• Tested the feeds regarding the functionality and Performance manually.
• Created parameter files in Informatica and passed them to Informatica sessions.
• Execution of Test plan, Implementation Plans & identified areas for process improvement of workflows, mappings in Informatica.
• Modified existing mappings for enhancements of new business requirements.
• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Environment: Informatica 8.1, Oracle 10g, Tivoli workload scheduler, TOAD, Squirrel

Confidential

ETL Developer

Responsibilities:

• Managing ETL operations: Job-stream definition and management, parameters, scheduling, monitoring, and alerting.
• Member of warehouse design team, which interacted with the business community and database administrators to identify the business requirements and data realities.
• Involved in dimensional modeling data warehouse to design the business process.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width) and Excel files to staging database and from staging to the target Oracle database.
• Developed a number of Informatica Mappings, Mapplets and transformations to load data from relational and flat file sources into data warehouse.
• Used SQL queries and PL/SQL for database programming (Stored Procedures/Functions and Database Triggers).
• Designed and Developed complex ETL mappings and stored procedures for data integration
• Used various Transformations like Source Qualifier, Lookup, Update Strategy, Router, Filter, Sequence Generator and Joiner on the extracted source data according to the business rules and technical specifications.
• Assisted in logical and physical data modeling using ERWIN.
• Implemented Slowly Changing dimensions to update the dimensional schema.
• Implemented procedures/functions in PL/SQL for stored Procedure Transformations.
• Documented the mapping process and methodology used to facilitate future development.
• Team member of production support team to resolve the issues during production run time.

Environment: Informatica Power Center8.1, Oracle 8i, Erwin 4x.