SUMMARY

• Around 6+ years of IT experience in Design, Analysis and development of software applications and implementation of Data warehousing using ETL/OLAP with Oracle, SQL Server, Netezza, Teradata databases on windows and UNIX platforms.
• Experience in Data warehousing, Data Extraction, Transformation and loading (ETL) data from various sources like Oracle, SQL Server, Netezza, XML Files and Flat files into Data Warehouse and Data Marts using Informatica Power Center 9.x,10.x (Repository Manager, Mapping Designer, Workflow Manager, Mapplet Designer, Workflow Monitor, Source Analyzer, Transformations Designer, Warehouse Designer).
• Extensively used Source Qualifier, Connected and Unconnected Lookup, Normalizer, Router, Filter, Expression, Aggregator, Stored Procedure, Java, Sequence Generator, Sorter, Joiner, Update Strategy, Union Transformations, Mapplets.
• Experience in Mappings, Mapplets, Worklets, Reusable Transformations, Sessions/Tasks, Workflows and Batch Processes in Informatica Server.
• Extracted data from multiple operational sources for loading staging area, Data warehouse, Data Marts using SCDs Type 1/Type 2/ Type 3/Type 4 loads.
• Experience in using the Informatica Utilities like Pushdown optimization and Session Partitioning to improve the performance of Informatica mappings.
• Proficient with Informatica Data Quality (IDQ) for cleanup and massage data at staging area.
• Experience with high volume datasets from various sources like Oracle, Flat files, SQL Server and XML.
• Extensive experience using Informatica power center, Netezza, DB2, Oracle 10g/9i/8i,Teradata, UNIX Shell Scripting, Windows, and as well as External Sources like flat files, COBOL (VSAM)sources.
• Worked extensively on Error Handling, Performance Analysis and Performance Tuning of Informatica ETL Components and Teradata Utilities, UNIX Scripts, SQL Scripts etc.
• Worked on complex queries to map the data as per the requirements.
• Strong Data Modeling experience in ODS, Dimensional Data Modeling Methodologies likes Star Schema, Snowflake Schema.
• Good exposure to Mainframe Systems and knowledge in handling COBOL files.
• Well versed in writing UNIX shell scripting.
• Good in planning, organizing, prioritizing multiple tasks.
• Interested in learning new technologies and willing to working changing environments.
• Strong decision - making and interpersonal skills with result oriented dedication towards goals.

TECHNICAL SKILLS

ETL Tool: Informatica Power Center 9.x,10.x

Databases: Oracle 9i/10g/11g, DB2, SQL Server, Netezza, Postgres

Data Modeling Tool: ERWIN, Toad Data modeler and MS Visio

Scripting Languages: UNIX Shell Scripting, Windows Batch scripting.

Operating Systems: Windows, LINUX, UNIX

Schedulers: Control-M, Autosys, Tivoli

PROFESSIONAL EXPERIENCE

Confidential, Virginia

Sr Informatica Developer

Responsibilities:

• Analyze the source systems data and the current reports at the client side to gather the requirements for the Data warehouse Data Model.
• Participating in daily scrum meetings and attending weekly keys meeting.
• Involved in creating Informatica mapping to populate staging tables and date warehouse tables from various sources like flat files, XML files, DB2, SQL sources.
• Analyzed the source data coming from SQL, DB2, XML, flat files and loading into Netezza warehouse. Worked with Data Warehouse team in developing Dimensional Model.
• Developed and tested thoroughly Informatica mappings/workflows as per technical and functional specs provided.
• Worked extensively on Informaticadesigner to design a robust end-to-end ETL process involving complex transformations like Source Qualifier, Java, Filter, Joiner, Lookup, Update Strategy, Router, Aggregator, Sequence Generator, Expression for the efficient extraction, transformation and loading of the data to the staging and then to the Data Mart (Data Warehouse) checking the complex logics for computing the facts.
• Worked mainly on maintenance bug fixes on existing Informatica Mappings to produce correct outputs.
• Extensively used the reusable transformation, mappings and codes using Mapplets for faster development and standardization.
• Created and configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables usingInformatica Workflow Manager.
• Involved in Performance Tuning inInformaticafor source, transformation, targets, mapping and session.
• Created variables and parameters files for the mapping and session so that it can migrate easily in different environment and database.
• Designed various tasks usingInformaticaworkflow manager like session, command, email, event raise, event wait and so on.
• Used Unix Command and Unix Shell Scripting to interact with the server and to move flat files and to load the files in the server.
• Responsible for file archival using Unix Shell Scripting.
• Worked on Tivoli to scheduleInformaticajobs.
• Used DB visualizer to access the data base
• Used the Microsoft share point to upload the design and test cases documents

