We provide IT Staff Augmentation Services!

Sr. Informatica Etl Developer Resume

Moline, Il

SUMMARY:

  • Around 10 years of experience in IT Software Development Life cycle involved in Business Requirement Analysis, Application Design, Data Modeling, Development, Testing and Implementation of Data Warehousing applications in Manufacturing, Travel and Insurance domains.
  • Extensive experience in writing SQL, Stored procedures, Functions, Packages, Database triggers, Shell - Scripts and SQL Loader scripts.
  • Extensive experience in ETL/Informatica Power Center and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 9.x/8.x/7.x, IDQ 9.6.1/9.0.1/8.6 and PowerMart 8.x/7.x.
  • Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
  • Experience in working with business analysts to identify and understand requirements and translated them into ETL code in Requirement Analysis phase.
  • Experience in creating High Level Design and Detailed Design in the Design phase.
  • Worked on IDQ/IDE tools for data profiling, data enrichment and standardization.
  • Expertise in creating very detailed design documents and performing Proof of Concepts (POC).
  • Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
  • Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
  • Extensively created mapplets, common functions, reusable transformations, look-ups for better usability.
  • Well versed in OLTP Data Modeling, Data warehousing concepts.
  • Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
  • Experience in integration of various data sources like Oracle, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area.
  • Good understanding of Views, Synonyms, Indexes, Joins and Sub-Queries. Extensively used Cursors and Ref Cursors.
  • Extensively used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
  • Experience in using Exception handling strategies to capture errors and referential integrity constraints of records during loading processes to notify the exception records to the source team.
  • Experience in creating Reusable Transformations (Joiner, Sorter, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Aggregator, and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
  • Experienced in UNIX work environment, file transfers, job scheduling and error handling.
  • Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
  • Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
  • Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
  • Involved in Unit testing, System testing to check whether the data loads into target are accurate.
  • Experience in support and knowledge transfer to the production team.
  • Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.
  • Upgraded to Informatica PowerCenter 8.6.1 from version 8.1.1. Installed Hot fixes, utilities, and patches released from Informatica Corporation.
  • Expert in Oracle 11g/10g, IBM DB2 8.1, Sybase, SQL Server 2008/2005/2008, SQL, PL/SQL Stored procedures, functions, and exception handling using Toad and PLSQL.
  • Experience working in Agile methodology and ability to manage change effectively.
  • Responsible for Team Delivery and Participated in Design Reviews.
  • Excellent communication, interpersonal skills, enthusiastic, knowledge-hungry self-starter, eager to meet challenges and quickly assimilate latest technologies concepts and ideas

TECHNICAL SKILLS:

ETL Tools: Informatica 9.5/9.1/8.6.1/8.1//7.1.2/6.2 (Power Center), IDQ 9.6.1/9.0.1/8.6, MDM 9.7.1/9.5.1/9.1, SQL Server, SSIS,Pentaho

Data Modeling: Ralph Kimball Methodology, Bill Inman Methodology, Star, Snow-Flake, Fact Tables, Dimension Tables, Physical and Logical Modeling, Normalization and De Normalization.

Databases: Teradata V2R12/V2R6, Oracle 11g/10g/9i/8i/8.0/7.x, MS SQL Server 2008/2005, DB2 UDB, MS Access 2000, Sybase

Others: Toad, SQL Navigator, Crystal Reports, TSA, C#

Environment: MS Windows 2008/2005, LINUX, UNIXJob SchedulingAutosys, Control-M

PROFESSIONAL EXPERIENCE:

Confidential, Moline, IL

Sr. Informatica ETL Developer

Responsibilities:

  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Parsed high-level design specification to simple ETL coding and mapping standards.
  • Designed and customized data models for Data warehouse supporting data from multiple sources on real time
  • Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
  • Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
  • Cleanse and Scrub the Data in uniform data type and format applying MDM Informatica and IDQ tools and Load to STAGE and HUB tables and then to the EDW and Finally to Dimension and rollup/aggregate the data by the business grains into the FACT tables.
  • Primary activities include data analysis identifying and implementing data quality rules in IDQ and finally linking rules including Address Doctor to Power Center ETL processes and delivery to MDM Data Hub and other data consumers.
  • Developed MDM Hub Match and Merge rules Batch jobs and Batch groups.
  • Created Queries Query Groups and packages in MDM Hub Console.
  • Created mapplets to use them in different mappings.
  • Developed mappings to load into staging tables and then to Dimensions and Facts.
  • Used existing ETL standards to develop these mappings.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Involved in Analyzing / building Teradata EDW using Teradata ETL utilities and Informatica.
  • Modified existing mappings for enhancements of new business requirements.
  • Used Debugger to test the mappings and fixed the bugs.
  • Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 9.6.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer 9.1, PL/SQL, Oracle 11g, Erwin, Autosys, ERP, Ultra Edit, SQL Server 2005, Sybase, UNIX AIX, Toad 9.0, Cognos9.

Confidential, Denver, CO

Sr. Informatica ETL Developer

Responsibilities:

  • Created analysis of source systems, business requirements and identification of business rules.
  • Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
  • Worked on complex mappings, mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.
  • Extensively used ETL to transfer and extract data from source files (Flat files and DB2) and load the data into the target database.
  • Documented Mapping and Transformation details, user requirements, implementation plan and schedule.
  • Extensively used Autosys for Scheduling and monitoring.
  • Designed and developed efficient Error Handling methods and implemented throughout the mappings.
  • Responsible for Data quality analysis to determine cleansing requirements.
  • Worked with several facets of the Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings for better performance.
  • Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads.
  • Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance. Understand the business needs and implement the same into a functional database design
  • Prepared Unit/ Systems Test Plan and the test cases for the developed mappings.
  • Responsible for team members' work assignment and tracking.

Environment: Informatica Power Center 9.5/9.1, Oracle 11g/10g, DB2 7.1, SQL Server, UNIX(Sun Solaris5.8/AIX), Toad 10.0,SQL Developer 3.0, WinScp, Putty, SFTP/FTP, XML Editor, MS-Excel, Ms-Access.

Confidential, St. Louis -MO

Sr. Informatica ETL Developer

Responsibilities:

  • Interacted with business analysts and translate business requirements in to technical specifications
  • Using Informatica Designer, developed mappings to populate the data into target tables
  • Used Source Analyzer and Target Designer to import the source and target database schemas and the mapping designer to map the sources to the targets
  • Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows
  • Developed complex mappings/session using Informatica power center for data loading
  • Enhanced performance for Informatica session using large data files by using partitions, increasing block size, data cache size and target based commit interval
  • Extensively used aggregators, lookup, update strategy, router and joiner transformations
  • Develop the mappings to validate the detail files with control files to load various sales data into the system
  • Extensively used TOAD to analyze data and fix errors and develop
  • Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes
  • Developed UNIX shell scripts to automate repetitive database processes and maintained shell scripts for data conversion
  • Experienced in developing Web Intelligence, Desktop Intelligence and Crystal Reports using different Data Sources.
  • Designed web intelligence reports for dimensional hierarchical data
  • Created web reports through report template in Web Application Designer.
  • Created dictionaries using Informatica Data Quality (IDQ) that was used to cleanse and standardized Data. Worked with Informatica and other consultants to develop IDQ plans to identify possible data issues.
  • Extensively used IDQ which helped in debugging and also reducing development time.
  • Used Match and Consolidator transformation in IDQ which helped in reducing the duplicates.
  • Created several session and workflows in IDQ which we deployed in Power Center.
  • Extracted data from SAP R/3 and loaded into Oracle Data Warehouse.
  • Used Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively.
  • Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows.
  • Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
  • Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.

Environment: Informatica Power Center 9.5, IDQ 9.6.1, IDQ 8.6, MDM 9.7.1, Oracle 11g, Business objects, Power Exchange, Flat files,MS SQL server 2008, DB2 8.0, Erwin, SSIS, Winscp, Control-M, MS. Visio, Shell Script, UNIX.

Confidential, Milwaukee, WI

Sr. ETL/Informatica Developer

Responsibilities:

  • Created detailed Technical specifications for the ETL processes.
  • Performed ILIT (Irrevocable Life Insurance Trust) implementation and replacement activities.
  • Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
  • Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into databases.
  • Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
  • Developed the Informatica mappings using various transformations, Sessions and Workflows. SQL Server was the target database, Source database is a combination of Flat files, Oracle tables, People Soft, Excel files, CSV files etc.
  • Worked with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
  • Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
  • Involved with the DBA in performance tuning of the Informatica sessions and workflows. Created the reusable transformations for better performance.
  • Optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and mapplets.
  • Involved with the DBA in performance tuning of the Informatica sessions and workflows. Created the reusable transformations for better performance
  • Involved in writing UNIX shell scripts for Informatics ETL tool to run the Sessions.
  • Fixing and tracking mapping defects and implementing with enhancements.
  • Managing post production issues and delivering task/projects within specific timeline.
  • Involved in the mirroring of the staging environment to production.
  • Worked on Modification of Actuate report to upload and run reports on servers.
  • Worked on Autosys to schedule jobs, define dependencies and etc.
  • Collaborated with teams for migration and Production Deployment activities.
  • Scheduling Informatica jobs and implementing dependencies if necessary using Tidal Scheduler.
  • Responsible for performing SQL query optimization using Hints, Indexes and Explain plan.
  • Played a Vital role in requirement gathering, preparation of engineering gathering requirement specification.
  • Using Perforce as a versioning tool for maintaining revision history for code.
  • Managed production issues and delivered all assignments/projects within specified time lines.
  • Worked on all phases of multiple projects from initial concept through research and development, implementation, QA, to live production, by strict adherence to project timelines.

Environment: Informatica Power Center 8.1 IBM UDB DB2, SQL server 2008, SSIS, doc Loader, Embarcadero Rapid SQL 7.7.1, Autosys, Text Exceed 14, UNIX.

Confidential

ETL/Informatica Developer

Responsibilities:

  • Evaluating business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
  • Created detailed Technical specifications for Data Warehouse and ETL processes.
  • Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into databases.
  • Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
  • Applying most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
  • Extensively practiced Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
  • Involved in Initial loads, Incremental loads; Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner. Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
  • Extensively worked in the performance tuning of SQL, ETL and other processes to optimize session performance..
  • Integrated the data into centralized location. Used migration, redesign and Evaluation approaches.
  • Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
  • Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
  • Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
  • Extensively used Power Exchange to integrate the sources like Mainframe, DB2 and XML files.
  • Performance Tuning of SQL queries, SQL and PL/SQL coding.
  • Developed stored procedures using PL/SQL and driving scripts using Unix Shell Scripts.
  • Expertise in Debugging and Performance tuning of targets, sources, mappings and sessions. Managed Scheduling of Tasks to run any time without any operator intervention.
  • Leveraged workflow manager for session management, database connection management and scheduling of jobs.
  • Scheduling Informatica jobs and implementing dependencies if necessary using Tidal Scheduler.
  • Responsible for performing SQL query optimization using Hints, Indexes and Explain plan.
  • Managed production issues and delivered all assignments/projects within specified time lines.

Environment: Informatica Power Center 8.1, Power Exchange, Oracle 9i,DB2 8.0, SQL server 2008, Staples Loader, Toad 7.0, Tidal Enterprise scheduler, UNIX.

Confidential

ETL Informatica Developer

Responsibilities:

  • Involved in analyzing the data models of legacy implementations, identifying the sources for various dimensions and facts for different data marts according to star schema design patterns.
  • Developed complex mapping using Source qualifier, Aggregators, Connected & unconnected lookups, Filters & Update strategy.
  • Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.
  • Used Debugger to validate transformations by creating break points to analyze, and monitor Data flow.
  • Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
  • Worked along with the QA Team and provided production support by monitoring the processes running daily.
  • Defined Target Load Order Plan for loading data into Target Tables.
  • Implemented Slowly Changing Dimensions methodology and developed mappings to keep track of historical data
  • Written SQL overrides in Source Qualifier and Lookups according to business requirements.
  • Involved in troubleshooting the loading failure cases, including database problems.
  • Responsible for Documentation of the Test cases, completed modules and the results of acceptance testing.

Environment: Informatica Power Center 7.1.1, Oracle 9i, MS SQL Server 2005, UNIX, PL/SQL, UNIX shell scripting, SQL*PLUS, SQL, TOAD, Reports, MS Excel, MS Access, Flat Files, XML.

Confidential

Informatica Developer

Responsibilities:

  • Imported various Sources, Targets, and Transformations using Informatica Power Center Server Manager, Repository Manager and Designer.
  • Created and managed the global and local repositories and permissions using Repository Manager in Oracle Database.
  • Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
  • Used heterogeneous files from Oracle, Flat files and SQL server as source and imported stored procedures from oracle for transformations.
  • Designed and coded maps, which extracted data from existing, source systems into the data warehouse.
  • Used Dimensional Modeling Techniques to create Dimensions, Cubes and Fact tables.
  • Written PL/SQL procedures for processing business logic in the database. Tuned SQL queries for better performance.
  • Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager.
  • Generated completion messages and status reports using Informatica Server manager.
  • Tuned ETL procedures and STAR schemas to optimize load and query Performance.
  • Starting Sessions and Batches and make Event based scheduling
  • Managed migration in a multi-vendor supported Server and Database environments.

Environment: Informatica Power Center 7.1.2, DB2 v8.0, SQL, Windows 2000, UNIX, SQL Server 2000, Oracle 8i, Flat files, SQL *Plus, Business Objects 5.1.6

Hire Now