PROFESSIONAL SUMMARY:

• Having around 11 years of extensive experience with Informatica power center 9.5.1/9.1/8.6/8.5/8.1.1/8.0 (Source Analyzer, Target Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, workflow Monitor).
• Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server 2008 and Teradata.
• Good knowledge in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table and Dimension Table.
• Extensively worked on ETL Informatica transformations effectively including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Union, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator and created complex mappings.
• Good experience in Relational Databases like Oracle, Teradata
• Experienced in Tuning Informatica Mappings to identify and remove processing bottlenecks. Automation and scheduling of UNIX shell scripts and Informatica workflows.
• Excellent experience working on Teradata to write complex SQL queries, Teradata views , Bulk writer, Bulk reader etc using Informatica .
• Good Knowledge on Physical modeling, logical modeling, Relational modeling, Dimensional modeling (star schema, Snow Flake, Fact Dimensions),
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Experience on post-session and pre-session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.
• Extensive experience in creating deployment groups and ETL packaging (SCM) and promoting the packages to Test, UAT and Production.
• Excellent experience on using Teradata SQL Assistant, Teradata Administrator, PMON and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, and Exposure to T pump on UNIX/Windows environments and running the batch process for Teradata.
• Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads from various sources such as Oracle, ASCII delimited Flat Files, EBCDIC files, XML, COBOL, DB2, and SQL Server.
• Participated in Full life cycle development of Data Warehouse systems such as Analysis, Design, Development, Testing and Technical Documentation.
• Developed Mappings using Type 1, Type 2 and Type 3 SCD logic to load data into Dimension tables.
• Experience in Shell scripting on various Unix Environments.
• Excellent analytical and logical programming skills with a good understanding and interpersonal skills with a strong desire to achieve specified goals.

TECHNICAL SKILLS:

OS: Windows95/98/2000/XP, Windows NT 4.0, UNIX, MS DOS

Languages: C, C++, SQL and PL/SQL, Unix shell scripting.

ETL Tools: Informatica Power Center 9.5/ 9.1/8.6/8.5.1/8.1.1/8.0 , (Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager, Workflow Monitor).

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Schema, FACT and Dimensional Tables, Physical and Logical Data Modeling.

Databases: Oracle 11g/10g/9i, DB2, MS Access, SQL Server 2005/2008, Teradata R12, R13, TD13, TD14.

Database skills: Views, Materialized views, Cursors, Stored Procedures, Functions, Database Triggers, Packages.

DB Tools: TOAD, SQL Developer, SQL*Loader, Teradata Utilities BTEQ, FastLoad, MultiLoad.

Scheduling Tools: Autosys, Informatica Work Flow Scheduler.

Other tools: Tableau, Ultra edit, Software Change Manager, Putty, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Informatica Developer/ Teradata developer

Responsibilities:

• Involved in gathering of business requirements, interacting with business users and translation of the requirements to ETL High level and Low-level Design.
• Documented both High level and Low-level design documents, Involved in the ETL design and development of Data Model.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volume data.
• Developed complex ETL mappings and worked on the transformations like Source qualifier, Joiner, Expression, Sorter, Aggregator, Sequence generator, Normalizer, Connected Lookup, Unconnected Lookup, Update Strategy and Stored Procedure transformation.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Worked on loading the data from different sources like Oracle, DB2, EBCDIC files (Created Copy book layouts for the source files), ASCII delimited flat files to Oracle targets and flat files.
• Experience in working with Mapping variables, Mapping parameters, Workflow variables, implementing SQL scripts and Shell scripts in Post-Session, Pre-Session commands in sessions.
• Coding using BTEQ SQL of Teradata to Load the data from STAGE to EDW.
• Design and developed ETL process to load and extract data using BTEQ, MLOAD and Fast Export.
• Experience in writing SQL*Loader scripts for preparing the test data in Development, TEST environment and while fixing production bugs.
• Experience in understanding the Explain statements and optimization of queries
• Experience in using the debugger to identify the processing bottlenecks, and performance tuning of Informatica to increase the performance of the workflows.
• Experience in creating ETL deployment groups and ETL Packages for promoting up to higher environments.
• Involved in various phases of the software development life cycle right from Requirements gathering, Analysis, Design, Development, and Testing to Production.
• Performed and documented the unit testing for validation of the mappings against the mapping specifications documents.
• Performed production support activities in Data Warehouse (Informatica) including monitoring and resolving production issues, pursue information, bug-fixes and supporting end users.
• Experience in writing and implementing FTP, archive and purge Scripts in UNIX.

Environment: Informatica Power Center 9.1/8.6.1, Oracle 11g/10g/9i, DB2, MS Access, TOAD 9.0, UNIX, Autosys, Teradata.

Confidential

Sr. Informatica Developer

Responsibilities:

