Professional Skill Set Summary:

• 9+ years of experience in the IT industry with a strong background in software development and experience in Development & Testing Business Intelligence solutions in data warehousing and decision support systems using ETL tool Informatica Power Exchange, Informatica Power Center 9.5.1,9.0.1,8.6.1.
• Proven track record in planning, building, and maintaining successful large-scale Data Warehouse and Decision Support Systems. Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data loading and Data management.
• Certified in Oracle IZ0 -007 for SQL.
• Implemented Agile Methodology.
• Experience working with various heterogeneous source systems such as T-SQL, Oracle, DB2, MS SQL server, XML files, flat files, Teradata and MySQL server
• Expertise in working with Teradata database (Fast load, Multiload, Tpump and Fastexport), Oracle SQL and PL/SQL through various procedures, functions, and packages, Triggers to implement the business logic. Worked with other DB like DB2, SQL Server.
• Experience in Oracle 10g/11g, TOAD 9.6.1,PL/SQL, SQL*Loader, UNIX AIX, UNIX Shell Scripting, & PERL
• Experience in working with ERwin Tool for ER Data Modeling.
• Widely used PDO Push Down Optimization option for Oracle and Teradata.
• Strong in Data warehousing methodologies of Star /Snow Flake schemas of Ralph Kimball, Bill Inman. Strong knowledge in ETL Concepts.
• Expertise in using Variables and parameters in Informatica.
• Experience in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources systems into data warehouse using Informatica Power Center.
• Experience in developing Informatica Mappings(includes Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer), Workflow Manager (Includes Sessions, Worklets and Tasks) and Informatica Monitor along with Informatica versioning. Experience in working with Deploying groups.
• Developed complex mappings and SCD Type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router, Stored Procedure, Normalizer, XML and SQL transformations.
• Experience in working with COBOL files, Flat files, XML files, CVS files.
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables. Functional, Regression, System Testing, Load Testing, UAT Testing using QC
• Used Power Exchange to source copybook definition and then to row test the data from data files, VSAM files.
• In depth knowledge in UNIX AIX, UNIX Shell Scripting, & PERL.
• Experience in Performance Tuning, Error handling, Oracle query optimization ,Product support on various Platforms. staging, reusability, data validation, Real time
• Experience in Infomatica jobs persformance tuning and oracle query optimization.
• Worked on OS load analysis during the peak hours when all the ETL jobs run. worked OS engineering team in fixing the load issue.
• Good in analysis, problem solving and team player .
• Good in writing and communication skills.
• Good in planning, organizing, prioritizing multiple tasks.
• Interested in learning new technologies and willing to working changing environments.

Software and Plat Form Experience and Exposure:

• ETL Tools: Informatica Power center 9.5.1,9.0.1, 8.x, 7.x.
• Databases: Oracle 11G,10g 9i/8i, MS SQL Server 2008, DB2, MS Access, Sybase, T-SQL.
• Operating Systems: Windows 95/98/2000/2003 Server/NT Server Workstation 4.0, UNIX.
• Scripting Languages : SQL, PL/SQL, UNIX AIX, UNIX Shell Scripting, & PERL Scripting, VB.
• Methodologies : E-R Modeling, Star Schema, Snowflake Schema.
• Other tools : Autosys,DAC, TOAD 9.6.1, SQL*Loader

Professional Experience:

Confidential , Plano, Tx

Sr.Informatica Developer

Responsibilities:

• Gathered requirements from the end users and Involved in analysis of source systems, business requirements and identification of business rules.
• Designed and developed Complex Mappings, which involved slowly changing dimensions (Type2), Error handling, and implementation of business rules.
• Worked with (Fact and Dimensional tables) OLAP (Star schema, Snowflake schema).
• Design and Implement Informatica mappings to Migrate data from various legacy applications/acquisition offices to a centralized application.
• ILM for data management.
• Good in Unix shall scripting and Perl Scripting. Parameter values are passed through Unix and Perl scripts.
• Deploy Informatica Objects and Business Object Universes to TEST, UAT and Production Environments.
• Involved in development of Informatica Mappings, Mapplets and Workflows for complex Business rules.
• Various Transformations like Expression, Lookups, Filters, Sequence Generator, Joiner, and Sorter were used to handle situations depending upon the requirement.
• Called Stored Procedures to perform Database operations on Post-Session and Pre-Session commands.
• Implemented Type2 slowly changing dimensions to keep track of Historical data.
• Created parameter file for session parameters and called in the sessions.
• Created shortcuts to reuse objects across folders without creating multiple objects in the repository.
• Involved in coding & designing of SQL, procedures, functions and support.
• Dropped and recreated the Indexes on tables for performance improvements
• Performance Tuning of SQL Queries and ETL Mappings.
• Performed Unit Testing and verified the data using Informatica Debugger break points.
• Tuned mappings and sessions for better performance on the data loads.
• Performed Error handling on sessions in Workflow Manager.
• Involved in Internal KT’s and Production support transitioning.
• Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, and transformation and loading strategies.
• Member of the warehouse design team, which interacted with the business community and database administrators to identify the business requirements.

