PROFESSIONAL SUMMARY

• 7 years of experience in Information Technology with a strong back ground in Analyzing, Designing, Developing, Testing and Implementation of Database development in various verticals such as Insurance, Sales, Health care, power and capital.
• 7 years of Database experience using Oracle 11g,10g, Teradata V13, V2R5, MS SQL Server 2005, XML, PL/SQL, Teradata Utilities Mload,Fload,Tpump,BTEQ .
• 6 years of strong experience in Data Warehousing and ETL using Informatica PowerCenter 9.5,9.1,8.6.1/8.1, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, and Informatica server ETL, Datamart, OLAP and OLTP.
• 1 years of Experience in Dimensional Data Modeling using Star Schema Snowflake Schema, FACT Dimensions tables, Slowly Changing Dimensions Type I II , Physical logical data modeling, surrogate key assignment and CDC change data capture . Strong experience in DBMS Packages, Database Design, TOAD and ODBC interfaces to Oracle.
• Configured Informatica PowerCenter Integration services to extract and load Relational, Non-Relational, and Changed Data during Batch, Change and Real- Time basis.
• Experience in integration of various data sources like Oracle, DB2UDB, Teradata, SQL Server, MS Access, Flat Files, and Mainframes into the staging area.
• Hand on experience in Database development skills using Oracle PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Excellent working knowledge of UNIX shell scripting and Job Scheduling on multiple platforms like Windows NT/2000, HP-UNIX, Sun Solaris.
• Efficient in all phases of the software development lifecycle, coherent with Data Profiling, Data Cleansing, Data Conversion, Performance Tuning, Unit Testing, System Testing, User Acceptance Testing.
• Good knowledge in Multi-tier and Cross-platform environments. Strong leadership qualities with excellent communication skills.

TECHNICAL EXPERIENCE

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica Developer

Responsibilities:

• Extensively used Informatica Power Center 9.5.1/9.1.1 as ETL tool for developing the project.
• Worked with various Informatica Client Tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Created complex mappings using various transformations like SQ, filter, sorter, aggregator, expression, union, joiner, router, SQL, Look up for inbound and outbound processes.
• Developed the ETL modules using Teradata BTEQ scripts, macros and other utilities such as fast load, multi load, fast export etc.
• Designed the ETL process and customized templates around Informatica and Teradata.
• Used the Teradata utilities like BTEQ, Mload, and TPT to get the data into the system and exporting it to the other database.
• Interacted with the business people on user requirements.
• Used debugger extensively to identify the bottlenecks in the mappings.
• Unit tested all conversions and interface mappings.
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.
• Used workflow manager to create workflows, sessions, and also used various tasks like command, email.
• Prepared the flow documentation for conversions and interfaces.
• Gathered the requirements from the client for the ETL Objects implementation
• Having daily interaction with the client for gathering the requirements and status updates.

Environment: Informatica PowerCenter 9.5.1/9.1.1 Work Flow Manager, Work Flow Monitor, Teradata 14 ,Utilities:BTEQ,FLOAD,TPT UNIX Shell Scripting, LINUX.

Confidential

Sr. Informatica Developer

Responsibilities:

• Extensively used Informatica Power Center 9.1.1/8.6.1 as ETL tool for developing the project.
• Gathered the requirements from the client for the ETL Objects implementation
• Having daily interaction with the client for gathering the requirements and status updates.
• Perform the Gap analysis of the requirements.
• Created the ETL design document.
• Reviewing the code, optimizing the code, optimizing source query to take less time, test case review, suggestion to include important test cases particular to particular ETL logic.
• Analyze the source data, do impact analysis, see how the data would fit into the data model designed and how it would help in feeding the reports.
• Mentor the team members by providing assistance with the functional environment/Technical aspects.
• Used Informatica designer to create complex mappings using different transformations to move source data to a Data Warehouse.
• Prepared High level estimates, system integration support and worked in code migration activities moving the code from DEV/QA/PROD.
• Developed PL/SQL procedures/Packages for loading the data from stage table to Facts/Dimensions with complex transform logic.
• Involved in the OBIEE RPD creation for all the business markets.
• Developed Dashboards as per the business requirements
• Created complex mappings using various transformations like SQ, filter, sorter, aggregator, expression, union, joiner, router, SQL, Look up and various other transformations.
• Developed the ETL modules using Teradata BTEQ scripts, macros and other utilities such as fast load, multi load, fast export etc.
• Designed the ETL process and customized templates around Informatica and Oracle.
• Interacted with the business people on user requirements.
• Used debugger extensively to identify the bottlenecks in the mappings.
• Unit tested all conversions and interface mappings.
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.
• Used workflow manager to create workflows, sessions, and also used various tasks like command, email.
• Prepared the flow documentation for conversions and interfaces.

Environment: Informatica Power Center 9.1.1 Work Flow Manager, Work Flow Monitor, Oracle 11g, OBIEE,UNIX Shell Scripting, LINUX.

Details of the project in Cognizant June 2010 to Nov 2011

Confidential

Informatica Developer

