SUMMARY:

• Around 10+ years of IT experience in all phases of Software Development Life Cycle (analysis, design, development, test, implementation and support).
• 9+ years of experience in Data Warehousing using ETL and OLAP tools Informatica PowerCenter 9.6/9.5/9.1/8.6 /8.5/8.1, Informatica PowerExchange 9.6/9.5/9.1/8.6, Informatica Data Quality(IDQ), Oracle 11g/10g, Teradata, SQL Server, DB2, Unix, Unix shell Script, IBM MQ Series.
• Extensively worked in Extraction Transformation Loading (ETL) process using Informatica 9.x/8.x/7.x, Informatica Data Quality (IDQ) 9.x, Informatica Big Data Edition (BDE) 9.x and developing user - centric data models, queries.
• Worked on Data Profiling using IDQ-Informatica Data Quality to examine different patterns of source data. Proficient in developing Informatica IDQ transformations like Parser, Classifier, Standardizer and Decision.
• Experience wif creating profiles, rules, scorecards for data profiling and quality using IDQ.
• Involved in cleaning teh data using Informatica Data Quality.
• Strong noledge of upgrading informatica power center and good experience of Informatica Administration.
• Sound noledge of Relational and Dimensional modeling techniques of Data warehouse (EDS/Data marts) concepts and principles (Kimball/Inmon) - Star, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization and facts and dimension.
• Designed and Developed teh ETL processes for various domains like HealthCare, Finance, Banking, Logistics and Insurance.
• Interacted wif end-users and functional analysts to identify and develop Business Specification Documents (BSD) and transform it into technical requirements.
• Created DQ Scorecards both on Profile and Physical Data Objects (PDO).
• Optimized teh Solution using various performance tuning methods (SQL tuning, ETL tuning (i.e. optimal configuration of transformations, Targets, Sources, Mappings and Sessions), Database tuning using Hints, indexes, partitioning, Materialized Views, External Table, Procedures, functions).
• Involved in teh design of Multi-Dimensional Data Modeling (Star, Snow Flake schema) using Erwin 7.1/4.5.
• Proficiency in data warehousing techniques for Staging area design, data cleansing, error handling, audit login, surrogate key assignment and real-time change data capture (CDC).
• Proficient wif RDBMS systems, SQL, Oracle PL/SQL, database design and optimizations
• Skilled in Data warehousing, Scripting and Data Modeling wif 9 years’ experience in dealing wif various Data sources like Oracle, SQL Server, MS-Access, Teradata, MQ Series and DB2.
• Proficient in creating Oracle Function, Stored procedure, Package, Trigger and Materialized View and oracle partitioning.
• Excellent working noledge of UNIX shell scripting, job scheduling on multiple platforms, experience wif UNIX command line and LINUX.
• Worked on scheduler tool Control-M and Auto Sys to create job for ETL workflows.
• Worked on Production support L2 and L3, Onsite-offshore model and on call support.
• Excellent working noledge of tracking work status, effort estimation, coordination wif various team, reporting and resolving prod issues, creating prod process and run book.
• Created various connectors for Informatica Cloud to extract and load data.
• Developed and Implemented Error logging, Error handing and Error resolution process in many projects.
• Strong organizational, problem solving and decision-making skills wif teh proven ability to assimilate, research information to develop sound and ethical solutions; Detail-oriented, process-driven wif excellent communications skills wif teh ability to work wif and influence colleagues and customers at all levels;

TECHNICAL SKILLS:

Data warehousing ETL Tool: Informatic Power Center 9.6/9.5/9.1/8.6 /8.5/8.1, Informatica Power Exchange 9/6/9.5/9.1/8.6, Erwin 8/7.5/4.0, Informatica Data Quality(IDQ) 9.6

Big Data: Hadoop, Map Reduce, HDFS, HBase, Zookeeper, Hive, Spark, Pig, Sqoop Cassandra, Oozie, Flume.

BI Reporting Tools: WEBFOCUS

Databases: Oracle 11g/10g/9i, Sybase, Teradata 13/12/V2R6, MS-Access, DB2 8.0/7.0, Sybase, Nateza

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

Operating System: HP-UX 11/10/9,IBM-AIX6.1/5.3, Sun Solaris 9/8/7, SCO-UNIX, LINUX, Windows XP Professional/95/98/2000/XP/2010/Vista/Windows 8,CentOS

Other Tools: MS Visual Source Safe, PVCS, Autosys, Control M, uni center, Remedy, Clarity, Planview

DB Tools: SQL*Plus, SQL*Loader, Export/Import, TOAD, SQL Navigator, SQL Trace, MLOAD, FLOAD, FEXPORT, TPUMP

Microsoft Tools: MS Office, MS Front Page, MS Outlook, MS Project. MS Visio

Development: Object-Oriented Design, Technical Documentation, Agile Development, Quality Assurance, Solution Architecture, Project Management

