We provide IT Staff Augmentation Services!

Senior Informatica Developer Resume

Santa Clara, CA

SUMMARY:

  • Having 9+ years of experience in analysis , design , development and testing client server environment with focus on Data Warehousing application using tools like Informatica PowerCenter9.x/8.x/7.x/6.x , Business Objects with Oracle , SQL Server databases
  • Proficiency in using Informatica Power Center tool to design data conversions from wide variety of source systems
  • Experience in using ETL methodologies for supporting Data Extraction , Data Migration , Data Transformation and developing Master Data using Informatica Power Center , Teradata
  • Involved in Full Software Development Life Cycle (SDLC) involving Application Development , Data Modeling , Business Data Analysis and ETL / OLAP Processes
  • Strong Data Warehousing ETL experience of using Informatica 9.6.1/9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager
  • Vast experience in Extraction , Transformation and Loading ( ETL ) data from various sources into Data Warehouse and Data Marts
  • Worked on Informatica Designer Components - Source Analyzer , Warehouse Designer , Transformation Developer , Mapplet and Mapping Designer .
  • Having good Knowledge on SQL & PL / SQL
  • Understanding the business requirements and producing quality work in time
  • Practical understanding of the Data modeling ( Dimensional & Relational ) concepts like Star - Schema Modeling , Snowflake Schema Modeling , Fact and Dimension tables
  • Strong experience in Extraction, Transformation and Loading ( ETL ) data from various sources into Data Warehouses and Data Marts using Informatica Power Center ( Repository Manager , Designer , Workflow Manager , Workflow Monitor , Metadata Manger ), Power Exchange , Power Connect as ETL tool on Oracle , DB2 and SQL Server Databases
  • Closely worked with business users in order to develop reports according to user requirements
  • Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server, DB2 8.0/7.0, UDB, SQL Databases, Mongo DB, MS Access and Teradata

TECHNICAL SKILLS:

Tools: JIRA, HP ALM/ Quality Center, QTP/UFT 12.0, Selenium WebDriver, SQL Developer,JMeter, Informatica Power Center 9.6,MYSQL

SDLC: Agile, Waterfall

Databases: Oracle 10g/11g, MS SQL Server.

Language: SQL, VB Script, C++, Fortran, Maple, AZ procede.

Operating System: Windows 2012,Windows 2008R2, Windows 7

PROFESSIONAL EXPERIENCE:

Confidential - Santa Clara, CA

Senior Informatica Developer

Responsibilities:

  • Responsible for Business Analysis and Requirements Collection .
  • Translated requirements into business rules & made recommendations for innovative IT solution
  • Involved in the Design and development of Data Mart and populating the data from different data sources using Informatica.
  • Documented data conversion, integration, load and verification specifications.
  • Parsing high-level design spec to simple ETL coding and mapping standards.
  • Worked with the various enterprise groups to document user requirements, translate requirements into system solutions and produce development, testing and implementation plan and schedule.
  • Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
  • Developed, documented and executed unit test plans for the components.
  • Set some understanding according to the business approach and making development while confirming with BA’s, if any BR (Business Rule) being used was not effective. In a way, that using the experience and business understanding to make out BR’s and implements them to design the business logics.
  • Documenting the developed code, run the sessions and workflows, while keeping track of source and target row count.
  • Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
  • Extensively used un-connected Look-Ups for minimizing the run time and add to the performance of the server, while making sure to avoid duplicates of data from other source systems .
  • Created pre-session and post-session shell scripts and mail-notifications.
  • Extensively worked on the Informatica Designer, Repository Manager, Repository Server, Workflow Manager/Server Manager and Workflow Monitor.
  • Extensive use of Performance tuning techniques to minimize the run time and create pre-session caches with load being balanced on server.
  • Extensive use of Performance tuning techniques to minimize the run time and create pre-session caches with load being balanced on server.
  • Created Workflows containing command, email, session, decision and a wide variety of tasks.
  • Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.
  • Co-ordinated with and led off shore team (India Development team).
  • Employed performance tuning to improve the performance of the entire system.
  • Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.

Environment: Informatica Power Center 10.1 (Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console), SQL Server 2014, Flat Files, Netezza

Confidential - CA

Informatica Developer

