SUMMARY:

• Over 9+ years of experience in Information Technology in Analysis, Design and Development of software applications. Expertise in development of Data warehousing solutions using Informatica Power Center 7.x /6.x /5.x and Power Mart 7.1.1 /6.2 / 5. x, Power connect.
• Expertise in Implementation of Enterprise Data warehouses using Informatica Power Center 7.1.1/6.2.1 / 5. x and Power Mart 7.1.1/6.2.1 / 5. x, and Decision Stream
• Extensively worked on overall SDLC implementation that includes requirement gathering, development, testing, debugging and deployment as well as Documentation, Production Support.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Experience in real - time monitoring and alerting of applications deployed in AWS using Cloud Watch, Cloud Trail and Simple Notification Service.
• Implemented and maintained monitoring and alerting of production and corporate servers such as EC2 and storage such as S3 buckets using AWS Cloud Watch.
• Experience with Informatica MDM Multi-Domain and Informatica Data Director. Experienced in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Experience in Master Data Management (MDM) concepts and Informatica MDM tool -Informatica MDM by creating Base objects, staging tables, mappings, setting up strong match rules and creating IDD applications.
• Strong Hands on experience on Informatica Power center and Informatica Analyst tool and Informatica Data Quality (IDQ).
• Experience working with IDQ transformations like Labeller, Parser, Standardizer, Match, Exception, Merge and Association etc.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Extensive Knowledge on the development life cycle process from requirements gathering to deployment of code to production and good knowledge on the Dimensional modeling.
• Troubleshooting and problem solving applications with Informatica Debugger and performing codemigration from Dev to Test.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
• Extensive experience in UNIX (Korn, bash) Scripting and Perl Scripting
• Worked on Informatica B2B data Exchange MFT tool to exchange the files transfer from one vendor to other vendor with SSL authentication & PGP encryption & decryption process.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Proficient in Unix Shell Scripting and ETL process automation using Autosys Scheduler and TIDALScheduler.
• Experience at Enterprise-level ETL development and ETL architecture using Informatica and understanding the COBOL file structures.
• Experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files (Fixed width & Delimited), XML Files, COBOL files, Excel, Oracle, Sybase, MS SQL Server and Teradata.
• Worked on power exchange to create data maps, pull the data from mainframe, and transfer into staging area.
• Used web service consumer and provider transformations, power exchange for salesforce transformations.
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in UNIX Shell Scripting, windows batch scripting for applying data fixes and automation of ETL jobs.
• Experience working with advanced transformations like Java transformation, Web services transformation, Normalizer, xml sources and targets.
• Good knowledge in Power exchange for salesforce and loading data into salesforce environments through Informatica using BULK API.
• Good knowledge in Informatica cloud for performing Data synchronization, replications and transferring binary files across environments.
• Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x. Informatica Power Exchange, Informatica Power Mart, Informatica Data Quality, Informatica cloud, Informatica MDM

Data Bases: Teradata V2R6/12, Sybase 12.5, DB2 8.2, Oracle 11i/10g/9i/8i, SQL Server 2005/2000, MS-Access

Database Tools: Oracle Enterprise Manager, Quest TOAD, SQL*PLUS, SQL*Loader, SQL*Net, SQL Navigator Export/Import, Oracle Discoverer 10g

Programing Tools: C, C++, Java, SQL, PL/SQL, T-SQL, Shell scripting, Perl

Web Technologies: HTML, CSS, XML

Other tools: MS-Word, Excel, PowerPoint 2003/2007.

Operating System: Unix, Windows 95/98/NT/2000/XP/7/8

PROFESSIONAL EXPERIENCE:

Confidential, Portland, OR

Sr. Informatica MDM Developer

Responsibilities:

