SUMMARY:

• Informatica certified PowerCenter Data Integration 10 Developer Specialist.
• 8 years of strong experience in using ETL (Extraction, Transformation, and Loading) utilizing Informatica 10.x/9.x/8.x/7.x/6.x (Power Mart/Power center).
• 6 years of data warehousing experience and Hadoop eco system, Exposure to NoSQL (HBase)
• 5 years of health care experience
• 3 years of Informatica cloud experience
• Have experience with big data product called 1010data.
• Knowledge of Architecture of complex OLTP database for online applications and mapping the OLTP data elements into Data Warehouse Architecture, Design, development, testing and documentation of data flow of OLTP systems to OLAP systems
• Implementation of tools/ languages - Informatica Power Center, Power Mart, Business Objects, Data Modeling using Erwin, Oracle, PL/SQL, SQL, Unix, Shell Scripting, SQL Server, Business Objects, SQL Loader, Access, C.
• Good experience in creating SQL Server database objects like tables, views, procedures, functions and triggers for a project.
• Experience in Administration activities like Creating and Managing Repositories, Users, User Groups, Folders, Working with Administrator functions of Repository Manager
• Knowledge of Data Modeling and deployment of multi-dimensional schema (Star and Snowflake Schemas) using Ralph Kimball Methodology, Conceptual/Logical/Physical design, Entity Relationship modeling using Erwin, Power Designer, Visio.
• Worked extensively on creation of ETL mappings and transformations using Informatica Powermart/PowerCenter to move data from multiple sources into target area
• Worked extensively with complex mappings using expressions, Routers, Lookups, ERP source qualifiers, aggregators
• Experienced in creating sessions and batches using Informatica server manager to run with the logic embedded in the mappings
• Experienced in performance tuning of sources, mappings, targets and sessions
• Strong experience in Oracle database Performance tuning
• Extensive experience in coding using SQL, PL/SQL Procedures/Functions, Triggers and Packages in Oracle
• Working knowledge of Shell Scripting and job scheduling on multiple platforms such as UNIX and Linux
• Team and Independent Player with excellent Organizational and Interpersonal skills.
• Experience in web Technologies like HTML, DHTML, XML, XSL, VB Script, Java Script, ASP
• Excellent written and oral communication skills.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9x/r 8.5/8.1.2/7.1.4/6.1/5.1.2, Power Exchange, Mapping Designer, Warehouse Designer, Datamart, OLAP, StarSchema, Snowflake Schema, OLTP.

Business Intelligence: Business Objects R 3.1/5.1.6/6.5/ XIR3.1 (Designer, Supervisor, Reporter & WEBI), Ab Initio, SSIS,SSRS,Cognos Impromptu 5.0, SAP BODS,MDM

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERwin

Databases: Oracle 11i/10g/ 9i/ 8i/8.0/7.x,MS Access 7.0,SQL SEVRER 2005,Netezza

Programming: SQL, PL/SQL, UNIX Shell Scripts,T-sql, MS - SQL Developer 2008(Views, Stored Procedures, Triggers and Constraints)ASP.Net 3.5, VB.NET, C#

OS: Windows95/98/NT/2000/2003, HP-UX, Mainframe.

Tools: TOAD 9.5,SQL*Loader,Autosys,SQL Server Management Studio,1010data,control M, Aginity,Informatica,SAP BODS

Markup Languages: HTML, DHTML, XML

PROFESSIONAL SUMMARY:

Confidential, Houston, TX

Sr. Informatica Developer

Responsibilities:

• Responsible for activities related to the development, support, implementation of ETL processes for large scale data warehouse using Informatica Power Center.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Extracting the data from SAP using SAP BODS.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Worked on 1010data, 1010data is cloud-based platform for big data and data sharing
• Analyzed performance issues within applications/databases and make recommendations for improvement.
• Created new and maintained new control M jobs and system job, file watcher jobs for Informatica and shell scripts
• Created and automatic audit scripts to send email on completion or failure of jobs using control M
• Worked with a team in the integration of various data sources definitions like SQL Server, Netezza, and Flat Files and As400
• Understand the prebuilt mappings and design the new mapping based on the existing standards if required
• Developed, scheduled and maintained the mappings in Informatica could
• Worked on Big data Tenup scripts to load the data from Netezza to 1010data
• Involved in design and building the ETL system in Unix to load the data to 1010data
• Created sessions and batches and scheduled them on Success tasks like Email to the ETL team and Business Analysts.
• Created Sessions, reusable Worklets and workflows in Workflow Manager and Scheduled
• Workflows and sessions at specified frequency.
• Interacted with DBA’s, Informatica Support team to resolve the issues.
• Created and scheduled jobs using Control-M.
• Responsible feeor Control M application support, Problem solving, coding, Issue resolving and coordination with Global team members, Business/Vendors.
• Involved in migrating the plans from Development to Production and automating the process.
• Performed testing, knowledge transfer and provide technical support and hands-on mentoring in the use of Informatica.

