We provide IT Staff Augmentation Services!

 informatica Developer Resume

Jacksonville, FloridA

SUMMARY:

  • 5 years of experience in implementing Data Warehousing & Business Intelligence application end - to-end
  • 5 years of experience in Informatica, UNIX, SQL and PL/SQL
  • 1 years of experience in Callidus Cloud Compensation Design and Administration
  • Exposure to Design, Development and Implementation of data warehousing projects
  • Good understanding and experience with Data Modeling (ErWin), including both ER and Dimensional modeling
  • Efficient in performing Data cleansing, Scrubbing and validating the data before loading the data into Data Warehouse
  • Knowledge in Performance tuning, Load optimization for Informatica batch processes and enforcing repository best practices
  • Having experience on UNIX shell scripting
  • Experience with various tools such as TOAD, Oracle SQL Developer and job scheduling tools such as Tivoli Workload Scheduler (TWS) and Control-M
  • Knowledge in Variable Compensation Plans using Callidus Cloud Sales Compensation Application to pay the Agents and Agencies
  • Strong understanding of variable Compensation Design Concepts and Principles and design appropriate solutions
  • Good communication and presentation skills and ability to quickly adapt to the technical environment as a developer

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5/9.1/8.6 (Repository Manager, Designer, Work Flow Monitor, Work Flow Manager) RDBMS - Oracle 10g/11g, Teradata, MS-SQL Server 2008/12, SQL, PL/SQL

Languages/Utilities: HTML, XML, SQL, Oracle PL/SQL, UNIX shell scripting.

Tools: Oracle SQL Developer, TOAD, Tivoli Workload Scheduler (TWS), Control-M, MS Office

Engagement Experience: Applications Development, Application / Integration Testing, ETL Development, Query Performance Tuning, Application Debugging

Operating Systems: Windows 2000/XP/7, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, Florida

Informatica Developer

Responsibilities:

  • Involved in Analysis, Design, Development, Testing and Implementation of Informatica mappings and workflows for extracting the data from the multiple systems.
  • Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and Callidus Cloud Compensation Application
  • Designing mapping templates to specify high-level approach.
  • Extracted data from heterogeneous data sources with multiple databases and transformed into a harmonized data store under stringent business deadlines.
  • Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Repository server and Informatica server to load data from flat files, SQL Server.
  • Involved in PL/SQL programs like Procedures, Function, Packages, and Cursors to extract data from Target System.
  • Developed Slowly Changing Dimensions (SCD) Type 2 for loading data into Dimensions and Facts.
  • Designed the mappings between sources (files and databases) to operational staging targets.
  • Used Source Qualifier, Expression, Filter, Aggregator, Joiner, Lookup, Sequence Generator, Router, Sorter and Stored Procedures, Update Strategy transformations in populating data processes.
  • Involved in Migrating Repository.
  • Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into oracle Server.
  • Translated Business specifications into PL/SQL code. Designed, Developed and fine-tuned Oracle Stored Procedures and triggers.
  • Carried out Defect Analysis and fixing of bugs raised by the users.
  • Designed and implemented compensation plans using Callidus Cloud Compensation Application
  • Developed compensation plans on both Commissions UI and Incentive Compensation UI.
  • Designed the Sales Compensation Plans using the application functionalities like Plan Components, Plans, Rules, Classifiers and Compensation Elements.
  • Have setup Earning Groups, Event Types, Credit Rules, Measurement Rules, Incentive Rules and Commissions and Deposits.
  • Research compensation related issues and propose solutions

Environment: Informatica Power Center 9.5.1, PL/SQL, Oracle 10g, Oracle SQL Developer, Callidus Cloud Sales Compensation Application, Windows 2007, Unix, Toad, Control-M.

Senior Software Engineer

Confidential

Responsibilities:

  • Involved in Analysis, Design and Development, test and implementation of Informatica transformations and workflows for extracting the data from the multiple systems.
  • Worked cooperatively with the team members to identify and resolve various issues relating to Informatica.
  • Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
  • Developed mappings in multiple schema data bases to load the incremental data load into dimensions.
  • Experience in Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files & XML Files.
  • Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence Generator and Joiner transformations.
  • Created, launched & scheduled sessions and batches using Power Center Server Manager.
  • Used Connected and Unconnected lookups in various mappings.
  • Scheduled jobs using tools such as Tivoli Workload Scheduler (TWS).
  • Reviewed and documented existing SQL*Loader ETL scripts.
  • Analyzed the session and error logs for troubleshooting mappings and sessions.
  • Worked on SQL tools like TOAD to run SQL Queries to validate the data.

Environment: Informatica Power Center 9.1, PL/SQL, Oracle 10g, Teradata, SQL Server 2008/12, Windows 2000, UNIX, Shell Scripting, PL/SQL, TOAD 11.0.

Software Engineer

Confidential

Responsibilities:

  • Actively participated in understanding business requirements, analysis and designing ETL process.
  • Effectively applied all the business requirements and transforming the business rules into mappings.
  • Developed Mappings between source systems and Warehouse components.
  • Used Informatica designer to create complex mappings using different transformations to move data to a Data Warehouse.
  • Developed extract logic mappings and configured sessions.
  • Extensively used the Filter Control & Expression on Source data base for filter out the invalid data etc.
  • 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 9i.
  • Worked on Debugging, Troubleshooting and documentation of the Data Warehouse.
  • Created reusable transformations and mapplets to use in multiple mappings.
  • Handled the performance tuning of Informatica mappings.
  • Developed Shell Scripts as per requirement.
  • Prepared PLSQL scripts for data loading into Warehouse and Mart.
  • Fixed SQL errors within the deadline.
  • Making appropriate changes to schedules when some jobs are delayed.
  • Self-Review of Unit test cases, Integration test cases of all the assigned modules.

Environment: Informatica Power Center 8.6, Windows XP, Oracle 10g, UNIX/LINUX, SQL Server.

Hire Now