• Design and Development of ETL routines, using Informatica Power Center 9.5.1 Within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Maplets, connected and unconnected Lookups, and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done also designed and reported using power connect informatica from external systems like SAP,DB2.
• Used UNIX Shell scripting for automation of the process, invoking PL/SQL procedures, andInformatica sessions.
• Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions.
• Preparation of technical specification for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards
• Participated in the Design Meetings, and prepared technical and mapping documentation.
• Involved in the preparation of High level design documents and Low level design documents.
• Modified the shell/Perl scripts as per the business requirements.
• Responsible for writing shell script to call migration logics using Pre ETL-Command and Post ETL Command and Perl Scripting command working with File and File Transfer.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
• Involved in loading of data into Teradata from legacy systems and flat files using complex MLOAD scripts and Fast Load.
• Extracted data from Oracle database transformed and loaded into Teradata database according to the specifications.
• Using AWS Cloud Watch performed Monitoring, customized metrics and file logging.
• Used AWS SDK for connection to Amazon S3 buckets as it is used as the object storage service to store and retrieve the media files related to the application.
• Implemented AWS client API to interact with different services as Console configuration for AWSEC2.
• Used Informatica B2B data transformation to read unstructured and semi structured data and load them to the target.
• Used the Informatica B2B Transformation to integrate the semi structured data and transformed into Usable format.
• Create MDM mappings using IHA best practices to capture the errors and have a clean load using Informatica power center.
• Performed unit testing in all stages of MDM and ETL from where data releases.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Involved in match/merge and match rules to check the effectiveness of MDM process on data.
• Involved in enhancement for the COBOL coding and promoting the code in to the production systems.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
• Using Ralph Kimball approach individual data marts were developed to provide 360 degree views into organizational data.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Developing ETL mappings and workflows to implement the business logics for standardizing the data.
• Involved in developing PL/SQL procedures and Shell scripts.
• Performing code review, formal testing, optional testing, and specification review using Test Director.
• Performing unit testing, Integration testing and quality checks.
• Responsible for the documentations of the different processes carried out like design documents and mapping documents, share point for the version control of the documents and star team for the version control of source code for all the interfaces in the Interface Project.
• Documented Design Documents and Unit Test plans for Informatica mappings, design and validation rules.
• Documenting mappings, sessions, workflows and procedure related information.
• Involved in performance tuning by following best practices.
• Providing Knowledge share to production teams on new developments (workflows/jobs).

Environment: Informatica Power Center 9.1, Informatica Power Exchange, Oracle 9i, SQL, PL/SQL, SQL*Plus, Sybase, XML files, Sun Solaris 5.8, Windows NT/2000, TOAD 7.0, PL/SQL Developer, Cobol, Crystal Reports XI, MS Excel, Autosys, Perl, Informatica B2B, AWS, Unix Shell Scripting, Import Wizard, Central Management Console, Info View, True Task Scheduler, Tidal Scheduler, Informatica MDM, SQL Server Management Studio, IDQ 9.5.1, SQL server 2008R2, Infohub, HTML, JavaScript.

Confidential, Farmington, CT

Informatica Developer

Responsibilities:

• Worked with Data Architects and Business Analysts to understand the data flow, existing logic and creation of Business Requirement Documents on the business logic involved in creation of feeds.
• Performed multiple roles such as building extensible, robust, maintainable systems participating in all stages of Software development life cycle using Agile Scrum/ Kanban.
• Created technical specification for the development of Informatica extraction, transformation and loading (ETL) mappings in order to load data into classified tables in DATA Marts and defined ETL standards.
• Optimized mappings, sessions/tasks, source, and target databases as a part of performance tuning.
• Extensively involved in Recovery process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.
• Create Datamaps using Power Exchange 9.5.1.
• Build servers using AWS, Importing volumes, launching EC2, RDS, creating security groups, auto-scaling, load balancers (ELBs) in the defined virtual private connection.
• Installed, deployed and upgraded AWS Cloud- based servers and services in accordance with project guidelines.
• Provided support on AWS application provisioning and maintenance tasks, AMI upgrades, and database snapshots.
• Apply Hotfix and Service Packs to Informatica Power Center/Power Exchange.
• Involved in monitoring the sessions, workflows and worklets using Workflow Monitor to ensure the data is properly loaded into the Enterprise Data Warehouse.
• Maintained the batch processes using Unix Shell Scripts.
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Engaged in designing and developing test cases, error control routines, data validation, load processes, audit and log controls using PL/SQL, SQL.
• Source data was extracted from Oracle, SQL Server, flat files, COBOL sources.
• Worked with business SMEs on developing the business rules for cleansing. Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Analyzed the data based on requirements, wrote down the techno-functional documentations and developed complex mappings using Informatica Data Quality (IDQ).
• Modified the existing COBOL, JCL to include new functionality as per the business rules.
• Involved in writing Teradata SQL bulk programs and in Performance tuning activities for Teradata SQL statements using Teradata EXPLAIN.
• Used External Loaders like Multi Load, T Pump and Fast Load to load data into Teradata database.
• Worked extensively on Source Analyzer, Mapping designer, Warehouse Designer.
• Schedule, Run and monitor sessions by using Informatica Server Manager .
• Configured and used secured FTP by the Informatica Server to access source and target files.
• Installed and Configured Informatica MDM 9.7 Hub server, process server and Resource Kit.
• Created PostLoad, PostMerge and PostUnMerge user exits to customize MDM Hub functionality.
• Worked with PowerCenter team to load data from external source systems to MDM hub.
• Developing ETL mappings and workflows to implement the business logics for standardizing the data.
• Developed and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Worked on Repository manager to create and manage user profiles, and used Repository manager extensively to migrate the code from dev to production and compared both codes.
• Created, launched & scheduled sessions. Involved in the Performance Tuning of Database and Informatica.
• Migration of code between the Environments and maintaining the code backups.
• Involved in writing SQL Stored procedures and Shell Scripts to access data from Oracle, MS SQL Server 7.0.
• Involved in developing PL/SQL procedures and Shell scripts
• Performing unit testing, Integration testing and quality checks.
• Involved in communications with client and Business analysts for gathering requirements.
• Involved in performance tuning by following best practices.
• Scheduling the scripts using Tidal Scheduler.
• Worked with production support in finalizing scheduling of workflows and database scripts using Tidal Scheduler.