Middleware Tool: IBM MQ Series 5.3/6.0

PROFESSIONAL EXPERIENCE:

Sr Informatica Developer

Confidential, Houston, TX

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Converted business requirements into technical documents - BRD, explained business requirements in terms of technology to teh developers.
• Developed Data Flow diagrams to create Mappings and Test plans.
• Teh Data flow diagrams ranged from OLTP systems to staging to Data warehouse.
• Developed Test plan to verify teh logic of every Mapping in a Session. Teh test plans included counts verification, look up hits, transformation of each element of data, filters, and aggregation and target counts.
• Developed complex Informatica mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
• Successfully loaded files to Hive and HDFS from MYSQL for ETL operation.
• Worked on Data Profiling using IDQ-Informatica Data Quality to examine different patterns of source data. Proficient in developing Informatica IDQ.
• Global Address Verification experience in IDQ.
• Extensively used Informatica Address Doctor for global address verification by standardizing global address data for Different countries like USA, Canada.
• Used Different transformations like Standardizer, Address Validator, Match, Association, Parser, Weighted Average.
• Extensively used SCD’s (Slowly Changing Dimension) to handle teh Incremental Loading for Dimension tables, Fact tables.
• Designed various mappings for extracting data from various sources involving Flat files, Oracle, Sybase and SQL Server, IBM DB2, Nateza.
• Worked on Informatica cloud and extracted data from Sales Force source.
• Worked on Debugging and Troubleshooting of teh Informatica application. For debugging utilized Informatica debugger.
• Worked on Performance Tuning to optimize teh Session performance by utilizing, Partitioning, Push down optimization, pre and post stored procedures to drop and build constraints.
• Identify users and see wat level of familiarity they has wif this data. Segment these users based on criteria like influence, authority and participation levels.
• Identifying automated decision-making possibilities.
• Worked on Teradata utilities BTEQ, MLOAD, FLAOD and TPUMP to load staging area.
• Worked on Audit login, Error login and check while loading data to Data warehouse.
• Created Unix Script for ETL jobs, session log cleanup and dynamic parameter.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor and Schedular alert editor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Wrote Unix scripts, Perl scripts for teh business needs. Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process.

Environment: Informatica PowerCenter 9.6/9.5/9.1, Informatica PowerExchange 9.6/9.5/9.1, Informatica IDQ, Oracle10g, Teradata, MSSQL Server 2008 R2, T-SQL, Erwin 8, SQL Server 2008, TOAD, PL/SQL Developer, Linux, Tidal, Shell Scripting, Perl Scripting, DB2 Mainframe, Salesforce, Nateza.

Sr Informatica Developer

Confidential, Houston, Tx

Responsibilities:

• Involved in Requirement Gathering and Business Analysis and created tech specs for ETL process.
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Setup folders, groups, users, and permissions and performed Repository administration using Repository Manager.
• Design, development and implementation. It includes teh several modifications, enhancement and maintenance of existing software.
• Build teh Dimension & Facts tables load process and reporting process using Informatica.
• Consolidate sales order data using Informatica and loaded to aggregate tables for reporting.
• Coordinated wif Onsite and Offshore team.
• Transfer teh source code & setup file to outside conversion team for production movement and support. Coordinate wif vendor, business, developers & tester for UAT and system testing.
• Developed various complex Mapplets and Stored procedure to facilitate loading of data on weekly and monthly basis.
• Worked on Various transformations such as Joiner, Filter, Update Strategy, Expression, Router, Lookup, Union, and Aggregator.
• Administered and developed monitoring scripts for power center server process and workflow jobs.
• Designed and developed enhanced data models and ETL applications to meet teh business requirement.
• Used Informatica Power Connect to extract data from third party databases, web services and XML.
• Mapping type 1 & type 2 Slowly Changing Dimension (SCD) using Informatica.
• Timely delivery of ETL tasks is performed using workflow manager and scheduler.
• Worked closely wif DBA and developers during planning, analyzing, developing and testing phase of teh project.
• Involved in Designing of Data Modeling for teh Data warehouse.
• Involved in teh performance tuning of teh Informatica mappings and stored procedures and teh sequel queries inside teh source qualifier.
• Involved in teh Performance Tuning of Database and Informatica. Improved performance by identifying and rectifying teh performance bottle necks.
• Involved in user acceptance testing. Defect reporting & tracking in Jira and resolved them.
• Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.

Environment: Informatica Power Center 9., Informatica PowerExchange 9.1 MS OFFICE/VISIO 2007, Oracle Exadata, DB2 Mainframe, UNIX Solaris, Rally, MS Series, Web Services, Java, Tidal, Putty, Basecamp, Erwin 7.5, PL/SQL, Nateza.

Informatica Developer

Confidential

Responsibilities:

