SUMMARY

• 7+ years of IT experience in analysis, design, development and implementation of Client/Server, Internet/Intranet, Data Warehouse/Data Mart & Business Intelligence applications
• Hands on experience with HDFS, MapReduce andHadoopEcosystem
• Have experience with Spark processing Framework such as Spark and Spark Sql.
• Well versed with developing and implementing MapReduce jobs usingHadoopto work with Big Data.
• Experience and strong business knowledge in domains like Finance, Insurance, Banking and Pharma.
• Extensive experience with ETL toolInformatica Power Center /Power Mart 9x/8x/7x, Power Exchange 9.x/8.xin designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, Configuring the Informatica Server and scheduling the Workflows and sessions.
• Experienced in using Databases Oracle 11g/10g/9i, DB2, Sybase, Teradata, Netezza, SQL Server 2005/2008. Strong Experience on database interfaces like PL/SQL Developer, SQL Plus and TOAD.
• Extensive experience in designing and developing complex mappings from varied transformation logic likeUnconnected and Connected lookups, Normalizer, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Experience in Configuration of Informatica MDM Data Director, Hierarchy Manager, Match/Merge
• Experience in completeSoftware Development Life cycle(SDLC) including Requirement, Analysis, estimations, Design, Construction, Unit and System Testing and implementation.
• Experience in Application Design, Data Extraction, Data Acquisition, and Data Mining Development, Implementations and Testing of Data warehousing and Database business systems.
• Extensively followed the advanced concepts ofRalph KimballandBill Inmon Methodologies.
• Extensive knowledge ofData Modeling, Data Conversions, Data integration and Data Migrationwith specialization in Informatica Power Center and Erwin.
• Expert onSlowly Changing Dimensions Type 1, Type 2andType 3for inserting and updating Target tables for maintaining the history.
• Expert - level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files.
• Implemented data warehousing methodologies for Extraction, Transformation and Loading usingInformatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console.
• Experience in working withUNIX Shell Scriptsfor automatically running sessions. Written number of shell scripts to run various batch jobs.
• Solid experience in writing SQL queries,Stored Procedures, Cursors, Indexes, and Views.
• Experience onDebuggerto validate the mappings and gain troubleshooting information about data and error conditions.
• Experience in working with Informatica web services components.
• Experience onpost-session and pre-session shell scriptsfor tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x, HIVE, Spark, SSIS

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Sybase Power Designer 16/15, Erwin 3.5.2/ 3.X & Toad 8.0/9.1

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, Netezza 5.0/6.0, XML, Teradata, SQL Server 2000/ 2005/ 2008 & MS Access

Scheduling Tools: Autosys, ESP

Reporting/OLAP Tools: SSRS, SSAS, Business Objects XI 3.1, OBIEE 10.1.X

Programming: SQL, PL/SQL, HIVE, VB, C, C++ & Java, SQL*Plus & SQL*Loader, UNIX Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr Informatica Developer

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Developed and maintained ETL (Extract, Transformation, and Loading) mappings to extract the data from multiple source systems like Oracle, SQL Server, Flat files, Cobol Files, Teradata and loaded into Oracle.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches, and Target Data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.6.1.
• Responsible for analyzing large data sets and derive customer usage patterns by developing new MapReduce programs.
• Extensively used Spark for optimizing of existing process in Hadoop using Spark Context, Spark-SQL, Data Frames.
• Written MapReduce code to parse the data from various sources and storing parsed data into Hbase and Hive.
• Extracted and Loaded data into Teradata using FastLoad and mLoad.
• Worked on data extraction from various source sources like Oracle 12C/11g/10g, DB2, and Complex Flat Files.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Scheduled workflows using Autosys job scheduler.
• Involved in Performance Tuning of mappings in Informatica.
• Migrated the codes from Dev to QA, Dev to UAT, UAT to Prod environment and wrote up the Team Based Development technical documents to the smooth transfer of the project.
• Used PMCMD, PMREP and UNIX shell scripts for workflow automation and repository administration.

Environment: Informatica PowerCenter 9.6.1, HIVE, Spark, Teradata, Oracle, Netezza, UNIX, Autosys, SQL Server.

Confidential, NC

Sr Informatica Developer

Responsibilities:

