SUMMARY

• 6 years of experience in Information Technology Industry with the specialization on Data warehousing using Informatica Lifecycle Development and Database development
• Well versed in all vital phases of the Software Development Life Cycle, including preparing development strategies, analysis, design, development, program specifications, coding, test plans & testing, deployment
• Experienced in Design, Development and Administration of ETL methodologies using Informatica Power Center 8.x/9.x/10.x with the good domain exposure to business systems like Health Care and Property and Casualty Insurance
• Well experienced in working with Informatica Power Center - Designer, Repository Manager, Workflow Manager, and Workflow Monitor
• Worked in Informatica Web service using XML Generator, XML Parser
• Well versed with various Informatica transformations and implemented number of complex mappings
• Working experience in using Informatica Workflow Manager to create and schedule workflows and Worklets.
• Extensive experience in Extraction, Transformation and Loading of data from heterogeneous source systems like Flat files, Excel, Teradata, Oracle and SQL Server
• Extensively worked on Informatica Designer Components - Source Analyzer, Target Designer, Transformation Developer, Mapplet and Mapping Designers.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Work lets Designer.
• Experience in integration of various data sources like Relational Data base tables like Oracle, Teradata and Flat files into staging area
• Experienced and good knowledge in Data warehousing
• Data modeling knowledge using Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables.
• Worked with views & materialized views, UTIL File, SQL Loader
• Good in communication and interpersonal skills
• Worked closely with business users at various stages of software development life cycle, including Requirement gathering, Design, Development and supporting during Test phases
• Worked as an individual contributor as well as a team player

TECHNICAL SKILLS

ETL Tool: Informatica Power Center 10.x/9.x/8.6

Databases: Oracle 11G/10G, Teradata, DB2

Programming Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting

Database Tools: WinSQL, SQL Developer, AQT, Toad, TD Studio

Other Tools: Quality Center, JIRA, CA Agile, uDeploy

PROFESSIONAL EXPERIENCE

Confidential, Windsor, CT

ETL Developer

Responsibilities:

• Participating the requirements walkthroughs and identifying the scope of the ETL project
• Analyzing the source data after receiving the requirements and raising the issues to System’s analyst or Product Owner
• ETL development using Informatica Power center. Mapping development, Sessions and Workflows creation
• Including data transformation and business rules into the Informatica mappings.
• Worked extensively on different types of transformations like Source qualifier, Joiner, Expression, Router, filter, Update strategy, Lookup, Sorter, Normalizer, Aggregator and Sequence generator
• Developed the mappings to load the data on to SCD Type-2 tables to maintain the history of the data
• Worked on the mappings with Source as Flat/CSV files, Oracle and Teradata tables, to load the data on to Warehouse Oracle tables and generating the flat and CSV files.
• Unit testing the mappings in DEV environment, publishing the Unit testing results and deploying the mappings on to System and INT environments.
• Supporting the System Testing and Integration Testing by resolving the issues reported by testing team
• Worked on the various mappings to load the data from Staging to Warehouse (CSA) based on the different business rules for the QANI, Mental Health Parity and Client RDS to MLR.
• Defect analysis, defect resolution and re-deploying the code into the corresponding environment

Environment: Informatica 10.2.0, Oracle 11G, OS: Windows, Other tools: SQL Developer/Toad Oracle and uDeploy

Confidential, Minnetonka, MN

ETL Developer

Responsibilities:

• Involved in Analysis, Requirements Gathering, Design, Development and also fixing the defects raised by Integration testing team
• Analyzed source data and reporting the issues in the mapping requirements
• Creation of mappings on Informatica Power Center 9.1 based on functional ETL requirements
• Contributing to the high level design document for each mapping
• Preparation and Execution of Unit Test cases
• Worked extensively on SQL using TOAD and SQL Developer tools.
• Supporting the QA teams during the Testing phases and analyzing the issues reported
• Defect analysis, defect resolution and re-deploying the code into the corresponding environment

Environment: Informatica Power Center 9.1, AutoSys, Oracle 10g

Confidential, Madison, WI

ETL Consultant

Responsibilities:

• Co-ordination with System Analyst/Product Owner and Scrum team during the development life cycle for smooth sailing of the project
• Scope Identification/requirement gathering by attending the requirement walkthroughs.
• Understanding and giving the inputs for the Designs. Participating in the Architecture and Design reviews given by the ESAs and IDAs.
• Analyzing the source data from Policy Center system against the Mapping Specification and discuss with SA for any queries
• ETL development using Informatica Power center. Mapping development, Sessions and Workflows creation for the Advance Auto Projects.
• Providing clarifications to offshore team about technical specification documents including data transformation and business rules.
• Worked extensively on different types of transformations like Source qualifier, Expression, Router, filter, Update strategy, Lookup, Sorter, Normalizer, Aggregator and Sequence generator
• Developed the mappings to load the data on to SCD Type-2 tables, which maintains the history of the policy data for multiple terms.
• Worked on the mappings with Source as Flat files, Oracle tables, Mainframe Flat file to load the data on to Warehouse Oracle tables, Mainframe files and Generating the flat file.
• Unit testing the mappings in DEV environment, publishing the Unit testing results and deploying the mappings on to INT environment after the INT environment setup.
• Supporting the Integration testing by making the data available for testing teams

Environment: Informatica 9.0.1, oracle 10G, OS: Windows, Other tools: SQL Developer, WinSQL and AutoSys