• Designed and developed complex mappings using various transformations in Designer to extract teh data from sources like Oracle, SQL Server and flat files to perform mappings based on company requirements and load into Oracle tables.
• Extensively worked on various source like flat files, Databases, XML and Web services.
• Created and altered Tables, Triggers, Sequences, and other DDL, DML, DCL and utilities of Oracle.
• Extensively worked in teh performance tuning of ETL procedures and processes.
• Error checking & testing of teh ETL procedures & programs using Informatica and Oracle procedures.
• Performance Tuned Informatica Targets, Sources, mappings & sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval.
• Developed UNIX shell scripts to automate applications, Schedule jobs, develop interfaces and Created pre-session and post-session shell scripts and mail-notifications.
• Responsible for production support.
• Created Queue Manager, Channel, Queue wif help of IBM MQ Series.
• Performed administration tasks in development and test environments on IBM MQ Series V6.0.
• Any issues wif teh daily running jobs, find out teh errors and fix them wifin time limit
• Mainly responsible for solving Informatica and Database Issues for different departments if ticket is opened.
• Any problem wif teh ETL codes, prime responsibility was to test in Integration Environment before loading in Production.
• Used Debugger utility of teh Designer tool to check teh errors in teh mapping and made appropriate changes in teh mappings to generate teh required results for various tickets.
• Part of documenting and testing all teh ETL connections at teh time of migration from Old to New Teradata box.
• Used FTP on a few occasions to solve complex supply chain problems.
• Created Oracle Stored Procedure, Function, Cursor, Package and Triggers.
• Wrote Analytical queries to generate report, designed normal and materialized View.
• Optimized mappings having transformation features like Aggregator, filter, Joiner, Expression and Lookups
• Created daily and weekly workflows and scheduled to run based on business needs

Environment: Informatica PowerCenter 9.1/8.6, Informatica PowerExchange 9.1/8.6, Oracle 10g, Teradata V2R5, XML, TOAD, SQL, PL/SQL, UNIX Shell Scripts, Unix Solaris, Erwin 6.1, Remedy, AutoSys scheduler.

Informatica Developer

Confidential, Chicago, IL

Responsibilities:

• Collection of requirements from business users and analyzed based on teh requirements.
• Extensively used flat files for Designed and developed complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of teh data between various applications.
• Designed and developed complex mappings using various transformations in Designer to extract teh data from sources like Oracle, SQL Server and flat files to perform mappings based on company requirements and load into Oracle tables.
• Well versed wif creating and Altering Table, Triggers, Sequences, and other DDL, DML and DCL utilities of Oracle 9i and 10g.
• Extensively worked in teh performance tuning of programs, ETL procedures and processes.
• Error checking & testing of teh ETL procedures & programs using Informatica session log.
• Performance Tuned Informatica Targets, Sources, mappings & sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval.
• Developed UNIX shell scripts to automate applications, Schedule jobs, develop interfaces and Created pre-session and post-session shell scripts and mail-notifications.
• Performed error handling for removing database exceptional errors.
• Used Debugger utility of teh Designer tool to check teh errors in teh mapping and made appropriate changes in teh mappings to generate teh required results.
• Worked wif tools like TOAD to write queries and generate teh result.
• Provided Knowledge Transfer to teh end users and created extensive documentation on teh design, development, implementation, daily loads and process flow of teh Informatica mappings. Involving also in teh functional and technical design document sessions wif Technical team and business users team.
• Working on teh Data Analyzer, Data Quality and data profiler tool for handling teh business logic and exception logic from teh inbound feeds and also teh outbound feeds.

Environment: Informatica PowerCenter 8.1, DB2 Mainframe, ORACLE 10g, UNIX, Windows NT 4.0, UNIX Shell Programming, PL/SQL, TOAD, Putty, WinScp, Remedy MQ Series V6.0

Informatica developer

Confidential, Chicago, IL

Responsibilities:

• Developed complex mappings to extract source data from heterogeneous databases SQL Server Oracle and flat files, applied proper transformation rules and loaded in to Data Warehouse.
• Involved in identifying bugs in existing mappings by analyzing data flow, evaluating transformations using Debugger.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Worked closely wif Production Control team to schedule shell scripts, Informatica workflows and PL/SQL code in Autosys.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures etc.
• Defects were tracked, reviewed and analyzed.
• Conducted UAT (User Acceptance Testing) wif user community.
• Extracted data from VSAM file and XML files.
• Involved in Data transfer from OLTP systems forming teh extracted sources.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of teh system.
• Analyzed teh sources, transformed teh data, mapped teh data and loading teh data into targets using Power Center Designer.
• Designed and developed Oracle PL/SQL Procedures.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Participated in teh design of Star & Snowflake schema data model.
• Performed administration tasks in development and test environments on MQ V5.3/6.0.
• Setup naming standards for teh Queue managers, Queues and Channels.

Environment: Informatica PowerCenter 8.1, Oracle 10g, SQL Server 2000, Erwin 3.5, XML, TOAD, Unix Solaris, DB2, IBM MQ Series 5.3/6.0.