PROFESSIONAL SUMMARY:

• 11+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems in Healthcare, Banking, Life science and Insurance
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Informatica Powercenter, Hadoop, Data Warehouse/Data Mart Design, ETL, OLAP, BI,
• Expertise in working with relational databases such as Oracle 10g/10g/9i, SQL Server 2008/2005 and Teradata.
• Worked in Hadoop environment using Hortonworks, loaded the data from oracle to HDFS using SQOOP, written ETL scripts in PIG, Hive and wrote PIG UDF in Python.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Knowledge in Database Programming using RDBMS databases like SQL Server, Oracle 10g/11g and Teradata.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, SQL Server, Teradata, xml, CSV files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like ActiveBatch, Autosys, Informatica scheduler and UNIX.
• Worked extensively with slowly changing dimensions.
• Hands - on experience across all stages of Software Development Life Cycle (SDLC) including data mapping, build, unit testing, systems integration and user acceptance testing.
• Worked in AWS cloud to store the data in S3 environment.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

Operating Systems: Windows 2008/2007/2005/ NT/XP, UNIX, MS-DOS

ETL Tools: Informatica Power Center 10.x, 9.x/8.6/8.5/8.1/(Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server)Databases Oracle 11g/10g/9i, MS SQL Server 2008/2005, Teradata.

Languages: SQL, PL/SQL, UNIX, basic Shell scripts, PIG ETL scripts, HIVE, SQOOP, Python

Scheduling Tools: OOZIE, Autosys, Informatica scheduler and UNIX CRONTAB

Other Utilities: Toad 9.0, SQL Management Studio, Oracle SQL Developer, SQL *plusSQL server 2000/2005/2012 , CA WCC Autosys, Hortonworks, Jenkins, Udeploy

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Senior ETL Developer

Responsibilities:

• Developed mappings to load QNXT, MHC, GTE, Leon, Blue data into staging, build and dbo tables.
• On daily basis working on Incident management, problem management, Request management and change management tickets.
• Developed the shell scripts for moving files from external environment to informatica source folders, zipping the file, archiving files, transferring the files to remote location.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Improved Informatica performance using FLOAD, MLOAD Teradata utilities to load the data.
• Developed PL SQL scripts to implement complex business logic and called using informatica mappings.
• Fixing the data issues, code issues and coordinating DB, AB server issues.
• Deployed the mappings using Jenkins and udeploy.

Environment: Informatica Powercenter 10.1, Unix Shell scripting, SQL server, SQL, PLSQL Teradata, Active batch

Confidential, Dorchester, MA

ETL developer

Responsibilities:

• Developed rules in IDQ based on the business requirement and integrated that mapplet in informatica powercenter.
• Used IDQ to complete initial data profiling and removing duplicate data.
• Used IDQ 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.
• Profiled customer data and identified various patterns of the address to be included in IDQ plans.

Environment: Informatica Powercenter 10.1, Informatica IDQ, Unix Shell scripting, SQL server, Oracle

Confidential, Dayton, OH

Senior ETL Developer

Responsibilities:

• Collaborated on insights with other Data Scientists, Business Analysts, and Partners.
• Created and maintained Technical documentation for launching and prior to development.
• PCPAT, PCPAS and CMHC data are loaded in staging tables and CORR tables using informatica worflows.
• Worked on debugging, performance tuning in loading the data in CORR tables.
• Implemented test scripts to support test driven development and continuous integration
• Worked on tuning the performance join queries.
• Involved in creating email task and attaching the files that contains rejected records to the source team.

Environment: Informatica 9.5.1, Oracle, Teradata. PLSQL, SQL, UNIX

Confidential, Windsor, CT

Senior ETL Developer

Responsibilities:

• Documenting the design document after gathering requirements from the user.
• Created mapping documents to outline data flow from sources to targets.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Loading the data from oracle to HDFS using SQOOP from HDFS, using the PIG, the ETL scripts written to load the data.
• Extracted the data from the flat files and oracle databases into staging area and populated onto Data warehouse.
• All quote files will be from mainframe sources. The copy book will be sent to system. Copy book changed to cobol file and imported the structure in informatica PowerCenter.
• Production support for jobs failed. Analyzing the reason for failure and fixing the bug.
• Parameterized hardcoded values in informatica by keeping data in param files.
• Done performance tuning in mapping after by identifying the bottleneck and reduced the long running session.
• Creating JIL scripts, changing the scripts by adding job dependency, changing scheduled time, adding exclude calendar and deploying.

Environment: Informatica 9.1, PL/SQL, Oracle 11g, CA WCC Autosys, SQOOP, HIVE, PIG, HBASE, Python

Confidential, Shelton, CT

Sr. ETL Developer

Responsibilities:

• Developing mappings using mapplets, Autosys jobs, SQL Scripts and ensuring prudential standards.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Wrote UNIX shell Scripts & PMCMD commands for running informatica workflows and transferring file to remote location and arcHIVE the files after zipping it.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Mentoring the team and reviewing their mappings and procedure.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and dimensions and measured facts
• Conducted Peer reviews developed by my team mates before moving the code into QA.
• Promoting the code from QA to production environment.

Environment: Informatica 9.1, PL/SQL, Oracle 11g, CA WCC Autosys

Confidential

ETL Developer

Responsibilities:

• Designed ETL specification documents sapphire module.
• Loading data from various sources, XML, oracle DB.
• Received the XSD and imported in Informatica powercenter and loading the xml file data in oracle tables.
• Developed Type 2 SCD mappings on case dimension tables.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Developed mappings to load into staging tables and then to Dimensions and Facts
• Prepared Unit Test Cases for the developed interfaces.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Creation of PLSQL scripts and triggers for audit table.
• Developed Stored Procedures, Packages and materialized views.

Environment: Informatica 8.5.1 & 8.6.1, PL/SQL, Oracle 10g, XML

Confidential

Senior System Engineer

Responsibilities:

• Understand the requirements of the clients and prepare the Low level design document with the listing of various sources and targets
• Create the Mapping document so that which source field can be moved to the target field based on which mapping logic
• Used Session parameters, Mapping variable/parameters and created Parameter files
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Document the process from business and functional perspective - Design, Test Plan, Quality control process etc.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Changing the Mapping for performance tuning and implementing user’s standards.

Environment: Informatica 8.1.1, PL/SQL, Oracle 10g, UNIX Shell Scripting, Teradata

Confidential

Senior System Engineer

Responsibilities:

• Involved in the analysis of the user requirements and identifying the sources.
• Created technical specification documents based on the requirements by using mapping documents.
• Involved in the preparation of High level design documents and Low level design documents.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.
• Modified existing mappings for enhancements of new business requirements.
• Used Change Data Capture (CDC) to simplify ETL in data warehouse applications.
• Preparation of Unit Test cases.
• Involved in testing and documentation.

Confidential

System Engineer

Responsibilities:

• Creation of Mappings, Sessions and Workflows.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart
• Using Informatica PowerCenter created mappings and mapplets to transform the data based on mapping document.
• Worked on various kinds of transformations like Expression, Aggregator, Stored Procedure, Lookup, Filter, Joiner, Rank, Router and Update Strategy
• Creation of Oracle PLSQL Queries
• Preparation of Unit Test cases, integration testing.
• Involved in Unit, Integration, System, and Performance testing levels.