• Responsible for requirement definition and analysis in support of Data Warehousing efforts.
• Developed ETL mappings, transformations using Informatica PowerCenter.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping
• Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used ETL Tool Informatica to load data from Flat Files, Oracle.
• Developed data Mappings between source systems and target system using Mapping Designer.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Developed reusable Mapplets and Transformations.
• Developed and tested all the Informatica mappings and update processes.
• Extensively worked with the Debugger for handling the data errors in the mapping designer.
• Hands on experience with mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Aggregator, Joiner, Update Strategy, Java Transformations and Re-usable transformations.
• Created events and tasks in the work flows using workflow manager.
• Responsible for tuning ETL procedures to optimize load and query Performance.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Tested the mapplets and mappings as per Quality and Analysis standards before moving to production environment.
• Taken part of Informatica administration. Migrated development mappings as well as hot fixes them in production environment.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Worked closely with business analysts and gathered functional requirements. Designed technical design documents for ETL process.
• Developed Unit test cases and Unit test plans to verify the data loading process.

Environment: Informatica - PowerCenter 9.5.1, Power Exchange, Teradata, Oracle 10G, Oracle 11G, DB2, UNIX Shell Script, Windows NT/2000/XP, SQL Server 2008.

Confidential, Raleigh, NC

SQL Server Developer(SSIS/SSRS)

Responsibilities:

• Converted Data Transformation Services(DTS)application to SQL Server Integrated Services(SSIS)as assigned.
• Creating reports usingSQL Reporting Services (SSRS)for customized and ad-hoc Queries.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services(SSIS).
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• Designed dynamicSSISPackages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed dashboard reports usingReporting Services, Report Model and ad-hoc reporting usingReport Builder.
• Involved in migration from SQL Server 2005to SQL Server 2008.
• Experience in creatingParameterized reportsandLinked reportswith thorough knowledge of report serving architecture. (Table,chartandmatrix report).
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for theSSAScubes.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services(SSRS).
• Experience in creatingParameterized reportsandLinked reportswith thorough knowledge of report serving architecture. (Table,chartandmatrix report).
• UsedSSISto unite data from existing system and performed transformations on MS SQL 2008.
• Extract Transform Load(ETL) development Using SQL server 2008,SQL 2008 Integration Services(SSIS)
• Generated several drill down and drill through reports usingSSRS.
• Used Performance Point Server to create reports, scorecards and dashboards.
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Designed and created the table schema andstored proceduresthat will be used in Data QC.
• Designed and developed theData QC Maintenancewebsite that will be used to maintain the application tables, execution of main Data QC store procedures, and report generation that will be exported to Microsoft Excel file.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
• Responsible for documentation of system related activities.
• Provides technical documentation of the system
• Experienced in integrating different Microsoft BackOffice Components such as Share Point and IIS with MS SQL Server
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.

Environment: MS SQL Server2005/2008, SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS),MS Visual Studio.NET# 2008, TFS (Share Point ), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

Confidential, St. Louis, MO

Informatica Developer

Responsibilities:

• Extensively used ETL to load data from different source systems like Flat files into the Staging table and load the data into the target database.
• Worked on Informatica Power Centre tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and mapplets for data load to data warehouse and database.
• Multi source Extraction Transformation and Loading into the target structures using Informatica.
• Worked closely with multiple business units and a data solutions engineer to identify key information that will enhance business decision-making.
• Performance tuned mapping, sessions and database.
• Wrote stored procedures to accomplish tasks.
• Created sessions to move the data at specific intervals and on demand.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.
• Debugged the mapping for failed session to fix data and code issues.
• As a part of daily loading into the warehouse, used UNIX shell scripting to triggers the workflows in a particular order.
• Involved in coding UNIX shell scripting to execute pre/post session commands.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Analyzed and Created Facts and Dimension Tables.
• Used different Data Warehouse techniques like Star-Schema, Snow-Flake Schema.
• Developing multiple dimensions (drill down hierarchies), logical objects in business model & mapping layer and creating presentation catalogs in presentation layer.
• Informatica Data Quality was used for cleansing and matching the customer data. Real-time address cleansing was achieved using Informatica Power Connect for Web Services.

Environment: Informatica Power Center 9.0.1/8.6.1 , PL/SQL, Oracle 9i, TOAD, Erwin 7.0, Unix, SQL Server 2005, Autosys, Windows Server 2003, Visio 2003.

Confidential

Junior Oracle Developer

Responsibilities:

• Interact with end users to gathering requirements.
• Identifying integrity constraints for tables.
• Developed procedures and functions using PL/SQL and developed critical reports.
• Extensively used PL/SQL to implement cursors and triggers.
• Developed Date entry, query and reports request screens.
• Create record groups for manipulation of data.
• Perform unit and system integrated testing.
• Co-Ordination with users and SQL tuning on existing reports.
• Moved data from one database to other database, used SQL*Loader for data migration.

Environment: Oracle 8i, PL/SQL, Forms, Oracle Reports 2.5, Visual Basic, J2EE, Windows 98, Unix.