We provide IT Staff Augmentation Services!

Etl Informatica Developer Resume

Bloomington, IL

SUMMARY:

  • Eight (8) 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.6.1/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,DB2,Teradata

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:

Confidential, Bloomington, IL

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 DB2 database.
  • Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
  • 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 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
  • Designed and Developed Custom Mappings, Workflows
  • Responsible for performance tuning at Mapping level, Session level, Source and Target level.
  • Create and execute test cases
  • Implemented Type 1 and Type 2 Slowly changing dimensions for Dimension and Fact loads.
  • Designed the error handling techniques in the mappings according to the business rules
  • Responsible for performance tuning at Mapping level, Session level, Source and Target level.
  • Handled Informatica administration work like migrating the code using Export/Import & Informatica
  • Report the identified defects using Trac tool
  • Keep track of the reported defects and support other teams to resolve defects
  • Used control-m tool to schedule the jobs.

Environment: Informatica Power Center 9.6.1, UNIX,DB2 Database, SQL*PLUS, SQL*Loader, TOAD

Confidential, Boca Raton, FL

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.
  • 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 Teradata database.
  • 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.
  • Extensively used Various Data Cleansing and Data Conversion Functions like RTRIM, LTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr, ReplaceStr and IIF functions in Expression Transformation.
  • Extensively used various transformations like Filter, Router, Sequence Generator, Lookups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
  • Loading data from various data sources and legacy systems in Teradata using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD
  • Refreshed the data by using fastexport and fastload utilities..
  • Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
  • Worked with slowly changing dimension Type2
  • Performance tuning of the process at the mapping level, session level, source level, and the target level
  • 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
  • Worked closely with QA team during the testing phase and fixed bugs that were reported.
  • Validate the ongoing data synchronization process using validation tools to ensure that data in source and target systems are in sync
  • Worked with release team in migrating the code ( Informatica Objects,UNIX Scripts) from Development to Test, Production Servers.

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

Confidential, Bloomington, IL

ETL Informatica Developer

Responsibilities:

  • 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.
  • Extract data from flat files,DB2 and to load the data into the SalesForce database.
  • Worked with Informatica power center tools like Designer, Workflow Manager, Repository Manager,
  • Prepared High Level Design and Low Level Design based on Functional and Business required documents of the project. source analyzer, warehouse designer, mapping & mapplet designer and Transformation developer.
  • Used source qualifier, joiner, Lookups, expression, filter, router, and aggregator, sorter, and update strategy and normalizer transformations for various data transformation activities.
  • Worked with SQL override, Lookup override, Lookup caches, and Index and Data caches while designing the mappings.
  • Extensively worked with lookup caches like Static cache, Persistent cache, and Dynamic cache.
  • Designed reusable transformations and mapplets.
  • Worked with mapping parameters and variables, session parameters, pmcmd commands, email tasks.
  • Used debugger wizard to troubleshoot data and error conditions.
  • Fine tuned the mapping and sessions for better performance.
  • Tuned performance of Informatica sessions for large data files by implementing pipeline partitioning and increasing block size, data cache size, sequence buffer length and target based commit interval and resolved bottlenecks.
  • 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.
  • 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

Confidential

Data Integration Specialist/ ETL Developer

Responsibilities:
  • Proposed enhancements and changes to the technical and business solution to meet the new requirements.
  • Estimated Efforts accurately & actively worked with PM’s in completing the project plan.
  • Engaged with external vendors to develop a new Highly Available Open systems platform for the customer to support new applications (Master) and move data from the existing platforms(read-only) into the HA environment.
  • Shared & provided details about all Design & Transformation rules document with Offshore & guided them to build the necessary components. Worked with offshore team members to prepare Coding Standards, ETL Specification & Test case documents template.
  • Worked with new ETL tools to decide which would be the most suited for all of the upcoming data conversion projects. Focus here was mainly to cut down licensing and maintenance costs by moving to open source tools suite (where ever possible, without compromising on any of the main criteria)
  • Conducted Proof of Concept/ Technology and created Architectural Design Documents (ADDs).
  • Assisted Project Business Analysts by providing key Design & Data mapping inputs for documenting the FSD. Involved in QA Test plan & Test case review meetings. Worked with Release Management team in migrating the components to QA environment for QA testing. Provided necessary technical assistance in fixing the QA defects.
  • Designed patterns for Data movement and Transformation. Here factors such as data replication, synchronization, availability for real time/initial load and batch processing played a key role. Designed the patterns for Data Replication and Data Synchronization of Master and Slave (read - only type) data.
  • Lead the effort to implement Cloud functionality (Sales force) using Informatica Power Center for data movement and transformation (read and write) data to cloud from DB2 and PostgreSQL.
  • Drove an effort on Web Service interaction with Informatica Power Center 9.1 using a WSDL and SOAP UI client.
  • Created data maps for Change Data Capture (CDC) for db2 capability using Informatica MD5 function
  • Lead an effort for using Power Center mappings for XMLs.
  • Used Performance tools to Measure /Monitor Performance of the ETL jobs and loader utilities (EDB loader).
  • Automated scripts for Enterprise Database Loader (similar to Oracle’s PL/SQL).

Confidential

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 DB2.
  • 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.
  • Extensively used Various Data Cleansing and Data Conversion Functions like RTRIM, LTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr, ReplaceStr and IIF functions in Expression Transformation.
  • 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), db2, Flat files, Windows XP Professional

Confidential, Chicago, IL

ETL Informatica Developer

Responsibilities:

  • 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.
  • Designed and developed Informatica Mappings, Mapplets and Sessions for data loads and data cleansing.
  • Developed and implemented various enhancements to the application in the form of production and new production rollouts.
  • Extensively worked on confirmed Dimensions for the purpose of incremental loading of the target database.
  • Responsible for gathering the business requirements and converting the same into technical specifications.
  • Tuning of the mappings and SQL Scripts for a better performance.
  • 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.

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

Confidential, Chicago, IL

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

Confidential, San Antonio, TX

ETL Informatica Developer

Responsibilities:

  • Responsible for gathering the user requirements and converting the same into technical specifications
  • Responsible for designing of transformations, mappings, and workflows to implement the business logic.
  • Created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy
  • Worked on loading techniques like slowly changing dimensions and incremental loading for extraction, transformation, and loading of the data.
  • Worked extensively with various Passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator, and Lookup Transformation
  • Extensively worked with aggregate functions like Avg, Min, Max, First, Last, and Count in the Aggregator Transformation.
  • Extensively used SQL Override in the Source Qualifier Transformation
  • Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
  • Created Connected and Unconnected lookup transformation to get the related values.
  • Responsible for Performance tuning of sources, targets, mappings and SQL queries in the transformations
  • Created reusable transformations and used in various mappings.
  • Responsible for error handling using logs

Environment: Informatica Power Center 7.1,Oracle, SQL, DB2 UDB, Windows20

Confidential, PA

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