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, Confidential, 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 with creating profiles, rules, scorecards for data profiling and quality using IDQ.
• Involved in cleaning the data using Informatica Data Quality.
• Strong knowledge of upgrading informatica power center and good experience of Informatica Administration.
• Sound knowledge 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 the ETL processes for various domains like HealthCare, Finance, Banking, Logistics and Insurance.
• Interacted with 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 the 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 the design of Multi-Dimensional Data Modeling (Star, Snow Flake schema) using Erwin 7.1/4.5.
• Proficient with RDBMS systems, SQL, Oracle PL / SQL, database design and optimizations
• Proficient in creating Oracle Function, Stored procedure, Package, Trigger and Materialized View and oracle partitioning .
• Excellent working knowledge of UNIX shell scripting, job scheduling on multiple platforms, experience with 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 knowledge of tracking work status, effort estimation, coordination with 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 with the proven ability to assimilate, research information to develop sound and ethical solutions; Detail-oriented, process-driven with excellent communications skills with the ability to work with 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, Confidential 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:

Confidential, Houston, TX

Senior Informatica ETL Developer

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 the developers.
• Developed Data Flow diagrams to create Mappings and Test plans.
• The Data flow diagrams ranged from OLTP systems to staging to Data warehouse.
• Developed Test plan to verify the logic of every Mapping in a Session. The 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.
• 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 the Informatica application. For debugging utilized Informatica debugger.
• Worked on Performance Tuning to optimize the Session performance by utilizing, Partitioning, Push down optimization, pre and post stored procedures to drop and build constraints.
• Identify users and see what level of familiarity they have with this data. Segment these users based on criteria like influence, authority and participation levels.
• Identifying automated decision-making possibilities.
• Worked on Confidential utilities BTEQ, MLOAD, FLAOD and TPUMP to load staging area.
• 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 the 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, Confidential, 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.

Confidential, Houston, Tx

Informatica ETL Developer

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 the several modifications, enhancement and maintenance of existing software.
• Build the Dimension & Facts tables load process and reporting process using Informatica.
• Consolidate sales order data using Informatica and loaded to aggregate tables for reporting.
• Coordinated with Onsite and Offshore team.
• Transfer the source code & setup file to outside conversion team for production movement and support. Coordinate with 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.
• Administered and developed monitoring scripts for power center server process and workflow jobs.
• Designed and developed enhanced data models and ETL applications to meet the 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 with DBA and developers during planning, analyzing, developing and testing phase of the project.
• Involved in Designing of Data Modeling for the Data warehouse.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
• Involved in the Performance Tuning of Database and Informatica. Improved performance by identifying and rectifying the 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.

Confidential, Jersey City, NJ

Informatica Developer

Responsibilities: -

• Designed and developed complex mappings using various transformations in Designer to extract the 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 the performance tuning of ETL procedures and processes.
• Error checking & testing of the 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 with help of IBM MQ Series.
• Performed administration tasks in development and test environments on IBM MQ Series V6.0.
• Any issues with the daily running jobs, find out the errors and fix them within time limit
• Mainly responsible for solving Informatica and Database Issues for different departments if ticket is opened.
• Any problem with the ETL codes, prime responsibility was to test in Integration Environment before loading in Production.
• Used Debugger utility of the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results for various tickets.
• Part of documenting and testing all the ETL connections at the time of migration from Old to New Confidential 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, Confidential V2R5, XML, TOAD, SQL, PL/SQL, UNIX Shell Scripts, Unix Solaris, Erwin 6.1, Remedy, AutoSys scheduler.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Collection of requirements from business users and analyzed based on the requirements.
• Extensively used flat files for Designed and developed complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications.
• Designed and developed complex mappings using various transformations in Designer to extract the data from sources like Oracle, SQL Server and flat files to perform mappings based on company requirements and load into Oracle tables.
• Well versed with creating and Altering Table, Triggers, Sequences, and other DDL, DML and DCL utilities of Oracle 9i and 10g.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Error checking & testing of the 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 the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results.
• Worked with tools like TOAD to write queries and generate the result.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings. Involving also in the functional and technical design document sessions with Technical team and business users team.
• Working on the Data Analyzer, Data Quality and data profiler tool for handling the business logic and exception logic from the inbound feeds and also the 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

Confidential, Chicago, IL

Informatica Developer

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 with 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) with user community.
• Extracted data from VSAM file and XML files.
• Involved in Data transfer from OLTP systems forming the extracted sources.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Analyzed the sources, transformed the data, mapped the data and loading the 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 the 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 the 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.