Responsibilities:

  • Analyzed the Specifications and identifying the source data needs to be moved to data warehouse.
  • Involved in Database design, entity relationship modeling and dimensional modeling using Star schema .
  • ETL mappings were developed to perform tasks like validating file formats, business rules, database rules and statistical operations.
  • Used Informatica Designer to create Reusable transformations to be used in Informatica mappings and Mapplets.
  • This project is intended to load and extract Procurement, Order Management, and Accounting data from Oracle database.
  • Performed tuning of Informatica sessions by using optimizing techniques such as database partitioning , increasing block size, data cache size, sequence buffer length, target based commit interval and SQL overrides. Identify the Bottlenecks in mappings.
  • Create test cases for the above projects in providing error free solution. Monitored Workflows and sessions using Workflow Monitor.
  • Involved in Error handling (Ignore, rejecting bad records to a flat file, loading the records and reviewing them).
  • Used Informatica Version Control for checking all the versions of objects, used in Mappings and Workflows to track the changes in Development, Test and Production environments.
  • Debug through Session logs and fix issues utilizing database for efficient transformation of data.
  • Prepared Mapping documents, Data Migration documents, and other project related documents like mapping templates and VISIO diagrams.
  • Expertise in Data Modeling using tools likes Erwin, ER/Studio and MS Visio along with the hands on experience in using Forward Engineering and Reverse Engineering functionality.
  • PL/SQL programming to create Oracle stored procedures and calling the procedures from Informatica sessions for data manipulation and error handling.
  • Used shell scripts for automating the execution of maps.
  • Experience in Working with Oracle PL/SQL, UNIX Shell Scripting in UNIX environment.
  • Develop technical documents in ease of improvements on existing code.
  • Involved in data conversion, migration, and integration quality profiling tasks.

Environment: Informatica Power Center 8.1, Oracle10g/9i, PL/SQL Developer, SQL Server 2005, UNIX, Windows 2003, AutoSys, Toad

Confidential - Austin, TX

Informatica Developer

Responsibilities:

  • Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis
  • Configured static lookups, dynamic lookups, bulk uploads.
  • Developed ETL mapping spreadsheet and Fact-Dimension matrix prior to performing the ETL process
  • Involved in Data modeling for GL Data Mart to bring in various set of books assets and balances into the warehouse
  • Used complex transformations such as Connected and Unconnected Lookups, Joiner, Router, Filter and Stored Procedure transformations for data loads
  • Worked with Memory management for the best throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations and involved in pipeline partitioning
  • Debugged and implemented the best practices in mappings, sessions and workflows for data extraction and loading into Slowly Changing Dimensions type 1 and type 2
  • Created and scheduled Informatica workflows .

Environment: Informatica Power Center 9.6, Oracle 11g, Oracle PL/SQL, Windows Application Server, SQL Server 2008 R2

Confidential - Santa Clara, CA

Informatica Developer

Responsibilities:

  • Worked with business requirements analyst to identify and understand source systems.
  • Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, and Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.
  • Cleansed the source data, extracted and transformed data with business rules, and built reusable transformation logic, known as ‘Mapplets’ using Informatica Designer.
  • Modified several of the existing mappings and created several new mappings based on the user requirement.
  • Used the Debugger in debugging some critical mappings to check the data flow from instance to instance.
  • Created various tasks like sessions, worklets, and workflows in the workflow manager to test the mapping during development.
  • Involved in Performance tuning of various mappings and sessions to increase the performance.
  • Created and executed test cases for Unit and System Testing .
  • Extensively worked on tuning and thereby improving the load time.
  • Developed all the mappings according to the design document and mapping specs provided and performed unit testing.
  • Used Workflow monitor to see the work flows running and get the session properties and session log.
  • Performed unit testing and documented the unit test plan and its results.

Environment: Informatica PowerCenter, Microsoft Visio 2003, Oracle 8i/9i, PL/SQL, UNIX, Windows NT/2000 and Siebel

Confidential

Informatica Administrator

Responsibilities:

  • Responsible in drafting the SQL queries as per business and Transformation rules.
  • Responsible to work on Dim and fact tables.
  • Responsible to validate to source feeds, source tables and target tables as per business and transformation rule.
  • Analyzing and Understanding the Mapping document
  • Understanding Business Rules and transformation rules
  • Analyzing and understanding the software Requirement Specifications.
  • Creation and Execution of Test Cases.
  • Reviewing Test Cases of team members.
  • Logging defects in QC.
  • Onsite Coordination.
  • Daily Status Reporting.
  • Maintain documentation of test results
  • Follow agreed upon quality processes and standards

Environment: ETL Informatica, OS,QCNetezza,

Hire Now