SUMMARY

• Having 7 Years of IT Experience in Software Analysis, Design, Development, Testing and Maintenance for a wide range of applications.
• Expertise in using Informatica client tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Sound knowledge/skills in ETL, Data warehouse concepts, RDBMS, SQL, PL/SQL and UNIX shell scripts.
• Proficient in all phases of software development life cycle (SDLC) including requirements definition, data conversion, system implementation, maintenance and acceptance testing.
• Good Knowledge on Data Warehousing Concepts, Business Objects (BO), Reporting tools, Informatica MDM, Teradata utilities, IBM Netezza Oracle PL/SQL.
• Hands on experience with Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling / IDQ Developer.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in creating complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle, flat files etc.,
• Practical understanding of the Data modelling concepts, Star schema, Snowflake schema, fact and dimension tables.
• Designed complex ETL mappings, reusable transformations using Regular Expressions, Dynamic Lookups, and Update Strategies for slowly changing dimensions, critical performance tweaking stages with partitioning, persistent cache, and extensive use of mapplets for common sub routines.
• Experience in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Hands on Experience in writing SQL queries, Stored Procedures, Packagesthrough the use of cursors, triggers. Extensive experience in working with the TOAD tool.
• Highly proficient in Oracle SQL, PL/SQL including writing queries, stored procedures, functions and triggers and implement business rules and validations.
• Have good understanding of ETL/INFORMATICA standards and best practices, Confirmed Dimensions, Slowly Changing Dimensions (SCD1, SCD2, and SCD3).
• Extensively used Informatica versioning to maintain different versions of ETL code.
• Proficient and prompt in learning and adapting to new technologies. Experienced in coordinating, managing and assigning responsibilities in team.
• Excellent oral and written communication skills, Analytical skills, capable to convey technical information at all levels, excel in research, analysis and problem solving.
• A team player with strong communication, leadership qualities, achieves organizational goals and milestones in an accurate and consistent manner
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member with excellent Verbal and Communication Skills and clear understanding of Business procedures.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/ 8.x/7.x, MDM, IDQ

Databases: Oracle11g/10g, SQL Server 2008/2005, NETEZZA, TERADATA

Languages: SQL, PL/SQL, UNIX Shell Scripting, FTP/SFTP,HTML

Operating Systems: UNIX, Windows 7/Vista/XP

Database Tools: Toad, SQL DeveloperOther Tools MS Office (MS Word, MS Excel, MS Power Point)SQL server Management StudioScheduling Tools Control-M

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

ETL Programmer

Responsibilities:

• Developing mappings/reusable objects/ transformation mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
• Written SQL override queries in source analyzer to customize mappings.
• Created reusable transformations and mapplets and used them in mappings.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Aggregator, Update strategy & stored procedure transformation.
• Designed complex Business rules in IDQ.
• Developed complex IDQ rules which can be used in Informatica and as well in Online
• Developed webServices through IDQ to be interacted in online.
• Worked on Informatica Data Quality (IDQ) to create the Mapplets.
• Hands on Master Data Management tool, IBM Initiate Inspector.
• Supporting ETL routines required for populating the Data Warehouse and Experience in loading high-volume data, Tuning and troubleshooting of mapping.
• Developed workflows and sessions associated with the mappings using Workflow Manager.
• Working on Repository manager to create and manage user profiles, and used Repository manager extensively while migration the code from development to production and compared both codes.
• Involved in writing SQL queries, PL/SQL programming and created new packages and procedures and modified and tuned existing procedure and queries using TOAD.
• Monitored and improved the performance of Sessions, Load Manager Properties, Parameter files, Mappings and documented the rectified issues in detail.
• Involved in Performance Tuning at various levels including Target, Source, Mapping and Session for large data files.
• Worked on both DEV and testing Environment
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Performed Unit testing and Migrate the ETL code to QA Environment.
• Working closely with the end users in writing the functional specifications based on the business needs.
• Create/Maintain database stored procedures, functions, views, types, tables.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Implemented Type II slowly changing dimension to keep a full history of dimensional data in the table

Environment: Informatica Power Center 9.6.1/8.6.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Repository Server Admin console), Informatica Dashboard, Oracle 10g/11i,SQL, PL/SQL, UNIX, DB2, Toad, MS SQL Server

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