Environment: Informatica 10.1, SQL, DB2, DB visualizer, Windows, UNIX, WinScp, Putty, Flat Files, XML Files, Tivoli, Hudson.

Confidential, Atlanta GA

Sr Informatica Developer

Responsibilities:

• Closely worked with Business Analyst, Architects and business users.
• Involved in analysis of end user requirements and business rules based on given documentation and worked closely with Business Process Management team and Business analysts in understanding the requirements.
• Business analysis and transforming the business requirements into the STM.
• Data analysis, data sampling, creation of data flow.
• Design and develop ETL jobs for transforming and loading various targets using Informatica, database scripts.
• Worked on different sources like Mainframe files, DB Tables (Oracle, SQL Server, DB2), flat files and FTP sources.
• Created various reusable transformations.
• Extensively used all Power Center/Power mart capabilities such Target override, Connected, Unconnected and Persistent lookup’s.
• Provide support for design of experiments, data analysis, and result interpretation related to continuous improvement projects.
• Code optimization and performance tuning.
• Creation of Informatica mapping for the different stages of ETL.
• Responsible for Performance improvements in Informatica.
• Create Business Process Flow diagrams showing interfaces among connected systems for each scenario in Visio.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, Source Qualifier and Stored procedure transformations.
• Developed, tested stored procedures, functions and packages in PL/SQL for Data ETL.
• Extensively used mapping parameters, mapping variables and parameter files.
• Performed data validation by writing SQL queries.

Environment: Informatica Power Center 9.5, Oracle 11g, SQL Server 2008, PL/SQL, TOAD, UNIX.

Confidential, Tampa FL

ETL Developer

Responsibilities:

• Responsible for developing the mappings from given technical documents using various transformations like Aggregator, Joiner, Sorter, update, expression etc.
• Experience in doing changes to existing mappings in accordingly to the user requirements and business logic.
• Worked with sources like flat files, COBOL files, Oracle tables and legacy systems. Written various types of SQL queries involving joins, aggregate calculations and tuning the queries too.
• Responsible for Creating workflows and worklets. Created Session, Event, command, and Control Decision and Email tasks in Workflow Manager.
• Extensively used Expression, Joiner for heterogeneous sources, look-up, filter, aggregate, and update strategy transformations to transform data before loading into the target tables.
• Developed workflow sequences to control the execution sequence of various jobs and to email support personnel.
• Implemented various transformation logics using transformations like Joiner, Aggregator, sorter, Update strategy, and filter, Router, Expression.
• Responsible for implementation of one time data movement and data replication methods.
• Worked extensively with parameterizing the workflows, configuring the reusable success and failure mails, control tasks command tasks, Informatica scheduler.
• Solid experience in performance tuning on Teradata SQL Queries and Informatica mappings.
• Created joins, macros and secondary indexes for faster retrieval of data.
• Worked on preparing a table of summarization and aggregation of the fact data
• Expertise in ETL reporting based on the Flat Files data sourced in different platforms.
• Handling the File transfer through SFTP Scripts, which are running through Informatica and also having some Unix Shell Scripts used to send mails to Clients whenever there is success or failure depending upon the Business requirements to the Customers.
• Developed ETL jobs to extract information from Enterprise Data Warehouse.
• Extensively used Informatica Power Center for extracting, transforming and loading data from relational sources and non-relational sources.
• Extensively used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, Aggregator, Update Strategy, and Joiner while migrating data from various heterogeneous sources like Oracle, DB2, XML and Flat files to Oracle.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for Data Load.
• Setting up and Sessions and Workflows to schedule the loads at required frequency using Power Center Workflow manager.
• Created connected and Un-Connected transformations to lookup the data from Source and Target Tables.
• Monitoring the ETL jobs and fixing the Bugs.
• Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
• Monitored the ETL Production Jobs and coordinated with offshore team to delegate tasks and monitor the day-to-day progress status and resolve the technical bugs and issues.
• Analyzing the end to end system of the Data warehouse.
• Designed complex UNIX scripts and automated it to run the workflows daily, weekly and Monthly.
• Fixing operational issues of the jobs to ensure data currency up to date and meeting the business requirements.
• Active interaction with business users, participating in onshore offshore conferences with the client, downstream business users and other vendors under consideration.

Environment: Informatica 9.1, Oracle, PL/SQL, SQL, Sybase, UNIX Shell Scripting.

Confidential

Systems Engineer

Responsibilities:

• Analyzed the source code and understood the issues.
• Involved in finding the root cause of the issues.
• Involved in debugging the developed code and made suitable changes in code to make it work properly.
• Involved in communicating with the development and testing teams in order to fix the issues.
• Solved issues in the functionality of online banking features.
• Solved critical issues with critical deadlines.
• Resolved on-going maintenance issues and bug fixes.

Environment: Eclipse IDE, TOAD, SQL.