SUMMARY

• Senior Informatica Developer with 9 years of extensive experience on ETL Informatica PowerCenter with strong business understanding and knowledge of Extraction, Transformation and Loading of data from heterogeneous source systems like Flat files, Excel, XML, UDB, Oracle, Sybase, SQL Server.
• Extensively involved in ETL Data warehousing using Informatica Power Center 6.x/7.x/8.x/9.x/10.x Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Good knowledge in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Slowly Changing Dimensions (SCD), Fact Table and Dimension Tables.
• Good experience in Relational Databases like Oracle, Teradata, Netezza.
• Excellent experience working on Netezza to write complex SQL queries, Netezza views, Bulk writer, Bulk reader etc using Informatica.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions.
• Very strong in writing SQL Joins, Nested Queries, Unions, Multi - table joins.
• Expertise in using SQL*LOADER to load Data from external files to Oracle Database.
• Experience in Optimizing the Performance of SQL scripts and Oracle database, Tuning Informatica Mappings to identify and remove processing bottlenecks. Automation and scheduling of UNIX shell scripts and Informatica workflows.
• Excellent in coding using SQL, T-SQL, SQL*Plus, PL/SQL, Procedures/Functions, Triggers and Packages.
• Developed Batch Jobs using UNIX Shell scripts to automate the process of loading, pushing and pulling data from different servers.

TECHNICAL SKILLS

• Informatica Power Center 10.x/9.x/8.x/7.x Power Exchange.
• Oracle 12/11g/10g/9i
• SQL Server 2005/2008R
• Teradata R12/R13
• Netezza
• Aginity
• Business Objects XI R2/R1/6.x.
• Zena
• Cron Tab
• Cognos 10.2
• T - SQL
• PL/SQL
• UNIX Shell Scripting
• XML
• Sybase
• Erwin 4.1.
• Oracle PLSQL Developer
• Quest Toad for Oracle.
• UNIX
• IBM AIX 4.3/4.2
• Windows NT/2000/XP/7.
• Tidal
• JIRA
• Jenkins
• SVN
• ESP scheduler.

PROFESSIONAL EXPERIENCE

Senior ETL Programmer Analyst

Confidential, Cincinnati, Ohio

Responsibilities:

• Worked on multi layered project which involves building new data marts with various staging levels data and finally loading data into a de-centralized data warehouse.
• Involved in building the Data warehouse for enterprise sales dashboard.
• Interacted with Business Partner to analyze and understand the business process and requirements, worked with Data Architect and Data stewards to make necessary changes to schema objects as per the reporting needs.
• Worked on Financial data and reports related to eReportal, Markit, PACE and SATUIT.
• Designed and developed the ETL process for different business units in life using the Informatica Power center. Created Informatica mappings, mapplets to extract data from different kinds of sources like flat files, xml and tables to load into data mart for generating reports.
• Developed SQL stored procedures and functions for complex business rules.
• Involved in Code review for ETL standards and performance tunings of data loads.
• Prepared design documents, Test cases and Test scripts to test the ETL process and validated the Test Plans and Test Scenarios.
• Worked with COE Team for multiple releases to Stage and production, involved in backup and recovery activities, involved in network outage issues to restore the Informatica environment.
• Worked on Data quality project by profiling, cleansing, masking and massaging the data as per TMNA standards into Data Warehouse.
• Created ESP scheduling for jobs executions in UAT and Production environments.
• Monitored the prod jobs and investigated the data and performance issues by Performance Tuning techniques to identify various bottlenecks at session and mapping level and resolved the issues
• Research and resolved production issues by identifying the root cause analysis for defects and resolved the issues by designing and developing long terms solutions and documenting the resolutions for defect tracking on SharePoint.

Environment: Informatica PowerCenter 10.2, Oracle12c, MS SQL Server2016, ESP scheduler, Agile scrum.

Senior Application Developer

Confidential, San Francisco, California

