PROFESSIONAL SUMMARY

• 7+ years of experience in IT in the areas of analysis, design, development and testing in client server environment with focus on Data warehousing applications using ETL/OLAP tools like Informatica, Business Objects with Oracle, SQL Server databases, SSIS, MDM etc.
• Experience in complete software development life cycle (SDLC) of project with experience in domains like Retail, Healthcare Insurance and Automobile.
• Experience in business requirements gathering, define and capture metadata for business rules, system analysis, design, development, production support, testing, user training, and strategic decision making, problem solving associated with the ETL processes by working closely with BI team.
• Experience in developing Enterprise level Data warehouse, Data marts and Operational databases.
• Experience in creating complex mappings using various transformations and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica 9.1/ 8.6/ 7.x/ 6.x/ 5.x.
• Experience in source systems analysis and data extraction from various sources like Flat files, Oracle 11g/ 10g/ 9i/ 8i, DB2 UDB.
• Extensive experience using tools and technologies such as Oracle 11g/ 10g/ 9i/ 8i, SQL Server 2012/ 2008R 2/ 2008/ 2005/ 2000 , DB2 UDB, Sybase, Teradata 13 / 12/ V2R5/ V2R4, Netezza MS Access, SQL, PL/SQL, SQL*Plus, Sun Solaris 2.x, Erwin 4.0/3.5, SQL* Loader, TOAD, Stored procedures, triggers.
• Experience in Performance Tuning. Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Strong data modeling experience using Star/Snowflake schemas, Re - engineering, Dimensional Data modeling, Fact & Dimension tables, Physical & logical data modeling.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE), Informatica Data Quality (IDQ) and Informatica Master Data Management (MDM).
• Experience in writing complex sub queries, PL/SQL programs (functions, procedures, packages), stored procedures, and shell scripting to run pre-session and post session commands.
• Experience working with heterogeneous data sources like Oracle, SQL Server 2008/2005, flat files, XML files, DB2 UDB, Main Frames and COBOL files.
• Experience in error handling as part of production support on Informatica as well as Unix.
• Experience in performance tuning of sources, transformations, targets, mapplets, mappings, worklets, workflows, sessions and batches
• Expertise in using GUI tools like Erwin, Toad, SQL Developer, SQL Navigator and SQL *Loader.
• Excellent communication skills, team player, ability to work individually and meet tight deadlines.
• Experience in Installation, Configuration, and Administration of Informatica Power Center 9.x/ 8.x/ 7.x/ 6.x, power exchange 8.1 and Power Mart 6.x/ 5.x Client, Server.
• Experience in Validating ETL Tools like Informatica Power Center.
• Extensive knowledge in System Testing / Integration Testing and Regression testing
• Extensive experience in writing SQL scripts to validate the database systems and for backend database testing.
• Expertise in defining Test Strategies, writing detailed Test Plan and Test Cases, Defect Tracking and Defect Reporting using Mercury Quality Center.
• Adaptable and proficient in the design and programming of systems in a wide variety of areas including Real Time Systems.
• Strong Team Player with communication and relationship management skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center, Power Exchange 9.5/ 8.6/ 8.1/ 7.1 , Metadata Manager, Power-Exchange, IDQ, IDE, MDM, SSIS, DataStage, Salesforce

Reporting Tools: Business Objects XIR2/ 6.1/ 5.0, Qlikview, OBIEE, Micro strategy, Oracle Analytics,

Databases: Oracle 11g/ 10g/ 9i/ 8i, MS SQL Server 2012/ 2008R 2/ 2008/ 2005/ 2000 , MS Access, IBM, DB2, Teradata 14.0,Netezaa 4.0, Siebel CRM, PeopleSoft

Data Modeling : Data Modeling, Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

DB Tools: TOAD, SQL Developer, SQL Assistant, Visio, ERWIN

Languages: C, C++, Java, SQL, PL/SQL, Unix Shell Scripting

Operating Systems: UNIX, Windows

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr ETL Developer/ Sr Application Developer

Responsibilities:

• Gathered requirements and understood the Functional Business processes and Requirements given by the Business Analyst.
• Designed High Level Technical Documentation based on specification provided by the Manager.
• Used ETL Tool Informatica extensively to load data from Flat Files, Oracle, SQL Server, Teradata etc.
• Drove out requirements and designs and worked with business and technical teams.
• Created Complex SQL queries for reporting against tables.
• Used Teradata Utilities FastLoad, multiload, tpump to load data
• Designed and developed Informatica mappings for data loads and data cleansing.
• Worked with various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Stored procedure, Router and Normalizer etc.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows.
• Used PMCMD command to start, stop and ping server from UNIX and created Shell scripts to automate the process.
• Provided production support as required.
• Worked on special assignments such as targeted data loads for WCDST and business partner needs.
• Worked with SQL server, SSIS and XML.
• Integrated sources from different databases and flat files.
• Used Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability.
• Performed complex troubleshooting, root-cause analysis and solution development independently
• Worked on end to end system testing, performance and regression testing and data validations and Unit Testing.
• Used Deployment group to move Informatica objects from DEV to TEST and from TEST to QA/PROD.
• Suggested best practices in Informatica and ETL processes to improve efficiency of the ETL process.