• Creating the design document as per requirements.
• Create CA7 jobs for scheduling and NDM jobs for sending and receiving file between two servers.
• Developing Informatica mappings to implement business logic and also creating test cases and executing to minimize the defect.
• Experience in resolving issues related to file transfer processes taking place through accellion manager
• Analyzed queue managers and queues to find potential problems and worked towards fixing them
• Developing ETL components and loading data from numerous data sources to Oracle database, flat file, mainframe systems.
• Hands on Master Data Management tool, IBM Initiate Inspector.
• Create Pl/Sql functions and procedures to provide ETL solution and also create change requests and database requests to move code to production.
• Used MQ explorer to check the status of the queues, delete messages in the DLQs, browse messages in the queues just to name a few.
• Developed complex code based on PL/SQL (Procedure, Packages, Functions etc.) and UNIX Shell scripts for new enhancements
• Analyzed Informatica job failures & connection issues and worked with DBA and network teams to resolve them
• Experience in code migration and folder refreshes across different environments.
• Experience in analyzing the cause of long running jobs and implementing different performance tuning methods
• Analyzed business requirement and file transfer error using MQ FTE logs
• Restarted agents and outboxes after analyzing the file transfer issues
• Used Active directory to check and modify the groups’ and users’ permission
• Analyzed Autosys job failures and worked with Autosys team to resolve the issues
• Used Blade Logic to check the status of services running on windows servers and checking the permissions of users and groups
• Used admin console to create and modify different Informatica services
• Experience in decommissioning the extra servers, removing servers from Informatica grid, and deleting nodes belonging to the decommissioned servers
• Worked with respective teams for the cleanup of the agents and outboxes in the decommissioned servers.

Environment: Informatica Power Center 9.5 (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Repository Server Admin console), Autosys Scheduler, Oracle 10g/11i,SQL, SQL *PLUS, MS SQL Server SSIS, BladeLogic, UNIX, Putty,CA7 Automation Tool, Harvest, ToadforOracle

Confidential, Morrisville, NC

ETL Informatica

Responsibilities:

• Interacted with the Functional Analysts to understand the process flow and the business.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Analyzing Source to Target mapping Excel document.
• Coordinating the team and assigning dependencies tasks to team.
• Extract data from Teradata in to Informatica Power Center 9.6.1 version and develop the code using different transformations and Loading to Landing area Teradata.
• Parameterized the mappings and increased the re-usability.
• Created mappings using different transformations joiner, normalizer, expression, sorter, Aggregator, Filter, Router, lookup, update strategy.
• Migrate the ETL code to QA Environment.
• Worked on both DEV and testing Environment.
• Create structures for new WorkLets in Workflow Manager.
• Created and Monitored workflows using Workflow manager and Workflow monitor.
• Design and develop solutions for new strategic initiative
• Assist other developers and other groups in identifying and correcting issues with data and/or programming
• Worked on slowly changing dimension Type2.
• Involved in performance tuning of the process at mapping, session, source level and at target level.
• Used debugger in identifying bugs in existing mappings by analysing data flow, evaluating transformations.
• Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Power Center 9.6.1, Oracle, Teradata, SQL Server 2008, DB2, SQL Loader, Flat Files, Unix.

Confidential, New Carrollton, MD

Informatica Developer

Responsibilities:

• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager and Informatica Power Exchange.
• Worked with Data modeler, according to changes in the model worked on changes in the Informatica.
• Imported the source definition into source analyzer from oracle and for DB2, VSAM files used Informatica power exchange in the source analyzer.
• Imported the Target definitions into Target Designer from oracle and for DB2, VSAM files used Informatica power exchange in the Target Designer.
• Working with Business Analyst, Translating Business requirements into Functional requirements.
• Developed and Tested new mappings.
• Created and configured the sessions for work flow.
• Created and maintained parameter files for workflows in the UNIX and CVS.
• Worked on Joiner, Aggregator, Update Strategy, Rank, Router, Lookup (static and Dynamic), Sequence Generator, Filter, Sorter, Source Qualifier.
• Implemented slowly changing dimensions - Type I, II &III in different mappings as per the requirements.
• Created connections for relational, Non-relational and applications in the workflow manager.
• Created mappings using Reusable Transformations.
• Migrating mappings, workflows and parameter files from development to production.
• Developed PL/SQL scripts line packages and store procedures for data updates.