Responsibilities:

• Worked on multiple projects which involved building new data marts and extracting data from various sources into data mart.
• Involved with the design reviews and building the architecture of new data mart.
• Worked with business analysts closely in gathering requirements and providing information on data profiling and translating the business requirements into technical specifications.
• Developed NZSQL queries and NZ stored procedures to load data into data mart as per complex business rules.
• Created Informatica mappings using Push down Optimization to pick data from the data mart and generate the extract files to transmit to BCBSA.
• Developed automated Audit scripts and jaws scripts using UNIX to handle job executions.
• Worked on Healthcare data related to FACETS, ARGUS, AUTH, MGLN, DBP, PIMS, ASH and MES.
• Worked on the Production and UAT support round the clock for job executions and data validations and issue analysis.

Environment: Informatica Power Center 10.2, Oracle SQL Developer, UNIX, Netezza, Jira, Aginity.

Senior ETL Developer

Confidential, Las Vegas, Nevada

Responsibilities:

• Worked with business closely as their main point of contact for the region. Managed the roles as an Analyst for requirement gathering (BRD) & business analysis, Architecture Developer and for translating the business requirements into technical specifications to build the Enterprise data warehouse and Tester for the whole processes developed.
• Worked on design and analysis of data extraction from FACETS using TOAD.
• Converted the design queries into Informatica mappings, workflows to load data into staging area, data warehouse and data marts in TOAD.
• Worked with several kinds of files like XML, UNICODE etc related to Member, Provider, Pharmacy and Confidential t Claims Data.
• Generated & Prepared detailed extract reports and documents for the business.
• Worked as the Production support for the ongoing jobs and assisting Informatica Admin, DBA as per needed.

Environment: Informatica 9.5.1, Toad for Oracle 12.6, SQL Server Studio 2016, Visual studio 2012.

Senior ETL Developer

Confidential, Overland Park, Kansas

Responsibilities:

• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in SQL Server.
• Worked on Mainframe Cobol data files.
• Prepared Test data and execution plans for different entities and executed the testing with team and Involved in Integration testing.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Wrote complex SQL scripts to avoid Informatica Look-ups to improve the performance, as the volume of the data was heavy.
• Scheduling the workflows using Tidal as per business needs.
• Prepared projects, dashboards, reports and questions for all JIRA related services.
• Generated scripts for effective integration of JIRA applications with other tools.

Environment: Informatica 9.1, SQL Server 2012, Tidal, JIRA, COBOL.

Senior ETL Developer

Confidential, Sacramento, California

Responsibilities:

• Prepared design specification documents for all the ACA claims data types by using the existing informatica mapping references.
• Worked on data migration from Oracle to MySQL.
• Created corresponding informatica mappings & workflows for MySQL target to load the data.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents & Use case documents to outline data flow from sources to targets.
• Developed mapping parameters and variables to support SQL override.
• Developed mappings to load into staging tables and then to Dimensions and Facts, mapplets to use them in different mappings.
• Creating Data flow diagrams using Visio.

Environment: Informatica 9.6, Oracle 11g R2, Toad for MySQL 7.5, PLSQL Developer, Visio 2007.

Senior Informatica Developer

Confidential, Tampa, FL

Responsibilities:

• Worked on 834 transactions, Enrollments & Enhancements
• Prepared FSD and TDD’s for the vendors and their different line of businesses.
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in SQL Server and Oracle.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into the dimension, facts, and lookup tables simultaneously from different source systems.
• Writing UNIX shell scripts to run and schedule batch jobs.
• Prepared unit testing cases and documentation of the ETL process.
• Involved in Production deployments, support in resolving issues and bugs.
• Created the transaction summaries for the daily change jobs as well as monthly audit reports.
• ConstructingTriggers,Tables, implementingstored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity using T-SQL.
• Creating Work orders, branching and merging the code.
• Extracted data from oracle, flat file and xml sources.
• Used PL/SQL extensively for database related functionality.
• Involved in tuning the performance of sessions and mappings.