Responsibilities:

• Understanding the entire source system.
• Worked on SQL Server, Teradata, Db2 sources and FLAT files.
• Migrated the Ingenix mainframe generated cobal data files from different regions in to WellPoint source system SQl server Database.
• Worked extensively in the development of SQl server stored procedures.
• Extensively worked on developing the Unix Hell scripts.
• Alter and fine tune existing mappings and resolved the performance bottle necks.
• Mentor the team members by providing assistance with the functional environment.
• Involved in stages like test case preparation, test log preparation.
• Coordinate with on-site to get requirements and executed at offshore successfully.
• Maintained and supported the complete batch process.
• Used Informatica Power Center to extract, transform and load data from various source systems Mainframe systems, VSAM to staging and target Data warehouse.
• Translate customer requirements into technical specifications and prepared ETL design documents.
• Effectively applied all the business requirements and transforming the business rules into ETL mappings.
• Actively involved in understanding business requirements, analysis and design of the ETL process.
• Used Informatica designer to create complex mappings using different transformations to move source data to a Data Warehouse.
• Worked as a lead to analyze the ETL work, preparing level of estimates, distribution, system test support and involved in code migration activities..
• Expertise in the development of process to Audit the existing ETL process and the controlling the jobs by using PL/SQL procedures to maintain complete status.
• Expertise in the design of ETL and developed mappings to load data into staging Oracle database to generate Surrogate Keys.
• Used aggregator, router, joiner, stored procedures, look up, filter, source qualifier and update strategy transformations extensively.

Environment: Informatica PowerCenter 8.6.1 Work Flow Manager, Work Flow Monitor, Oracle 10g,SQL Server, UNIX Shell Scripting, LINUX.

Confidential

Informatica Developer.

Responsibilities:

• Worked on Informatica Power Center 8.1.1 - Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Develop the Design docs based on the requirements.
• Analyzed the design specifications of the project, source target mapping matrix, maintained the naming conventions of the enterprise standard and customized.
• Worked on SQL Server, Teradata, Db2 sources and FLAT files.
• Involved in System Integration Testing, Unit testing and User Acceptance Testing
• Alter and fine tune existing mappings and resolved the performance bottle necks.
• Mentor the team members by providing assistance with the functional environment.
• Involved in stages like test case preparation, test log preparation.
• Coordinate with on-site to get requirements and executed at offshore successfully.
• Developed Mappings and Workflows for ETL Jobs, developed reusable scripts, transformations and Mapplets to use in multiple mappings.
• Tuned SQL queries, views using explain plan, tuning of Informatica mappings and configured for push down optimization.
• Created mapping parameters, variables in Informatica to handle the loading date's logic and Implemented Change data capture CDC to capture change data from the sources..
• Development of an automated process for loading the data into the base tables in EDW for ETL using Fast load, Multiload, Fast Export, BTEQ utilities of Teradata.
• Developed mappings to load data to partitioned tables and tuned for performance.
• Used the Normalizer transformation to extract source data from COBOL Source files.
• Written scripts for data cleansing, data validation, data transformation for the data coming from different source systems.
• Handled CR's Change Requests and enhancements for existing application.
• Developed UNIX shell scripts to run batch jobs in production.
• Extensively involved in Database testing by writing SQL queries and executing test cases to check the accuracy integrity of database field values as part of Testing.
• Involved in troubleshooting and fixing the defects which are identified by end users in UAT.
• Performed production deployment support and validated post-production environment.

Confidential

Informatica Developer.

Responsibilities:

• Developed various Mapplets, Transformations and was responsible for validating and fine-tuning the ETL logic coded into mappings.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target, Mapplets and Transformation objects.
• Created or edited existing Informatica mappings and sessions to accomplish data migrations. Sources were Oracle database and flat files and targets were flat files.
• Re-designed ETL mappings to improve data quality.
• Created and managed daily, weekly, cycle and monthly data operations, workflows and scheduling processes.
• Partitioned the sessions to reduce the load time.
• Responsible for validating the Informatica mappings against the pre-defined ETL design standards.
• Provided production support by monitoring the processes running daily.
• Developed Informatica mappings and also tuned them for better performance.
• Created Informatica mappings with PL/SQL Procedures/Functions to build business rules to load data.
• Designed and developed Oracle PL/SQL Procedures.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Performance tuning of Oracle PL/SQL Scripts.
• Designed and developed UNIX shell scripts.
• Optimized/Tuned mappings for better performance and efficiency
• Created complex joins, transformations of all types to pass data through ETL maps.
• Recommended tuning options to source/target database DBA team to gain optimum performance.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Used UNIX Shell scripting for automation of the process, invoking PL/SQL procedures, and Informatica sessions.
• Responsible for QA testing of all applications developed by the team.

Environment: Informatica PowerCenter 7.1/6.1 Work Flow Manager, Work Flow Monitor, Oracle 9i/10g, UNIX Shell Scripting, SQL, PL/SQL, COBOL, SQL Loader, TOAD, MS SQL Server 2000, UNIX, Windows NT 4.0.