We provide IT Staff Augmentation Services!

Sr. Informatica Developer Resume

0/5 (Submit Your Rating)

PA

SUMMARY

  • About 8 years of IT experience in the design, development and testing of Data Warehousing applications involving ETL - Informatica Power Center 9.5/9.1/8.6/8.1/7.1 , Oracle 11i/10g/9i
  • Extensive experience with ETL tool Informatica in designing and developing Mappings, Mapplets, Transformations, Workflows, Worklets and scheduling Workflows, Sessions.
  • Extensive experience in various ETL processes such as extraction, transformation and loading from various sources into Data Warehouse.
  • The various data sources/targets include Flat Files, COBOL Files, Oracle, SQL Server, Teradata and DB2.
  • Extensive experience on Informatica Power Centre/Power Mart.
  • Strong Experience in creating complex mapping using various Transformations such as Aggregator, Expression, Ranking, Router, Lookup, Filter, Joiner, Update Strategy transformations.
  • Experienced in loading data into Data Warehouse/Data Marts using Informatica, Oracle Scripts and SQL*Loader.
  • Experience with working on Informatica Push Down Optimizations.
  • Involved in all the phases of a project lifecycle including writing test scripts and performing unit-testing.
  • Excellent data analysis skills and the ability to transform business logic into mappings using various transformation logics in Informatica.
  • Thorough knowledge in Data Warehousing concepts like Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snow Flake Schema, Fact Table, Dimension Table and Dimensional Data Modeling.
  • Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
  • Strong knowledge in databases which include Oracle, SQL Server, DB2 and Teradata.
  • Good experience in using Oracle PL/SQL to create stored procedures, functions, packages and triggers.
  • Good experience in using SQL Scripts Views/Procedures/functions.
  • Worked on Informatica Data Explorer (IDE), Informatica Data Analyzer and Informatica Data Quality (IDQ) for analysis of data and quality.
  • Good knowledge in fine tuning Informatica mappings, identifying Bottlenecks and resolving them to improve the performance of the data loads.
  • Extensive experience in creating complex mappings using various transformation logics and also very good experience in working with Type 1, Type 2 and Type 3 Slowly Changing Dimensions.
  • Experience in handling job scheduling tools such as Autosys and Control-M.
  • Created Documentation of the ETL processes and also involved in Production Support.
  • Experience in developing Shell scripts on UNIX.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9x/8x, Informatica Power Mart 7x/6x, Informatica Power Exchange 7.x/8.x/9.x, Repository Admin console, Repository Manager, Designer, Workflow Manager, workflow Monitor.

Databases: Oracle11x/10g, Sybase12.0/11.x, Teradata 13/12, DB2 UDB 8.0/7.0, MS SQL Server 2008/2005/2000 , MS Access 2003/2000.

BI Tools: OBIEE 10.x, Cognos 8.4.1 (Framework manager and Transformer).

Programming: C, C++, UNIX Shell Scripting, SQL, T-SQL, and PL/SQL.

Environment: Windows XP/2000/98, Win NT, UNIX, MS-Dos.

Data Modeling: ERWIN 4.x/3.x, Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical and Logical Modeling, Dimension Data Modeling, Fact Tables, Dimension Tables, Normalization, Denormalization.

Other Tools: SQL*Plus, Toad, SQL Navigator, Ms-Office.MS VISIO.

PROFESSIONAL EXPERIENCE

Confidential, PA

Sr. Informatica Developer

Responsibilities:

  • Analyzing the business specification documents and interacting with business owners for clarifications.
  • Loading Data to the Target Data Warehouse Tables from multiple data sources such as Oracle9i/10g, Flat files and Excel Spreadsheets using Informatica Power Center and ODBC connection.
  • Implemented Aggregate, Filter, Join, and Expression, Lookup, Sequence generator and Update Strategy transformations.
  • Simplified the data flow by using a Router transformation to check multiple filter conditions at the same time.
  • Executed the Unit Test Cases using Sample data and reported the defects.
  • Test all the applications and transport the data to target Warehouse Oracle tables on the server, Schedule and Run Extraction and Load process and monitor sessions by using Informatica Workflow Monitor.
  • Extensively used the debugger in Informatica Power Center Designer to debug and fix any logical errors in the connections between the transformations in the mappings.
  • Documented the complete Mappings, Sessions, Mapplets and Workflows.
  • Migrated mappings, workflows from one environment to another environment (Lower to Higher).
  • Used Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process
  • Helped tune the database to resolve performance issues and ensured high performance through periodic performance evaluation and improvements.
  • Responsible for creating, handling and taking care of Parameter File Modifications in new releases and enhancement.
  • Load monthly, weekly, daily data, to track issues and resolve them based on the priority.
  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
  • Monitored all aspects of organizational business engagements, both internal as well external, to ensure that the interfaces are developed and delivered to meet ETL standards and best practices
  • Extensively used the debugger in Informatica Power Center Designer to debug and fix any logical errors in the connections between the transformations in the mappings.
  • Prepared Informatica Mapping Document and also involved in the preparation of the Informatica check list, Batch Check list as per client provided standards.
  • Responsible for monitoring the batches on regular basis for smooth going.
  • Fixing the PCR’s for the enhancements

