SUMMARY

• Software professional with around 6 years of IT experience in the analysis, design and development, testing of Data warehouse and Business Intelligence applications using, Informatica, Oracle, Teradata.
• Experience in Data Warehouse concepts, development methodologies and design and dimensional modeling experience with Star schema, snowflake schemas.
• Hands-on experience using Informatica for building data warehouses and integrating different data sources.
• Experience in Data Warehouse development working with Data conversion, Data Quality and ETL using Informatica ,Oracle, Teradata.
• Extensively worked on Power Center Designer Source Analyzer, Warehouse designer, Transformation Developer, Mapping Designer and Mapplet Designer .
• Achieved Oracle 9i Certified Associate and strong experience in SQL, PL/SQL and Teradata utilities Fload, Tpump,Mload , Bteq.
• Expertise in Query Analyzing and Performance Tuning.
• Experience in developing Fact tables, Dimension tables and Slowly Changing Dimensions
• Hands-on-Experience in preparation of ETL Design Specs, Unit Test Cases, Audits and Deployment forms.
• Worked on ETL development projects with multiple team members, providing mentoring, technical assistance, troubleshooting and alternative development solutions.
• Actively involved in Error and Exception handling on various ETL processes.
• Perform peer document reviews and code reviews to ensure adherence to user requirements as well as applicable standards and conventions.
• Ability to rapidly learn new concepts with excellent interpersonal skills and problem solving skills
• Team player with good interpersonal skills and the ability to work in team

IT Skills:

RDBMS : Oracle 9i, 10g, Teradata 12/13

ETL Tools : Informatica 9.x/8.x/7.x

Operating Systems : Unix, Linux, Windows

Data Modeling : Erwin 4.1

Scheduling Tools : Universe

Programming skills : .NET , SQL, PL/SQL, Unix Shell scripting

UI : Web designing, Photoshop

Professional Experience:

Confidential

Sr. ETL/Informatica developer

Environment

Informatica 9.1, Oracle 9i/10g, Teradata 12/13, Toad, Linux, Alliance remedy tool, Mercury Quality Center, Business objects, Universe.

Responsibilities:

• Analysis of the Business Requirements FRD Specifications.
• Designing detail ETL design Documents, column mapping documents.
• Developed the ETL mappings as per the architecture standards.
• Involved in Review meetings during Design Development to identify, reduce/mitigate risk at every stage.
• Extensive Development on Informatica Tool Mapping Designer, Workflow Manager and Workflow Monitor.
• Developed various Informatica mappings using complex transformations like Aggregators, lookups, Filters, Sequence Generator, Normalizer, Update strategy and stored procedure transformations.
• Involved in Data reconciliation of EDW environment.
• Post-Production support to monitor jobs in new environment, Oracle,Teradata.
• Studying and understanding of the Mapping documents.
• Analysis of the Source tables, columns and creating Target table definitions.
• Responsible for QA migration and Production Deployment.
• Implemented incremental extraction with use of parameters and variables from flat files in Linux.
• Involved in troubleshooting the scripts and providing the solutions.
• Work with QA team during testing phase to resolve the open defects.
• Worked on performance monitoring, tuning and optimization of ETL Loads.
• Support the code deployment phase during production go live and during the warranty period and give KT to Ops team on the whole assignment.
• Post production Support

ETL Developer

Confidential

Environment

Informatica 8.1.1, BO XI, Oracle 10g, Toad, Test Director, Remedy, Linux

Responsibilities:

• Used Extraction Transformation and Loading tool to transfer the data to the target Database.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Developed various Informatica mappings and mapplets using complex transformations like Aggregators, lookups, Filters, Sequence Generator, Normalizer, Update strategy and stored procedure transformations.
• Implemented Slowly Changing Dimension Type 2 in the logic.
• Involved in Performance tuning and elimination of bottlenecks for better performance.
• Responsible for Creating workflows, Created Session, Event, and Command, Control, and Decision tasks in Workflow Manager.
• Wrote shell scripts for extracting data from different sources like flat files, and oracle databases and for transformation of data.
• Involved in Unit, System integration, User Acceptance Testing of ETL Process.
• Responsible for delivering their report requests or needs, updating of the reporting database changes as it pertained to the Oracle database, creation of reports and exporting results.
• Mentored end users and technical users.
• Support the code deployment phase during production go live and during the warranty period and give KT to Ops team on the whole assignment.
• Post production Support

ETL Developer and Tester

Confidential

Environment

Informatica 8.1.1, BO XI, Oracle 10g, Toad, Test Director, Remedy, Linux

Responsibilities:

• Understanding the BRD and Functional Requirement document requirements and transform them into technical requirements.
• Created the ETL design documents and source to target column mapping documents.
• Worked on Source Analyzer, Warehouse Designer, Mapping Designer, and Transformations Developer.
• Developed various Informatica mappings and mappets using complex transformations like Aggregators, lookups, Filters, Sequence Generator, Normalizer, Update strategy and stored procedure transformations.
• Implemented Slowly Changing Dimension Type 2 in the logic.
• Involved in Performance tuning and elimination of bottlenecks for better performance.
• Responsible for Creating workflows and work lets. Created Session, Event, and Command, Control, and Decision tasks in Workflow Manager.
• Scheduling informatica workflows for extracting data from different sources like flat files, and oracle databases and for transformation of data.
• Involved in Unit, System integration, User Acceptance Testing of ETL Process.
• Responsible for creating the deployment documents for production deployment and post production activities.