Environment: Informatica 9.5/9.1 , UNIX, Windows 2007, Oracle 9i Enterprise Edition, PL/SQL, SQL, Netezza, T- SQL,SQL Server 2008/2005, Shell Scripting, Putty, WinSCP, Toad and SQL developer, ERwin, Autosys.

Confidential , NYC, NY.

Sr.Informatica Developer

Confidential is one of the top most financial banks in USA. The work was in a team Environment with 3 oracle developers, 1 Informatica Admin and a team lead. As an Informatica Developer maintaining the existing projects i.e., scheduling, monitoring them, tune them accordingly; assist other teams in their work etc, configuring the Email task for sending the success or failure mails. Here I effectively utilized my programming skills to adhere to coding standards, procedures and techniques while contributing to the technical code base including any required documentation. Our main primary source was EDW.

Responsibilities:

• Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, and transformation and loading strategies.
• Member of the warehouse design team, which interacted with the business community and database administrators to identify the business requirements.
• Involved in ETL load process and control framework for the warehouse.
• Extensive experience in creation of ETL mappings and transformations to reflect business rules using Informatica Power Center to move data from multiple sources into target area, source systems are mainly relational tables, and flat files.
• Designed and developed Complex Mappings, which involved slowly changing dimensions (Type2), Error handling, and implementation of business rules.
• Worked with (Fact and Dimensional tables) OLAP (Star schema, Snowflake schema).
• Extensively worked with Debugger using breakpoints and various test conditions to test the logic and the validity of the data moving through the mappings.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Used various transformations like Source Qualifier, Lookup (connect, unconnected), Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
• Involved in coding & designing of SQL, procedures, functions and support.
• Dropped and recreated the Indexes on tables for performance improvements
• Performance Tuning of SQL Queries and ETL Mappings.
• Unix shall scripting and Perl Scripting has been used to generate dynamic parameter file generation.
• Unix shall scripting is used to run the Workflows in sequence and generate the generate lock file for easy handling of restart and resume.
• Created Sessions, Work lets and workflows for designed mappings.
• Used Conversion process for VSAM to ASCII source files using Informatica Power Exchange.
• Used Power Exchange to source copybook definition and then to row test the data from data files etc.
• Worked on Teradata by bringing the COBOL Files and loading in to the Teradata Tables by using the FLoad.
• Knowledge of loaders in Teradata including Fast load, MLoad, Tpump, BTEQ, TPT.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed Debugged the mapping of the failed session.
• Migration of mappings, sessions and workflows from Development to Stage and Production environments.
• Code validation of the mappings migrated to production environment.
• Performed Unit tests on the sessions and recommended measures to improve the performance of sessions.
• Responsible for performance tuning ETL process to optimize load and query Performance.
• Used Shell scripts to call procedures and load the data into the table.
• Developed Perl scripts to automate pre session and post session tasks.
• Involved in the End user training and worked in testing and production support environments.
• Efficient Documentation (Migration document) was done for all mappings and workflows.

Environment: Informatica Power center9.1/8.6, Power Exchange 8.1.1, VSAM files, Business Objects/6.X, Oracle 11g/10g, PL/SQL, SQL*PLUS, SQL Server 2008,2005 Flat files, XML,COBOL, TOAD, UNIX, TOAD, ERwin 4.0,Rapid SQL, Teradata, Teradata SQL Assistant,Autosys

Sr.Informatica Developer

Responsibilities:

• Clear Quest tool is used for implementing the Software Development Methodology (SDM) process in any development and enhancement work at CCL. As per the SDM process followed at CCL, any development and enhancement work needs to have -
• I have been working on Informatica (Fixing/modifying/developing/mappings/sessions/workflows)
• Extensively worked with Debugger using breakpoints and various test conditions to test the logic and the validity of the data moving through the mappings.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Used various transformations like Source Qualifier, Lookup (connect, unconnected), Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
• Involved in coding & designing of SQL, procedures, functions and support.
• Dropped and recreated the Indexes on tables for performance improvements
• Performance Tuning of SQL Queries and ETL Mappings.
• Created Sessions, Work lets and workflows for designed mappings.
• Used Conversion process for VSAM to ASCII source files using Informatica Power Exchange .
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed Debugged the mapping of the failed session.
• Migration of mappings, sessions and workflows from Development to Stage and Production environments.
• Code validation of the mappings migrated to production environment.
• Performed Unit tests on the sessions and recommended measures to improve the performance of sessions.
• Responsible for performance tuning ETL process to optimize load and query Performance .
• Used Shell scripts to call procedures and load the data into the table.
• Developed Perl scripts to automate pre session and post session tasks.
• Involved in the End user training and worked in testing and production support environments.
• Efficient Documentation (Migration document) was done for all mappings and workflows.

