SUMMARY:

• Senior Informatica Developer with 8.5 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. 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 9.x/8.x/7.x Power Exchange.
• Oracle 12/11g/10g/9iSQL Server 2000/2005/2008 R2/2012Teradata R12/R13Netezza TwinFin.
• Business Objects XI R2/R1/6.x.
• Zena, Cron Tab
• Cognos 10.2
• T - SQL, PL/SQLUNIX Shell Scripting, XMLSybase, Erwin 4.1.
• Oracle PLSQL DeveloperQuest Toad for Oracle.
• UNIX, IBM AIX 4.3/4.2Windows NT/2000/XP/7.
• Tidal, JIRA.

CHRONOLOGICAL SUMMARY OF EXPERIENCE:

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 Patient 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, KS

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, CA

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.
• Constructing Triggers, Tables, implementing stored 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, 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.