TECHNICAL SKILLS:

Operating System: UNIX, IBM AIX 4.3/4.2, Windows7/NT/2000/XP

Database and utilities: Oracle 9i/10g/11g, MS SQLServer, Teradata V2R6, 12.0, 13.0 Teradata SQL Assistant, BTEQ, Sybase, Erwin 3.5/4.0, IBM DB2, Business Objects.

Informatica Tools: Informatica PowerCenter 9.6/9.5/8.6/8.1/7.1, Informatica B2BDT,Power exchange, Informatica Data Analyzer.

Database Tools: SQL developer, TOAD

Programming Languages: SQL, PL/SQL, TSQL, Unix Shell Scripting, XML, C, C++, C#, Cobol, JavaScript,NZSQLOther Tools: WLM, Autosys, Control - M, Crystal Reports,OBIEE, Tableau,Rational Clear Case, Rational Clear Quest, Tivoli.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Snr. ETL developer

Responsibilities:

• Experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Oracle 10g/11g, Teradata, DB2, Flat files, CSV files and Microsoft SQL Server into Oracle target Data Warehouse.
• Designed, configured and deliveredMDMhubs across multiple data domains (Customer, Product, Vendor.
• Preparing Low Level Requirements documents as well as High level/detailed level design documents for Data warehouse modelling and ETL processes.
• Created STM mapping as per the requirements of the Technical specification documents.
• Estimates and planning of development work using Agile Software Development.
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
• Extracted data from Facets data model in Oracle using PLSQL and SQL Server then used Teradata for data warehousing.
• Wrote UNIX shell Scripts &PMCMD commands for invoke workflows and FTP of files from remote server and backup of repository and folder.
• Performed unit testing for the Informatica mappings and UNIX scripts developed, Created and executed unit test plans based on system and validation requirements and Assisted Testing team in creating test plan and test cases.
• Optimizing Performance Tuning at source, target, mapping and session level
• Participated in weekly status meetings and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment:InformaticaPowerCenter9.6/9.5, Oracle12c/11g, IBM DB2, Teradata SQL,IBM DtataStudio, SQL Developer,SQL, Erwin, PL/SQL (Stored Procedures, Triggers, Packages), UNIX shell Scripting, Linux, Windows 10

Confidential, Pittsburg, KS

Role:Informatica Developer

Responsibilities:

• Involved in database development by creating Oracle PL/SQL Functions, Stored Procedures, Triggers, and Packages
• Working on multiple projects using Informatica as ETL tool to extract data from IBM DB2, Oracle11and flat file systems performed massive data cleansing applied all the business rules and loaded into Target system.
• Worked with Business Users and Business Analyst for requirement gathering and business analysis.
• Extensively worked with Data Analyst and Data Modeler to design and to understand the structures of the Fact and Dimension tables and Source to Target Mapping.
• Used IDQ analyst tool to correct the bad table records, reprocessed the records in Analyst.
• Created custom reports using various tools including Crystal Reports.
• Developed complex Informatica mappings, Mapplets using connected and unconnected Lookups, Rank, Sorter, Joiner, Aggregator, Filter, Router, Sequence generator and Stored Procedure transformations to transform the data as per the client requirements.
• Implemented Slowly Changing Dimensions Type-1, Type-2 and Type-3 approach for loading the target tables.
• Implemented complex business rules by creating Re-Usable Transformations, Mappings, Mapplets,Sessions, Tasks, Workflows, Parameter Variables and Workflow Variables. Designed various tasks using Informatica workflow manager like session, command, email, event raise, event wait etc.
• Prepared release notes to build DEV, SIT, UAT, PERF and PROD environments and handed them over to Integration and UNIX teams.
• Enhanced the code as per requirement changes and resolved the Production issues.
• Used Unix Command and Unix Shell Scripting to interact with the server and to move flat files and to load the files in the server. Used PMCMD commands in pre and post session to populate the parameter files and to execute the tasks.
• Worked extensively on shell scripting to prepare wrappers and JIL files to schedule the jobs using Autosys.

Environment:Informatica PowerCenter 9.6, IDQ 9.6, Informatica Analyst Tool, Oracle Data Integrator, Flat file, TOAD, UNIX scripting, Windows XP Professional, Hyperion, Microsoft DTS packages

Confidential, Chicago, IL

Sr.Informatica Developer

Responsibilities:

• Involved in gathering and reviewing business requirements. Involved in designing the specifications, Design Documents, Data modeling and design of data warehouse.
• Analyzing the technical documentation and concluding the design of the ETL loads.
• Extracting the data from the Relational Databases, Flat files using ETL process.
• Interacted with the Business Users&Enterprise Data Architects in the analysis & design of conceptual and logical data model that is required for solid MDM implementation & ensuring that it meets the business requirements and supports the products capabilities.
• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Worked extensively on different types of Transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, and sequence generator, joiner Transformation.
• Worked on Performance tuning of the ETL processes. Optimized/tuned queries in source qualifier, Lookup transformations in mappings for better performance and efficiency.
• Used Informatica Repository Manager to backup and migrate Repository in development, test and production systems.
• Administered & scheduled batches/sessions using server manager. Modify/Migrate the Informatica mappings (XML) from the Development to Test Server and Production server.
• Created sessions, database connections and batches, Scheduled and monitored transformation processes using Informatica Server Manager.
• Worked on all phases of data warehouse development life-cycle, ETL design and implementation, and support of new and existing applications.
• Resolving performance issues by understanding the Bottles necks at various levels and tuning them for better performance.
• Creating project plans, design and development Building a data model according to business needs by interacting with data architect.
• Setting up sessions to schedule the loads at required frequency using Power Center, Workflow manager, PMCMD and using scheduling tools.

Environment:InformaticaMDM 9.5.0,InformaticaMDM Data Director 9.1.0,InformaticaData Quality (IDQ) 9.5.0,InformaticaPower Center 9.1.0, AQT 9.0, Erwin, JBoss, HP Quality Center 9.2, Windows.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Used update strategy to effectively migrate data from source to target.
• Designed ETL Process using Informatica to load data from Oracle, Flat Files to target Oracle Data Warehouse.
• Interacted with the business community and database administrators to identify the Business requirements and data realties.
• Created various Transformations as per the business logic like Source Qualifier, Normalizer, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression and Update Strategy.
• Wrote stored procedures, functions, Packages and used in many Forms and Reports.
• Wrote database triggers for automatic updating the tables and views.
• Involved in the Performance Improvement project.
• Involved in designing of Testing plan (Unit Testing and System Testing).
• Tested scripts by running workflows and assisted in debugging the failed sessions.
• Improving Workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.
• Used persistent caches whenever data from workflows were to be retained.
• Used Connected and Unconnected lookups whenever appropriate, along with the use of appropriate caches.
• Perform Maintenance, including managing Space, Remove Bad Files, Remove Cache Files and monitoring services.
• Set up Permissions for Groups and Users in all Development Environments.
• Involved in the team meetings and providing status report to project manager.

Environment:InformaticaPower Center 8.6.1/9.0.1, Oracle 10g, Flat Files, OBIEE, PL/SQL, UNIX, Autosys, ERWIN, TOAD, UNIX Shell Scripting.

Confidential

Informatica/ SQL Developer

Responsibilities:

• Extensive user interface to gather requirements and perform business analysis.
• Extensively worked with Transformations like Aggregate, Joiner, Lookup, Rank, Sorter, Sequence generator, Union, Filter, Router, Update Strategy.
• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
• Participated in converting requirements to detailed design.
• Profiled source systems to identify Data gaps and Data quality.
• Created technical specifications for all mappings and interfaces.
• Unit Testing of mapping/sessions and batches.
• Analyzed the source systems to create a road map for the ETL process.
• Designed and developed the Informatica Mappings for source system data extraction; data staging, transformation, validation, and error handling.
• Designed testing procedures and test plans for mappings, workflows, and interfaces.
• Developed schedule processing scripts using Autosys scheduler.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Extensive work on Informatica stored procedure for business requirement.
• Managed Change control implementation and coordinating daily, monthly releases and reruns.
• Performance Tuning of the process at the mapping level, session level, source level, and the target level.
• Extensively used Mapplets for use in mappings thereby saving valuable design time and effort.
• Extensively worked with various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
• Involved in Scheduling the Informatica sessions using the workflow manager to automate the loading process, import and export data from Production to development box for testing.
• Worked extensively with the business Intelligence Team to incorporate any changes that they need in the delivered files

Environment: Informatica Power Center 8.6/9.0.1/, Business Objects, UNIX, SQL, PL/SQL, TOAD v11.6/ v12.0, Oracle 10g.

Confidential

Jr. ETL Informatica/ Database Developer

Responsibilities:

• Creating the Mappings and involved in Extraction, Transformations and Loading.
• Worked on Informatica Source Analyzer, Mapping Designer and used various Transformations such as the Source Qualifier, Aggregators, Lookup, Update strategy, Router, Filters & Sequence Generator, and Joiner.
• Creating and testing sessions.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, DB2 and Flat Files.
• Provided solution the Data Quality and Data Cleansing tracks for the MDM project.
• Extensive Use of SQL Overrides and substituted them in place of multiple transformations.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Worked on identifying Mapping Bottlenecks and improved session performance through error handling.
• Worked on Mapplets and created parameter files wherever necessary to facilitate reusability.
• Created Unix Shell Scripts to automate sessions and cleansing the source data.
• Used transformations for data joins, complex aggregations.
• Responsible for Improving Query and session performance.
• Created complex mappings using Lookup, Aggregator and Router transformations for populating target table in efficient manner
• Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Sequence generator and joiner transformations.
• Createdlaunched & scheduled sessions and batches using Server manager.
• Define mappings slowly changing dimensions(SCD Type), and slowly growing Targets.

  Environment:Informatica Power Center 8.6.1, Oracle 9i, PL/SQL, DB2, Win NT, UNIX, Flat Files, SQL loader, MDM, Unix shell Scripting, Putty and WinSCP.