PROFESSIONAL SUMMARY:

• 9+ Years of experience in System Analysis, Design and Development in the fields of database, data warehouse, client server technologies.
• Extensive experience in Data warehousing tools including Informatica, Oracle 11g, Teradata, SQL, PL/SQL databases.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Involved in the full life cycle of the data warehouse building process including dimensional modeling, ETL and Migration primarily using Informatica Power Center 9.6.x/9.1.x.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Stored Procedure, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Extensive experiences in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer and Warehouse Designer.
• Experience in working as part of an Agile SCRUM team responsible for iteratively delivering business outcomes.
• Good Exposure to Informatica Web services, Cloud based data integrations like Salesforce.com, Eloqua, and ServiceNow.
• Experience in performance tuning of sources, mappings, targets and sessions.
• Good Exposure on Apache Hadoop Map Reduce Programming and HDFS.
• Extensive experience in Relational Database Systems like Oracle, SQL Server, TeraData, design and database development experience with SQL, PL/SQL, SQL PLUS, Stored procedures, triggers.
• Knowledge of developing business mix reports, variance reports and exception reports using MICROSTRATEGY.
• Good in UNIX, shell scripting.
• Highly motivated, result oriented professional with a short learning curve and excellent communication skills.

TECHNICAL SKILLS:

Operating systems: UNIX, LINUX, Windows Server 2007

ETL Tool: Informatica Power Center 9.6/9.1/8.6, Informatica MDM 10.1, Informatica IDQ 9.1

BI Tools: Microstrategy 9.5, Tableau 10.3, Cognos 10.2, Business Objects XI, OBIEE

DataModeling: Sybase Power Designer 11, ERWIN 9.2, Star-Schema Modeling, Snowflake Modeling, FACT and Dimension Tables

Databases: Oracle 11g R2, SQL Server 13.0, DB2 LUW 11.1, TERADATA v15, MS Access, AWS Redshift

Languages: SQL, PL/SQL, UNIX Shell Scripting, XML

Big Data Ecosystem: HDFS, HIVE

DB Tools: Toad 12.1, SQL*Plus, SQL*Loader, MDX Queries, TERADATA SQL Assistant, BTEQ,TPUMP, FastLoad, Control-M, AutoSys

Version Control: Vault, Clear Case, Visual Source Safe

Defecttracking tool: Quality Center, JIRA, R ational clear Quest

PROFESSIONAL EXPERIENCE:

Confidential, Swiftwater, PA

Sr. Informatica Developer/Architect

Responsibilities:

• Extensively used Informatica Power Center 9.6/9.1 as ETL tool for developing project.
• Used Informatica Data Explorer and Informatica Data Quality for Data Quality Management and Data profiling purposes.
• Used Informatica Data Quality to formulate data conversion and data cleansing rules.
• Performed Data Integration, Data Standardization using IDQ.
• Designed mapping pipeline logic using lookup, Normalizer, aggregator, router, filter, expression, input, output, sequence generator and external procedure Transformations.
• Designed Mapplets, and reusable transformations within the ETL pipeline to embed the business process logic.
• Analyzed and defined detailed MDM processes, tasks, data flows, and dependencies.
• Extensively worked on Error Handling, Scheduling, Identifying ETL Job dependency and Recovery Mechanisms using SSIS.
• Written Hive queries for data analysis to meet the business requirements.
• Creating Hive tables and working on them using Hive QL.
• Importing and exporting data into HDFS and Hive using Sqoop.
• Integrated multiple cloud applications (like Salesforce, Netsuite) using Informatica Cloud Services (ICS).
• Used Oracle Warehouse Builder tools to deploy tables, mappings and related objects.
• Worked with Oracle EBS for SQL Database Integration.
• Extensively worked on performance tuning and monitoring of programs, ETL procedures and processes.
• Integrated PowerCenter with SAP Netweaver using Power Exchange tool.
• Have generated files through ETL Processes and placed them on AWS S3 for a global project.
• Designed ABAP mappings and BAPI mappings to extract and push the data from SAP Netweaver Environment.
• Integrated SAP BW with Enterprise Data warehouse using Power Exchange.
• Created Plans using Informatica Data Quality to perform Data Analysis and validation, Data Profiling and Creating Dashboards.
• Implemented ‘Best Practices’ for ETL in complex and multi-developer system including processes for code migrations and configuration controls.
• Interacted with the business users to collect Business Functional processes and translated them to ETL specification documents using Velocity Methodology.
• Used ETL debugger extensively to identify the performance bottlenecks within the mappings.
• Designed ETL Unit test strategy for pipeline data validations.
• Used workflow manager to create workflows, sessions, and used various tasks like command task, email task, control task and decision task.
• Prepared the ETL documentation for data conversions.

Environment: Informatica Power Center 9.6, Informatica Power Center 9.1, Power Exchange 9.1, IDE 9.1, IDQ 9.1, Oracle 11g, DB2 11.1, MS SQL Server, Teradata V15, UNIX, Autosys, Control-M, SAP Netweaver, SAP BW, Business Objects XI, Microstrategy.

Confidential, Pasadena, CA

Informatica Developer

Responsibilities:

• Designed the ETL processes using Informatica Power center 8.6.1 to load data from MS SQL Server, MS Access and Excel spreadsheet into the target Oracle database
• Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
• Prepare detailed design documentation by adhering to CMMI standards.
• Load monthly load, track issues and resolve them based on the priority.
• Extracted the data from the flat files and other RDBMS databases like DB2 into staging area and populated onto Data warehouse.
• Used Informatica Power Connect for SAP to pull data from SAP R/3.
• Developed number of complex Informatica mappings, Mapplets, reusable transformations to implement the business logic and to load the data incrementally.
• Developed Informatica mappings by usage of Aggregator, SQL Overrides in Lookups, Source filter in Source Qualifier, and data flow management into multiple targets using Router transformations.
• Worked with Informatica power exchange tools to give on demand access to the business users.
• Designing and creating data quality plans as per the requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Monitor and troubleshoot batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Developed UNIX shell scripts to move source files to archive directory.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Involved in Unit, Integration, system, and performance testing levels.
• Created documentation for all the mappings and uploaded documentation in company’s web portal

Environment: Informatica PowerCenter 8.6.1, IDQ, IDE, Power Exchange,Ms SQL Server, Oracle 10G, OBIEE, SQL Server 2000, SQL, PL/SQL, SQL* Loader, Erwin 4.5, TOAD 7.0, Star Schema, UNIX Shell Scripts, Flat files, Windows server 2003, and MS-Office tools.

Confidential, Santa Monica, CA

Informatica Developer

Responsibilities:

• Extensively involved in development of mappings using various transformations of Informatica according to business logic.
• Extensively used ETL tool to extract data from Oracle, Flat Files and XML sources.
• Designed and developed more than 60+ Mappings to load data from Source systems to staging Area and then to ODS, and to Data Mart.
• Created and Monitor the sessions using workflow manager and workflow monitor.
• Creation of Transformations like Lookup, Joiner, Expression, Update Strategy, XML Parser and Source Qualifier Transformations in the Informatica Designer.
• Crosschecked the mapping designs according to the business rules and suggested alternate designs to make the mapping design more robust and error-free.
• Data Quality Analysis to determine cleansing requirements.
• Extensively used ETL to load data from Oracle and Flat files to Data Warehouse.
• Extensively involved in writing Stored Procedures and calling them in Stored Procedure Transformation. Also used stored procedures for pre-load and post-load actions like logging.
• Involved in Database design for the staging area using Erwin tool.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Scheduled Sessions and Batches in the Informatica Server Manager.
• Fine-tuned existing sessions for performance increase measures.
• Involved in developing test plans, writing test scripts and test executions, analyzing test results.
• Successfully moved the Sessions and Batches from the Development environment to Production environment.

Environment: Informatica Power Center 8.6.0 Hot Fix 6, MS SQL Server2005, Oracle 10g SQL,TSQL, PL/SQL, COGNOS 8.4, SQL Server 2005, Sun Solaris OS, AutoSys 3.0, PL/SQL, SQL Developer.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Extensively used Informatica Power Center 8.6.0 as ETL tool for developing project.
• Used Informatica Data Explorer and Informatica Data Quality for Data Quality Management and Data profiling purposes.
• Used Informatica Data Quality to formulate data conversion and data cleansing rules.
• Performed Data Integration, Data Standardization using IDQ.
• Designed mapping pipeline logic using lookup, Normalizer, aggregator, router, filter, expression, input, output, sequence generator and external procedure Transformations.
• Designed Mapplets, and reusable transformations within the ETL pipeline to embed the business process logic.
• Extensively worked on performance tuning and monitoring of programs, ETL procedures and processes.
• Integrated PowerCenter with SAP Netweaver using PowerExchange tool.
• Designed ABAP mappings and BAPI mappings to extract and push the data from SAP Netweaver Environment.
• Integrated SAP BW with Enterprise Datawarehouse using PowerExchange.
• Created Plans using Informatica Data Quality to perform Data Analysis and validation, Data Profiling and Creating Dashboards.
• Interacted with the business users to collect Business Functional processes and translated them to ETL specification documents using Velocity Methodology.
• Used ETL debugger extensively to identify the performance bottlenecks within the mappings.
• Designed ETL Unit test strategy for pipeline data validations.
• Used workflow manager to create workflows, sessions, and used various tasks like command task, email task, control task and decision task.
• Prepared the ETL documentation for data conversions.

Environment: Informatica Power Center 8.6.0, Power Exchange 8.6.0, IDE8.6.0, IDQ8.6.0, Oracle 10g, DB2 9, Teradata V2R6, UNIX, SAP Netweaver, SAP BW, Business Objects XI.

Confidential, Seattle, Washington

Informatica Developer

Responsibilities:

• Developed ETL mappings, Transformations and Loading using Informatica Power Center 8.1.0.
• Developed mappings and workflows as per business logic, quality and coding standards prescribed for the module using Informatica Power Center8.1.0.
• Conducted performance tuning to increase performance of the mappings, sessions & workflows.
• Used PL/SQL with Informatica Power Center 8.1.0 for Oracle 9i database.
• Developed mapping document indicating the source tables, columns, data types, transformation required, bulk loading routines, business rules, target tables, columns and data types.
• Performed project management duties including analysis, design, and implementation of Extraction, Transformation and Loading methodologies.
• Additional project management duties included preparing Low Level Design (LLD) documents as per the business requirements and Unit Test Plan (UTP) documents for all test cases for developed mappings.
• Developed, implemented and enforced ETL best practices standards.
• Performance tuning and bottleneck resolution.
• Created and Implemented Reusable Sessions like E-mail.
• Involved in Data modeling team for developing Star Schema
• Developed application using UNIX operating system including scripting.

Environment: Informatica power center 8.1.0, TERADATA warehouse 8.1, Oracle10g, TOAD, SOLARIS UNIX, ERWIN.