PROFESSIONAL SUMMARY:

• Over 8 years of IT experience, ETL Designer and Developer, using Informatica Power Center 9.X/ 8.X/7.X and Informatica Data Quality, Oracle 12c/11i/10g/9i.
• Expertise in using Informatica (Repository Manager, Server Manager, Mapping Designer, Workflow Manager, Workflow Monitor, Transformation Developer, Source Analyzer) and DAC (Data ware house Application Console).
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Worked on various domains including Health, Insurance, Finance, Retail and Energy.
• Strong knowledge of Data warehouse concepts - Star Schema, Snowflake and Slowly Changing Dimensions.
• Involved in Full Life Cycle Development of building a Data Warehouse including agile and waterfall methodologies.
• Experience working with Informatica Data Quality tool Developer and Analyst tool. Carried out data analysis, data matching, and data conversion and reporting.
• Developed several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both the Informatica Power Center.
• Experience on creating profile, rules and mappings with IDQ.
• Experience working with IDQ transformations like Labeller, Parser, Standardizer etc.
• Knowledge in software development, maintenance, testing and troubleshooting on Master Data Management (MDM), data integration and Oracle database environment.
• Strong knowledge of Data warehouse concepts - Star Schema, Snowflake and Slowly Changing Dimensions (SCD) Type I and II.
• Experience in Enterprise Marketing Management software (UNICA).
• Closely worked on developing the business rules for cleansing and performed data profiling & various data quality rules development using Informatica Data Quality.
• Interacted with end users to resolve Informatica Power Center issues and coordinated with Informatica support for patches and bug fixes.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS) and Informatica.
• Developed complex mappings using various transformation logic like Source Qualifier, Router, Filter, Expression, Sorter, Aggregator, Joiner, Union, Connected/Unconnected lookups, Update Strategy and Normalizer and loaded data into different target types from different sources like Flat files (Delimited files and Fixed width files) like text files or CSV files, XML, Oracle, IBM Mainframe, Cobol files, SQL server, DB2, Teradata.
• Good exposure in writing BTEQ scripts and loading data into Teradata using FASTLOAD, MLOAD and TPUMP utilities.
• Experienced in writing Unix Shell Scripts for the automation of ETL processes and using schedulers like Autosys, Ctrl-M.
• Good communication and interpersonal skills, ability to learn quickly, with good analytical reasoning and adaptive to new and challenging technological environment
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within timeframe.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x, IDQ,Informatica Cloud

Database Tools: Oracle 12c/11i/10g/9i/8i, T-SQL, MS SQL Server 2012/2008/2005, Sybase SQL

Server 12.0/11.x Teradata V2R12/V2R6, MS Access 7.0/2000, SQL, PL/SQL, DB2 UDB 8.0/7.0/6.0

Development Languages: SQL, PL/SQL, UNIX, Shell Scripting,python

Data Bases: Oracle 11i/10g, My SQL

Operating Systems: Windows XP/7, UNIX, Sun OS

BI Tools: Crystal Reports

Scheduling: Informatica Scheduler, Control M, Autosys, Tidal

Web Technologies: Java, HTML, XML, Eclipse.

Others: Toad, PL/SQL Developer, WinSCP, Putty, MS Office, Remedy

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

ETL Informatica Developer/Support

Responsibilities:

• Worked on Informatica - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet and Transformations.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures using Informatica Power Center.
• Implemented logical and physical data modeling with STAR schema techniques in Data Mart.
• Performance tuning of Informatica sessions for large data files has been done by increasing block size, data cache size and, sequence buffer length.
• Extensively used various transformations Lookup, Update Strategy, Expression, Aggregator, Filter, Procedures and Joiner etc.
• Extensive experience in extraction of data from various sources like relational databases Oracle, SQL Server, Flat Files, MS Access & XML Files and DB2.
• Used Informatica Power Center Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Developed several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both the Informatica Power Center.
• Implementation of SCD type1/type2/type3 in existing ETL interfaces for capturing slowly changing dimensions.
• Performed planning and execution of large data conversion.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Source data was extracted from Oracle 11i, SQL Server, flat files, COBOL sources.
• Performed Incremental Loads and Data cleaning in SSIS. Expert in handling errors, logging using Event Handlers using SSIS.
• Implemented Change data capture and incremental logics in inventory ETL Interfaces by identifying the audit columns for the data.
• ETL mapping Documents for every mapping andData Migration document have been developed for smooth transfer of project from development to testing environment and then to production environment.
• Worked in debugging using Session Log messages, Server Messages.
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 9i in accordance with requirements and specifications.
• Used TOAD to run SQL queries.
• Extensively used SQL*Loader to load data from flat files to database tables in Oracle.
• Responsible for the analyzing and comparing complex data from multiple sources (Oracle, flat files).
• Responsible for writing Unix Shell Scripts to schedule the jobs.
• Actively interacted with business analysts.
• Used Autosys Tool to schedule shell scripts and Informatica jobs.
• Worked with Business analysts and the DBA for gathering requirements and for project coordination.

Environment: Informatica Power Center v9.6,Informatica Cloud, Oracle 12c, IMS Database (DB1), DB2, Teradata, SQL, Flat Files, Putty, Windows-XP (Client), Mainframe, Unix, AS/400, TOAD 12.6, MS Visio,ILM, Informatica servers on Unix and Power Exchange.

Confidential, Denver, CO

Informatica/IDQ Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated
• Developed Informatica Mappings/Workflows to load domain data from Sybase Database, Flat Files into Db2.
• 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.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 9.1.0
• Profiled customer data and identified various patterns of the phone numbers to be included in IDQ plan.
• Data extraction and data Transfer Sybase Database using utilities / tools like BCP, and BULK INSERT.
• Designed Informatica complex Mappings and Workflows to be re-startable after a failure.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, SQL Transformation, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
• Designed tables required for the execution of the ETL processes using Erwin.
• Developed DB2 SQLs for the ETL and for populating run statistics.
• Used scripts to import and export data to from the database.
• Developed various mappings to process data from flat files (.txt, Excel, and XML files) to Oracle database.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD.
• Developed UNIX Shell scripts for File Manipulation, FTP, Executing DB2 SQLs and archiving log files.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Sessions, Workflows and database.
• Involved in designing Logical/Physical Data Models (Star Schema), forward/reverse engineering using Erwin.
• Prepared Technical Documents related to design, development and testing as per CMM.
• Implemented reusable mappings & sessions for Operational Audit Process.
• Created mappings to keep historical data (SCD type 2) and load control for ETL extract.
• Prepared the technical specifications using use cases and maintained versioning & deployment groups’ functionality.
• Involved in monitoring of production ETL applications, Production Support through tickets. Executing
• Scripts / Managing scheduled activities based on business requirements.

Environment: Informatica Power Center 8.6.1, IDQ 8.6.1, CDC, IBM DB2 UDB 8, Facets 4.51, Sybase, Erwin 4.2, Teradata,SQL Server 2005, Oracle11g, Excel, Flat files, SQL, PL/SQL, SSIS,Win SQL, Windows XP, UNIX Shell Scripts, IBM AIX 5.3.4

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Involved in requirements gathering and analysis to define functional specifications.
• Extensively worked on Process Design, Development, Testing and Implementation of the Project.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Developed ETL processes to load data from different source systems such as Oracle and Flat Files into target systems i.e. Oracle and Flat files.
• Extracted the data from Oracle10g, Netezza, XML, XLS,Flat files, DB2 load the data in to Oracle warehouse.
• Extensively worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet & Transformations to import source and target definitions into the repository and to build mappings.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier.
• Defined Target Load Order Plan for loading data into Target Tables
• Used Informatics features to implement Type II changes in slowly changing dimension tables.
• Created tables, views, primary keys, indexes, constraints and sequences.
• Involved in developing optimized code using PL/SQL for Server related Packages to centralize the application through procedures, functions and packages.
• Different database triggers containing PL/SQL were created and stored in the database and fired off when contents of database were changed.
• Used debugger to test the mapping and fixed the bugs.
• Created and configured workflows, Worklets & Sessions to transport the data to target systems using Informatica Workflow Manager.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in the architecture and management of data governance with Business Intelligence team.
• Used Control-M Tool to schedule shell scripts and Informatica jobs.
• Performed Unit, Grid Integration, testing and validate results with end users.

