PROFESSIONAL SUMMARY:

• 7+ years of total experience in Information Technology including Data Warehouse/Data Engineer/Data Mart/Data integration/Data Pipelines development using ETL/Informatica Power Center.
• Extensive experience of Data Engineering/Data Migration/Data Auditing/Data Modeling in Banking, Insurance, Financial and Healthcare domains.
• Good exposure in overall SDLC including requirement gathering, development, testing, debuggingDeployment, documentation and production support.
• Experience with ETL process using Informatica Power Center 9.x Power Exchange, Designer (Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Repository Server, and Workflow Manager & Workflow Monitor.
• Experience in Data Integration/Data Analysis and problem solving process of various data sources with Multiple Relational Databases like Oracle, DB2Teradata, MS SQL Server and Worked on integrating data from XML files, flat files like fixed width and
• Excellent expertise with different types of data load strategies and scenarios like Historical dimensionsSurrogate keys, Summary facts etc.
• Experience in the successful implementation of ETL solution between an OLTP and OLAP database in
• Support of Decision Support Systems/Business Intelligence with expertise in all phases of SDLC.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema
• Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Good Communication and understanding of views, Synonyms, Indexes, Joins and Sub-Queries. Extensively used Cursors.
• Extensively created mapplets, common functions, reusable transformations, look-ups for better usability.
• Extensive experience in Tuning and scaling the procedures for better performance by running explain plan and using different approaches like hint and bulkload.
• Worked on healthcare data experience across Medicaid, Medicare, Healthcare data Exchange and commercial payer environments.
• Experienced with Teradata utilities FastLoad, MultiLoad, BTEQ scripting, FastExport, SQL Assistant.
• Involved in Understanding and translating the business requirements and to High Level and Low-level design for ETL processes in Teradata, Data stage and Informatica.
• Experience in Performance Tuning of mappings, ETL procedures and process and involved in complete life cycle implementation of data warehouse.
• Experienced in OLTP/OLAP system study, analysis and ER modeling, developing Database schemas like Star schema and Snowflake schema used in relational and multidimensional modeling by using Erwin, Visio.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and
• Extensive experience in implementing CDC using Informatica Power Exchange 9.x/8.x
• Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with
• Databases like Oracle 11x/10g, SQL Server 2005, Teradata, DB2, MSSQL, Excel sheets, Flat Files, Sybase, COBOL files and XML files.
• Strong RDBMS concepts and experience in creating, maintaining and tuning Views, Stored Procedures User Defined Functions and System
• Functions using SQL Server, T-SQL.
• Developed Complex mappings from varied transformation logics like Unconnected /Connected lookupsRouter, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed
• Effectively communicate with business, project manager and team members.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills.
• Basic knowledge working with large data sets, experience working with distributed computing (MapReduce, Hadoop, Hive, Pig, Apache Spark, etc.).

TECHNICAL SKILLS:

Informatica Tools: Informatica Power Centre 8x, 9x, 10.1.1, Informatica Master Data Management (MDM) 9.5, Informatica Data Quality 9.5 (IDQ). IICS(Informatica Intelligent Cloud Services)

Reporting tools: Tableau (Desktop/Server, Public/Reader) 10.2, SAP BO 4.3

RDBMS: Teradata, Oracle 9i/10g/11g, SQL Server 2008/R2/2012, TOAD 12.8, Amazon Redshift Database

Database skills: Stored Procedures, Database Triggers, Cursor, Packages

Languages: SQL, PL/SQL, UNIX

OS: UNIX, Windows 2003/2007/XP

Tools: Control-M 8.0, JIRA,Autosys R11.3, BMC Remedy 7.6, Atlassian JIRA 6.4, HP, Quality Center, Microsoft Office, Microsoft Excel, Microsoft Visio, MapReduce, Hadoop, Hive, Pig, Apache Spark

PROFESSIONAL EXPERIENCE:

Confidential - Sterling VA

Sr. Informatica Developer

Responsibilities:

• Worked on Field analyzing like identifying the business logic for each field, Participated in team meetings and proposed ETL Strategy.
• Worked on documenting solution and detail documents for the High - level Design Specifications for ETL Coding and mapping standards.
• Performed Unit-testing by generating SQL scripts based on the pre-defined test plans.
• Extensively used various active and passive transformations like Filter Transformation, Router
• Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, Look up Transformation, Update Strategy Transformation, Rank Transformation, and Aggregator.
• Created User Defined functions, reusable transformations to be re-used during the development life cycle.
• Created and implemented Informatica work flows in UNIX and Windows environments.
• Working on IICS(Informatica Intelligent Cloud Services) for Data movement.
• Working on Amazon AWS Redshift data base as my source and target.
• Written and used UNIX shell scripts extensively for scheduling and pre/post session management
• Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads and many default values of fact tables.

Confidential - Orlando FL

Sr. Informatica Developer

Responsibilities:

• Worked on Field analyzing like identifying the business logic for each field, Participated in team meetings and proposed ETL Strategy.
• Worked on documenting solution and detail documents for the High - level Design Specifications for ETL Coding and mapping standards.
• Performed Unit-testing by generating SQL scripts based on the pre-defined test plans.
• Extensively used various active and passive transformations like Filter Transformation, Router
• Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, Look up Transformation, Update Strategy Transformation, Rank Transformation, and Aggregator.
• Created User Defined functions, reusable transformations to be re-used during the development life cycle.
• Created and implemented Informatica work flows in UNIX and Windows environments.
• Written and used UNIX shell scripts extensively for scheduling and pre/post session management
• Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads and many default values of fact tables.
• Performed tuning of Informatica Mappings for optimum performance and SQL overrides in place of
• Homogeneous sources. Designed and coded rejected row handling process.
• Implemented Data Validation and Exception handling logic in the mapping to handle at runtime.
• Created the report for the Informatica CDC workflow s performance.
• Did change data capture (CDC) by using the MD5 function of Informatica.
• Implemented Slowly Changing Dimensions Type 1 and Type 2 to update the dimensional schema.
• Added enhancements such as mail functioning, success flag, pre and post session functions etc.
• 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.
• Extracting data from Database, Excel and Flat files through Informatica.
• Exposure to Agile environment.
• Created data lineage documents for data flow and ETL process using Informatica mappings to support the project once it implemented in production.

Environment: Informatica Power Center 9.6.1 (Designer, Repository Manager, Workflow Monitor, Workflow Manager),, Oracle 11g, DB2 V 9.1, Flat Files, UNIX Scripting, Windows XP.

Confidential - Scottsdale, AZ

Sr. Informatica Developer

Responsibilities:

• Analyzed the source data arriving from different source systems like Vendor Management Inventory, Invoice
• Processing System, Materials Forecasting, Purchase Orders and Requisition on Stores.
• Interacted with business teams for gathering business requirements and involved in documentation of Specifications.
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation.
• Developed standard mappings using various transformations like expression, aggregator, joiner, source
• Qualifier, router, lookup, and filter.
• Created Stored Procedures, Triggers, Functions, Indexes, Views, Joins and T - SQL code for applications.
• Developed mapplets for re-usability in ETL process.
• Writing SQL Server stored procedures using TSQL
• Involved in performance tuning and unit testing.
• Did change data capture (CDC) by using the MD5 function of Informatica.
• Scheduled and ran Extraction and Load processes and monitored tasks and workflows.
• Tuned the MMW databases (stage, target) for better, faster and efficient loading and user query performance.
• Involved in creating reports using Business Objects 8.1.
• Prepared low level technical design document and participated in build/review of the BTEQ Scripts, FastExports, Multiloads and Fast Load scripts, Reviewed Unit Test Plans & System Test cases.
• Used Netezza SQL to maintain ETL frameworks and methodologies in use by the company.
• Conducted code reviews.
• Wrote and drafted manuals needed for developed applications.
• Worked on highly complex projects in many different and varied technical areas and business segments.
• Collaborated with software architects to ensure alignment of the Netezza environment.

Environment: Informatica Power Center 9.6.1, Erwin 4.1, UNIX Shell Scripting, Oracle 10g, PL/SQLBO 8.1, Windows XP/2007.

Sr. Informatica Developer/ Business Analyst

Confidential - Nashville, TN

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Used Informatica Power Center 10.1.1 for extraction, loading and transformation (ETL) of data in the datamart.
• Designed and developed ETL Mappings to extract data from flat files, MS Excel and Oracle to load the data into the target database.
• Worked on healthcare data experience across Medicaid, Medicare, Healthcare data Exchange and commercial payer environments.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power sCenter.
• Transformation mapping for inserting and updating records when loaded.
• Expertise in conversions from SQL Server to Teradata.
• Created complex mappings to load the data mart and monitored them. The mappings involved extensive
• Extensively used ETL processes to load data from various source systems such as DB2, SQL Server and Flat Files, XML files into target system Teradata by applying business logic on Use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.
• Ran the workflows on a daily and weekly basis using Active Batch Scheduling tool.
• Examined the workflow log files and assigning the ticket to the Informatica support based on the error.
• Experience in developing Unix Shell Scripts for automation of ETL process.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Worked on healthcare data experience across Medicaid, Medicare, Healthcare data Exchange and commercial payer environments.
• Performed operational support and maintenance of ETL bug fixes and defects.
• Maintained the target database in the production and testing environments.
• Created Mapping Parameters and Variables.
• Worked with Teradata utilities such as Mload, Fload, export etc. to load or extract tables.
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Wrote numerous BTEQ scripts to run complex queries on the Teradata database.
• Supported migration of ETL code from development to QA and QA to production environments.
• Migration of code between the Environments and maintaining the code backups.
• Did change data capture (CDC) by using the MD5 function of Informatica.
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Developed PL/SQL code at the database level for the new objects.
• Building Reports according to user Requirement.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker chartsScatter Plots, Geographic Map, Cross tabs, Histograms etc.

Environment: Informatica Power Center 10.1.1, Oracle 11g, PL/SQL, Teradata, Flat files, SQL Server 2008, Erwin, UNIX. Toad 9.0, Oracle SQL developer 11g, Tableau 10.2.

ETL Developer

Confidential - Los Angeles, CA

Responsibilities:

• Experienced working with team leads, Interfaced with business analysts, third party vendors and end users.
• Interacted with various business people in Human Resource, and Global Finance to gather business
• Requirements and translated them into technical specifications.
• Documented business requirements, discussed any data issues with business people to get resolved and translated the input into ETL design documents.
• Worked with data analysts to find Source, target and RDBMS table's information to implement design of
• Informatica mappings, transformations, workflows, scripts and commands to meet business requirements.
• Involved in ETL process from design, development, testing and migration to production environments.
• Involved in writing the ETL test scripts and guided the testing team in executing the test scripts.
• Used UNIX Shell Scripting to invoke Sessions in the workflow manager.
• Perform UNIX code migration from one environment to another environment for application execution
• Did change data capture (CDC) by using the MD5 function of Informatica.
• Extracted data from various sources like Oracle, MS SQL server, Teradata, flat files, XML files and loaded into multiple targets like MS SQL server, Oracle database and created flat files and XML files.
• Worked extensively on Teradata Database to load data in EDW and Datamart using MLOAD, FASTLOAD, TPT and BTEQ.
• Created Collect Stats scripts for Teradata.
• Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Router, Sorter, Rank,Expression, Normalizer, Sequence Generator and Update Strategy.
• Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables, tasks and Session Parameters.
• Developed SFTP, FTP, and Session Parameter files for the workflows.
• Worked on Data Quality to trouble shoot data issues to meet the Project requirements.
• Involved in writing SQL queries to validate the data on the source and target databases according to source to target mapping document.
• Developed Pre - session and Post-session scripts, MS - DOS commands and scripts to rename files and move files from one share to another share location.
• Involved in ETL code reviews and followed Company standards in developing the interfaces.
• Worked with Support team to migrate the ETL code to Production servers from development servers by
• Creating a mapping document and Request for Change (RFC) of the process.
• Involved in Knowledge Transfer sessions to Support team after completion of UAT signoff.
• Handled Production issues and monitored Informatica workflows in production.

Environment: Informatica Power Center 9x, Oracle 11i/10g, Unix, MS SQL Server, Teradata, TOAD, SQL Developer, BMC CONTROL-M, HP Quality Center, Windows 7/XP professional.

ETL Developer

Confidential

Responsibilities:

• Worked on Field analyzing like identifying the business logic for each field, Participated in team meetings and proposed ETL Strategy.
• Worked on documenting solution and detail documents for the High - level Design Specifications for ETL Coding and mapping standards.
• Performed Unit-testing by generating SQL scripts based on the pre-defined test plans.
• Extensively used various active and passive transformations like Filter Transformation, Router
• Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, Look up Transformation, Update Strategy Transformation, Rank Transformation, and Aggregator.
• Created User Defined functions, reusable transformations to be re-used during the development life cycle.
• Created and implemented Informatica work flows in UNIX and Windows environments.
• Written and used UNIX shell scripts extensively for scheduling and pre/post session management
• Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads and many default values of fact tables.
• Performed tuning of Informatica Mappings for optimum performance and SQL overrides in place of
• Homogeneous sources. Designed and coded rejected row handling process.
• Implemented Data Validation and Exception handling logic in the mapping to handle at runtime.
• Implemented Slowly Changing Dimensions Type 1 and Type 2 to update the dimensional schema.
• Added enhancements such as mail functioning, success flag, pre and post session functions etc.
• 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.
• Extracting data from Database, Excel and Flat files through Informatica.
• Exposure to Agile environment.
• Created data lineage documents for data flow and ETL process using Informatica mappings to support the project once it implemented in production.

Environment: Informatica Power Center 9.1.1 (Designer, Repository Manager, Workflow Monitor, Workflow Manager), Autosys, Oracle 11g, DB2 V 9.1, Flat Files, UNIX Scripting, Windows XP.

Informatica ETL Consultant

Confidential

Responsibilities:

• Analyzed the source data arriving from different source systems like Vendor Management Inventory, Invoice
• Processing System, Materials Forecasting, Purchase Orders and Requisition on Stores.
• Interacted with business teams for gathering business requirements and involved in documentation of Specifications.
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation.
• Developed standard mappings using various transformations like expression, aggregator, joiner, source
• Qualifier, router, lookup, and filter.
• Developed mapplets for re - usability in ETL process.
• Involved in performance tuning and unit testing.
• Used Pipeline partitioning and External Loader to improve Session performance.
• Scheduled and ran Extraction and Load processes and monitored tasks and workflows.
• Tuned the MMW databases (stage, target) for better, faster and efficient loading and user query performance.
• Involved in creating reports using Business Objects 8.1.

Environment: Informatica Power Center 8x, Erwin 4.1, UNIX Shell Scripting, Oracle 10g, PL/SQLBO 8.1, Windows XP/2007.