Environment: Informatica Power Center 9.6.1, Teradata 14.0, Oracle 11g, SQL Server 2012, SSIS, PL/SQL, Visual Studio 2012, UNIX, TOAD, XML.

Confidential, Auburn Hills, MI

Sr Informatica Developer

Responsibilities:

• Prepared Conceptual Solutions and Approach documents and gave Ballpark estimates.
• Designed and developed Amazon Redshift databases and worked with XML, Redshift and Flat file connectors.
• Prepared Business Requirement Documents, Software Requirement Analysis and Design Documents (SRD) and Requirement Traceability Matrix for each project workflow based on the information gathered from Solution Business Proposal document.
• Worked in different subject areas - Medical, Pharmacy, Dental, Vision, Medicare, Medicare Advantage, PPO, HMO, POS, Master Medical and Care Management.
• Created and managed Virtual machines in Windows Azure and setting up communication with the help of Endpoints and VM migrations from Transactional hosts.
• Worked on Inbound, Outbound and Carve-out Data Feeds and developed mappings, sessions, workflows, command line tasks etc. for the same.
• Coordinated and worked closely with legal, clients, third-party vendors, architects, DBA’s, operations and business units to build and deploy.
• Used Data stage to manage the Metadata repository and for import /export for jobs
• Used IDQ address validation transformation to generate CASS and AMAS report for US and China addresses
• Worked with various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Stored procedure, Router and Normalizer etc.
• Worked with Connected and Unconnected Stored Procedure for pre-load and post load sessions
• Designed and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Used PMCMD command to start, stop and ping server from UNIX and created Shell scripts to automate the process.
• Worked on production tickets to resolve the issues in a timely manner.
• Prepared Test Strategy and Test Plans for Unit, SIT, UAT and Performance testing.

Environment: Informatica Power Center 9.5, Informatica IDQ, Oracle 10g, Teradata, SQL Server 2008R2, Toad, SQL Plus, SQL Query Analyzer, SQL Developer, MS Access, Windows NT, Shell Scripting, Clear Quest, Tivoli Job Scheduler, Windows Azure.

Confidential, Buffalo, NY

Sr ETL Developer

Responsibilities:

• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Worked on data modeling and designed the Data Warehouse using Star Schema methodology.
• Responsible for all the ongoing data model design decisions and database implementation strategies.
• Extracted data from different source systems such as Oracle, SQL Server, MS Access, DB2, Mainframes, XML and Flat Files.
• Created customer hub (MDM) - by consolidating and integrating various sources and storing the golden record as individual identity in the hub.
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and Load Data into DataMart’s, Enterprise Data warehouse (EDW) and Operational data store (ODS).
• Used Metadata Manager to manage the Metadata associated with the ETL processes.
• Used Power Center Data Masking Options (Random Masking, Blurring, SSN, and Credit Card) in mappings.
• Used error handling mapplets to capture error data into PMERR tables for handling nulls, analysis and error remediation process.
• Defined the test strategy, created unit test plans and supported UAT and regression testing using HP Quality Center.
• Used IDQ to do data profiling of the master data. Used Informatica Analyst to get an overview of the accuracy of the data and percentage populated.
• Used Informatica Developer client to set up Address validation, name matching using Match transformation, etc.
• Identified slowly running ETL jobs and reduced the run time drastically by applying performance tuning techniques.
• Advocated best practices for ETL Processes and conducted Data Integration COP meetings.
• Created slice and dice and drill down Reports, Dashboards, and Scorecards using OBIEE 11g for various subject areas.

Environment: Informatica Power Center 9.5/ 9.1.1/ 8.6 , Informatica MDM, Informatica Developer client, Power Exchange CDC, Oracle 11g, Erwin, Informatica IDQ, Quality Center, SQL SERVER 2008/ 2005, MS Access, XML, T-SQL, Shell Scripts, Control-M, Teradata.

Confidential, Kansas, KS

Sr ETL Developer

Responsibilities:

• Analyzed the functional specifications provided by the data architect and created Technical System Design Documents and Source to Target mapping documents.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Performed Source System Data Profiling using Informatica Data Explorer (IDE).
• Designed Staging and Data mart environments and built DDL scripts to reverse engineer the logical/physical data model using Erwin.
• Extracted data from SAP using Power Exchange and loaded data into SAP systems.
• Used Informatica Power Exchange for Mainframe to read/write VSAM files from/to the Mainframe.
• Worked on Basic Informatica administration such as creating folders, users, privileges, server setting optimization, and deployment groups, etc.
• Designed Audit table for ETL and developed Error Handling Processes for Bureau Submission.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows.
• Used Informatica IDQ to do data profiling of the source and check for the accuracy of data using dashboard.
• Managed Change Control Implementation and coordinating daily, monthly releases and reruns.
• Responsible for Code Migration, Code Review, Test Plans, Test Scenarios, Test Cases as part of Unit/Integrations testing, UAT testing.
• Used Teradata Utilities such as MLoad, FLoad and Tpump.
• Created BTEQ scripts.
• Used UNIX scripts for automating processes.

Environment: Informatica Power Center 9.1.1, Informatica Developer Client, IDQ, MDM, Power Exchange, SAP, Oracle 11g, PL/SQL, TOAD, SQL SERVER 2008/ 2005, XML, UNIX, Windows XP, OBIEE, Teradata.

Confidential, Pleasanton, CA

ETL Developer

Responsibilities:

• Translated the business processes/SAS code into Informatica mappings for building the data mart.
• Used Informatica PowerCenter to load data from different sources like flat files and Oracle, Teradata into the Oracle Data Warehouse.
• Implemented pushdown, pipeline partition, persistence cache for better performance.
• Developed reusable transformations and mapplets to use in multiple mappings.
• Implemented Slowly Changing Dimensions (SCD) methodology to keep track of historical data.
• Assisted the QC team in carrying out its QC process of testing the ETL components.
• Created pre-session and post-session shell scripts and email notifications.
• Participated in complete cycle from Extraction, Transformation and Loading of data using Informatica best practices.  
• Created mappings using Data Services to load data into SAP HANA.
• Participated in data quality checks by interacting with the business analysts.
• Performed Unit Testing and tuned the mappings for the better performance.
• Maintained documentation of ETL processes to support knowledge transfer to other team members.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows.
• Provided Production support.

Environment: Informatica Power Center 9.1, Oracle 11g, Teradata, SAP HANA, UNIX Shell Scripts.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Responsible for requirement definition and analysis in support of Data Warehousing efforts.
• Developed ETL mappings, transformations using Informatica PowerCenter 8.6.
• Used ETL Tool Informatica extensively to load data from Flat Files, Oracle, SQL Server, Teradata etc.
• Developed data Mappings between source systems and target system using Mapping Designer.
• Responsible for Test and Production issue resolutions.
• Developed shared folder architecture with reusable Mapplets and Transformations. 
• Worked with Debugger extensively for handling the data errors in the mapping designer.
• Created events and various tasks in the work flows using workflow manager.
• Tuned ETL procedures to optimize load and query Performance.
• Set up Batches and sessions to schedule the loads at required frequency using Informatica workflow manager and external scheduler.
• Tested the mapplets and mappings as per Quality and Analysis standards before moving to production environment.
• Participated in Informatica administration.
• Migrated development mappings as well as hot fixes them in production environment.
• Wrote shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.
• Migrated Informatica Objects using Deployment groups.
• Worked on trouble issues in TEST and PROD and did impact analysis and fixed the issues.
• Worked closely with business analysts and gathered functional requirements.
• Designed technical design documents for ETL process.
• Developed Unit test cases and Unit test plans to verify the data loading process and Used UNIX scripts for automating processes .

Environment: Informatica - PowerCenter 8.6, Power Exchange, Teradata, Oracle 10g, MS Access, UNIX, Windows NT/ 2000/ XP, SQL Server 2008, SSIS, OBIEE, Qlikview, Teradata, SQL Assistant, Netezza, DB2.

Confidential, Chapel Hill, NC

Informatica Developer

Responsibilities:

• Participated in requirement gathering and Understanding of the Functional Business processes and Requirements given by the Business Analyst.
• Designed High-Level Technical Documentation based on specification provided by the Manager.
• Created Complex SQL from Technical requirement document and optimized it.
• Created Complex SQL queries for reporting against tables.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Performance tuned ETL processes at the mapping, session and Database level.
• Integrated sources from different databases and flat files.
• Used Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability.
• Performed complex troubleshooting, root-cause analysis and solution development independently
• Involved in end to end system testing, performance and regression testing and data validations and Unit Testing.
• Extensively used SQL and PL/SQL Scripts.
• Extracted data from SAP using Power Exchange and loaded data into SAP systems. Used SAP BO as the reporting tools.
• Used Deployment group to move Informatica objects from DEV to TEST and from TEST to QA/PROD.
• Suggested best practices in Informatica and ETL processes to improve efficiency of the ETL process.

Environment: Informatica Power Center 8.6/ 8.1, Oracle 10g/ 9i, SQL Server 2005/ 2000, SSIS, PL/SQL, SQL, Visio 2003, UNIX, TOAD, DataStage.