SUMMARY

• Over Six years of experience in the field of Information Technology, with extensive experience in analysis, design, development and implementation Data Warehouses, Data marts using Informatica power center with Oracle, MS SQL server, DB2, Teradata databases.
• Extensively worked on Relational Databases SystemslikeOracle 11g/10g/9i/8i, MS SQL Server, Teradata. Also worked on various Source files like flat files, XML files and COBOL files.
• Well versed in administrative, development aspects of Informatica MDM 9.5, Informatica MDM Hub 9.5, IDD Developer 9.5 tool, Power Center, Power exchange and B2B exchange
• Worked on different versions of Informatica Power Center such as 7.1/8.1/8.6/9.1/9.5.1/9.6.1.
• Strong knowledge of Data warehousing concepts, dimensional Star Schema and Snowflake schema methodologies, FACT tables, Dimensional tables.
• Was responsible for understanding User requirements and translating those requirements into well designed solutions.
• Was responsible in Test data management (TDM) for SIT & Regression testdata warehouse projects.
• Extensive experience with ETL Informatica Power Center Client tools in designing and developing Mappings, Mapplets, Sessions and Workflows.
• Experience in creating Transformations and Mappings usingInformaticaDesigner and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Extensively worked on Informatica Power Center Transformations such as re - usable transformations and mappings/mapplets, Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
• Expertise in developing Slowly Changing Dimensions mappings (Type1, Type2) and Change Data capture.
• Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informaticadebugger to identify issues in mapping execution.
• Performed ETL procedure to load data from different sources into data marts and Data Warehouse using Power Center. Experience in working with scheduling tools like Autosys, Tidal and Control-M.
• Experience in Debugging / Optimizing / Tuning Informatica mappings for better Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Strong knowledge in using SQL * loader, materialized views, Export and import utilities.
• Quick learner with ability to master new concepts and applications.
• Expertise in writing DDL, DML, DCL and TCL commands.
• Expertise with SQL, PL/SQL, UNIX commands and writing shell scripts.
• Good knowledge in tuning with push down optimization.
• Worked with TLOAD,MLOAD, FASTLOAD, TPT, FAST EXPORT and BTEQ utilities of Teradata for faster loading and to improve the performance.
• Successful in meeting new technical challenges and finding solutions to meet the needs of the client
• Highly motivated team player with excellent analytical &problem-solving skills possessing the ability to effectively communicate with higher management and stake holders.
• Good knowledge in converting HL7 format files claims to XML files using parser in B2B data transformation.

TECHNICAL SKILLS

Operating System: Windows, UNIX and LINUX

Database: Oracle 11g/10g/9i/8i, Microsoft SQL server, Teradata.

Database Tools: TOAD 11.5/10.5/10.1 , SQL *Loader, SQL Assistant.

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

ETL Tools: Informatica 7.x,8.x,9.x(Power Center), Power Exchange, Informatica Data Quality.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, Virginia

Informatica/Teradata Developer

Responsibilities:

• Analyze the scope document, understand requirements, and identify the impacted scripts on a high level.
• Create a list of open queries for BSA and track it to closure.
• Interacted with the client to understand the business requirements in particular with MDM requirements for Address, Address Units, Company site and Other Party Site
• Developing validation, cleanse functions and message bundles and testing user exits developed by user exit developers for Address, Address Unit, Company site and Other Party Site MDM Hub 9.5 and MDM IDD 9.5 Development tool
• Prepared Technical Specification Document and identified all impacted objects in detail (WLM changes, Model changes, Scripts, etc.). Ensured that there is traceability for each requirement.
• Present the Technical Design Document to all Stake Holders and finalize the implementation plan.
• Retrieve latest codes (scripts, list files, parameter files, workflows, etc.) from PROD. Ensured that codes are compared between SIT, IR and PROD. Used Script Compare tools to avoid errors caused by manual check.
• Communicated with Source Team on the required data that will be used for testing.
• Executed all test cases and documented the results.
• Worked closely with DA and DBA to publish DB objects.
• Investigated and responded back with root cause and resolution steps for observations raised by Testing Team.
• Involved in creating the Teradata BTEQ scripts and used the Teradata tools (Fast load and multi load) to load the data.
• Worked on Control M and WML (Work Load Manager) tool to create jobs and scheduling runtime of jobs.
• Developed scripts for $N tables, backup tables, work tables, global temporary tables and volatile tables.
• Saved new and modified scripts as a version tracker using clear case tool.
• Experienced in production deployment activities.
• Created informatica work flow to load text format files.
• Performed regression testing.
• Loaded source files using Loader (Fast Load and M Load) and Relational connections.
• Validate PROD Environment after each release and take an appropriate action.

Environment: Informatica Power Center 9.6.1, TSRM, Oracle 11g, XML, UNIX Shell Scripting, Teradata 13/14, Control-M, WLM, Teradata sql assiant.

Confidential

Informatica Developer

Responsibilities:

• Involved in design and development of Business Requirements in liaison to business users and Technical teams by gathering requirement specification documents and identifying data sources and targets.
• Analyzed application requirements and provided recommended design and studied the current system to understand the existing data structures.
• Participated actively in user meetings and collected requirements from users.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files, XML Files, HL7 Files to target Oracle Data Warehouse database.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and from the relational database, which was Oracle 11g.
• Worked Informatica power center tools like source analyzer, mapping designer, mapplet and transformations
• Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier,UDT(unstructured data transformation), connected and unconnected look up, expression, aggregator, joiner, filter, normalizer, rank, router transformations, lookup caches like static cache, Dynamic cache, union and Stored procedures.
• Worked on configuring the Java class path in the session properties while using third-party Java packages, built-in Java packages, and custom Java packages in a Java transformation and in Java SDK Custom transformation.
• Source data analysis and data profiling for data warehouse projects.
• Good knowledge in converting HL7 format files claims to XML files and parsing HL7 files in B2B Data Transformation.
• Design and implement all stages of data life cycle. Maintain coding and naming standards.
• Developed Star schema as per business requirements.
• Used HL7 spy for analyzing HL7 flat files and ran queries to analyze source data issues.
• Extensive worked on Informatica 9.6.1 (mappings, session, workflow) in creating various mappings focusing on SCD2 and SCD1 implementation.
• Developed Re-Usable Transformations, Re-Usable Mapplets, sessions and workflows for designed mappings.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Worked on ETL strategy to store data validation rules, error handling methods to handle both expected and non-expected errors and documented it carefully.
• Used Update Strategies for cleansing, updating and adding datato the existing processes in the warehouse.
• Designed and developed UNIX shell scripts as part of the ETL process.
• Scheduled Jobs using scheduling tools likeControl-M.
• Created the Test cases and Captured Unit Test Results.
• Migrated Informatica objects from Development to Testing and Production environments using deployment groups.
• Recommended temporary fixes and workarounds for production issues and also proposed permanent fixes.
• Involved in Performance Tuning by determining bottlenecks at various points like targets, sources, mappings, sessions, or system. This led to better session performance.
• Used session partitions, dynamic cache memory, and index cache to improve the performance.

Environment: Informatica Power Center 9.6.1,HL7 files, Oracle 11g, XML, UNIX Shell Scripting, Control-M, Toad 11.5.