Environment: Informatica 9.0.1, Oracle 11g R2, T-SQL, SQL Server Studio 2012, Unix shell scripting, Toad, PL/SQL, Visual studio 2012.

Senior ETL Developer

Confidential, Boston, MA

Responsibilities:

• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Created mappings to load the data mart with the use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator and Update Strategy.
• Involved in review of the mappings and enhancements for better optimization of the Informatica mappings, sessions and workflows.
• Wrote complex SQL scripts to avoid Informatica Look-ups to improve the performance, as the volume of the data was heavy.
• Sourced the data from XML files, flat files, SQL server tables and Teradata.
• Prepared Technical Specification documents (TSD) for Mappings.
• Creating, maintaining and tuning views, Stored Procedures, User Defined Functions and System functions using SQL Server, T-SQL.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Involved in identifying errors in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that the mappings conform to the business requirements.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions. This led to better session performance.
• Created and troubleshoot (Debugged) Mappings.
• Prepared Test preparation and execution plans for different entities and executed the testing with team and Involved in Integration testing

Environment: Informatica 9.0.1, Cognos 10.2, Oracle 11g R2, Sql Developer.

Senior Informatica Developer

Confidential, Warren, NJ

Responsibilities:

• Worked with business analysts for requirement gathering (BRD), business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Developed mappings for fact and dimension tables using the various transformations to extract data from different source databases Oracle, SQL Server and XML Files.
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Worked on Migration of mappings from Data Stage to Informatica.
• Created Workflows using various tasks like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment and worked on scheduling of the workflows.
• Used mapping parameters and variables.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Used debugger to analyze the data flow between source and target to fix the data issues.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Used SQL Loader to load huge flat files into Oracle database.
• Implemented audit and reconcile process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Created the release requests for QA Builds to include all the release requirements and involved in the implementation of QA, UAT and Production releases.
• Developed UNIX Shell scripts, which will send the reports to client over the network by using file transfer protocol (FTP & SFTP) and generating the log file, which will keep the history for the FTP reports.
• Provided data loading, monitoring, System support and worked on data issues raised by end user during its production support phase.

Environment: Informatica PowerCenter 9.1.0, Oracle 10g, Oracle SQL* LOADER, Flat Files, UNIX Shell Scripting, TOAD.

Informatica Developer

Confidential, Redwood City, CA

Responsibilities:

• Interacted with various business people and gathered the business requirements and translated them into technical specifications.
• Documented business requirements and discussed issues to be resolved and translated user input into ETL design documents.
• Extracted data from various sources like Oracle, Netezza and flat files and loaded into the target Netezza database.
• Created NZSQL and NZLOAD scripts to load and unload data from Netezza
• Used Netezza Bulk writer and Netezza Bulk reader in Informatica to load and read data from Netezza.
• Wrote complex SQL queries on Netezza and used them in lookup SQL overrides and Source Qualifier overrides.
• Involved in migration of data from Oracle & DB2 to Netezza
• Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Stored Procedures, Router, Sorter, Rank, Expression, Normalizer and Update Strategy.
• Loaded TDS (tactical data store) with the derived voucher fields from MVS (Medical Vouchering System) from the reverse flow flat file.
• Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Created Netezza views to be used in SAP Business objects for semantic layer on data marts.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Created and Executed workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Developed Session Parameter files for the workflows.
• Analyzed the source fields and wrote SQL queries for field-to-field validation by referring source to target mapping document.
• Involved in the Data Analysis for source and target systems and good understanding of Data Warehousing concepts, Staging Tables, Dimensions, Facts and Star, Snowflake Schemas.
• Provided test data as per the test data requirements provided by the Medical Vouchering System team.
• Extensively worked with Unix Shell scripting to validate and verify the data in the flat files sent to MVS.

