SUMMARY:

• Over 4 years of experience in Analysis, Design, Development of various business applications in different platforms in data warehousing using Informatica 9.x/8.x/7.1/6.2, Oracle, Sybase, Teradata, SQL server.
• Extensive knowledge of various data sources like Oracle, Teradata, MSSQLServer, Flat files and HL7 files.
• Expertise in Data Warehousing, Data Migration, Data Integration using Business Intelligence (BI) tools such as Informatica Power Center, Power Exchange CDC, B2B Data Transformation, Informatica Data Quality, Informatica Data Integration, MDM, SSIS, OBIEE, Cognos, etc.,
• Extensive knowledge with Relational &dimensional data modeling, star schema/snowflakes schema, fact and dimension tables and process mapping using the top - down and bottom-up approach.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
• Coded several Shell Scripts for auditing UNIX in developing tools and system applications.
• Good exposure in Informatica MDM where data Cleansing,De-duping and Address correction were performed.
• Experience in Working with Informatica DVO (Data Validation Option) tool to Validate the archived jobs.
• Hands on experience with mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Aggregator,SQL transformation, Joiner, Update Strategy, Java Transformations and Re-usable transformations.
• Created ETL mappings using Informatica Power center to move Data from multiple sources like Flat files, Oracle into a common target area such as Data Marts and Data Warehouse.
• Good experience in Data Modeling concepts: Star Schema and Snow Flake Schema.
• Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using CDC/ SCD (Type1/Type2/Type3) loads.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Semantic layer.
• Extensive knowledge in Data Quality usingInformaticaIDQ (Developer and Analyst tools).
• Experience in PL/SQL Programming (Stored procedures, Triggers, Packages) using Oracle and have a good knowledge in Sybase.

TECHNICAL SKILLS:

ETL/DataModeling Tools: Informatica Power Center 9.6.1, 9.5.1/9.1/8.6.1/8.1/7.1/6. x (Repository Manager, Designer, Server manager, Work Flow Monitor, Work Flow Manager), SQL*Loader, SSRS, Tibco Spotfire, B2B (DT/DX), IDQ 9.X (Developer and Analyst tools)

RDBMS: Oracle 11g/10g/9i, DB2, Teradata, SQL Server, SQL, PL/SQL

Tools: DB Visualizer, SQL Assistant SQL*Plus, TOAD, SQL*Loader, TSA

Engagement Experience: Metadata Development/Customization, Applications Development, Application / Integration Testing, Report Development, ETL Development, Query Performance Tuning, Application Debugging.

Operating Systems: Windows XP/ 2008/2007/2003/ NT/98/95, UNIX, LINUX.

Environment: HTML, XML, SQL, PL/SQL, MYSQL, JavaScript

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

ETL Informatica Developer

Responsibilities:

• One of the responsibilities of being a senior developer is to involve in meetings with BA’s to derive the transformation rules that need to be applied for the identified sources.
• Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation
• Designing and implementing ETL environments using ETL strategies as well as tools Like Informatica Power Center 8.x/9.x, Power Exchange, Metadata Manager, IDQ and B2B.
• Filtered XML claims files by using filter conditions on D9 segment and converted back the filtered claims xml files to EDI format using serializer in B2B data transformation.
• Planned, created and executed Workflows to integrate data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
• Responsible for the Extraction, Transformation and Loading via Informatica 9.6.1 for RDBMS sources, and Informatica Power Exchange for Main frame files.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.
• Extensively worked with Slowly Changing Dimensions Type1 and Type2 for Data Loads and also used source qualifiers and adding left, outer and inner joins. We had cases where we need to apply pre SQL and post SQL in Informatica sessions.
• As part of moving them to persistent stage we have applied all the transformations that need to be done on individual fields and used Informatica Push down Optimization (PDO) for loading data faster.
• Creating Parameter files in UNIX environment and deploying them from dev to stage to production, creating and using parameters and variables and using them in workflows, also creating Informatica connections for workflows in all environments, deploy them.
• Created rules with Data Validation Option tool (DVO) to read metadata repositories to ensure data matches with validation option, to identify data inconsistencies.
• Worked with Offshore QA team by sharing resources & knowledge transfer on how to validate the results and extensively resolved defects up on basis of project standards with Unit test/UAT testing, Carried out end to end testing and supported UAT effort with immediate requirement document change/fixes/resolution for all changes/defects.

