We provide IT Staff Augmentation Services!

Informatica Developer Resume

Des Moines, IowA

SUMMARY

  • 6+ years of experience in using ETL methodologies for supporting ETL data integration, DWH, Migration, ETL Architecture using Informatica Power Centre, Oracle, Tera Data.
  • Good understanding of Dimensional Modelling using Star schema methodology and Snow Flake schema methodology.
  • Extensively worked on data extraction, Transformation and loading data from various sources like Flat files, Oracle and Teradata.
  • Excellent experience in designing and development of ETL Methodology using Informatica PowerCenter 10.4, 10.2,9.6.1
  • Working experience in Agile methodology.
  • Good experience in working with onshore, offshore team and End to End teams to ensure commitments are met.
  • Having experience in working with ORACLE 12g/11g, Teradata 15 databases.
  • Strong skills in coding and debugging Teradata utilities like Fast Load, MultiLoad and Fast Export for Teradata ETL processing huge volumes of data throughput.
  • Expert in Change Data Capture (CDC) Methodology using Informatica PowerCenter 10.x/9. X
  • Hands on experience in preparing DMS/ Column Mapping Sheet for Dimensional modeling and Data marts Sources
  • Experienced in UNIX work environment, file transfers, job scheduling and error handling.
  • Hands of Experience in writing the script in order to automation the process for Dynamic Files
  • Worked extensively in design and analysis of Requirements, Development, testing and deployment.
  • Prepared various types of documents like ETL specification, Data Mapping, Test cases, Test Results etc.
  • Expert in writing SQL query using multiple databases like ORACLE, Teradata.
  • Extensive knowledge of Informatica tuning and SQL tuning.
  • Expertise in SQL and PL/SQL programming and also excellent in Analytical Functions, Stored Procedures, Functions etc.
  • Performed Unit testing and supported System testing and prepared test report in different phases of project.
  • Created and modified UNIX Shell Scripts for ETL jobs.
  • Designed and developed complex mappings, mapplets, tasks and workflows and tuned it.
  • Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.
  • Good understanding of the Data modeling concepts like Star - Schema Modeling, Snowflake Schema Modeling.
  • Extensively used Slowly Changing Dimension (SCD) technique in business application.
  • Prepared the Code Review Checklist, Standards document and Reusable components to be used across multiple projects.

TECHNICAL SKILLS

ETL TECHNOLOGY: Informatica PowerCenter 10.4, 10.2, 9.x

DATA WAREHOUSE: Star Schema, Snowflake schema

DATA MODELLING: Erwin 9.5/7.1

DATABASES: Oracle 12g/11g, Teradata 15

PROGRAMMING: C, C++, SQL, PL/SQL, UNIX Scripting

OPERATING SYSTEMS: Windows, AIX, Sun Solaris, UNIX

APPLICATIONS: MS Office, Toad

Others: Quest, TOAD, SQL*PLUS, WinSCP, Putty, Rally

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, Iowa

Informatica Developer

Responsibilities:

  • Prepared the mapping document from source to target called Detailed Design document
  • Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
  • Developed re-usable transformations, Mapplets following the Informatica best practices.
  • Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
  • Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse tables.
  • Involved in client interaction, analyzing issues with the existing requirements
  • Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.
  • Created Source landing tables, staging tables, history tables, transaction tables, summarized tables, control tables to improve the system performance
  • Migrated Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
  • Wrote hundreds of SQL queries for data analysis to validate the input data against business rules.
  • Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
  • Extensively worked on Unit testing for the Informatica code using SQL Queries and Debugger.
  • Created Unit test cases and executed the unit test cases and prepared the unit test logs
  • Used PMCMD command to start, stop and ping server from UNIX
  • Involved in performance tuning SQL and Informatica mappings/sessions by session partitioning techniques.
  • Coordinated with Autosys team to run Informatica jobs for loading historical data in production.

Environment: Informatica PowerCenter 10.4/10.2, SQL, Oracle 12g, TOAD, Autosys, Shell Scripting, Rally

Confidential, Cypress, CA

Informatica Developer

Responsibilities:

  • Used Workflow manager for session management, database connection management and job scheduling.
  • Worked with Business Users and Business analysts to understand business logic and Project Documentation.
  • Extract Data from Homogenous Sources, Heterogeneous Sources that Includes Fixed Width, De-Limited Files, Oracle and Teradata.
  • Used Source Analyzer and Designer to import source and target database schemas, Mapping Designer to map the sources to the target, Mapplets and Transformation Developer to reuse the logic.
  • Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.
  • Involve in the Development of complex Mappings, Mapplets for loading data into data warehouse using different transformations like Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
  • Used Workflow Manager to create reusable tasks, Worklets and Workflows and to integrate sessions in a workflow according to business need to load the data.
  • Developed sessions and workflows and effectively used the session’s capabilities to kick-off any pre- and post-session commands.
  • Involved in scheduling Daily, Weekly and monthly depending on the frequency of source data.
  • Involved in Performance Tuning of Mappings, identifying source and target bottlenecks and work with the sessions and workflow properties to improve performance.
  • Perform Unit tests on all the mappings developed and documented the test cases and test results.
  • Used TOAD to work with Database.
  • Involved in creating deployment checklist, versioning the jobs developed.
  • Created Teradata bteq scripts and used Fastload and Multiload Utilities
  • DevelopedStored Procedures, FunctionsusingPL/SQL.

Environment: Informatica PowerCenter 10.2, SQL, Teradata, SQL Assistant, WinSCP, Oracle 11g, TOAD, Control M, Shell Scripting, Rally

Confidential, Morrisville, NC

Informatica Developer

Responsibilities:

  • Used update strategy for effectively migrate data from source to target.
  • Moved the mappings from development environment to test environment.
  • Designed ETL Process using Informatica to load data from Flat Files to target Oracle Data Warehouse database.
  • Interacted with the business community to understand the Business requirements.
  • Created various transformations according to the business logic like Source Qualifier, Normalizer, Lookup, Stored Procedure, Sequence, Generator, Router, Filter, Aggregator, Joiner, Expression and Update Strategy.
  • Created design document for mappings based on business requirement.
  • Created Informatica mappings using various Transformations like Joiner, Aggregate, Expression, Filter and Update Strategy.
  • Involved in the performance improvement project.
  • Involved in designing of testing plan (Unit Testing and system testing).
  • Tested scripts by running workflows and assisted in debugging the failed sessions.
  • Improving workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.
  • Used connected and unconnected lookups whenever appropriate, along with the use of appropriate caches.
  • Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.
  • Perform Maintenance, including managing Space, Remove Bad Files, Remove Cache Files and monitoring services.
  • Migration of developed objects across different environments.

Environment: Informatica PowerCenter 9.6.1, Shell Scripts, ORACLE 11g, SQL, PL/SQL, UNIX, Toad, SQL Developer, Cognos 9, Autosys, Rally

Hire Now