OBJECTIVE:

• Seeking a position, where my skills and work experience as a Senior Application Developer in Data Integration/Data Warehousing/ETL/Business Intelligence can be utilized and enhanced.

SUMMARY

• 5 years of overall experience in IT Industry with emphasis on Data Warehousing tools using industry accepted methodologies and procedures.
• Technical expertise in ETL methodologies, Informatica 9.x/10.x - Power Center, Client tools - Mapping Designer, Mapplet Designer, Transformations Developer, Workflow Manager/Monitor and Server tools - Informatica Server Manager, Repository Server Manager, and Power Exchange, Informatica cloud.
• Expertise in Data Warehouse, Data Migration, Data Modeling, and Data Cleansing.
• Experience in installing Informatica and configuration in windows and UNIX environment.
• Directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse. Complete knowledge of data warehouse methodologies (Ralph Kimball, Inmon), ODS, EDW and Metadata repository.
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Informatica
• Expertise in Extraction, Transformation & Loading of data using heterogeneous sources and targets.
• Experienced in integration of various data sources like Oracle, IBM DB2, MS SQL Server, My SQL, SAP, Flat files, XML, SOAP requests, JSON, ATOM, Teradata, Netezza, XML files, Mainframe, Sales Force(SFDC), CPQ sources into staging area and different target databases.
• Expert in Extracting, Transforming and Loading ( ETL ) data using Informatica ; creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities.
• Experience in performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL Queries and DVO validation.
• Expertise in Oracle (SQL/PLSQL) and SQL server performance tuning using optimization techniques.
• Data Modeling experience on Data modeling, ERwin 7.1/4.5, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Datamarts, OLAP, FACT & DIMENSIONS tables, Physical & Logical data modeling and Oracle Designer.
• Data Analysis strong experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Expertise in creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Extensive database experience and highly skilled in SQL in Oracle, MS SQL Server, DB2, Teradata, Sybase, Mainframe Files, Flat Files, CSV files, MS Access.
• Skilled in SQL, PL/SQL, SQL*Plus, TOAD, SQL Assistant.
• Experience in implementing Data Warehousing Applications using Informatica Power Center / Power Mart for designing and developing transformations, mappings, sessions, and for scheduling and configuring workflows.
• Skilled in UNIX, Shell programming on UNIX systems using VI Editor, Windows scripting and in Informatica Sessions.
• Closely worked with Reporting team and built some reports for business needs.
• Proficiency in Microsoft Office Tools (Project, Excel, Word, PowerPoint, Visio, etc.)
• Worked on Business Objects (SAP), Cognos to create and run reports by using the data that has been loaded into data warehouse and monitoring these reports on their daily run.
• Worked on Business Intelligence launch pad for Business Objects
• Loading data from ETL to data warehouse.
• Experience in delivering End-User report generating tools Cognos, Reporting Services.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.
• Self-motivated and able to work independently and as a member of a team.
• Excellent teamwork spirit and capable of learning new technologies and concepts.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.x/9.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server, Business Objects, Business Intelligence (BI) launch pad, Cognos, Informatica Cloud IICS, Cloud Services AWS and Azure, Web Services and APIs(WSDL, SOAP, REST and WS standards)

Databases: Teradata, Oracle11g/10g/9iMS SQL Server 2012/2008 Netezza, MS Access 2010, IBM DB2, SAP, Flat files, XML, SOAP requests, JSON, ATOM, Sales Force(SFDC), MySQL Workbench, CPQ

Programming: SQL, PL/SQL, T-SQL, UNIX Shell Scripting, Perl, MongoDB

Scheduling Tools: ESP, Autosys, BatchIR

Operating System: UNIX, Solaris, Linux, Red Hat, Windows 8/7/2000/XP/ NT

Methodologies: Rational Unified Process (RUP), Waterfall, Spiral, Agile

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

• Understanding the business requirements, developing design specifications for enterprise applications using Informatica Power Center and Oracle database.
• Designing/Developing ETL processes using Informatica to load data from different ERP Systems to target Oracle Data Warehouse.
• Working with various sources such as Flat files, Relational Sources (i.e., like Oracle, DB2, SQL Server) & SAP as part of extracting data from ERP Sources using Informatica and generating ABAP programs.
• Implementing Slowly Changing Dimensions - Type I, II and III in mappings as per the requirements.
• Ensuring Conformance to Informatica coding standards.
• Creating test cases and performed unit testing for the Informatica code developed. Documenting Unit testing. Logging and resolving defects in the roll out phase.
• Developing the automated and scheduled load processes using Control-M/ Autosys scheduler.
• Develop mappings from various transformations such as unconnected/connected lookups, routers, filters, expressions, aggregators, joiners, update strategy and more.
• Applied slowly changing dimensions like Type 1,2,3 effectively to handle the delta Loads
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Prepared the error-handling document to maintain the Error handling process.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Involved in the Defect analysis call for UAT environment along with users to understand the data and to make any modifications if suggested by the user.
• Imported Sales Force (SFDC) objects. Created mappings in Informatica Cloud to bring the data from Sales Force (SFDC) using replication task and normal mappings. Querying tables using work bench to see and validate the data loaded into the Oracle and MS SQL Server database
• Used synchronization tasks to create jobs to pull data from ODBC and ServiceNow
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Developed reconciliation scripts to validate the data loaded in the tables as part of unit testing.
• Prepared complex SQL Queries to validate the data in both source and target databases.
• Performed data cleansing and data governance with standards good for Cognos reporting
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.