Environment: Informatica Power Center 9.6.1,MDM, Mainframe, B2B, IBM DB2, DT/DX, SQL Server, PL/SQL,DB Visualizer, SQL Assistant, TOAD, Data Validation Option(DVO),Autosys, UNIX/LINUX.

Confidential, Dallas, TX

ETL Developer

Responsibilities:

• Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse
• Involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.
• Design database table structures for transactional and reference data sources.
• Filtered XML claims files by using filter conditions on D9 segment and converted back the filtered claims xml files to EDI format using serializer in B2B data transformation.
• Source data analysis and data profiling for data warehouse projects.
• Successfully managed in setting up the data and configured the components needed by Hierarchy Manager for MDM HUB implementation which included in implementing hierarchies, relationships types, packages and profiles by using hierarchies’ tool in model workbench.
• Design and implement all stages of data life cycle. Maintain coding and naming standards.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Initiate the data modeling sessions, to design and build/append appropriate data mart models to support the reporting needs of applications.
• Design and develop data modeling concepts using various data modeling tools like star schema and dimensional modeling
• Extract data from heterogeneous data sources with multiple databases like Oracle, SQL Server, Fixed Width and Delimited Flat Files and transformed into a harmonized data store under stringent business deadlines.
• Used features like email notifications, scripts and variables for ETL process using Informatica Power Center.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM, Cleansed the data using MDM technique
• Involved in Data Extraction from Oracle and Flat Files using SQL Loader Designed and developed mappings using Informatica Power Center.
• Extensively worked on Data Cleansing, Data Analysis and Monitoring Using Data Quality.
• Written shell scripts for parameter files that needs to be used in Environment.
• Extensively used Transformations like Source Qualifier, Expression, Filter, Aggregator, joiner, and lookup, Sequence Generator, Router, Sorter and Stored Procedures, Java Transformations.
• Used debugger to test the mappingsand unit testedmappings.
• Involved in fixing of invalid Mappings, Performance tuning, testing of Stored Procedures and Functions, Testing of Informatica Sessions, Batches and the Target Data.
• Developed slowly changed dimensions (SCD) Type 2 for loading data into Dimensions and Facts.
• Coded highly complex SQL/PLSQL quires and written query plans andtroubleshooted quires that are created statistics on tables and optimized the run time for records that are gigantic.

Environment: Informatica Power Center 9.5.1, MDM, DB2,Mainframe, B2B,DT/DX, Oracle 11g,SQL Server 2000, SSRS, PL/SQL, TOAD, Data Validation Tool(DVO), Autosys, UNIX

Confidential

Jr. ETL Developer

Responsibilities:

• Involved in design and development of data warehouse environment, liaison to business users and/or technical teams gathering requirement specification documents and presenting and identifying data sources, targets and report generation.
• Used reverse engineering in Erwin 4.x to understand the existing data model of the data warehouse.
• Worked on Informatica Power Center 7.1 tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Optimized Query Performance, Session Performance and Reliability, did performance tuning of Informatica components for daily and monthly incremental loading tables.
• Used Normalizer, Router, Lookup, Aggregator, Expression and Update Strategy Transformations.
• Created complex workflows with multiple sessions and worklets with consecutive sessions.
• Used Workflow Manager for creating validating, testing and running sequential batches.
• Implemented source and target based partitioning for existing workflows in production to improve performance so as to cut back the running time.
• Involved in the Migration process from Development, Test and Production Environments.
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Wrote stored procedures and triggers in Oracle 9i for managing consistency and referential integrity across data mart.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Scheduled the batches to be run using the Workflow Manager.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Involved in migrating Informatica ETL application and Database objects through various environments such as Development, Testing, UAT and Production environments.
• Documented and presented the production/support documents for the components developed when handing-over the application to the production support team.

Environment: Informatica Power Center 7.1,Oracle9i,Erwin 4.x, MS SQL server 2005,Erwin, Robot,Toad 7.6, SQL, Unix Shell Scripting.