Environment: Informatica Power Center 9.1, Informatica Data Quality, Oracle 10g, SQL Server, SSIS 2013, SSRS 2012, PL/SQL, MS Visio, UNIX Solaris/AIX, WINSCP.

Confidential, Atlanta GA

Informatica Developer

Responsibilities:

• Developed Informatica mappings, reusable transformations. Developed and wrote procedures for getting the data from the Source systems to the Staging and to Data Warehouse system.
• Extensively used transformations to implement the business logic such as Sequence Generator, Normalizer, Expression, Filter, Router, Rank, Aggregator, Look Up (Target as well as Source), Update Strategy, Source Qualifier and Joiner, Designed complex mappings involving target load order and constraint based loading
• Create/build and run/schedule workflows and worklets using the Workflow Manager.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes. Coded database triggers, functions and stored procedures and written many SQL Queries.
• Helped coding shell scripts for various administration activities for daily backup. Involved in Physical schema implementation, objects like table-space, table rollback segments, Created database structures, objects and their modification as and when needed.
• Performance Tuning of the Informatica Mappings by adopting Explain plans, cutting down query costs using Oracle hints, changing the mapping designs.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Optimizing/Tuning mappings for better performance and efficiency, Creating and Running Batches and Sessions using the Workflow Manager, Extensively used UNIX Shell scripts for conditional execution of the workflows.
• Optimized the performance of Mappings, Workflows and Sessions by identifying and eliminating bottlenecks Performed Unit Testing at development level, Source code migration and documentation
• Managed users & roles for database security, Maintained system security, control and monitor user access to database.
• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Assigned predefined profiles and roles to the users to maintain database security, CPU activity, idle time and quota management on table-spaces

Environment: Informatica Power Center 8.6, SQL, MS SQL, Windows NT, SQL Server, SQL * Loader, UNIX shell scripting, Toad

Confidential

ETL Developer

Responsibilities:

• Involved in Software Requirement Analysis and Design Documents (SRD) and Requirement Traceability Matrix for each project workflow based on the information gathered.
• Work on the complete Software Development Life Cycle (SDLC) from Extraction, Transformation and Loading of large amount of data using Informatica.
• Use Informatica Designer, Workflow Manager and Repository Manager to create source, target definition and design mapping.
• Create Mappings using various transformations such as Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Stored procedure, Router and Normalizer etc to populate target tables.
• Used Parameters and Variables, Pre SQL/Post SQL, Pre session and post session commands, Emails in sessions.
• Develop workflow dependency in Informatica using Event Wait Task, Command Wait.
• Responsible for Performance Tuning at the Session Level and Mapping level for optimum performance.
• Extracted data from heterogeneous and homogeneous sources such as oracle, flat files, XML and Excel files.
• Work with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Defined Target Load Order Plan and to load data correctly into different Target Tables
• Translating business rules into stored procedures and functions using PL/SQL and import them into Informatica using stored procedure transformation.
• Develop Informatica mappings for Type 1, 2 Slowly Changing Dimensions.
• Wrote shell scripts to create file list for different kinds of flat files that included both delimited and fixed width files.
• Involved in generating reports using Business Objects for analysis.
• Used Standards for naming conventions and best practices for Informatica mapping development and Migration of Informatica mappings and workflows from dev to test, production and deployment groups.
• Troubleshoot issues and solve applications problems with Informatica Debugger, session log and workflow log.
• Developed UNIX shell scripts to automate the data transfer (FTP) process to and from the Source systems, to schedule weekly and monthly loads/jobs.
• Create effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.

Environment: Informatica Power Center 8.1, Oracle 8i, PL/SQL, UNIX Scripts, Microsoft Visio, SQL Plus and TOAD, Business objects XI.