SUMMARY:

• Around 7+ years of IT experience in the Design, Development, Implementation, Testing and Support of Enterprise Data Warehouse and Data Mart applications for Healthcare, Sales, Finance, using Informatica Power Center.
• Strong experience in ETL (Extraction, Transformation and Loading) process using different tools like Informatica Power Center (8.1.1/8.6.1/9.1 ), Informatica Power Exchange and Informatica Data Quality (IDQ).
• Performed ETL process to load data from different sources into data warehouse using Informatica Power Center (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Experience in integration of various data source databases like Oracle, DB2, Fixed Width Flat Files, Delimited Flat Files, Access and XML Files into staging area. And also involved in migration of data from different source DB to oracle DB.
• Extensively worked on Dimensional modeling, Data migration, Data cleansing and Data Staging of operational sources using ETL processes.
• Extensive experience in migration of data from legacy systems and also involved in Data Warehouse Development and Data Mart Life Cycle development.
• Experienced in Star - Schema data modeling, Data Cleansing, Logical and Physical data model design process.
• Actively involved in Performance Tuning, Error handling support on various Platforms.
• Experience in implementing update strategies, incremental loads and Change Data Capture (CDC).
• Designed and developed complex mappings and transformation logics using transformations like Lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more. Experience in execution of Sessions, workflows and worklets.
• Experience in designing and building the Business Objects Universe and Building WEBI Reports on Business Objects XI 3.1/4.0
• Experienced in creating reports using Web Intelligence, schedule the reports as per the business needs and supporting.
• Expertise in Client-Server application development using Oracle 11g/10g.
• Very good knowledge in designing database objects like Tables, Views, Constraints, Indexes and defaults.
• Experience in designing Data Models using Erwin 4.0/4.3 tool for both Relational and dimensional modeling.
• Proficiency on using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL*Loader.
• Good working knowledge of Data Acquisition, Data Integration and Data Loading.
• Experienced in ETL techniques and Analysis and Reporting including hand on experience with the Reporting tools such as Business objects.
• Extensively worked on 837 claim encounters mappings and state submission of files per CMS 5010/4010 specifications.
• Experienced on complete Software Development Life Cycle (SDLC) using various methodologies like Waterfall Model.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.

TECHNICAL SKILLS:

ETL: Informatica Power Center (9.6.1/8.6.1/8.1.1 ), Informatica Power Exchange, Informatica Data Quality(IDQ)

Database: Oracle 11g/10g/9i, Microsoft SQL Server 2000, DB2 8.1, MS Access 7.0/97/2000.

BI Tools: Business Objects XI 3.1/4.1

Data Modelling Tool: Erwin 4.0/4.3

Query Tools: SQL Developer, Toad

Languages: SQL, PL/SQL, UNIX, Java, C++

Scheduling Tools: IBM Tivoli,Autosys, Informatica Scheduler

Web Technologies: HTML, CSS, XML

Operating System: MS-DOS, Windows 95/98/NT 4.0/XP/2000/2003 Server/Vista/7, Unix, Red Hat Linux Enterprise 4/5

PROFESSIONAL EXPERIENCE:

Confidential

Sr.ETL Developer

Responsibilities:

• Gathering requirements, conducting a design overview, detailing ETL specifications, data analysis/troubleshooting, implementation tasks, and general mentoring.
• Identified data sources to work with source system developers and business owners for defining data extraction methodologies.
• Developed Mappings and Mapplets extensively using Informatica Designer tools - Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Transformation Developer.
• Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router, Rank, Union, Normalizer, Sequence Generator, Update Strategy, and Joiner.
• Developed sessions using Workflow Manager for loading data into target Database.
• Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks. Designing of Error Handling Strategies.
• Worked with Data / Data Warehouse Architect on logical and physical model designs.
• Supported users with word processing, spreadsheets, databases and presentation software.
• Data modeling and design of data warehouse and data marts in Snowflake and Star schema methodology with confirmed and granular Dimensions and Fact tables
• Maintaining the Metadata of the Data Model
• Keeping track of the changes and various version of Data Model intact.
• Involved in Creating and maintaining Universes by using Universe Designer module to include objects like Dimensions, Details and Measures according to the Functional specifications.
• Developed Universes by linking different data sources.
• Created Aliases and Contexts for resolving Loops and checked the cardinality and Integrity.
• Resolved data mismatch issues that are raised from end users.
• Created Web Intelligence Documents by writing SQL Queries for Derived tables in the universe as per the Functional Specifications.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.
• Developed various Charts, Graphs and drill down reports in webi (Web intelligence).
• Developed, executed, documented Unit test plans and validating the results with Business Analyst and Customer.
• Performed migration of mappings and workflows from Development to Test and to Production Servers.
• Scheduled walkthroughs of design documents, specifications, code, test plans etc. as appropriate throughout project lifecycle.
• Worked with DBA to set up development, test and production environments.
• Involved in analyzing database schema. Performed impact analysis for systems and database modifications.

Environment: Informatica Power Center 9.6.1, Oracle 11g, SQL Server 2000, MS Access, Windows XP, Linux, Business Objects XI 3.1/4.1, UNIX, Toad.

Confidential

Sr. ETL Developer

Responsibilities:

• Participated in requirement meetings with Business Analysts to understand analytical content needs, assisted in documenting these requirements, resolving ambiguities, conflicts, and ensuring requirements are complete.
• Ensures proper configuration of the Power Center Domain components. Experience in nodes, Repository services, Integration services, and Reporting Services.
• Worked with Data / Data Warehouse Architect on logical and physical model designs.
• Developed Mappings and Mapplets extensively using Informatica Designer tools - Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Transformation Developer.
• Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router, Rank, Union, Normalizer, Sequence Generator, Update Strategy, and Joiner.
• Created reusable transformations and Mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer and Mapplet Designer, respectively.
• Performed impact analysis for systems and database modifications.
• Analyzed data values, relationships from legacy systems, relational databases, non-relational databases, ERP systems, file formats to check compliance with existing standards and business rules.
• Extracted data from different sources such as SQL Server 2000, DB2, Oracle, Fixed width and Delimited Flat files to load into Operational Data Store (staging area).
• Developed pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables.
• Optimized performance by tuning the Informatica ETL code as well as SQL.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Developed shell scripts, which will invoke the Informatica Power Center workflows passing all the variables for the job to execute like user id, password.
• Developed, executed, documented Unit test plans and validating the results with Business Analyst and End User.
• Performed migration of mappings and workflows from Development to Test and to Production Servers.
• Running and monitoring daily scheduled jobs by using Work Load manager for supporting EDW (Enterprise Data Warehouse) loads for History as well as incremental data.
• Investigating failed jobs and writing SQL to debug data load issues in Production
• Used Autosys to schedule Informatica workflows and UNIX scripts to automate jobs.
• Optimized the performance using PL/SQL table types and record types.

Environment: Informatica Power Center 9.1, Business Objects XI 4.1, Oracle10g,SQL Developer, PL/SQL, SQL Server 2000, Windows NT, Oracle Linux v5, Autosys.

Confidential

ETL Developer

Responsibilities:

• Gathering requirements, conducting a design overview, detailing ETL specifications, data analysis/troubleshooting, implementation tasks, and general mentoring.
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Providing in-depth technical consultation to ensure development of efficient application systems by utilizing standard methodologies and best practices.
• Writing program specifications and developing mappings.
• Created the mappings according to technical design document and ETL documents.
• Hands-on expertise over transformations like Source Qualifier, Lookup, Expression, Filter, Router, Sequence Generator, Update Strategy etc.
• Designing and implementing schemas for reference data, Change Data Capture, process control and audit balancing.
• Did code reviews for the fellow team members to follow company standards.
• Extracted data from various source systems like relational data bases, Flat files and load data into the database after performing certain validations.
• Full technical support for Project to UAT testing team.
• After each post data load, analyzing and fixing the defects raised by UAT team.
• Ensuring the zero down time for the ETL system with strong 24x7 support by helping junior team members.