We provide IT Staff Augmentation Services!

Infomatica Developer Resume

Chicago, IL

PROFESSIONAL SUMMARY:

  • 10 Years of IT experience with Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
  • 9 Years of experience with Strong Data Warehousing ETL experience of using Informatica 9.6/9.1/8.6.1/8.5/8.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
  • Experience in using various types of transformations like Aggregator, Rank, Router, Normalizer, Sorter, Lookup, Update Strategy, Stored Procedure, Joiner, Filter, External Procedure, Sequence Generator and Source qualifier etc.
  • Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
  • Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
  • Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
  • Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica PowerCenter (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
  • Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
  • Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
  • Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
  • Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting
  • Experience in Production Support, Troubleshooting ETL jobs and follow escalation procedures to resolve the issue
  • Having experience in collaborating with larger DM team to meet SLA and provide technical solutions as required resolving complex production issues. Provide on call support for Informatica ETL jobs
  • Participated in upcoming releases, risks, mitigation plan and create implementation plan
  • Experience in using Automation Scheduling tools like Autosys, Control-M and Crontab.
  • Experience in CI Technologies like Jenkins and Spinnaker
  • Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, Flat Files, JAVA into the staging area, ODS, Data Warehouse and Data Mart.
  • Worked extensively with slowly changing dimensions.
  • Hands-on experience across all stages of Agile Methodology including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
  • Excellent interpersonal and communication skills, and is experienced in working with managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

ETL Tools: Informatica Power center 9.6/9.0/8.6

Scheduling Tools: Control-M, Crontab

CI Technologies:: Jenkins and Spinnaker

OLAP Tools: Cognos 8.0/8.1/8.2/8.4/7.0/, Business Objects XI r2/6.x/5.x, OBIEE 10.1.3.4/ 10.1.3.3

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2 v8.1, Teradata

Data Modeling: Star schema and Snowflake schema, Erwin, Toad

Operating Systems:: Windows 2000/07/NT/XP, UNIX (Sun-Solaris, HP/UX), LINUX.

Scripting languages:: Windows scripting, UNIX Scripting.

Languages: C, C++, SQL, PL/SQL, Java,J2EE.

Packages: SQL* PLUS, Toad 7.x, SQL Developer

Web Technologies: HTML, DHTML

Applications: MS Word, Excel, Outlook, and PowerPoint.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Infomatica Developer

Responsibilities:

  • Involved in gathering and analyzing the requirements and preparing business rules for migration from Oracle to Informatica.
  • Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
  • Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
  • Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server,Netezza,Abinitio and Flat files, java and loaded into Teradata.
  • Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
  • Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
  • Extracted data from different databases like Oracle,Netteza,Abnitio and external source systems like flat files using ETL tool.
  • Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
  • Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.6
  • Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
  • Involved in Performance Tuning of mappings in Informatica.
  • Experienced to work in Development team, Production support teams in handling critical situations to meet the deadlines for successful completion of the tasks/projects.
  • Troubleshooting ETL jobs and follow escalation procedures to resolve the issue with in SLA
  • Collaborate and provide technical solutions as required to resolve complex production issues
  • Daily monitored around 70 workflows/mappings which are running into

Environment: Informatica 9.6, Oracle 11g, Scheduler crontab, Unix, Flat files, Reporting BI

Confidential, AUSTIN, TX

Infomatica Developer

Responsibilities:

  • Worked in different changes of project from Development, enhancement and production maintenance.
  • Worked on view to extract data and load into target based on incremental Strategy.
  • Extensively used Informatica Power Center tools and Transformations such as Lookup, Aggregator, Joiner, Ranking, Update Strategy.
  • Understanding & working Knowledge of CDC(Change Data Capture).
  • Worked with pre and post sessions and extracted data from Transaction system into Staging Area.
  • Prepared ETL design document which consists of the database structure, change data capture, Error handling, restart and refresh strategies
  • Created mapping for creating a parameter file
  • Worked with DBA's to design and build the Staging/Target databases
  • Developed Unix Shell Scripts for pre and post session tasks and for scheduling workflows. .Performed Unit and Integration testing and wrote test cases.

Environment: Informatica 9.6, Oracle 11g, Scheduler Crontab, Unix, Flat files, Reporting BI

Confidential, Irvine, CA

Informatica Developer

Responsibilities:

  • Working with different source systems like flat files, Oracle,Java,Xml
  • Contacting the Business Analysts/Users to develop, document and to evolve process and data models based upon their input and feedback
  • Experience in Agile methodology
  • Experience translating business requirements into Conceptual and Logical Process and Data Models.
  • Experience in preparing Logical data models as well as Physical data models and document the same
  • Worked extensively on different types of transformations like source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Union, Stored Procedure and sequence generator.
  • Created reusable transformations for converting varchar into upper case and string to date
  • Created Mapplet for history management dates, ETL Process status
  • Created mapping for error handling sessions
  • Participated in Data modeling meetings, helped to identify the relationship between tables according to the requirements
  • Prepared ETL design document which consists of the database structure, change data capture, Error handling, restart and refresh strategies
  • Created mapping for creating a parameter file
  • Worked with DBA's to design and build the Staging/Target databases
  • Assisted business users for data cleansing and user acceptance testing
  • Worked in Informatica Power Center for the Extraction, Transformation and Loading from various sources to the enterprise data warehouse
  • Developed and tested extraction, transformation, and load (ETL) processes
  • Involved in change data capture (CDC) ETL process
  • Created sessions and workflows for the source to staging data flow and staging to Target loading
  • Implemented Type II changes for different Dimensions
  • Developed functions and stored procedures to aid complex mappings

Environment: Informatica PowerCenter 8.6, Java, Oracle 9i, SQL developer, TOAD, Windows NT/XP, HP Quality center 10.0,cognos.

Confidential, Cupertino, CA

Informatica Developer

Responsibilities:

  • Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Worked on gathering, analyzing and documenting business reqs
  • Involved in the team during the entire ETL process and development of data marts using Informatica Power Center.
  • Worked with enterprise architects to develop the new logical and physical ER data models in line with corporate standards and guidelines.
  • Created the necessary documentations like High Level Design document (HDD), Detail Design Document (DD) with the ETL Mapping Matrix for the new data marts.
  • Created Informatica Mappings to load data and used transformations like Stored procedure
  • Transformation, Connected and Unconnected lookups, Source Qualifier, Expression, Sorter,
  • Aggregator, Joiner, Filters, Sequence, Router and Update Strategy transformations.
  • Architected and developed Fast Load and MLoad scripts, developed BTEQ scripts to process the data in staging server.
  • Worked on Variables, Parameters, Parameter files and File list on Informatica.
  • Implemented slowly changing dimensions (Type I and Type II) for customer Dimension table loading.
  • Extensively used Stored Procedures, Functions and Packages using PL/SQL for creating Connected and Unconnected Stored Procedure Transformations.
  • Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run Confidential specified time and as well to read data from different sources and write it to target databases.
  • Involved in writing Automation Testing scripts using Shell and worked on Maestro to schedule these scripts in DEV and QA environments.
  • Extensively used Toad during development and testing to ensure data quality and investigate data issues.
  • Performed Unit and System Testing as per the test plan and documented the test results as per the corporate standards. Monitored the data loads during UAT tracked and resolved the defects raised by the business users.
  • Involved in development of programs for Extraction and Transformation, Fast Load and
  • MLoad scripts developed BTEQ scripts to process the data in staging server.
  • Created documentation such as Run Books, Technical Architecture Specifications, Source to Target Mappings, Data Flow Diagrams for the users and the support team.
  • Weekly status meeting with the client to communicate the development progress and any issues arising during Design, Development and Testing phases.
  • Ensured that the documentations comply with the corporate stand.

Environment : Informatica Power Center 9.1, power Exchange, Oracle10g, DB2, SQL Server 2008, MY SQL, XML, HP Quality Center 9.0, Toad, SQL Developer, Control - M, PL/SQL (Stored Procedures, Triggers, Packages), Erwin, UNIX shell Scripting, AIX, Windows XP

Confidential, Bakersfield, CA

Informatica Developer

Responsibilities:

  • Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
  • Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
  • Developed standard and re-usable mappings and Mapplet using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
  • Involved in analysis, requirements gathering, functional/technical specification, and development, deploying and testing.
  • Involved in designing Oracle schemas for specific functional areas.
  • Provided back-end support for customized forms for customer, supplier maintenance, bill, receipt, letter of credit, invoice, debit and credit notes.
  • Doing unit testing on reports, PL/SQL stored procedures, functions, triggers, packages, views and cursors.
  • Implemented archiving process on huge FACT table, which included creating of stored procedures for adding and dropping Partitions on table based on the Business requirements.
  • Analyze, design and develop stored objects in PL/SQL to improve the performance of data load
  • Scheduled ETL loads using CRONTAB and provided monitoring using Workflow Monitor
  • Design and develop relevant triggers, stored procedures, sub-programs and packages with advanced PL/SQL programming techniques such as ref cursor, collections, and bulk operation.

Environment: Informatica 8.1, Oracle 9i, HP-UNIX, Flat Files, IBM DB2, PL/SQL Developer and TOAD.

Hire Now