SUMMARY

• Over Eight 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 and netezza databases.
• Extensively worked on Relational Databases Systems likeOracle 11g/10g/9i/8i, MS SQL Server, Teradata and Netezza . Also worked on various Source files like flat files, XML files and COBOL files.
• Worked on different versions of Informatica Power Center such as 7.1/8.1/8.6/9.1/9.5.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.
• Extensive experience with ETL Informatica Power Center Client tools in designing and developing Mappings, Mapplets, Sessions and Workflows.
• Experience in creating Transformations and Mappings using Informatica Designer 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.
• Worked with NZSQL,NZLOAD utilities of netezza.
• 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.
• Worked on configuring the Java classpath in the session properties while using third-party Java packages, built-in Java packages, and custom Java packages in a Java transformation and also in Java SDK Custom transformation.

TECHNICAL SKILLS

Operating System: Windows, UNIX and LINUX

Database: Oracle 11g/10g/9i/8i, Microsoft SQL server, Netezza, 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, Pittsburgh, PA

Sr 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 also 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 classpath in the session properties while using third-party Java packages, built-in Java packages, and custom Java packages in a Java transformation and also 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.
• Worked with NZLOAD, NZSQL utilities of Netezza for faster loading and to improve the performance.
• Scheduled Jobs using scheduling tools like Control-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, Netezza.

Confidential, Chicago, IL

Sr Informatica Developer

Responsibilities:

• Interacted actively with Business Analysts on mapping documents and design process for various sources and targets.
• Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected look up, expression, aggregator, joiner, filter, normalizer, rank, router transformations and lookup caches like static cache, Dynamic cache.
• Used Netezza as one of the source.
• Worked Informatica power center tools like source analyzer, mapping designer, mapplet and transformations.
• Developed Informatica mappings and also tuned for better performance.
• Worked with MLOAD, FASTLOAD and BTEQ utilities of Teradata for faster loading and to improve the performance.
• Extensively used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, and IIF function.
• Responsible for Performance Tuning at the Mapping Level and Session level.
• Worked with SQL Override in the Source Qualifier and Lookup transformation.
• Used Update Strategy DD INSERT, DD UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic for Type 1 SCD and Type 2 SCD.
• Developed Re-Usable Transformations and Re-Usable Mapplets.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Extensively worked on tuning (Both Database and Informatica side) and thereby improving the load time.
• Scheduled Jobs using scheduling tools like Control-M.
• Analyzed existing system and developed business documentation on changes required.
• Automated the entire process using UNIX shell scripting
• Prepared Detail design documentation thoroughly for production support department to use as hand guide for future production runs before code gets migrated.
• Conduct status meetings with project managers, escalate issues when necessary, conducts meetings for issues resolution
• Interacted with Lead Developers, System Analysts, Business Users, Architects, Test Analysts, Project Managers and peer developers to analyze system requirements, design and develop software applications.
• Created new extracts for external vendors and use Informatica ETLs for new workflows to move data out of multiple data sources.
• Unit test coding changes, fill out required documentation such as installation instructions, and follow standards and procedures.
• Provided Tier l support duties for Informatica Production Support, including off hours and weekends. Keep the Production Support team management informed of any issues or concerns. New development and support task responsibilities.

Environment: Informatica Power Center 9.5.1,Netezza, Oracle 11g, XML, UNIX Shell Scripting, Teradata 13, Control-M, Toad 11.5.

Confidential, Pittsburgh, PA

Informatica Developer

Responsibilities:

• Interacted with Business Analysts to gather and analyze the Business Requirements.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Worked on Dimension/Fact tables to implement the business rules and get required results.
• Used Informatica designer for developing various mappings.
• Designed and developed ETL Mappings using Informatica to extract data from various sources like Teradata, Oracle and to load the data into the target database.
• Created reusable transformations in transformation developer/ mapplets in mapplet designer.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions, Union, Normalizer, Sequence generator and Aggregator transformations to pipeline the data to Database.
• Used Informatica Power Center to create mappings, mapplets, workflows, worklets, sessions and tasks.
• Created Sessions, Workflows, Link Tasks and Command Tasks using Workflow Manager and monitored the workflows/sessions using Workflow Monitor.
• Worked with events such as Timer, Event Wait, Event Rise, Control and Decision.
• Used debugger to test mapping and fix the bugs.
• Worked with NZLOAD, NZSQL utilities of Netezza for faster loading and to improve the performance.
• Extracted data from various sources like SQL server, Oracle, Teradata and relational databases.
• Integrated workflow and created Autosys jobs for scheduling.
• Involved in migration of the mappings, Sessions and other Objects from Development and to Production environment.

Environment: Informatica 9.1.1, Oracle 10g, Teradata, Flat files, UNIX shell scripting, Autosys, Oracle SQL Developer, Netezza.

Confidential, Dearborn

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.
• Cleanse the source data, extract and transform data with business rules and built mapplets using in informatica design.
• Designed and developed a number of complex mappings using various transformations like Source Qualifier, Aggregator, Router, Joiner, Union, Expression, Lookup (Connected & unconnected), Filter, Update Strategy, Stored Procedure, Sequence Generator and used reusable transformations as well as mapplets.
• Worked with Workflow Manager for the creation of various tasks like Worklets, Sessions, Batches, E-mail notifications, Decision and to Schedule jobs
• Extensively used the Slowly Changing Dimensions-Type II in various data mappings to load dimension tables in Data warehouse
• Scheduled jobs using Autosys
• Involved in extensive performance tuning by determining bottlenecks using Debugger at various points like targets, sources, mappings, sessions or system, this led to better session performance.

Environment: InformaticaPower Center 8.6.1, Oracle 10g, TOAD 10.1 for Oracle, Flat Files, PL/SQL, UNIX shell scripting, Autosys.

Confidential, Madison, WI

Informatica Developer

Responsibilities:

• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Design and build snow flake schema dimensional models for the first data warehouse of IBT.
• Extensively used ETL and Informatica to load data from MS SQL Server, MS Access, Excel spreadsheet, flat files and XML files into the targets like Oracle, Flat Files, and SQL Server.
• Utilized various Transformations in Mappings like Joiner, Aggregate, Union, Transaction Control, XML SQ, XML Parser, XML Generator, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Used various tasks like session, email, command, Event wait, Event raise and control etc.
• Developed very complex workflows and mappings for complex business requirements.
• Created Windows Batch Scripts for Informatica workflows to start, schedule, unscheduled workflows as well as to modify, delete, rename, move flat files.
• Created SQL Server tables and imported them in Informatica.
• Used Debugger to check the errors in mapping.
• Generated UNIX shell scripts for automating daily load processes.

Environment: Informatica Power Center 8.1, Oracle 9i, MS Access 2003, SQL Server 2005, XML, Excel 3000, Flat Files, SQL developer, unix .

Confidential

ETL/Oracle Developer

Responsibilities:

• Understanding the customer’s requirements, analysis, design, development and implementation of system gather and define business requirements, improve business processes.
• For Informatica updated user groups and their privileges, created project folders and deployment groups TEST and PROD environments.
• Designed and developed solutions for very complex business logics. Designed and build reusable objects (Informatica Mapplets, Sessions, Email Task, Worklets and more) as a Standard for multiple projects
• Optimized the queries to improve the performance of the application.
• Created Batch Jobs.

Environment: InformaticaPower Center 7.1, SQL Developer, SQL Server 2005, Oracle 9i, Windows, PL/SQL.