Environment: Informatica PowerCenter 8.6.1, Netezza Twinfin, Teradata, Oracle, DB2, MS Access, TOAD 9.0, SQL Developer, UNIX.

ETL Informatica Developer

Confidential, Irvine, CA

Responsibilities:

• Actively involved in designing and developing of Extraction, Transformation and Loading Process.
• Scheduling meeting with the business users to gather the business analysis reporting requirements.
• Involved in designing and creating mappings and mapplets using informatica source, warehouse, and transform and mapplet designers.
• Scheduling the workflows using informatica scheduler as per business needs.
• Enhancing the data mart as per business needs.
• Ftping the XML files to source directories.
• Recovering the failed sessions.
• Involved in writing Unix parameter files for informatica jobs
• Creating trigger file to create indicator files for continues workflows using command task.
• Used all transformations such as Expression, Filter, Router, Update, Union, Lookup, Rank, Connected Stored Procedures, Aggregator, and Sequence Generator. Sorter, Joiner Transformation.
• Maintained both development and production environments since a long-time using Power Center, Oracle (PL/SQL) under Unix and NT. Monitoring the load jobs, checking the error log files for regular load and interacting with users were my primary focus areas

Environment: Windows XP, Informatica 8.1.1 (PowerCenter), Business Objects XIR2, Oracle 10g, MS SQL Server 2005, TOAD, ERWIN, Shell Scripts, PERL, Autosys scheduling.

ETL Developer

Confidential, Dallas, TX

Responsibilities:

• Interacted with business users, analysts to gather, understand, analyze, program and document the requirements of Data Warehouse.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Created complexity mappings using Aggregator, connected, unconnected and dynamic Lookup, Joiner and created reusable transformations and mapplets in the mappings.
• Using Sequence generator for Surrogate keys in the dimensions to reduce the complexity and for improving the performance of composite keys.
• Worked on Workflow Manager to Schedule the workflows and run the sessions according to job dependency.
• Set up batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Troubleshoot the issues by checking sessions and workflow logs.
• Conducting debugging sessions and fixing invalid mappings.
• Created the Data Flow Diagrams to check the dependency.
• Involved in DBMS developments include building data migration scripts using Oracle SQL*LOADER and UTL packages.
• Written and used UNIX shell scripts extensively for scheduling and pre/post session management
• Developed unit testing, systems testing and post-production verification.
• Involved in extensive Performance tuning by determining bottlenecks at various points like targets, sources and systems. This led to better session performance.

Environment: Informatica Power Center 8.1/ 8.6, Oracle 11i/10g, Oracle SQL * Loader, Flat Files, UNIX Shell Scripting, TOAD.

Informatica Developer

Confidential

Responsibilities:

• Worked with business analyst in requirement gathering and involved in developing technical specifications from business requirements to build database.
• Installed and Configured Informatica 6.1
• Created necessary Repositories to handle the metadata in the ETL process.
• Performed Extraction, Transformation and Loading Process.
• Created Dimension Tables and Fact Tables based on the warehouse design.
• Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates.
• Integrated various sources in to the Staging area in Data warehouse to Integrate and for Cleansing data.
• Involved in building of the Data Warehouse, which includes the Design of Data mart using Star Schema.
• Created the Source and Target Definitions in Informatica PowerCenter Designer.
• Created Reusable Transformations and Mapplets to use in Multiple Mappings.
• Created Sessions and Batches using Server Manager for data movement through Mappings.
• Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, for Consistent access to SQL data source.
• Designed and developed backed Database in Oracle 8.
• Used SQL Loader to load the data into Oracle database.
• Developed PL/SQL procedures, functions to facilitate specific requirement.

Environment: Informatica 6.X/ 7.X, Oracle 8, Visual Basic 6.0 / Windows NT 4.0, Windows 2000 server, SQL* Plus, SQL, PL/SQL, SQL *Loader.