Environment: Informatica5.2/6.2, ORACLE 8i/9i, UNIX, Windows NT 4.0, Informatica B2B, UNIX Shell Programming, PL/SQL, IDQ 9.6.1, Business Objects 4.7, TOAD Quest Software, Tidal Scheduler, AWS Cloud, Business Objects XI R3.1/RI 2.0, Web Intelligence, Cognos, Cobol, Designer, Data Mapping, Business View Manager, Desktop Intelligence Crystal Reports, MS Excel, Informatica MDM, Perl, Live Office, Import Wizard, Central Management Console, Info View, ORACLE 10g

Confidential, Wilmington, DE

ETL Developer

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Involved in Extraction, Transformation and Loading (ETL) of data by using Informatica PowerCenter 6.2 / 7.1.1.
• Extracted source data from flat files, XML, Teradata, Oracle and loaded to a relational warehouse.
• Using InformaticaPowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools.
• Used MDM Services Integration Framework to demonstrate how to access, update, or distribute data stored in an Informatica MDM Hub using web services.
• Performed land process to load data into landing tables of MDM Hub using external batch processing for initial data load in hub store.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Created Cronjobs and Maestro scripts for automation of ETL processes.
• Tuned the Informatica mappings for optimal load performance.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Involved in scheduling the workflows through Autosys Job scheduler using UNIX scripts.
• Scheduled Informatica Jobs through Autosys scheduling tools.
• Have generated reports using OBIEE 10.1.3 for the future business utilities.
• This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Environment: InformaticaPowerCenter, Designer 8.6/8.1, Informatica Repository Manager, Oracle10g/9iDB2 6.1, Erwin, BTEQ, FLOAD, MLOAD, OBIEE, UNIX, Shell, Teradara, Informatica MDM, Autosys, TOAD,Unix- SunOS, PL/SQL, SQL.

Confidential, Miami, FL

Informatica Developer

Responsibilities:

• Interacted with Business Analysts to translate Business requirements into technical specifications.
• Involved in Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center 6.2.
• Extracted source data from Sybase, flat files, XML, Teradata, oracle, IMS and VSAM and loaded to a relational warehouse.
• Used Informatica B2B data transformation to read unstructured and semi structured data and load them to the target.
• The translation of formats was done using Data Transformation and the data logging for the transformation/translation info was done using B2B Data Exchange using DX transformations inInformatica Power Center.
• Implemented SCD methodology including Type 1, Type 2 and Type 3 changes to keep track of historical data.
• Involved in creations of transaction level snapshots, periodic snapshots and Accumulated Snapshots.
• Implemented Aggregate, Sorter, Router, Filter, Joiner, Expression, Lookup and Update Strategy, Normalizer, Sequence generator transformations.
• Used shortcuts (Global/Local) to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Used the Workflow manager to create workflows, worklets and tasks.
• Implemented pipeline partioning concepts like hash-key, round robin, key-range, pass-through techniques in mapping transformations.
• Created UNIX shell scripting and automation of ETL processes using Crontab.
• Involved in performance tuning of targets, sources, mappings, and sessions.
• Created post-session and pre-session shell scripts and mail-notifications.
• Used pmcmd, pmrepagent and pmrepserver in non-windows environment.
• Used debugger to test the mapping and fixed the bugs.
• Worked closely with DBA in performance tuning of queries using ANALYZE Tables and SQL Trace.
• Documented Informatica mappings, design and validation rules.
• Involved in design of logical and physical data models using ERWin.
• Generated simple list reports, Grouped list, cross tab, grouped cross tab reports using CognosImpromtu and Power Play.
• Created Multi-Dimensional cubes using Power Play Transformer.

Environment: Informatica Power Center 6.2, Cognos Impromptu 7.2, Power Play, Transformer, Oracle 8i, MS SQL Server 2000, Sybase, B2B Data Transformation, Teradata V2R4, XML, IMS, VSAM, SQL Plus, PL/SQL, MS Visio 2002, Toad 7.0, SCO Unix 5.0.5, Windows 2000.

Confidential

Data Warehouse Developer

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
• Involved in System Analysis and worked on Design, Coding and implementation.
• Written many routines (as functions), which were called from other procedures.
• Developed user interface screens, master detail relations and Reporting screens.
• Developed various Reports for the end users as per their requirements and created many report to suit preprinted format of the company.
• Designed and developed different reports and forms.
• Wrote stored procedures, Functions and Database triggers using PL/SQL.

Environment: Informatica Power Center 7.1, Erwin 4.5, Oracle 9i, Windows NT, Flat files, SQL