Environment: Informatica Power Center 10, Oracle 11g, XML, flat files, CSV Files, DB2, SAP, Toad, SQL Developer, Windows 7, Unix, Winscp, SQL server, Cognos, IICS

Confidential

Informatica Developer

Responsibilities:

• Documenting every ETL mapping specification. Preparing documentation for source analysis & ETL design, which are required prior to development.
• Involved in extraction, cleansing and loading of data into database.
• Worked with the Business analysts for requirements gathering, business needs analysis, testing, and project coordination
• Moving the data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions type two and type one
• Architected and Designed the ETL solution that included designing Mappings and workflows, deciding load strategies, implementing appropriate error handling and error notification processes, scheduling and designing re-usable ETL pieces through parameterization
• Worked extensively on different types of transformations like source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Union, Stored Procedure and sequence generator
• Scheduled the Jobs by using Informatica scheduler
• Improved performance of the ETL processes by benchmarking different approaches to reduce the ETL load time. Based on the benchmark figures, implemented changes to the ETL processes that included changing the design of certain mappings, addition of new intermediate / staging tables and using database partitioning / informatica pipeline partitioning for large loads
• Extensively used Informatica Debugger for testing the mapping logic during Unit Testing
• Actively involved in import and export of XML files, code migration of the folders, Linux files, flat files and database objects
• Worked with complex SQL queries for data validation
• Loaded data to data warehouse. Loading dimension table (one time load) and fact tables generally SCD type 2
• Developed the ETL mechanisms to load the data incrementally from the source database into the staging area and from there to feed the satellite applications in the form of flat files, XML files and relational tables. Most of the extract process was incremental, while others were full loads and snapshots
• Reviewed data models and functional specifications before creating the ETL mappings. Apart from Relational databases, these included unstructured data and non-relational data that were received daily. Automated the process using Shell Scripts (bash, Perl) and Informatica to load the newly arrived flat files
• Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions and batches
• Developed Test cases for Unit Testing of the Mappings, and was involved in the Integration Testing
• Worked closely with team members and QA team for finalizing ETL Specification documented test scenarios
• Worked with data modeler to create Universe
• Worked on Business Objects with Business Intelligence launch pad
• Created reports to meet the business requirements by using the data loaded into Data warehouse
• Worked on Business Objects(SAP) to make reports and monitoring them
• Provided production support by monitoring the processes running daily at early hours
• Worked in production environment for Finance section in project and took control over the tickets that come daily and processed these tickets with quality.
• Worked with Clients Service Center to follow the tickets raised by various teams and resolved them by inserting or updating or deleting data.
• Managing check and EFT, voids and reissues.
• Worked with Tivoli Workload Scheduler (TWS) for observing scheduled jobs to follow up and fix the failed jobs for production.

Environment: Informatica Power Center 9.6, Oracle 10g, XML, flat files, CSV Files, DB2, Toad, SQL Developer, Windows 7, Unix, Winscp, SQL server, Autosys, Tivoli Workload Scheduler (TWS), Service Center 2.0,Business Objects(SAP), Business Intelligence (BI) launch pad

Confidential

Informatica/PL/SQL Developer

Responsibilities:

• Based on the requirements created Functional design documents and Technical design specification documents for ETL.
• Extracted data from various Source Systems like Oracle, SQL Server and Flat Files as per the requirements.
• Designed and developed mappings and Mapplets using Informatica Source analyzer, Warehouse designer, Transformation designer and Mapplet designer.
• Created tables, views, indexes, sequences and constraints.
• Developed stored procedures, functions and database triggers using PL/SQL according to specific business logic.
• Transferred data using SQL*Loader to database.
• Involved in testing of Stored Procedures and Functions. Designed and developed table structures, stored procedures, and functions to implement business rules.
• Involved in design and development of data validation, load process and error control routines.
• Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
• Generated monthly and quarterly drugs inventory/ purchase reports.
• Coordinated database requirements with Oracle programmers and wrote report SQL's for sales data.

Environment: Informatica Power Center 9.6, Autosys, Oracle 9i, SQL, PL/SQL, SQL *Loader, Windows.