Environment: IBM Netezza, SQL Server 2005/2008, AS400, DB2, Tenup utility,SAP BODS, 1010data, Control M, Informatica 9.x,Informatica cloud, Linux, Unix.

Informatica Lead

Responsibilities:

• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Responsible for Business Analysis and Requirements Collection.
• Created mapping documents to outline data flow from sources to targets.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories

Environment: Informatica Power Center 9.6.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, PL/SQL, Oracle 10g/9i, Erwin, Autosys, SQL Server 2005, UNIX AIX, Toad 9.0,

Sr.ETL Developer

Responsibilities:

• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.
• Responsible for Business Requirement Documents BRD's and converting Functional Requirements into Technical Specifications
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
• Interacted actively with Business Analysts and Data Modelers on Mapping documents and design process for various Sources and Targets in corresponds to project coordination.
• Worked directly with Senior Architect and other team members to create ETL design specifications and support the implementation
• Obeyed and maintained Confidential IT development standards and best practices.
• Prepared detailed functional/technical specifications, and ETL Design documents from which software applications will be developed and implemented.
• Exclusively worked on TFS (Team Foundation Server) to migrate the code from different environments and stacks.
• Exclusively worked on Autosys (Scheduling tool) to create Informatica jobs scheduled as demanded.
• Extracted data from wide variety of data Sources like Flat files and Relational Databases (Oracle& SQL Server).
• Designed Data transformation from Transient to Staging, Fact and Dimension Tables in the Warehouse.
• Used transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure and update strategy to meet business logic in the mappings.
• Created and tested Informatica mappings and workflows to automate Job scheduling.
• Created Workflow, Worklet, Assignment, Decision, Event Wait and Raise and Email Task, scheduled Task and Workflow based on Client requirement
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Created sessions, batches for incremental load into staging tables, and schedule them to run daily/weekly/monthly.
• Developed various Mappings with the collection of Sources, Transformations, and Targets, using designer.
• Extensively worked on Performance tuning to increase the throughput of the data load (like read the data from flat file & write the data into target flat files to identify the bottlenecks).
• Extensively worked on SQL tuning process to increase the source qualifier throughput by analyzing the queries with explain plan, creating new indexes, partitions and Materialized views.
• Developed, executed Test Plans and Test Cases to validate and check Referential integrity of data extracts before loading it to Data Warehouse.
• Work closely with the development team during the development phase of the project to ensure:Standards and processes are followed.
• Unit/Integrated test plans are written and tested
• Migration checklist is prepared
• Responsible for migration of code from Dev to QA, UAT and PROD for ETL environments
• Provided expertise in design changes and strategy
• ETL job tuning

Environment: Informatica 9.1.0/8.6.1, Oracle 10g, SQL Server 2005/2008, Remedy, SQL Integration Services (SSIS), Autosys, TFS, 8.3/8.4.1,Unix, Windows XP/Windows7

Sr.ETL Developer (Informatica 8.6)\Lead

Responsibilities:

• Create complex technical solutions and design utilizing ETL tool (Informatica) and other technologies.
• Provide technical guidance and direction for each ETL (Extract, Transform, Load) project design and development team and ensure documentation is produced using defined methodologies.
• Liaison with projects managers and lead developers to assess project schedules and resource allocations needed to complete projects in a timely manner.
• Develop ETL processes using the various data warehousing software.
• Maintain ETL metadata and document all business rules.
• Seek out best practices to find opportunities for improvements in develop processes and makes recommendations for implementation.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Leverage skills and experience to contribute to overall architecture for IM systems, in developing end-to-end system design for specific data warehouse application, escalate issues and assess risks and look out for Data Integration Development interests in project teams.