Environment: Informatica Power Center 9.5/9.1,Oracle 11i/10g,Cognos 8.4.1, Benthic Golden, PL-Edit, PL/SQL, MS.Net, ATS, Windows 2000/XP,IBM Main Frame, Proprietary scheduling tool OPCON, MS Visio

Confidential, Richmond, VA

Informatica Developer

Responsibilities:

  • Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Filter and Router transformations.
  • Worked on Informatica tool - Source Analyzer, Data warehouse designer, Mapping Designer & Maplet and Transformations.
  • Fine tuned the existing Informatica mappings for better performances.
  • Worked with Teradata Utilities like MLOAD, TPUMP and FASTLOAD to improve the performance and for faster loading.
  • Extensively used ETL to load data from flat files to Teradata database.
  • Working on migration project in which we are retiring Oracle database and moving to Teradata.
  • Used UNIX scripting for file formatting before it gets into Informatica.
  • Involved in performing impact analysis before any enhancements are made to the existing Informatica code or existing Tables.
  • Created a code review check list that will be used in reviewing the Informatica code before the code gets migrated to different environment.
  • Parameterized all the connection information and input output files for Informatica.
  • Created system defects to inform the project team about the status throughout the process.
  • Involved in the Unit testing, Event and System testing of the individual.
  • Efficient Documentation was generated for all mappings and workflows.
  • Efficient Unit testing documentation was created along with Unit test cases for the development code.
  • Involved in production support for the first 3 weeks after the code migrated to production

Environment: Informatica Power Center 8.6.1, Oracle 11g, DB2 version 9.5/8.2, SQL*Loader, SQL Navigator, SQL, PL/SQL, Cognos version 8.4/8.1,, XML, IDQ, Toad 9.1, DB Visualizer, Windows server 2003/2005.

Confidential, Columbus, OH

Informatica Developer

Responsibilities:

  • Worked on developing Unix scripts for data cleansing and data archiving
  • Created complex mappings using Unconnected Lookup, Sorter, Aggregator, Union, Rank, Normalizer, Update strategy and Router transformations for populating target table in efficient manner.
  • Implemented slowly changing dimension Type 1 and Type 2 for Change data capture using Version control.
  • Involved in Creation of SQL, Packages, Functions, Procedures, Views, and Database Triggers.
  • Expertise in configuration, performance tuning, installation of Informatica, & in integration of various data sources like Oracle, MS SQL Server, XML, Flat files into the staging area and Design ETL processes that span multiple projects
  • Created various Oracle database objects like Indexes, stored procedures, Materialized views, synonyms and functions for Data Import/Export.
  • Created reusable worklets and workflows.
  • Used Transformation Language functions in the mappings to produce the desired results.
  • Used TOAD to run SQL queries and validate the data in warehouse and mart.
  • Involved in Debugging and Troubleshooting Informatica mappings.
  • Populated error tables as part of the ETL process to capture the records that failed the migration.
  • Designed ETL process using Informatica Tool to load from Sources to Targets through data Transformations
  • Implemented various Data Transformations using Slowly Changing Dimensions
  • Developed test cases for Unit, Integration and system testing
  • Involved in Maintaining the Repository Manager for creating Repositories, user groups, folders and migrating code from Dev to Test, Test to Prod environments.
  • Partitioned the Sessions for better performance.
  • Wrote SQL Scripts and PL/SQL Scripts to extract data from Databases

Environment: Informatica Power Center 8.1, UNIX, Oracle 10g, SQL, PL/SQL, Oracle Designer, Toad, Perl

Confidential, Huntsville, AL

Informatica Developer

