SUMMARY

• Overall 7+ years of experience in software design and development, Project Implementation.
• Expert in using Informatica Power Center 9.0.1,9.5,9.6, SQL, UNIX, Shell scripting
• Worked on all the Transformations like Lookup, Aggregator, Expression, Filter, Update Strategy (Implemented slowly changing dimensions Type1 and Type2), stored procedure, Sequence Generator, Sorter, Rank and Router.
• Having knowledge in full life cycle development of Data Warehousing Project.
• Expertise in designing ETL Architecture, Error Handling Strategies, Trouble Shooting, Unit Testing and system testing, QA and Writing Technical Specification Documents and designing test cases.
• Good knowledge of Data Analysis, Data Profiling and Data Modeling.
• Experience in integrating data in variety of modes such as Message queue (XML messages), direct connection, flat files, COBOL files (Mainframe).
• Comfortable in DWH Technologies like Metadata Management, Dimensional Modeling, Star Schema data modeling, Snow flaking, Late arriving dimensions, Rollup and aggregation strategies and data mart creation.
• Extensively involved in End to End solution design involving design of end to end extract, transform and load processes with data coming from heterogeneous source systems to target systems.
• Extensively used ETL methodology for supporting Data Extraction, transformation and loading processing, in a corporate - wide-ETL Solution using Informatica.
• Performance Tuning of ETL mappings using best practices like push down optimization, avoiding memory and CPU intensive transformations like Aggregator and Ranker.
• Performance Tuning of SQL and PL/SQL code using techniques like Bulk Collection, Merge Statement, inline views, parallelization, using Hints etc.
• Good experience in implementing SQL analytical functions such as rank (), row number (), GROUP BY CUBE and GROUP BY ROLLUP
• Good knowledge of forward and reverse engineering
• Ensuring Informatica best practices based on velocity guidelines.
• Good experience in facing the client, Requirement gathering and Analysis of the proposed Business requirements.
• Good experience of Clinical data and development procedures and Retail pharmacy system
• Very good experience in heterogeneous data sources and integrating their data in target data warehouse layers.
• Experienced in Financial Services, Health Care and Retail pharmacy, and Life Science domains. Good understanding of Clinical data
• Demonstrated ability to quickly grasp new concepts, both technical and business related and utilize as needed.
• Excellent attitude towards teamwork.
• Worked extensively in team oriented environment with strong analytical, interpersonal and communication skills.

TECHNICAL SKILLS

System Design & Development: Requirements gathering, Gap Analysis, Design, Development and Implementation

Technical: ETL Design / Architect, Development, Testing, Tuning and Scheduling, SQL Tuning

Languages, Software and Tools: Informatica Power center 8.x, 9.x, UNIX, Toad

RDBMS: Oracle 10g/9i

Operating Systems: UNIX, Windows NT/2000/XP

Business Areas: Financial Services - Trade Surveillance

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Work with BA/users to finalize the requirements.
• Create High level & low level design for the ETL process
• Work with data profiling and analysis on source data using customized queries and third party tools such as Trillium Discovery
• Evaluate various technologies to employ data quality solutions
• Evaluate the quality of data and workout strategies to handle Late arriving dimensions and conforming values
• Manage a team of developers and QA resources and ensure a seamless coordination between various groups.
• Translating the ETL requirements into physical design
• Defining the process flow for the entire development cycle and QA cycle
• Do peer review for code
• Guide fellow designers and developers to resolve complex scenarios
• Deciding best practices and standards for the ETL process and making sure that they are being followed.
• Chalk out extensive error handling and reporting strategy
• Creating shell scripts to preprocess the source provided data files.
• Write PL/SQL function and procedures to implement complex recursive logic.
• Fine tuning the PL/SQL code for performance
• Fine tune the ETL code for performance gain
• Work with release management team to ensure seamless code migration and version control of the developed code
• Coordinate with offshore team to get the code developed and meet project milestones.
• Work with 3rd party vendors such as Informatica and oracle to meet tool level challenges
• Design the Autosys jobs and schedule the data load strategy.
• Verify the test plan and test results prepared by testing team
• Analyze defects raised by users and fix them working with complex financial Instruments such as Equities, ETFs, FI instruments such as Mortgages and BONDS etc.

Environment: Linux 64-bit, Oracle 11g, Informatica PowerCenter 9.5.

Confidential

ETL Data Analyst

Responsibilities:

• Analyze reported data issues and inconsistencies.
• Streamline the current system design where possible.
• Evaluates data mining request requirements and help develop the queries for the requests.
• Write complex SQL queries to pull and analyze data from large relational databases.
• Perform analysis on existing data and identify root causes for data inaccuracies.
• Analyzing Business requirement specifications and identifying the source data and transformations that needs to be applied in the process of moving data to target database
• Preparation of High level design and ETL Technical specifications
• Identifying Fact and dimension tables and Primary key foreign key constraints on the basis of data profiling
• Figuring out various error handling strategies to be adopted during cross system data migration.
• Working on Informatica - Repository Manager, Designer, Workflow Manager & Workflow Monitor
• Maintain, improve and support current ETL and data integration processes.
• Respond in a timely manner to data requests to ensure daily, weekly and monthly deadlines and goals are met.
• Analyze data and create detailed reports utilizing proprietary tools and third party technologies to identify and resolve data quality issues to ensure quality assurance and drive data quality initiatives.
• Involved in discussing Requirement Clarifications with multiple technical and business teams
• Impact analysis of scheduled source and target changes on the Data warehouse components. Formulating tactical and strategic solutions to accommodate these changes.
• Formulating exhaustive Informatica metadata queries to establish data lineage across various layers of data warehouse.
• Use SQL, PL/SQL to validate the Data going in to the Data Ware House
• Creating complex data analysis queries to troubleshoot issues reported by users.
• Working with various project managers and business users to sort out any potential impact of scheduled changes in business logic on the system from data acquisition to downstream views and reports.
• Validating business rules using Trillium discovery

Environment: Sun Solaris 32-bit, Oracle 9i, Informatica PowerCenter 9.1, Informatica Metadata manager, Trillium Discovery.

Confidential

ETL Data Analyst

Responsibilities:

• Analysis of existing Source System, Business Flow & Target System using given Functional Document.
• Designed the Mappings according to the Mapping Design Document.
• Developed ETL mappings, transformations using Informatica Power Center.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression.
• Involved into source code review, the mappings created by my team members.
• Prepared deployment document and assisted to deployment team while migration.
• Involved in creating test cases
• Mappings were designed to cater the slowly changing dimensions.
• Developed several reusable transformations and Mapplet that were used in other mappings.
• Used Pre and Post Session SQL statements to drop and recreate the indexes.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed sessions.

Environment: Windows 32-bit, Oracle 10g, Informatica PowerCenter 8.6, Informatica Metadata manager, Trillium Discovery.

Confidential

ETL Data Analyst

Responsibilities:

• Analysis of existing Source System, Business Flow & Target System using given Functional Document.
• Designed the Mappings according to the Mapping Design Document.
• Developed ETL mappings, transformations using Informatica Power Center.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression.
• Involved into source code review, the mappings created by my team members.
• Prepared deployment document and assisted to deployment team while migration.
• Involved in creating test cases
• Mappings were designed to cater the slowly changing dimensions.
• Developed several reusable transformations and Mapplet that were used in other mappings.
• Used Pre and Post Session SQL statements to drop and recreate the indexes.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed sessions

Environment: Windows 32-bit, Oracle 10g, Informatica PowerCenter 8.6, Informatica Metadata manager, Trillium Discovery.