We provide IT Staff Augmentation Services!

Informatica Developer Resume

Jacksonville, FL

PROFESSIONAL SUMMARY

  • Overall 6 years of experience in Data Warehousing ETL tool INFORMATICA 9.6/9.5/8.6 and 5 years of experience in
  • Business Intelligence reporting in Confidential 10.1/10.2/8.4 , experience in Mainframe, Software Testing including UAT.
  • Duties are to develop and maintain the ETL environment, processes, and scripts to acquire data from various disparate systems and apply the data to tables in a database for reporting/analytics purposes
  • Use data analytics techniques such as data mining to analyze the source data and determine the best reporting structures to build
  • Manage the physical and logical data models in support of the data warehouse development and production environments
  • Review database design and integration of systems, provide backup recovery and make recommendations regarding enhancements and/or improvements
  • Formulate policies, procedures, and standards relating to database management, and monitor transaction activity and utilization
  • Direct the activities of Junior ETL Developers
  • Strong experience in Extraction, Transformation and Loading(ETL) data from various sources into
  • Data Warehouses and Data marts using Informatica Power Center as ETL tool on Oracle, DB2. XML, SQL and flat files.
  • Experienced in Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
  • Possess strong data warehouse applications knowledge
  • Possess experience with data migration initiatives and data warehouse concepts (cubes, star schemas, etc.), and experience with front - end web technologies (HTML, Confidential, JavaScript)
  • Possess knowledge and experience of working with relational databases and SQL
  • Possess expert-level SQL coding/querying skills in Oracle

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center , Data Stage, SSIS

Business Intelligence: Crystal Reports XI and XIR2

Databases: Oracle , MS Access

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, XML

Web Design: Dreamweaver , Flash

Oracle Tools: TOAD, SQL Developer, SQL Navigator, SQL*Loader, SQL*PLUS

Office Tools: MS OFFICE 2000

Webservices: SOAP UI,Webservice Hub(WSH), Informatica

Software Lifecycle Management Methods: Scrum, Agile, Spiral, and Traditional Waterfall model.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

  • Involved in gathering and analyzing the requirements and preparing business rules.
  • 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 and Flat files and loaded into Oracle.
  • 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 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.1.0.
  • 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.
  • Good understanding of source to target data mapping and Business rules associated with the ETL processes.

Environment: Informatica 9.1, Oracle 11g, SQL server 2008 R2, SQL, T-SQL, PL/SQL, Toad 10.6, SQL Loader, Tidal Enterprise Scheduler 5.3.1, Accurev, Unix, Flat files.

Confidential

ETL Developer

Responsiblities:

  • Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
  • Develop key integrations with both internal and external systems
  • Collaborate with team members to prototype, test, and debug code which will provide data for use in business reports
  • ETL development, testing, implementation, and support of integration solutions
  • Support ETL and Data Warehouse production, development & test environments
  • Conversion/Migration of data into new systems
  • Data analysis, data mapping, data loading, and data validation
  • Working with various sources such as Flatfiles, Relational, XML and Webservices as part of Informatica Mappings.
  • Worked with Mapping and Workflow variables by using the value of mapping variables on the workflow level.
  • Used concept of staged mapping in order to perform asynchronous Web Services request and response as part of Informatica Mappings
  • Responsible to tune ETL mappings to optimize load and query Performance
  • Wrote UNIX Shell Scripting for Informatica Pre-Session, Post-Session Scripts and also to run the workflows.
  • Worked on Shell Scripts in order to convert incoming Excel Flat files from .xls to .csv which helps importing into Informatica.

Environment: SQL, PL/SQL, HP Quality Center, Java XML, Oracle, PostgreSQL, Informatica, Business Objects, TOAD for Oracle

Confidential, Jacksonville, FL

ETL Developer

Responsibilities:

  • Understanding the functional specifications and the documents related to the Architecture.
  • Understanding legacy systems data and building, designing Target DB schema.
  • Identified suitable dimensions and facts for schema.
  • Helped users in building the scenarios.
  • Worked on Extraction, Transformation and Loading of data using Informatica.
  • Experienced in Informatica data quality (IDQ), power center, data cleansing, data profiling, data quality measurement and data validation processing.
  • Developing several complex mappings in Informatica a variety of Power center transformations, Mapping Parameters, Mapping Variables, Mapplets& Parameter files in Mapping Designer using both the Informatica PowerCenter and IDQ.
  • Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
  • Updated and remediate existing Business Intelligence scripts and Teradata applications to reflect changing business data requirements.
  • Performed profiling, matching, cleansing, parsing and redacting data using Informatica IDQ and implementing standards and guidelines
  • Used GSK application to setup the group and subscriber data in the FACETS application.
  • Participated in regular discussions with the Facets team to enter test data.
  • Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
  • Performed profiling, matching, cleansing, parsing and redacting data using Informatica IDQ and implementing standards and guidelines.

Environment: Informatica Power Center 8.6, Informatica Data Quality (IDQ), Toad, Teradata,Oracle 11g, PL/SQL, RDBMS, Facets 4.51, Unix Shell Programming, Control-M.

Confidential

ETL Developer

Responsibilities:

  • Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
  • Part of the Informatica upgrade project which was from version 7.0 to 9.0.
  • Testing and Redesigning the existing Informatica mapping/workflows as a part of upgrade.
  • Scheduling the Informatica and other related processes using MAESTRO schedulers and BEE(Nationwide own).
  • Modifying the UNIX scripts as a part of Upgrade and making sure they point to the correct directories.
  • Modifying table structure according to the new/changing requirement and also interacting with business users and DBA in order to be on the same page.
  • Working closely with the testers in order to help with overall-testing completion of the commited Iteration capacity(points).

Environment: Informatica Power Center 9.0/8.6 - (Designer, Repository Manager, Workflow Manager), Oracle 9i, Oracle 10g, TOAD, SQL Developer, AQT, UNIX Shell Scripts.

Hire Now