We provide IT Staff Augmentation Services!

Etl Informatica Developer Resume

FL

Summary:

  • Over 7 years of Software Life Cycle experience in System Analysis, Design, Development, Implementation, Maintenance, and Production support of Data Warehouse Applications.
  • Expertise in working with Informatica , Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer , Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer , Worklet Designer, Gant Chart, Task View, Mapplets, Mappings, Workflows, Sessions, Re-usable Transformations, Shortcuts, Import and Export utilities.
  • Have RDBMS concepts experience in Oracle 9i/8i/7.x, Oracle PL/SQL, SQL*Plus, SQL*Loader, IBM DB2 8.0/7.0, MS SQL Server 2000/2005/2008.
  • Sound Knowledge in Data warehousing concepts like Bill Inman Methodology, Ralph Kimball Methodology, Star Schema, Snow Flake Schema, OLAP , ROLAP, MOLAP, HOLAP, EDW, Data marts, Normalization, Dimensions, Facts,
  • Strong experience in designing and developing business intelligence solutions in Data warehouse/Decision Support Systems using ETL tools Informatica Power Center 9.1/8.6.1/8.1/7.1/6.2/6.1 , OLTP, OLAP.
  • Expertise in working with relational Databases i.e. Oracle 8/9i, DB2 UDB, Sales force
  • Experienced in Error Handling and Troubleshooting Techniques using various log files.
  • Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
  • Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions
  • Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Data Transformation Services etc
  • Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
  • Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers.
  • Experience in creation and customization of ETL extracts and load process using Informatica.
  • Experience in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
  • Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
  • Experience in design and implementation using ETL tools like Informatica (Power Center) Designer, Repository Manager and Workflow / Server Manager. Experience working in Oracle 8/9i with database objects like triggers, stored procedures, functions, packages, views, indexes.
  • Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts. Collaborated onsite teams, interacted and well managed various offshore teams.
  • Strong Team working spirit, communication and relationship management skills.

Technical skills:

Data Warehousing/ETL Tools

