We provide IT Staff Augmentation Services!

Sr Informatica Developer/ Technical Lead Resume

PROFESSIONAL SUMMARY:

  • Over 12+ years of Information Technology Experience in Data Warehouse Projects using Tools like Informatica Power Center 9.1/8.6/8.1.1/7. x/6.x, Power Exchange 8.x, Mapping Architect Visio and Informatica Developer (IDQ) tool.
  • Extensive experience in Banking and Financial Domains.
  • Strong Knowledge of Data Warehouse Architecture and Designing Star Schema, Snow flake Schema, FACT and Dimensional Tables.
  • Extensive experience in Extracting, Transforming and Loading of data using Informatica from different Source systems including flat files, RDBMS tables and Excel Sheet to Warehouse system.
  • Extensive experience in designing and developing Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
  • Hands on experience in Trouble shooting and implementing Performance tuning at various levels such as Source, Target, Mapping and Sessions.
  • Experience creating and administering repositories, folders, mappings, sessions, workflows, mapplets, User defined Functions and transformations using Repository Manger, Designer and Server Manager/Workflow Manager.
  • Experience in Administrative jobs like code migration, Import/Export utilities.
  • Hands on experience in creating & configuring sessions, workflows and worklets using the Workflow Manager of Informatica.
  • Worked on UNIX shell scripts in scheduling Informatica pre/post session operations.
  • Proficiency in data warehousing techniques for Data cleansing, Slowly Changing Dimension phenomenon’s (SCD’s) and Surrogate key assignment.
  • Hands on experience through complete Software Development Life Cycle (SDLC) including Analysis, Design, Development, Testing and Implementation.
  • Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers and Indexes.
  • Expertise in creating Database objects like Tables, Views.
  • Enthusiastic to learn the new Technologies through self - earning.
  • Completed/Learned the Big Data Technologies Hadoop, Hive, Pig & Sqoop training.
  • Interested to work in BIG Data Technologies.
  • Excellent communication, presentation skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS:

Data Warehousing: Informatica PowerCenter 9.1/8x/7x/6x, Hadoop, Hive, Pig & Sqoop Repository Manager, Designer, Workflow Manager, workflow MonitorSQL LoaderDatabases: Oracle11g/10g/9i/8i/7.3, Db2

Data Modeling: ERWIN 4.x/3.x, Ralph-Kimball Methodology, Bill-Inmon MethodologyStar Schema, Snow Flake Schema, Extended Star SchemaPhysical And Logical Modeling, Dimension Data ModelingFact Tables, Dimension Tables, Normalization, Denormalization

Programming: Unix Shell Scripting, SQL, and PL/SQL, Java

Other Tools: Tivoli Scheduling, Control-M Scheduling Tool, SQL*Plus, Toad, PuttyMs-Office.MS VISIO

PROFESSIONAL EXPERIENCE:

Confidential

Sr Informatica Developer/ Technical Lead

Environment: Informatica Power Center 9.1.0, Tivoli Scheduling, Netezza 7, LINUX, UNIX Shell Scripting

Responsibilities:

  • Working with Data architect team to understand functional and technical requirements
  • Creating source to target mapping document for ETL developers
  • Documenting various ETL standards to be followed which include both Informatica and Oracle Design standards
  • Creating various Informatica mappings to load data from Staging to Data warehouse (dimension and fact tables)
  • Working on Informatica Power Center to create various Type 1 and Type 2 mappings using transformations like Joiner, Lookup, Router, Filter, Union, Sequence Generator, Aggregator and Expression
  • Creating workflows and sessions to execute mappings using Workflow manager
  • Extensively worked in using mappings variables, session variables and workflow variables
  • Using UNIX parameter files at session and workflow level
  • Working on sessions to be executed in parallel or series based on requirement
  • Working on pre and post session commands to send email notifications using Informatica Workflow Manager and renaming files in UNIX
  • Creating Unit Test Plan and test case document for all ETL changes
  • Migrating ETL changes from DEV to QA. Also involved in taking Repository backup to avoid any loss of code being developed
  • Working with QA team providing Developer support and resolving any issues in test environment
  • Executing data loads in DEV and QA and collected statistics for all ETL jobs
  • Configured the Informatica Server to read data from MS ACEESS Database.
  • Worked with Admin team to setup the automated migration process in Jenkins to migrate the informatica mappings, Sessions, workflows & UNIX files.

Confidential

Technical Lead

Environment: Informatica Power Center 9.5.1, Tivoli Scheduling, Oracle 11g, SQL Developer 7.1.0, LINUX, UNIX Shell Scripting

Responsibilities:

  • Working with Data architect team to understand functional and technical requirements
  • Creating source to target mapping document for ETL developers
  • Documenting various ETL standards to be followed which include both Informatica and Oracle Design standards
  • Performing code review and approving the code to higher environment
  • Providing status updates to Project Manager by gathering updates from developers
  • Assigning tasks to developers based on priority
  • Involved in Datawarehouse design to load data in Staging and Datamart
  • As a developer, I am involved in developing various POC mappings for developers
  • Working on loading data into Staging from Oracle and flat files
  • Creating various Informatica mappings to load data from Staging to Datamart(dimension and fact tables)
  • Working on Informatica Power Center to create various Type 1 and Type 2 mappings using transformations like Joiner, Lookup, Router, Filter, Union, Sequence Generator, Aggregator and Expression
  • Created reusable lookup transformation for mappings which use static tables like Geography and Time dimension tables
  • Creating workflows and sessions to execute mappings using Workflow manager
  • Extensively worked in using mappings variables, session variables and workflow variables
  • Using UNIX parameter files at session and workflow level
  • Working on sessions to be executed in parallel or series based on requirement
  • Working on pre and post session commands to send email notifications using Informatica Workflow Manager and renaming files in UNIX
  • Extensively worked with Oracle admin to improve performance which include creating indexes, partitioning
  • Using oracle hints for better performance on SQL override queries
  • Walking through each Informatica module and implementing performance tuning logic on sources, targets and sessions
  • Implemented Error handling and Exception handling in Informatica Mapping Designer
  • Understanding data quality scenarios from business and implement the same in Staging
  • Creating Unit Test Plan and test case document for all ETL changes
  • Migrating ETL changes from DEV to QA. Also involved in taking Repository backup to avoid any loss of code being developed
  • Also worked as Informatica Admin in adding users to repository, creating folders for each project being developed and granting permissions to users
  • Working with QA team providing Developer support and resolving any issues in test environment
  • Executing data loads in DEV and QA and collected statistics for all ETL jobs
  • Using Informatica scheduler to execute jobs accordingly
  • Closely working with BO team and Risk Team(customers) to help understand the needs and make necessary ETL changes

Hire Now