SUMMARY

• Over 8+ years ofInformation Technologyexperience in the Analysis, Design, Development, Testing and Data Warehouse Implementation/development for Telecommunication, Health care, Pharmaceutical, Insurance, and Banking.
• Knowledge about Software Development Lifecycle (SDLC), Agile, Application Maintenance Change Process (AMCP).
• Expertise on Mapping Designer, Workflow Manager, Repository Manager and Workflow Monitor. Experienced in overall Data Warehouse, Database, ETL and performance tuning.
• Involved in preparing ETL mapping specification documents and Transformation rules for the mapping
• Implemented various ETL solutions as per the business requirement using Informatica 9.x /8.x /7.x.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Experienced in defining data quality, data modeling, data warehouse, Star/Snowflake Schema Designs with requirements analysis - definition, database design, testing and implementation, and Quality process.
• Familiar in Creating Secondary indexes, and join indexes in Teradata.
• In-depth knowledge and understanding of dimensional modeling (Star schema and Snowflake schema, SCD types- 1, 2, 3), and data modeling (star schema) at logical and physical level.
• Extracted sources from flat-files, DB2 & oracle and load them into Oracle & Teradata.
• Over 1 year of experience on Teradata development and OLAP operation with Teradata database.
• Involved in Performance tuning of the informatica mappings, sessions and oracle.
• Expertise in integration of various data source definitions like SQL Server, Oracle, Flat Files, SAP, and XML.
• Was involved in basic Informatica administration such as creating folders, users, change management, etc., and also involved in deploying code from DEV to TEST and PROD - using deployment groups in Informatica Repository manager.
• Experienced with Metadata Manager to generate Lineage and load MM resources.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Extensively worked with SQL loader for bulk loading into the oracle database.
• Experience in complete life- cycle of test case design, test plans, test execution, defect management.
• Experience in UNIX Shell and Perl Scripting.
• Experienced in Implementing HP Quality Center for bug detection and fixing in testing.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
• Team player with good interpersonal and problem solving skills, ability to work in team and also work independently.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.6.1/9.1/8.6.1 , PowerExchange and PowerConnect

Databases: Oracle 12c/11g/10g/9i, SQL Server 2012/2008, MS-Access, DB2, Teradata.

BI Reporting Tools: Oracle Business Intelligence (OBIEE 11.1.1.5/11. X, OBIEE 10.1.3.4.1/10. x), Dashboards, BI Publisher, BI Administration.

Languages: SQL, PL/SQL, Java, C, JavaScript, HTML, DHTML, XML, UNIX Shell Script, Perl, Visual Basic 6.0, Powershell.

Data Modeling Tools: MS Office Suite, MS project, MS Visio, Model Right (Data Modeler Tool), Erwin Data Modeler 4.1, UML

Web: Oracle Apex, Microsoft Front-page, HTML, DHTML and XML.

Operating Systems: Linux (RHEL), AIX, Solaris Windows 8/7/NT, UNIX

Multimedia Tools: Adobe Photoshop and Dreamweaver.

PROFESSIONAL EXPERIENCE

Confidential, NC

Informatica ETL Developer

Responsibilities:

• Interacted with the Business Analysts to understand the process flow and the business.
• Analyzing Source to Target mapping Excel document (BRS).
• Created Data Flow Mappings to extract data from source system and Loading to Target.
• Developed the strategy for the incremental loads.
• Worked on various tasks like Session, E-Mail task and Command task.
• Converted the regular mappings to handle the Slowly Changing Dimension.
• Created and used various re-usable tasks, workflows, worklets, mapplets, and re-usable transformations.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner etc.
• 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.
• Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Extensively used Unix Scripting, Scheduled PMCMD and PMREP to interact with Informatica Server from command mode.
• Created Users, Groups, Roles and grant privileges to the users. Create folders, Relational and Application connections and configure the ODBC connectivity.
• Involved in the Upgrade of Informatica Power Center v9.1 to v9.6.1.
• Worked with Admin team for migration strategy to the upgraded environments.
• Created web service jobs by configuring WSDL in designer and used Informatica Web Services Hub to start the Informatica tasks.
• Functionality, Back-end and Regression testing during the various phases of the application and Data Integrity/back end testing by executing SQL statements.
• Involved in Prod Support to research and resolve the daily load issues.
• Document the Prod job failures and provide the root cause analysis to the management.
• Used Informatica Dynamic Deployment groups to deploy the Informatica jobs among different environments (DEV, TEST, QA and PROD).
• Developed UNIX scripts for scheduling the delta loads and master loads using Autosys Scheduler.
• Scheduled meetings with Senior Data Leads and analyzed the data.
• Prepared the documents for all the modules developed.

Environment: Informatica Power Center 9.6.1/9.1, Flat files, Oracle 11gr2, CDC, SQL Server 2012/2008, Windows 7/NT, UNIX/Linux, DB2 and Teradata.

Confidential

ETL Senior Developer

Responsibilities:

• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center
• Develop Mappings and Workflows to generate staging files.
• Developed various transformations like Source Qualifier, Sorter transformation, Joiner transformation, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created multiple Mapplets, Workflows, Tasks, database connections using Designer, Workflow Manager
• Created sessions and batches to move data at specific intervals & on demand using Server Manager
• Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Extensively used Unix Scripting, Scheduled PMCMD and PMREP to interact with Informatica Server from command mode.
• Responsibilities include creating the sessions and scheduling the sessions
• Recovering the failed Sessions and Batches.
• Extracted the data from Oracle, DB2, CSV and Flat files
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance.
• Understanding the Functional Requirements.
• Designed the dimension model of the OLAP data marts in Erwin.
• Wrote documentation to describe program development, logic, coding, testing, changes and corrections.
• Performed Unit testing and System integration testing. Preparing the documents for test data loading
• Troubles shoot the Productions failure and provide root cause analysis. Worked on emergency code fixes to Production.

Environment: Informatica Power Center 9.1/8.6.1, Oracle 11gr1, DB2 9.7, AIX 6.1/ Linux RHEL 6.x, SQL SERVER 2008/2010, SQL Navigator, SQL, PL/SQL,Autosys.

Confidential, Tampa, FL

Informatica ETL Developer

Responsibilities:

• Worked closely with the business analyst and Data warehouse architect to understand the source data and need of the Warehouse. Worked in different stages of Data Stage basically on Hash Partitions
• Involved in designing of star schema based data model with dimensions and facts.
• Used Informatica as ETL tool for building the data warehouse.
• Worked on DQ team for fixing issues related to DQ tickets and worked on Data Stage for extracting and loading ODBC and data storages.
• Developed Data mappings using Informatica Designer and workflows using Workflow Manager.
• Extensively worked on different subject areas like Product, Individuals, Accounts, Scores, Billing, Services, Demographics, Call details and summary details.
• Created mappings with heterogeneous sources like flat files, Oracle databases and created targets in Oracle using Informatica Mapping Designer
• Designed and developed aggregate, join, lookup transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica Power center.
• Designed and developed mappings using Source qualifier, Aggregator, Joiner, Lookup, Sequence generator, stored procedure, Expression, Filter and Rank transformations.
• Created session variables to build sessions more effectively by using Informatica server manager.
• Developed mappings to dynamically use parameter files used by other mappings.

Environment: Informatica Power Center 8.6,Oracle 10g, TOAD,Control-M, UNIX, Windows XP.

Confidential

Senior ETL Developer

Responsibilities:

• Interact with end users and Business Analyst to gather and understand the Business process and requirements.
• Worked with the Source analysts to figure out the different source systems involved for the project and also provided necessary information as per development perspective.
• Involved in design review meetings to finalize the Data Model and the design documents necessary for the development. Prepared and reviewed Technical design documents for ETL coding. Worked on SCD Implementation in Data Stage.
• Created Sessions and workflows for related mappings
• Performed unit test for the code developed before promoting code to QA
• Worked with the configuration team for getting the environment setup for QA testing and also supported the end to end QA testing and successfully fixed the defects raised by the QA analyst.
• Involved in Informatica Admin tasks like Objects Migrations through different environments, creating folders and users.
• Developed the ETL design and Restart document for Production support team to fix the production failures that may occur after the post production of the project.
• Majorly involved in improving Operational Process and procedures.
• Additional responsibilities included, Educating new developers and assisting in designing and automation using
• Autosys, organizing team meetings, review of Autosys job Docs, Monitoring Batch schedule

Environment: Informatica Power Center 8.6, Oracle 10g, SQL Developer, UNIX, Autosys, HP Quality Center, Windows XP.

Confidential

Informatica ETL Developer

Responsibilities:

• Involved in analysis of source systems, business requirements and identification of business rules.
• Extracted sources from flat-files, DB2 & oracle and load them into Oracle & Teradata.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Powercenter.
• Implemented Slowly Changing Dimensions (Type 1 &2).
• Created mappings using the transformations like Source qualifier, Aggregator, Expression, lookup,
• Router, Filter, Update Strategy, Joiner, and Stored procedure transformations.
• Worked on Informatica Power Center 8.5 tool - Source Analyzer, Data warehousing designer, Mapping
• Designer &Mapplets, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
• Extensively used Informatica to load data from DB2, Flat Files and mainframes to Teradata/Oracle
• Created reusable transformations and Mapplets and used them in mappings.
• Involved in the process in documentation of source-to-target documentation design documentation of the Data Warehouse Dimensional Upgrades. Extensively used Informatica for loading the historical data from various tables for different departments.
• Created complex mappings and transformations.

Environment: Informatica Power Center 8.5, Oracle 10g, DB2, TOAD, SQL Developer, UNIX, Autosys, WINDOWS XP.

Confidential

ETL Developer

Responsibilities:

• Study the existing system and responsible for acquiring business requirements from the client
• Coordinating the team and delivering the products in time
• Responsible for Improving Data Model and for Designing of High Level and Low Level Design Documents
• Performed mapping to identify the customer profitability, customer lifetime value, and to understand customer segmentation, attrition analysis, and affinity analysis
• Created Parameter files to run the workflows and performed batch scheduling of tasks.
• Extensively worked in Oracle SQL, PL/SQL.
• Designed and developed Informatica mappings for data loading, manipulation etc
• Extensively worked on Informatica Mapping Designer and Informatica Workflow Manager
• Extracted data from sources like Oracle, Flat Files and Loaded the data into target Oracle database.
• Analyzing and Design the ETL mappings of all transactions.
• Developed complex mappings using a range of transformations on the extracted data according to the Transformation Business Rules and user requirements.
• Used session parameters whenever the same session was to be run using different values.

Environment: Informatica 8.1, Oracle, Flat files, MS SQL Server 2005, UNIX.