Informatica PowerCenter 9.x/8.x/7.x/6.x (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformation, Sessions, Workflow Manager-Workflow, Task, Commands, Worklet, Transactional Control, Constraint Based Loading, SCD I, II,Data Flux, Datamart, OLAP, ROLAP, MOLAP, OLTP.

Databases

Oracle 9i/8i, MS SQL Server 2000/7.0/6.5 , MS Access 7.0/2000,SQL Server,Postgress

Data Modeling

Star Schema and Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ER Studio, Erwin 4.5/4.2/3.5/3. x

Tools

MS Office 97/2000/professional, SQL*Plus 3.3/8.0, TOAD,Microsoft Visio, Putty, Text Pad, .csv files, Erwin, ER Model, Salesforce Integration.

Programming Languages

Unix Shell Scripting, Oracle PL/SQL (Stored Procedures, triggers, Indexes).

Environment

Windows 98/2000/2003/ XP/NT and Windows NT, UNIX.

Professional Experience:

Client: Confidential, FL

Role: ETL Informatica Developer

Responsibilities:

  • Prepared High Level Design and Low Level Design based on Functional and Business required documents of the project.
  • Interact with the requirements team and designers to get a brief knowledge of business logics.
  • Review the Master Data Workbooks for better understanding of business logic.
  • Conducted Review sessions with SME’s and Business users for better understanding of the requirements.
  • Extract data from flat files, Oracle and to load the data into the Oracle database.
  • Incremental extraction using CDC MD5 function
  • Extensively used various transformations like Filter, Router, Sequence Generator, Lookups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
  • Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
  • Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
  • Worked with slowly changing dimension Type2
  • Designed and Developed Custom Mappings, Workflows
  • Performance tuning of the process at the mapping level, session level, source level, and the target level
  • Involved in Data Validating, Data integrity, Performance related to DB, Filed Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
  • Prepare test data for positive and negative test scenarios as per the business requirements
  • Create and execute test cases
  • Report the identified defects using Trac tool
  • Keep track of the reported defects and support other teams to resolve defects
  • Validate the data in source and target systems using SQL queries
  • Validate the ongoing data synchronization process using validation tools to ensure that data in source and target systems are in sync

Environment: Informatica Power Center 9.1, UNIX, Oracle Database, SQL*PLUS, SQL*Loader, TOAD, UNIX

Client: Confidential , MO

Role: ETL Informatica Developer

Responsibilities:

  • Prepared High Level Design and Low Level Design based on Functional and Business required documents of the project.
  • Interact with the requirements team and designers to get a brief knowledge of business logics.
  • Review the Master Data Workbooks for better understanding of business logic.
  • Conducted Review sessions with SME’s and Business users for better understanding of the requirements.
  • Extract data from flat files, DB2 and to load the data into the SalesForce database.
  • Extensively used various transformations like Filter, Router, Sequence Generator, Lookups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
  • Extensively used ETL processes to load data from flat files into the target database by applying business logic on transformation mapping for inserting and updating records when loaded.
  • Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
  • Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
  • Validate the ongoing data synchronization process using validation tools to ensure that data in source and target systems are in sync
  • Performance tuning of the process at the mapping level, session level, source level, and the target level
  • Involved in Data Validating, Data integrity, Performance related to DB, Filed Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
  • Prepare test data for positive and negative test scenarios as per the business requirements
  • Create and execute test cases
  • Designed and Developed Custom Mappings, Workflows and Registered in DAC.
  • Validating source data and Target data usnig Data Flux
  • Report the identified defects using Trac tool
  • Keep track of the reported defects and support other teams to resolve defects
  • Validate the data in source and target systems using SQL queries

Environment: Informatica Power Center 9.1, DB2, SQL, UNIX, Control-M, Data Flux, Salesforce Database, Unix

Client: Confidential, NY

Role: ETL Informatica Developer

Responsibilities:

  • Responsible for gathering the business requirements and converting the same into technical specifications.
  • Worked with Informatica power center tools like Designer, Workflow Manager, Repository Manager, source analyzer, warehouse designer, mapping & mapplet designer and Transformation developer .
  • Worked with relational databases like ORACLE 9i.
  • Developed complex mappings using source qualifier, joiner, Lookups (connected and unconnected), expression, filter, router, and aggregator, sorter, update strategy and normalizer transformations.
  • Worked with Source qualifier override, lookup override for customizing the SQL queries.
  • Created pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables.
  • Implemented Type 1 and Type 2 Slowly changing dimensions for Dimension and Fact loads.
  • Responsible for performance tuning at Mapping level, Session level, Source and Target level.
  • Worked with Static cache, Persistent, Dynamic cache, Index cache, Data cache and target based commit interval in order to improve the performance at session level.
  • Responsible for Unit Testing of Mappings and Workflows.
  • Worked closely with reporting team and helped them whenever they had any ETL issues
  • Responsible for creating and running the batch jobs in UNIX .
  • Tested Mappings using Debugger.
  • Worked closely with QA team during the testing phase and fixed bugs that were reported.
  • Responsible for Production support, maintained the standard SLA in resolving the production failures.

Environment: Informatica Power Center 8.6.1(Designer, Workflow Manager, Workflow Monitor), Oracle9i, SQL, Toad 9.7.2, Mapplets, Repository, UNIX, Flat files, Windows XP Professional

Client: Confidential, DE

Role: Informatica Developer

Responsibilities:

  • Actively involved in gathering requirements from business users, involved in modifying various technical & functional specifications in the development.
  • Extensively involved in developing ETL code using Informatica in order to meet requirements for extract, cleansing, transformation and loading of data from source to target data structures.
  • Used Source Analyzer and Warehouse designer to import source and target elements, then Informatica powercenter designer to create complex mappings based on Business requirements.
  • Created various transformations like filter, router, lookups, stored procedure, joiner, update strategy, expressions and aggregator to pipeline data to Data Warehouse/Data Marts and monitored the Daily and Weekly incremental data loads.
  • Created Mappings, Mapplets, Sessions and Workflows using Informatica Power Center 8.6.
  • Involved in Fine tuning SQL overrides in Source Qualifier and Look-up SQL overrides for performance Enhancements.
  • Developed Datamaps from Mainframe systems and COBOL copy books using Informatica Powerexchange.
  • Worked with health payer related data such as customers, policy, policy transactions, policy coverage, claims.
  • Generated weekly and monthly report status for the number of incidents handled by the support team.
  • Involved in writing and executing Stored Procedures, Functions, and Packages in PL/SQL
  • Extensive PLSQL Programming with design and development of physical and logical data model using ERWIN.
  • Developed UNIX shell scripts to create parameter files, rename files, compress files and for scheduling periodic load processes.
  • Used Control-M as Third Party Scheduling tool.
  • Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.
  • Involved in unit testing of mappings, mapplets also involved in Parallel Testing.

Environment: Oracle 10g, SQL, PL/SQL, TOAD 10.5, UNIX Shell Scripting, Informatica Power Center 8.6, Informatica PowerExchange, Windows XP, Control-M, WinSCP, Mainframe

Client: Confidential

Role: ETL Developer

Responsibilities:

  • Involved in Business analysis and requirements gathering.
  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Preparation of technical specifications and Source to Target mappings.
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Created mappings for dimensions and facts.
  • Extracted data from various sources like Oracle , flat files and DB2
  • Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer and Warehouse Designer and Transformation Developer .
  • Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations.
  • Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
  • Optimizing/Tuning mappings for better performance and efficiency.
  • Migrated mappings from Dev to Test and Test to Production repositories.
  • Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
  • Worked on issues with migration from development to testing.
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
  • Refreshed reports using Scheduler.
  • Preparation of UTP (Unit Test Plan) with all required validations and test cases.
  • Responsible for testing and validating the Informatica mappings against the pre-defined ETL design standards.
  • Created various tasks like sessions, decision, timer & control to design the workflows based on dependencies
  • Used workflow manager for session management, database connection management and scheduling of jobs.
  • Involved in production support.

Environment: Informatica Power Center 7.1, Oracle 8, Windows 2000, TOAD, Erwin 4.0

Hire Now