SUMMARY

• Result oriented professional with 8 years of comprehensive data warehouse design and development experience, with full life cycle knowledge of data warehouse methodologies, ETL and data modelling.
• Strong knowledge of OLTP and OLAP Database implementations.
• Extensive experience in developing ETL processes in various database models(Star Schema and Snowflake Schema)
• Presently in the role of an ETL Specialist with experience in creation of ETL programs using Informatica Suite of tools (PowerCenter, Power Exchange for Mainframe and Metadata Manager)
• Strong experience in ETL basic administration (Code Promotions, Performance & Tuning, User roles and Privileges)
• Good knowledge of BI tools like Cognos 8/10 and well versed with RDBMS like Oracle 8i/9i/10g, DB2 and Vertica 6.1 technologies.
• Strong SQL programming skills and experience in fine tuning and troubleshooting performance issues.
• Facilitated workshops and coordinated with the business users in defining user requirements and the scope of the projects/enhancements.
• Experience in building test plans and test cases for all unit and system integration testing activities.
• Coordinated the end user testing (UAT) with the testers and maintained the defect tracking logs.
• Conducted production readiness activities by preparing the check list of pre - requisites and post implementation checks, documenting rollback procedures.

TECHNICAL SKILLS

Data Integration Tools: Informatica PowerCenter 9.5/9.1/8.6/8.1/7.1 (Repository Manager, Designer, Server Manager, Workflow Manager, Workflow Monitor), Informatica Data Quality 8.6.1(Analyst, Developer, Administrator) Power Exchange for Mainframes (Navigator, Data Maps), Metadata Manager (X Connects, Lineage, Impact Analysis)

Business Intelligence Tools: Cognos 10/8.4/8.3/8.2 (Metric Studio, Report Studio, Query Studio, Analysis Studio, Power Play, Transformer, Framework Manager, Administration)

RDBMS: Oracle 10g/9i/8i.7.0,Vertica, DB2 UDB, MS-Access

Programming Languages: SQL and Basic UNIX Shell Scripts.

Operating Systems: Windows 95/98/2000 Server and AIX

PROFESSIONAL EXPERIENCE

ETL Specialist

Confidential

Environment: Windows,AIX 5.3, Vertica

Responsibilities:

• Excellent skills in requirement gathering by talking to various source systems as well as business users.
• Have the ability to interact with the customers at all levels.
• Excellent skills in design and develop robust, high performance and complex ETL systems
• Excellent skills in developing complete shell scripting framework to interface with Vertica DBMS. This included functions to efficiently parallelize insert-direct loads, execute multiple single threaded insert-directs in parallel
• Excellent skills in designing and develop complex data calculation and aggregation engines on Vertica using insert-directs
• Excellent skills in Tuning and resolving critical performance issues on a regular basis related to Vertica ETL and reporting SQL, Informatica ETL code, and Oracle.
• Extensively worked with all the transformations (Expression, Lookup (Connected and Unconnected), Joiner, Union, Normalizer, Update Strategy) etc., to meet the business requirements.
• Created reusable Transformations mainly Lookup, Sequence Generator and expression and used across multiple projects as they share common logic between them.
• Created complex Mappings and used reusable Transformations for efficient dataflow between Source and Target Definitions.
• Used Source Qualifier for overriding the SQL and applying Source Filter at the beginning of the process for improving the performance.
• Implemented Slowly Changing Dimensions in the mappings as per the data model of the Data mart.
• Extensively used Debugger Process in resolving issues in Development and Testing phases.
• Utilized Database Partitioning option with DB2 partitioned databases to increase the performance significantly.
• Created sessions, worklets and workflows and organized the processes according to· the requirements.
• Created Pre / Post Session Instructions using a command Task and embedded them in the workflow.

ETL Developer

Confidential

Environment: AIX 5.3, DB2 9.5 Informatica 9.1/8.6 Suite, Cognos 10/8 Suite

Responsibilities:

• Extracted data sources from Operational Source systems and other data stores.
• Created Informatica Folders with proper permissions (both personal and project folders).
• Maintained Groups and Users and assigned proper privileges depending on roles and responsibilities in the project.
• Implemented the Versioning feature and created Deployment Groups (both static and dynamic) for moving the objects from development to Production.
• Improved Performance by utilizing the partitioning option on the DB2 Databases.
• Automated Scheduling of Sessions using Scheduler and use of triggering mechanism.
• Worked on the cleanup process of reducing the redundant objects such as Source Definitions, Database connections etc., by using shortcuts and removing excess definitions and connections.
• Created reusable objects such as (Mapplets, Worklets, Transformations, Commands etc.) so that they can be reused in multiple projects.
• Established ETL development guidelines to enable common practices across all the programmers which helped in consistent coding methodologies.
• Extensively worked with all the transformations (Expression, Lookup (Connected and Unconnected), Joiner, Union, Normalizer, Update Strategy) etc., to meet the business requirements.
• Created reusable Transformations mainly Lookup, Sequence Generator and expression and used across multiple projects as they share common logic between them.
• Created complex Mappings and used reusable Transformations for efficient dataflow between Source and Target Definitions.
• Used Source Qualifier for overriding the SQL and applying Source Filter at the beginning of the process for improving the performance.
• Implemented Slowly Changing Dimensions in the mappings as per the data model of the Data mart.
• Extensively used Debugger Process in resolving issues in Development and Testing phases.
• Utilized Database Partitioning option with DB2 partitioned databases to increase the performance significantly.
• Created sessions, worklets and workflows and organized the processes according to· the requirements.
• Created Pre / Post Session Instructions using a command Task and embedded them in the workflow.
• Extensively used Timer, Command, Event Wait and Email tasks within the workflow to automate the process to the maximum extent.
• Worked with the project team and business counterparts in gathering project requirements and deliverables.
• Proactive in communicating and collaborating with various business units to analyse information needs, functional and system requirements.
• Assisted in obtaining the project estimates from the appropriate team members to ensure project is on track.
• Created Records and Tables Definitions of Mainframe Files using Navigator (used Copybooks if available else created manually).
• Imported Power Exchange Source definitions and integrated into PowerCenter for further processing.

ETL Developer

Confidential

Environment: Windows NT/2003, Oracle 10g, AIX 4.7 Informatica Power Center 8.1/7.1, SQL Development, Cognos Suite

Responsibilities:

• Extensively worked with all the components of PowerCenter (Repository Manager, Workflow Manager and Designer).
• Worked with different components of Designer (Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer and Mapping Designer).
• Created Manual Source Definitions & Target Definitions and worked with multiple sources / targets such as Relational Tables, Flat Files, Excel Source Definitions
• Created various transformations like Aggregator, Expression, Filter, Lookup, Update Strategy, Sequence Generator etc.,
• Created Mappings and used Transformations for efficient dataflow between Source and Target Definitions.
• Validated the mappings for checking the Source/Target Connections, Data type Compatibility and Expression Validation for writing the errors to Output Window.
• Created Mapping Parameters and Variables and provided Initial and Default values.
• Extensively used Debugger Process to troubleshoot data discrepancies by applying break points at the appropriate places.
• Worked with Mapping wizard and Created Simple Pass through and Slowly Growing Target Mappings using Lookup tables.
• Created Folders and organized the data, analyzed Source/Target Dependencies.
• Setting up Database Connections for Source and Target Definitions.
• Created and Imported Sessions for validating and running the existing mappings.
• Provided Security to Repositories thru User Groups, Repository Users, Privileges, Folder Permissions and locking mechanisms.
• Performed Incremental Aggregation, checking Source/Target Input/Output Efficiency.
• Assigned appropriate memory (Caches) requirements for Lookup, Aggregator and Rank caches for Optimum Performance.
• Grouped Sessions and run as Concurrent Batches/Nested Batches for Parallel Processing.
• Automated Scheduling of Sessions at various intervals using Shell Scripts (Cron Jobs).

ETL Developer

Confidential

Environment: Windows NT/2003, Oracle 8i Informatica PowerCenter 7.1, SQL Development, Cognos Suite

Responsibilities:

• Worked with different components of Designer (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer).
• Created single source & target definitions in a shared folder and let the users use the shortcuts, eliminating redundancies in the source / target objects.
• Extensively used Debugger Process to modify data and applying Break Points while Session is running.
• Assigned appropriate memory (Caches) requirements for Lookup, Aggregator and Rank caches for Optimum Performance.
• Created command line programs (PMCMD) for integrating with third party schedulers and automating the backup procedures
• Established ETL development guidelines to enable common practices across all the programmers which helped in consistent coding methodologies
• Followed the best practices as recommended by the vendor and leveraged the velocity templates for ETL design activities.
• Extensively worked with all the transformations (Expression, Lookup (Connected and Unconnected), Joiner, Union, Normalizer, Update Strategy) etc., to meet the business requirements.
• Implemented slowly changing Dimensions in the mappings per the data model of the Data mart.