Responsibilities:

  • Developed complex mappings with various Informatica transformations like Aggregator, Lookup (Connected, Unconnected), Source Qualifier, Update Strategy, Router, Joiner, Filter and Expression.
  • Involved in admin tasks like analyzing Table Space requirement, load balancing and Performance
  • Wrote the complex SQL queries to retrieve the data from different sources to validate.
  • Designed and developed efficient Error Handling methods and implemented throughout the mappings.
  • Used Dynamic SQL programming technique to build and process SQL statements "on the fly" at run time.
  • Tuned performance of Informatica sessions for large data files by implementing pipeline partitioning, Push down optimization technique and increasing block size, data cache size, sequence buffer length and target based commit interval and resolved bottlenecks.
  • Extracting Incremental data (Change Data Capture) from Source Systems using Informatica Power Exchange.
  • Experienced with Dimensional Data Modeling Techniques like Star Schema, Snowflake Schema, Surrogate Keys, Conformed dimensions and slowly Changing dimensions modeling design.
  • Used Informatica Tool to integrate Data from Excel files, UDB, Legacy Data providers and third party vendors for the large volumes of data.
  • Wrote UNIX (IBM-AIX) shell scripts and ran as Pre-Session, Post-Session scripts.
  • Developed Business Objects Universe, Reports for various Balance Scorecards, Reports for monthly, Quarterly, Yearly, Charts, Bar Graphs, Drill Down reports and Trend Reports.
  • Prepared test data for data driven tests for testing the application dynamically.
  • Reviewed computer logs (UNIX logs & Shell Scripts), reported program-processing errors.
  • Used Autosys to schedule the jobs.
  • Assisted in updating the logical model with all related entities, attributes and relationship with each entities based on the rules provided by the business manager using Erwin 4.0.

Environment: Informatica Power Center 8.0/7.1.3, Erwin 4.0, Power exchange, CDC, Windows 2000, Oracle 9i/8i, SQL Server 2000,PL/SQL, Sybase 11.x, Mainframes, DB2, Flat file, Erwin, TOAD, AIX, Autosys, Unix, Linux

Confidential, Woodcliff Lake, NJ

ETL Informatica developer

Responsibilities:

  • Involved in Analysis phase of the business requirement and design of the Informatica mappings.
  • Used various transformations of Informatica, such as Source Qualifier Transformation, Expression Transformation, Look-up transformation, Update Strategy transformation, Filter transformation, Router transformation, Joiner transformation etc for developing Informatica mappings.
  • Developed Informatica mappings for TYPE 2 Slowly Changing Dimensions.
  • Creating sessions and work-flows for the Informatica mappings.
  • Configuring sessions for different situations including incremental aggregation, pipe-line partitioning etc.
  • Creating mappings with different look-ups like connected look-up, unconnected look-up, Dynamic look-up with different caches such as persistent cache etc.
  • Creating various mapplets as part of mapping design.
  • Writing Oracle stored procedures and functions for calling during the execution of Informatica mapping or as Pre or Post session execution.
  • Writing UNIX shell scripts for execution of the Informatica sessions and work-flows.
  • Involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.
  • Extensively involved in testing by writing some QA procedures, for testing the target data against source data.

Environment: Informatica 7.1.4/8.1.1 , IBM Mainframes, UNIX, Windows XP, Oracle 9i, SQL, PL/SQL, SQL * Loader, SIEBEL, DB2, SQL Server, SAP, Toad, Mercury Quality Center.

Confidential

Data warehousing developer

Responsibilities:

  • Involved in the requirement definition and analysis in support of Data Warehousing efforts.
  • Created Repository using Repository Manager.
  • Worked Extensively on Informatica tools -Repository Manager, Designer and Server Manager.
  • Involved in Extraction, Transformation and Loading (ETL) Process.
  • Created the Source and Target Definitions using Informatica Power Center Designer.
  • Imported an XML file to Designer, did some modifications, used in the Mappings and exported into an XML file.
  • Developed and tested all the backend programs, Informatica mappings and update processes.
  • Created and Monitored Batches and Sessions using Informatica Power Center Server.
  • Tuned the mappings to increase its efficiency and performance.
  • Used Informatica Workflow Manager to create workflows
  • Workflow Monitor was used to monitor and run workflows
  • Involved in production support which also includes trouble shooting of connectivity issues.

Environment: Informatica PowerCenter 5.1/6.2, Oracle 8i, UNIX, TOAD, SQL * Loader, Windows NT.

We'd love your feedback!