• Interacted with various business people and gathered the business requirements and translated them into technical specifications.
• Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, and load strategy designing.
• Developed complex ETL mappings and worked on the transformations like Source qualifier, Joiner, Expression, Sorter, Aggregator, Sequence generator, Normalizer, Connected Lookup, Unconnected Lookup, Update Strategy and Stored Procedure transformation.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Maintain and Tune Teradata Production and Development systems
• Involved in providing the user requirement document as part of the Joint Requirement Discussions.
• Troubleshooting the Failure Jobs.
• Created views for analyzing the data in the virtual data marts
• Highly involved in Technical upgrades and system planning.
• Capacity planning and proactive monitoring to meet performance and growth requirements
• Monitoring Production system whenever in need and controlling Online and Batch jobs.
• Interacted with Clients, Data Modeler and Data Analyst to develop the Logical and Physical Design for a table.
• Worked on loading of data from several flat files sources to Staging using Teradata TPUMP, MLOAD, FLOAD and BTEQ.
• Performed Data Modeling activities such as performing Data Analysis, Strategies for Data Migration/conversion, Data Cleansing, Designing Technical specifications / Table level specifications and Creating Logical and Physical Data Models for CRM and Mercury Data Marts.
• Experienced in working with Teradata ETL tools like Fast Load, Multi Load, Tpump and Fast Export.
• Extensively used Teradata system Priority Schedule in controlling the load of the system.
• Teradata PMON is used to monitor the system performance when it is in load.
• Performance Tuning, Query optimization (Explain plans, Collect statistics, Primary and Secondary indexes).
• Build tables, views, UPI, NUPI, USI and NUSI.
• Checking the tables skewing, table compression.
• Moved database schema changes to stage/production database.
• Worked with the users and testing teams to implement the business logic as expected.
• Written several Teradata BTEQ scripts to implement the business logic.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Experienced in Teradata Manager which is used to create Alerts, Monitor system.
• Involved in documentation of requirements and technical design.

Environment: Informatica Power Center 9.1/8.6.1, Oracle 11g/10g/9i, DB2, MS Access, TOAD 9.0, UNIX.Autosys, Teradata

Confidential

Sr. Informatica Developer/ Teradata Developer

Responsibilities:

• Gathered user requirements and reporting requirements for a better understanding of the business process and the current reporting system.
• Involved in various phases of SDLC from requirement gathering, analysis, design, development and testing to production.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Constantly interacted with the Business Intelligence team and the Data warehouse Architecture team to understand the requirements and implement them seamlessly.
• Meeting with business users and defining Functional and Technical business requirements.
• Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Extensively created Reusable Transformations and Mapplets to implement the business logic for loading to the target database.
• Extensively used all the Transformations like source qualifier, aggregator, filter, joiner, Update Strategy, Unconnected and connected Lookups, Router, Sequence Generator.
• Extensively worked on Workflow Manager and Workflow Monitor to create, schedule, monitor Workflows, Worklets and various tasks like command, assignment, control and session tasks.
• Extracted data from various source systems like Oracle and flat files as per the requirements and loaded it to Teradata using FASTLOAD, TPUMP and MLOAD
• Worked on Informatica tool Source Analyzer, Data warehousing designer, Mapping Designer, Mapplets and Transformations.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Extensively worked on ETL performance tuning to tune the data load and worked with for SQL query tuning etc.
• Developed post-session and pre-session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from and to different servers.
• Developed the UNIX shell scripts to send out an E-mail on success of the process indicating the destination folder where the files are available.

Environment: Informatica Power Center 8.6, Oracle 10g/9i, DB2, MS Access, TOAD 9.0, Teradata V2R6, PL/SQL, UNIX.

Confidential, Charlotte, NC

Sr. Informatica developer/ Teradata Developer

Responsibilities:

• Developed ETL mappings, Transformations and Loading using Informatica Power Center 8.6.
• Developed mappings and workflows as per business logic, quality and coding standards prescribed for the module using Informatica Power Center 8.5.
• Extensively designed, developed, tested complex Informatica mappings, Mapplets and to extract data from external flat files, SQL Server, oracle tables using Informatica power center 8.5.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters for the delta process to extract only the additional data added during that period.
• Extensively used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Extracted data from various source systems like Oracle and flat files as per the requirements and loaded it to Teradata using FASTLOAD, TPUMP and MLOAD
• Worked with mappings to dynamically generate parameter files used by other mappings.
• Conducted performance tuning to increase performance of the mappings, sessions & workflows.
• Used PL/SQL with Informatica Power Center 8.5 for Oracle 9i database.
• Developed mapping document indicating the source tables, columns, data types, transformation required, bulk loading routines, business rules, target tables, columns and data types.
• Documented Design and Unit Test plan for Informatica mappings, design and validation rules.
• Wrote stored procedures, Functions, Triggers and UNIX shell scripts to support and Automate the ETL process
• Developed, implemented and enforced ETL best practices standards.
• Performance tuning and bottleneck resolution.
• Created and Implemented Reusable Sessions like E-mail.
• Used Autosys Tool to schedule UNIX shell scripts and Informatica jobs.

Environment: Informatica Power Center 8.5, Oracle 9i, UNIX, TOAD, SQL*Plus, Teradata

Confidential

ETL Informatica Developer

Responsibilities:

• Assisted gathering business requirements and worked closely with various Application and Business teams to develop Data Model, ETL procedures to design Data Warehouse.
• Extensively used ETL Informatica tool to extract data stored in MS SQL 2000, Excel, and Flat files and finally loaded into a single Data Warehouse.
• Used various active and passive transformations such as Aggregator, Expression, Sorter, Router, Joiner, connected/unconnected Lookup, and Update Strategy transformations for data control, cleansing, and data movement.
• Designed and developed Mapplets for faster development, standardization and reusability purposes.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Used Debugger to validate transformations by creating break points to analyze, and monitor Data flow.
• Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
• Worked along with the QA Team and provided production support by monitoring the processes running daily.
• Involved in pre and post session migration planning for optimizing data load performance.
• Interfaced with the Portfolio Management and Global Asset Management Groups to define reporting requirements and project plan for intranet applications for Fixed Income and Equities.
• Performed Unit testing during the mapping phase to ensure proper and efficient implementation of the transformations.
• Wrote UNIX Shell Scripts and pmcmd command line utility to interact with Informatica Server from command mode.

Environment: Informatica Power Center 6.2, MS SQL 2000, Oracle 9i, SQL, PL/SQL, SQL Navigator, UNIX Shell Scripting, Windows XP and 2000.