SUMMARY:

• 9+ years IT experience in Design, Development, Maintenance, Enhancements and Production Support of which includes D Confidential warehousing and Legacy applications using ETL tools like Informatica.
• Experienced using MapReduce, and "Bigd Confidential " work on Hadoop and other NO SQL platforms.
• Experienced working extensively on the Master D Confidential Management(MDM) and application used for MDM.
• Proficiency in requirement gathering and d Confidential modeling including design and support of various applications in OLTP, D Confidential Warehousing, OLAP and ETL Environment
• Created and managed Source to Target mapping documents for all Facts and Dimension tables
• Experience in developing ETL mappings using Informatica PowerCenter, Designer (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Repository Manager, Workflow Manager and Workflow Monitor.
• Experience in creating various mappings using Informatica Designer and tasks using workflow manager to apply business logics and move to d Confidential from multiple sources into targets.
• Demonstrated expertise in utilizing ETL tools Informatica power center and Power Exchange 8x/9x/ for developing the D Confidential warehouse loads as per client requirement.
• Experience in MDM Hub configurations - D Confidential modeling, D Confidential Mappings, D Confidential validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica D Confidential Director.
• Experienced in how to use high-level d Confidential processing tools like Pig, Hive, andSparkwork with HadoopExcellent skills in fine tuning the ETL mappings in Informatica..
• Excellent understanding of Terad Confidential MPP architecture such as Shared Nothing, Nodes, AMPs, BYNET, Partitioning, Primary Indexes etc. and in Depth understanding and usage of TERAD Confidential OLAP functions, proficient in TERAD Confidential SQL, Stored Procedures, Macros, Views, Indexes (Primary, Secondary, PPI, Join indexes etc.)
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.
• Expertise in developing UNIX shell scripts and used BTEQ, FastLoad, MultiLoad, Tpump, TPT, D Confidential Mover and Fast Export utilities extensively to load to target d Confidential base.
• D Confidential base experience using Oracle12c/11g/10g,MS SQL Server 2000 and MS Access.
• Experience inTableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7 and Tableau 8.
• Extensively used tools are MLoad, BTeq, FastExport and FastLoad to design and develop d Confidential flow paths for loading transforming and maintaining d Confidential warehouse.
• Expertise in working with various operational sources like Oracle, Terad Confidential, DB2, SQL Server, Flat files, Netezza into a staging area
• Expertise in Gathering and Analyzing Information Requirements,D Confidential Analysis,D Confidential Architecture, Business (E-R) modeling, Dimensional Modeling, ETL Design.
• Strong experience using SQL, PL/SQL Procedures/Functions, Triggers and Packages and experienced inUNIXOperating System andShell scripting.
• Experienced Working knowledge of D Confidential warehouse techniques and practices, experience including ETL processes, dimensional d Confidential modeling (Star Schema, Snow Flake Schema, FACT& Dimension Tables), OLTP and OLAP.
• Experienced in all d Confidential processing phases, from the Enterprise Model, D Confidential Warehousing (ETL).
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS:

ETL Tools: Informatica, Hadoop 2.7.0,Hadoop 2.6.2 (HDFS, MapReduce, Hive, Sqoop, Pig).(PowerCenter/PowerMart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect), TOS, TIS.

D Confidential bases: Oracle 12c/11g/10g, MS SQL Server, MS Access and DB2, Terad Confidential V2R5/V2R6, V12, V14, V15,Netezza.

Terad Confidential Tools & Utilities: Query Facilities: SQL Assistant, BTEQ Load & Export: FastLoad, MultiLoad, Tpump, TPT, Fast Export, D Confidential Mover.

Languages: SQL, PL/SQL, C, C++, Shell scripting (K-shell, C-Shell), Unix Shell Script.

Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal Server 2003/2007.

Web Technologies: HTML, XML, Java Script

Tools: SQL plus, PL/SQL Developer, Toad, SQL* Loader, Active Batch

Operating systems: Windows NT/2000/2003/XP/VISTA/7,UNIX,MSDOS and LINUX

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica Developer

Responsibilities:

• Extracted d Confidential from various centers with the d Confidential in different systems like Oracle D Confidential base and SQL Server and loaded the d Confidential into Terad Confidential staging using Informatica Power Center.
• Created jobs to load the d Confidential from csv files to oracle tables using Informatica Power Center. Files are coming from external source and loading them into oracle tables.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, SQL transformation, Stored Procedure, Normalizer, Lookup, Filter, Joiner, Rank, Router and Update Strategy. Created ETL Mapping with Informatica Integration Suite to pull d Confidential from Source, apply transformations, and load d Confidential into target d Confidential base.
• Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, Mapplets, connected and unconnected stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers and d Confidential flow management into multiple targets using Routers.
• Extensively used ETL processes to load d Confidential from various source systems such as SQL Server, Terad Confidential and Flat Files, XML files into target system SQL Server by applying business logic on transformation mapping for inserting and updating records when loaded.
• Proficient in Performance tuning of multiple Informatica mappings to improve performance as the volume of Internet orders entered the system on a daily basis. The factors involved were PDO (Push down optimization), bulk loading and also adding indexes on the staging tables.
• Extracted d Confidential from flat files/excel files, applied business logic to load them in the staging d Confidential base.
• Experience with all components of Informatica Power Center such as Source Analyzer, Target designer, Transformation, Mappings Designer, Mapplets.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Extensively used Informatica developer client (IDQ) for d Confidential profiling and d Confidential cleansing. Removing duplicates.
• Designed different type of STAR schemas for detailed d Confidential marts and plan d Confidential marts in the OLAP environment.
• Performed code reviews, analyze execution plans, and re-factor inefficient code and conducted system tests, corrected d Confidential base defects.
• Worked on Managing d Confidential, metad Confidential and business d Confidential
• Enforced referential integrity in the OLTPd Confidential model for consistent relationship between tables and efficient d Confidential base design
• Implemented population of slowly changing dimensions to maintain current information and history information in warehouse tables with change d Confidential capture ( Confidential ).
• Event raise tasks, used Informatica scheduler to schedule jobs. Used JCL scripts for scheduling the Informatica workflows.
• Responsible for providing daily status report for all Informatica applications to customer, Monitoring and tracking the critical daily applications & code migration during deployments.
• Managed theMetad Confidential associated with the ETL processes used to populate the D Confidential Warehouse
• Worked on creating various Oracle PL SQL stored procedures to handle complex logics.

Environment: Informatica Power Center 10/9, Oracle SQL, PL/SQL, Autosys, UNIX Shell Scripting, TFS, HP Quality Center, OBIEE 10g/11g

Confidential

Sr.Informatica Developer

Responsibilities:

• Worked on performance tuning by identifying the bottlenecks in Sources, Targets, and Mapping. Enhanced Performance on Informatica sessions using large d Confidential files by using partitions.
• Worked on ETL Mapping using Informatica Integration Suite to extract d Confidential from Source, apply transformations, and load d Confidential into target d Confidential base.
• Create and maintainmetad Confidential and ETL documentation that support business routines and detailed source to target d Confidential mappings.
• Created/modified various Informatica mappings and workflows for the successful migration of d Confidential from various source systems to oracle which meets the business requirements for reporting and analysis.
• Designed, developed, implemented and maintained Informatica Power center and IDQ application for matching and merging process.
• Developed a process in IDQ for cleansing and migrating global Customer d Confidential from flat files to Oracle and IDQ code deploy to Power center client.
• Used Developer client, Analyst Service and Informatica Administrator to integrate, profile, cleanse, monitor and load d Confidential in IDQ.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Guided Informatica developers to convert PL/SQL procedures to mappings, by creating documents outlining the source to target mappings and defining the underlying d Confidential transformations by collaborating with business users and Oracle Developers.
• Creating Reusable Transformations and Mapplets in a mapping.
• Involved in Creating tasks, worklets, workflows and Schedule, Run, Monitor sessions by using workflow manager and workflow monitor.
• Used BTEQ andSQL Assistant(Query man) front-endtools to issue SQL commands matching the business requirements to Terad Confidential RDBMS.
• Used existing UNIX shell scripts and modified them as needed to process SAS jobs, search strings, execute permissions over directories etc.
• Migrated Mappings, Sessions, and Workflows from Development to Test and then to Production environment.
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as D Confidential bases.
• Created and monitored sessions and batches to run the mappings.

Environment: Informatica, Workflow Manager, Workflow Monitor, Terad Confidential V13.0, Terad Confidential Utilities, ETL, Flat files, Oracle 10g, MS SQL Server 2008, Autosys, Hadoop, SQL, PL/SQL, Shell Programming, Toad, Excel and Unix scripting, Windows 2002.

Confidential

ETL Developer

Responsibilities:

• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure and Sequence Generator transformations.
• Implemented Slowly Changing Dimensions of type 1 & type 2 to store history according to business requirements.
• Used Parameter files to pass mapping and session parameters to the session.
• Tuned the Informatica mappings to reduce the session run time.
• Developed PL/SQL procedures to update the d Confidential base and to perform calculations.
• Worked with SQL*Loader to load d Confidential into the warehouse.
• Contributed to the design and development of Informatica framework model.
• Wrote UNIX shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
• Used SAS PROC IMPORT, D Confidential and PROC DOWNLOAD procedures to extract the FIXED Format Flat files and convert into Terad Confidential tables for Business Analysis.
• Helped users byExtracting Mainframe Flat Files (Fixed or CSV) onto UNIX Server and then converting them into Terad Confidential Tables using BASE SAS Programs.
• Collected Multi-Column Statistics on all the non-indexed columns used during the join operations & all columns used in the residual conditions.
• Generated and implemented Micro Strategy Schema objects and Application objects by creating facts, attributes, reports, dashboards, filters, metrics and templates using Micro Strategy Desktop.
• Developed BTEQ scripts to load d Confidential from Terad Confidential Staging area to Terad Confidential d Confidential mart.
• Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.
• Performed Unit testing and System testing of Informatica mappings.
• Involved in migrating the mappings and workflows from Development to Testing and then to Production environments.

Environment: Oracle8i, SQL, PL/SQL, SQL*PLUS, HP-UX 10.20, Informatica Power Center 7.x, DB2 Cognos Report net 1.1, Windows2000,