Environment: Informatica 8i ,UNIX, Windows 2003/07,Oracle 10g Enterprise Edition, Teradata, PL/SQL, SQL, UNIX Shell Scripting, Putty, ERwin, WinSCP and Toad,Autosys.

Confidential , Advanced America, SC

Sr.Informatica Developer

Description: Advanced America is a banking corporation. Advanced America provides loan amounts for various purposes like Personal Loan, Vehicle Loan, and Housing Loans. The company requires different levels of analysis regarding loan amount, type of customers, and type of payment schedules, and interest calculations. The data warehouse basically is a Data Mart, as it covers only one domain of the business and captures data from their Transactional Database maintained under Client/Server Architecture. Data populated into Facts and Dimensions using Informatica.

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing and participated document review meetings .
• Worked in Onsite and as well as in Offshore as a Developer and Coordinate the Onsite and Offshore Teams for maximum productivity by resolving the issues.
• Involved in the team during the entire ETL process and development of data marts using Informatica Power Center 8.6/7.x.
• Implemented Slowly Changing Dimensions methodology to keep track of historical data.
• Designed and developed Star Schema and created Fact and Dimension Tables for the Warehouse using Erwin and Business Intelligence Reporting Applications using OBIEE.
• Extracted the data from Oracle11g/10g, XML, Flat files load the data in to Oracle data warehouse.
• Worked on Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer, Workflow Manager, Mapplet Designer and Transformation Developer.
• Used Informatica Designer to create mappings using different transformations to move data to a Data Warehouse. Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank.
• Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager.
• Created Reusable transformation and Mapplet based on the business rules to easy the development process and responsible for document the changes.
• Maintained and modified mappings as per changing reporting requirements.
• Extensively worked on the performance tuning of the Mappings as well as the sessions.
• Checked Sessions and error logs to troubleshoot problems and also used Debugger for complex Problem troubleshooting
• Developed Informatica mappings/sessions/workflows for ETL processing and used Unix Shell Scripts for smooth application interfacing.
• Involved in identifying the bottlenecks in Sources, Targets & Mappings and accordingly optimized them.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Involved in using the Stored Procedures, Functions and Triggers at Data Base level and imported them in Informatica for ETL.
• Extensively used SQL * Loader for Bulk loading from Flat Files to Oracle Tables.
• Involved in Unit and System testing of developed mappings.
• Responsible for migrating the folders or mappings and sessions from development to production environment.
• Written Detail design documentation to describe program development, logic, coding, testing, changes and corrections.

Environment:Informatica Power center 7.x,XML, Flat Files ,UNIX, Windows 2003,Oracle 9i, PL/SQL, SQL, MS Visio, Shell Scripting, Putty, WinSCP and Toad

Confidential, Bangalore India

Informatica Developer

Responsibilities:

• Gathered requirements from the end users and Involved in analysis of source systems, business requirements and identification of business rules.
• Involved in the Data Warehouse Data modeling based on the client requirement.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Extracted sources from flat-files, Oracle, SQL Server and load them into Oracle.
• Responsible for creating system design and detail design documents based on the requirement document provided by the business users.
• Provides strategic thinking, leadership pertaining to new ways of leveraging information to improve business processes.
• Experienced in database design, data analysis, development, SQL performance tuning, data warehousing ETL process and data conversions.
• Based on the logic, developed various Mappings & Mapplets to load data from various sources using different transformations like Source Qualifier, Expression, Filter, Normalizer, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner in the mapping. Also developed Error Processing to capture the error records and loads them into Message Log table.
• Worked with Stored Procedure Transformation for time zone conversions.
• Created UNIX scripts to automate the activities like start, stop, and abort the Informatica workflows by using PMCMD command in it.
• Fine tuned the mappings by analyzing data flow and Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Lookup, Joiner and aggregator transformations.
• Provided production support including error handling and validation of mappings.
• Addressed and track requests for system enhancements, improvements from end users/customer and also resolved production issues.
• Extensively used Debugger Process to modify data and applying Break Points while Session is running.
• Used various Informatica Error handling techniques to debug failed session.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data.
• Responsible for migrating the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to other Environment.
• Proactive team player with the demonstrated ability to multi-task and prioritize in a fast-paced professional environment.
• Maintained effective communication with non-technical client personal and handled the change requests.

Environment:Informatica 6.1, UNIX, BO, Windows 2003,Oracle 8i, PL/SQL, SQL, XML, Flat Files and CSV, Shell Scripting, Putty, PL/SQL Developer.