Environment: Informatica Power Center 8.6.1, SQL Integration Services (SSIS), MS Office, Netezza4x, Crystal Reports, SQL Server 2008, T-SQL,Business Objects.

Sr. Informatica Developer\Admin

Responsibilities:

• Participated in ETL design and development discussions with Data Analyst.
• Developed ETL design specifications for the tasks and documented according to standards.
• Developed various complex mappings using Informatica 8.1.1 to handle business logic required.
• Created new session tasks, worklets and workflows using Workflow Manager and monitored them in Workflow monitor.
• Created new session tasks
• Created Workflows, Sessions for proper execution of mappings using Power Exchange Sources by passing the Mapping Parameters and Mapping Variables.
• Created complex mappings with use of transformations like Lookup, Router, Joiner, Expression, Sorter, Filter, Update Strategy, Source Qualifier and Normailzer etc.
• Used SQL Server Management Studio for SQL Operations extensively.
• Worked extensively with Procedures & Views.
• Played a part in Upgrade Informatica powercenter 8.1 to Informatica powercenter 8.6
• Developed incremental and updateable loading through Informatica mappings.
• Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)
• Documented the purpose of Datamarts (including transformations, mapplets, mappings, sessions and batches) so as to facilitate the personnel to understand the process and in corporate the changes as when necessary.
• Developed mappings according to the technical documentation and confirming to the business rules
• Created tables, views, indexes, sequences in development and test environment. DBA activities also included altering tables, dropping tables, checking database space and performance tuning.

Environment: Informatica PowerCenter 8.6.1, SQL SERVER 2005,SSIS, T-SQL,SSRSBusiness Objects XIR3.1,BizTalk, HP Quality Center, SQL Server Management Studio, AIX/UNIX, ASP.NET, C#

Informatica Developer

Responsibilities:

• Imported data from various Sources (Oracle, fixed width flat files, XML), transformed and loaded into Targets using Informatica.
• Implemented ETL Informatica designs and processes for the load of data from the sources to the target warehouse
• Created linked servers for multiple legacy systems using ODBC drivers and OLEDB Providers.
• Data modeling, ETL, gap analysis
• Designed and developed the data flow between normalized OLTP databases to Dimensional OLAP databases using DTS packages and Integration Services.
• Used all the Informatica client components like Designer, workflow Manger, Workflow Monitor, Repository Manger, and Repository Admin Console.
• Performance tuning of the ETL - by utilizing dynamic cache for Lookups partitioning the sessions.
• Worked extensively with various Passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator, Sorter Transformation, and Lookup Transformation.
• Designed mappings from the scratch and also did performance tuning of the mappings that were previously implemented
• Extensively worked with SCDs slowly changing dimensions Type 1, Type 2, and Type 3
• Responsible for performance tuning at various levels like mapping level, session level, and database level
• Worked on Power Center Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager
• Worked on Designer Tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, and Mapping Designer.
• Created Pipeline partitioning to improve Session performance.
• Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs
• Extensively used Source Qualifier Transformation, and used most of its features like filter, sorter, and SQL Override.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, and Aggregator Transformation.
• Developed Re usable Transformations, and Re-Usable Mapplets
• Worked with Shortcuts across Shared and Non Shared Folders
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Extensively worked with joiner functions like normal join, full outer join, master outer join, and detail outer join in the joiner transformation.
• Used Update Strategy DD INSERT, DD DELETE, DD UPDATE, AND DD REJECT to insert, delete, update and reject the items based on the requirement
• Worked with Index Cache and Data Cache in cache using transformation like Rank, Lookup, Joiner, and Aggregator Transformations.
• Solid experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor
• Responsible for query Optimization, performance tuning, SQL tuning, session performance
• Worked with Session Logs, and Workflow Logs for Error handling and Troubleshooting in DEV environment
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Analyzed existing java code used for conversion and develop ETL procedures as part of analysis and requirement gathering designed and implemented java batch code successfully to perform conversion on old legacy data
• Responsible for Unit Testing and Integration testing of mappings and workflows.
• Created the (ER) Entity Relationship diagrams & maintained corresponding documentation for corporate data dictionary with all attributes, table names and constraints.

Environment: Informatica Power Center 8.5 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), VB.NET, Teradata SQL Assistant v7, Mainframes, Flat Files, Business Objects 6.5, HP-UX, CA Autosys Scheduler