Environment: Informatica Power Center 8.1/8.5/8.6, Informatica Power Exchange 8.1/8.5/8.6, Oracle 10g, DB2, Flat files, UNIX, shell scripting, SQL Developer, Windows XP.

Confidential, Plano, TX

Informatica Developer

Responsibilities:

• Interacted with Business Analyst to understand the business requirements.
• Involved in developing the logical andphysical data models using Erwin.
• Involved in staging the data from external sources and was responsible for moving the data into the Warehouse using ETL Informatica.
• Used SCD2 to populate the data in a generic way. Single mapping is used to load multiple tables’ data.
• The scope of this design includes a generic design for implementing tables whose content will be managed in part by end-users of the Data Warehouse. The content changes can be made via the standard production change request process.
• Created mappings using flat files and relational databases as sources to build update Mappings.
• Created reusable transformations and mapplets and used them in mappings.
• Written SQL override queries in source analyzer to customize mappings.
• Debug mappings to gain troubleshooting information about data and error conditions using Informatica Debugger.
• As the requirement is to maintain the history of every change for all columns, have implemented the slowly changing dimension type 2 with effective start and end date of the record.
• Handled UNIX operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Analyzed source data and formulated the transformations to achieve the customer requested reports.
• Performed Unit testing and moved the data into QA.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Aggregator, Update strategy & stored procedure transformation.
• Handled UNIX operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Analyzed source data and formulated the transformations to achieve the customer requested reports.
• Performed Unit testing and moved the data into QA.
• Documentation of the project activity all along the course of the project along with Failure Recovery plans.

Environment: Informatica Power Center 9.5/9.0/8.6.1 , MS SQL server2005/2008, Oracle 11g, PL/SQL,TOAD, Flat Files, Windows XP, Unix.

Confidential, Chantilly, VA

Informatica Developer

Responsibilities:

• Involved in extraction of data from various sources like flat files, Oracle and SQL Server.
• Created Star Schema design using Data warehouse concepts like Fact Table and Dimension Tables.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Created Entity relationship diagrams, function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Created SQL tables with referential integrity and developed queries using SQL.
• Created complex mappings involving Filter, Router, Expression, Lookup, Update Strategy, Sequence generator, Joiner and Aggregator transformations.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Designed and developed Informatica Mappings based on the business requirements.
• Validate the data in the target tables once it was loaded.
• Fine-tuned existing mappings for performance optimization.
• Worked on bug fixes on existing mappings to produce correct output.
• Running the workflows quarterly and scheduling the workflows and monitoring them.
• Developed workflows and sessions associated with the mappings using Workflow Manager.
• Involved in writing complex queries for generating different reports as per client needs.
• Extensively used all the features of Informatica 8.6 including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Implemented various workflows using transformations such as Filters, update strategy, look up, aggregator, stored procedure and scheduled jobs for different sessions.
• Designed and developed several ETL scripts using Informatica, UNIX shell scripts.
• Involved in Performance Tuning at various levels including Target, Source, Mapping and Session for large data files.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.
• Documented ETL development standards as per client requirement.
• Involved in review of the mappings and enhancements for better optimization of the Informatica mappings, sessions and workflows.

Environment: Informatica Power Center 8.3, Oracle 10g, SQL, PL/SQL, TOAD, Shell Scripts, UNIX (AIX).

Confidential, Denver, CO

Informatica Developer

Responsibilities:

• Worked on the installation and configuration of Informatica Power Center 7.1.
• Created and Documented ETL Test Plans, Test Cases, Test scripts, Expected results, Assumptions and Validations.
• Used most of the transformations such as the Source Qualifiers, Routers, Java, SQL,
• Transaction control, Sequence Generators and Expressions as per the Business requirement.
• Extraction, Transformation and Load was performed using Informatica 7.1 to build the data warehouse.
• Monitored and improved the performance of Sessions, Load Manager Properties, Parameter files, Mappings and documented the rectified issues in detail.

Environment: Informatica Power Center 7.1, Oracle 8i, MS SQL Server, SQL plus, UNIX, Auto Sys, TOAD.