Senior Informatica Etl Developer / Oracle Developer Resume
Madison, WI
SUMMARY:
- 12+ years of Technical and Functional experience in Data warehouse implementations ETL methodology using Informatica Power Center 9.6.1/9.1.0/8.6/8.1/7.1, Oracle 10g/9i/8i and MS SQL SERVER 2005/2000.
- Involved in complete software development life cycle (SDLC) of the projects and have experience in various domains like HealthCare, Sales, Insurance and Banking.
- Involved in Informatica upgrade from Informatica Power Center 7.1.1 to Informatica Power center 8.6 and Informatica Power Center 7.1.1 to Informatica Power center 8.1.1.
- Worked with heterogeneous data sources like Oracle, UDB, Flat Files, VSAM, AS400, Teradata and Relational Databases.
- Extensively Worked on Data warehousing with Data Marts, ODS, Data Cleansing, ETL tool Informatica.
- Expertise in different types of loading like Normal and Bulk loading challenges. Involved in Initial Loads, Incremental Loads, Daily loads and Monthly loads.
- Involved in ETL Architecture and Data Modeling using ERWIN.
- Strong in using workflow tasks like Session, Control, Event wait, command tasks, Decision tasks, Email tasks, pre - sessions, post-sessions by using pre-SQL and Post-SQL.
- Developed batch jobs to normalize and load various data sources into a central repository used for reporting and analytics.
- Well experienced with preparing the design documents for mapping.
- Well acquainted with Performance Tuning of sources, targets, mappings and sessions to overcome the bottlenecks in mappings.
- Experienced in creating entity relational & dimensional relational data models using Kimball Methodology i.e., Star Schema and Snowflake Schema.
- Proficient in Data Mart, Star Schema, Extract, Transform and Load the Data, Requirement Analysis, Design, Development, Testing, Documentation and Implementation of Business Intelligence Applications.
- Experienced with creating ETL specifications as per the customer requirements.
- Experienced with creating Unit Test Cases for mapping and code reviews.
- Extensively worked on Informatica Tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer and Workflow Manager.
- Good Knowledge of SQL, PL/SQL.
- Have strong experience working in UNIX environment and developing Shell scripts in Bourne, Korn and C shell.
- Experience with transaction processing and exception handling in PL/SQL, experience with the use of cursor variables and system-supplied packages and Experience with SQL Performance tuning.
- Trouble shooting and problem-solving applications with Informatica.
- Resourceful, creative problem-solver with proven aptitude to analyze and translate complex customer requirements.
- Good Problem-solving skills, quick learner, effective individual, team player, excellent communication and presentation skills.
- Capable of working as an individual as well as a part of team.
- Experienced in various scheduling tools like Autosys, TIDAL and providing production support.
TECHNICAL SKILLS:
ETL Tools: Informatica Power Center 9.6.1/9.1.0/8.6/8.4/8.1/7.1, Data Stage.
Methodologies: E-R Modeling, Star schema, Snowflake schema.
OLAP Tools: Business Objects, Cognos Report net.
Programming Languages: C, C++, SQL, PL/SQL, JAVA, J2EE, OOPS.
Databases: Oracle 8i/9i/10g, Netezza, T-SQL, MS SQL Server 2000/2005, DB2.
Data Modeling: Erwin 4.2.2.
Operating Systems: Windows XP/NT/2000, UNIX.
Database utility tool: Toad, Aginity, Oracle SQL Developer.
PROFESSIONAL EXPERIENCE:
Confidential, Madison, WI
Senior Informatica ETL Developer / Oracle Developer
- Worked with Business Analyst to gather business requirements and Involved in weekly team meetings.
- Developed mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat Files, XML Files and Netezza Database and load the Data into oracle Data Warehouse.
- Used Netezza External tables to read the data from flat files, created views for external tables to import sources and load the data into Oracle Data warehouse.
- Experienced with creating Netezza External Tables and Views.
- Experienced in writing the Queries with Netezza SQL and Oracle SQL.
- Created Re-usable sessions and worklets for Master workflow.
- Worked on Linux Shell Scripting, that can be invoked from workflow.
- Worked on Informatica Power center tools - Source Analyzer, Target designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation.
- Dealt with slowly changing Dimensions (SCD).
- Applied slowly changing dimensions (SCD) in various complex Mappings to load data from source to target.
- Developed mappings/sessions using Informatica Power Center for data loading.
- Created, configured, scheduled and monitored the sessions and workflows based on run on demand, run on time using Informatica Power Center Workflow Manager.
- Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
- Involved in evaluating many invalid mappings, testing of these ETL sessions and validating the target data using the Debugger.
- Involved in Optimizing and Performance tuning logic on targets, sources, mappings, and sessions to increase the efficiency.
- Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
- Devised extensive PL/SQL Stored Procedures and Triggers to populate the base tables on daily basis and implementing business rules and transformations, Performed Mapping Optimizations to ensure maximum Efficiency.
- Involved in writing Stored Procedures, Functions, Triggers and Cursors.
- Involved in creation of pre-session command and post-session commands to re-usable sessions.
- Used PMCMD Command to invoke workflow from Shell Scripts.
- Schedule and Run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
- Used TOAD to develop oracle PL/SQL, DDL's and Stored Procedures. Performance and fine Tuning of SQL & PL/SQL stored procedures.
- Used bulk load option for fast loading of data.
- Involved in Unit Testing, System Testing, Integration Testing and User Acceptance Testing of developed mappings.
Environment: Informatica 9.0.1, Netezza 4.8, Oracle 11g, Unix, Shell Scripting, Toad, Aginity, SQL Plus, PL/SQL, Clear Case, Quality Center, TIDAL, ERWIN, Windows XP.
Confidential, Milwaukee, WI
Senior Informatica ETL Developer
- Worked with Business Analyst to gather business requirements and Involved in weekly team meetings.
- Developed mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat Files, XML Files and Netezza Database and load the Data into oracle Data Warehouse.
- Used Netezza External tables to read the data from flat files, created views for external tables to import sources and load the data into Oracle Data warehouse.
- Experienced with creating Netezza External Tables and Views.
- Experienced in writing the Queries with Netezza SQL and Oracle SQL.
- Created Re-usable sessions and worklets for Master workflow.
- Worked on Linux Shell Scripting, that can be invoked from workflow.
- Worked on Informatica Power center tools - Source Analyzer, Target designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation.
- Dealt with slowly changing Dimensions (SCD).
- Applied slowly changing dimensions (SCD) in various complex Mappings to load data from source to target.
- Developed mappings/sessions using Informatica Power Center for data loading.
- Created, configured, scheduled and monitored the sessions and workflows based on run on demand, run on time using Informatica Power Center Workflow Manager.
- Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
- Involved in evaluating many invalid mappings, testing of these ETL sessions and validating the target data using the Debugger.
- Involved in Optimizing and Performance tuning logic on targets, sources, mappings, and sessions to increase the efficiency.
- Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
- Devised extensive PL/SQL Stored Procedures and Triggers to populate the base tables on daily basis and implementing business rules and transformations, Performed Mapping Optimizations to ensure maximum Efficiency.
- Involved in writing Stored Procedures, Functions, Triggers and Cursors.
- Involved in creation of pre-session command and post-session commands to re-usable sessions.
- Used PMCMD Command to invoke workflow from Shell Scripts.
- Schedule and Run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
- Used TOAD to develop oracle PL/SQL, DDL's and Stored Procedures. Performance and fine Tuning of SQL & PL/SQL stored procedures.
- Used bulk load option for fast loading of data.
- Involved in Unit Testing, System Testing, Integration Testing and User Acceptance Testing of developed mappings.
Environment: Informatica 9.0.1, Netezza 4.8, Oracle 11g, Unix, Shell Scripting, Toad, Aginity, SQL Plus, PL/SQL, Clear Case, Quality Center, TIDAL, ERWIN, Windows XP.
Confidential
Senior ETL Developer / Data Mapping Analyst
- Involved in design and development of Business Requirements by coordinating with business users and Technical teams by gathering requirement specification documents and identifying data sources and targets.
- Involved in Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center.
- Worked on Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer, Workflow Manager, Mapplet Designer and Transformation Developer.
- Involved in designing, developing and documenting the ETL (Extract, Transformation and Load) strategy to populate the Data Warehouse from various source systems feeds using Informatica, PL/SQL scripts.
- Worked extensively on different types of ETL transformations like Joiner, Filter, Aggregator, Lookup, Stored Procedures, Router, Sorter, Rank, Normalizer and Update Strategy etc.
- Extensively used Source Qualifier Transformation to filter data at source level rather than at transformation level.
- Extracted data from various sources like MS SQL Server, DB2, flat files, Excel spreadsheets, Oracle and XML files and loaded into the target Oracle database.
- Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
- Created and Executed workflows and Worklets using Workflow Manager to load the data into the Target Database.
- Used Power Center Workflow Manager to create workflows, sessions, and used various tasks like command, event wait, event raise, email to run with the logic embedded in the mappings.
- Defined Target Load Order Plan for loading data into different Target Tables.
- Extensively used Informatica functions LTRIM, RTRIM, IIF, DECODE, ISNULL, TO DATE, DATE COMPARE in Transformations.
- Involved in design of logical and physical data models using ERWIN.
- Implemented Slowly Changing Dimensions methodology to keep track of historical data.
- Scheduling Informatica jobs using TIDAL.
- Involved in Performance Tuning at various levels including Target, Source, Mapping and Session for large data files.
- Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
- Involved in evaluating many invalid mappings, testing of these ETL sessions and validating the target data using the Debugger.
- Involved in Unit and System testing of developed mappings.
Environment: Informatica Power Center 8.6, Oracle 10g, Toad, SQL Plus, UNIX, UNIX-Shell Scripting, Clear Case, Quality Center, Tidal, ERWIN, Windows 2000.
Confidential
Senior ETL Developer / Data Mapping Analyst
- Involved in design and development of Business Requirements by coordinating with business users and Technical teams by gathering requirement specification documents and identifying data sources and targets.
- Involved in Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center.
- Worked on Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer, Workflow Manager, Mapplet Designer and Transformation Developer.
- Involved in designing, developing and documenting the ETL (Extract, Transformation and Load) strategy to populate the Data Warehouse from various source systems feeds using Informatica, PL/SQL scripts.
- Worked extensively on different types of ETL transformations like Joiner, Filter, Aggregator, Lookup, Stored Procedures, Router, Sorter, Rank, Normalizer and Update Strategy etc.
- Extensively used Source Qualifier Transformation to filter data at source level rather than at transformation level.
- Extracted data from various sources like MS SQL Server, DB2, flat files, Excel spreadsheets, Oracle and XML files and loaded into the target Oracle database.
- Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
- Created and Executed workflows and Worklets using Workflow Manager to load the data into the Target Database.
- Used Power Center Workflow Manager to create workflows, sessions, and used various tasks like command, event wait, event raise, email to run with the logic embedded in the mappings.
- Defined Target Load Order Plan for loading data into different Target Tables.
- Extensively used Informatica functions LTRIM, RTRIM, IIF, DECODE, ISNULL, TO DATE, DATE COMPARE in Transformations.
- Involved in design of logical and physical data models using ERWIN.
- Implemented Slowly Changing Dimensions methodology to keep track of historical data.
- Scheduling Informatica jobs using TIDAL.
- Involved in Performance Tuning at various levels including Target, Source, Mapping and Session for large data files.
- Involved in Unit and System testing of developed mappings.
Environment: Informatica Power Center 8.6, Oracle 10g, SQL Server, Flat files, DB2, Toad, SQL Plus, PL/SQL, UNIX, UNIX Shell Scripting, Clear Case, Quality Center, TIDAL, ERWIN, Windows 2000.
Confidential, First Street, DC
Senior ETL Developer / Data Mapping Analyst
- Involved in designing mappings between sources and targets and tuned them for better performance.
- Experienced with Informatica upgrade from Informatica Power Center 7.1.1 to Informatica Power center 8.1.1.
- Worked on Informatica tools Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer and Workflow Manager.
- Designed and Developed mappings in Informatica using different transformations like Source qualifier, XML transformations, Lookup (connected and unconnected), Aggregator, Expressions, Update Strategy, Filter, Joiner are mostly used.
- Used pmcmd commands in Perl and shell scripts to automate the execution of workflows.
- Production Support and Development, Modifications, Maintenance of Programs using Shell script, provided on call support for batch jobs running on UNIX.
- Created and monitored workflows using Workflow Manager and Workflow Monitor. The log was studied to modify the mappings to obtain correct results from the transformation.
- Informatica Workflow manager was used to do the loading of the transformed data on to the multi-dimensional schema.
- Modified Shell scripts to schedule batches on Cron Jobs. Modified Perl scripts to automatically create parameter files by replacing the placeholders for parameters and variables used in mappings, start the ETL process, check for the success of the session and notify the status through email.
- Creating source definitions from the operational sources and target definitions.
- Designed Sources to Targets mappings from primarily Excel/Flat files/XML to Oracle using Informatica.
- Worked Extensively on Informatica modules Repository Manager, Designer, and Server Manager.
- Created Sessions, reusable sessions, Worklets and Batches in Workflow Manager and Scheduled sessions at specified frequency.
- Wrote stored procedures and triggers in Oracle 9i for managing consistency and referential integrity across data mart.
- Used Debugger to check the errors in mapping. Documented the entire process. The documents included the mapping document, unit testing document and system testing document among others.
- Involved in tuning the performance of these ETL mappings.
- Written Test cases for Unit testing of the Informatica Jobs.
Environment: Informatica Power Center 8.1/8.6, DB2, Oracle 10g, MS SQL Server 2005, Toad, Oracle SQL Developer, SQL Plus, PL/SQL, UNIX, UNIX- Shell Scripting, Autosys, Clear case, ERWIN, Windows 2000.
Confidential
ETL Developer
- Extensively used Informatica to extract data from Central Database, which is SQL Server database.
- Used Informatica to load data into Data warehouse, which is Oracle Data base.
- Involved in the development of Informatica mappings and tuned for better performance.
- Created Informatica mappings to build business rules to load data.
- Improved integrity by identifying and creating relationship between tables.
- Loaded the consolidated data using the SQL Loader.
- Creating source definitions from the operational sources and target definitions.
- Designed Sources to Targets mappings from different databases to flat files using Informatica.
- Involved extensively when working on the Repository Manager, Designer, Workflow Manager and Workflow Monitor.
- Implement Data warehouse processes like Data Extraction/Transformation and Load ETL.
- Developed Transformation logic and designed various complex Mappings in the Designer.
- Worked with various transformations such as Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored procedure, Sequence Generator.
- Used Workflow manager to schedule, execute and monitor the session.
- Involved in creating tasks, worklets, and workflows, Scheduled the workflows using shell scripts to run automatically.
- Done Unit Testing for the mappings developed per the specifications.
- Involved with the testing team to build the test plans.
Environment: Informatica Power Center, Oracle, MS SQL Server, SQL plus, PL/SQL, UNIX, Shell Scripting, MS Access, Windows NT/2000.
Confidential
ETL/oracle Developer
- Involved in Extraction, Transformation and Loading (ETL) of data by using Informatica.
- Designed and developed ETL strategies and mappings from source systems to target systems, ETL strategies were designed to initial load and incremental load.
- Involved in performance tuning of targets, sources, mappings, and sessions.
- Participate in data sourcing, extract data investigation process and work with teams to develop PL/SQL code to extract, clean and sort data for flat file generation.
- Analyzed and developed business requirements.
- Periodic meetings with various departments to understand user requirements and needs.
- Involved in gathering data and requirements to support developers.
- Interacted with developers to resolve technical issues.
- Created tables, indexes, sequences, constraints and snapshots.
- Developed packages, procedures, functions and PL/SQL block for data validation.
- Developed procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements.
- Helped in writing proposals, documentation and training.
- Preparation of the Technical Specifications based on the functional specifications received from Client.
- Development of Code based on the approved Technical Specifications.
- Created Views from multiple Tables.
Environment: Informatica Power Center, Oracle 8i, MS SQL Server, Toad, SQL plus, PL/SQL, Windows 2000.