We provide IT Staff Augmentation Services!

Senior Informatica Developer Resume

0/5 (Submit Your Rating)

BostoN

SUMMARY

  • Over all 8+ years of Data Warehousing experience using Informatica Power Center 7.1.3/8.6.1/8.1.1/9.1.0 , Oracle 10g/11g, SQL, PL/SQL, UNIX and DB2.
  • Used IDQ (Informatica Data Quality) to extract, transform and load (ETL) rules and source - to-target mappings to derive additional business rules for data quality checks.
  • Have good understanding on Latest Informatica Power Center 9.5 and its added features.
  • Experience in Information Technology with strong business understanding into different domains like Banking, Insurance, Finance, Pharmaceuticals-Healthcare and Telecom Sectors..
  • Experience in performing ETL procedures to load data from different sources like Oracle 9i/10g, DB2, XML Files, Flat Files, MS SQL Server and MS Access into Data marts, Data warehouse using Informatica Power Center.
  • Experience using Oracle Business Intelligence Enterprise Edition (OBIEE) 10g and Oracle BI Apps.
  • Build custom profiles using IDQ to analyze the data and also run scorecards.
  • Used different Data Quality transformations like Standardizer, parser, Match, etc. in the mappings.
  • Proficient in performance tuning of Informatica Mappings, Transformations, and Sessions; experienced optimizing query performance.
  • Experience in Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica
  • Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using CDE/CDC/ SCD (Type1/Type2/Type3) loads.
  • Experience in writing PL/SQL functions using PL/SQL developer.
  • Database experience using Oracle 10g/9i/8.x/7.x, MS SQL Server 2000 and MS Access.
  • Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse
  • Proficient in Performance Tuning of Informatica Mappings, Transformations, Sessions and experienced optimizing query performance.
  • Used complex Informatica transformation like Normalizer, Transaction control, UDF’s and SCD’s (Type 1, Type 2 and Type 3).
  • Experience in integration of various data sources like Oracle, DB2, SQL Server, Flat Files, XML, and Mainframe into Warehouse.
  • Implementation and Support of various OLTP, Data Warehousing, and OLAP applications
  • Experience working in Oracle8i/9i/10g/11g with database objects like triggers, stored procedures, functions, packages, views, and indexes.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center (Source Analyzer, Repository Manager, Data warehousing designer, Mapping Designer, Mapplets, Transformations, Work flow Manager, Task Manager).

Reporting Tools: Business Objects, BO Web Intelligence, Xcelsius 2008.

Databases: Oracle 10g,8i,9i

Languages: SQL, PL/SQL, MS-Excel, Unix Shell Scripting.

GUI Tools: SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential, Boston

Senior Informatica Developer

Responsibilities:

  • Design, develop and test complex ETL code as per user requirement/ stories.
  • Develop Technical Design Documents as per Enterprise DataWarehouse requirements.
  • Assist Data Architect during design phase and ensure data model meets ETL and Business Requirements.
  • Ensure schema supports the ETL jobs and meets performance and Data Capacity requirements.
  • Create ETL architecture documents for entire project team.
  • Provide guidance to testing team for creating test scripts.
  • Schedule jobs as per requirement using Autosys and Control-M.
  • Manage end user Business Intelligence needs.
  • Assist the team in creating DDL and patch requests across environments.
  • Provide implementation support and creating of environments.
  • Improved the Query Performance by applying new techniques and removing wasteful processing of data by identifying and removing dormant and redundant data throughout the Data Warehouse.
  • Provide inputs to project manager on timeline of deliverables.
  • Break down entire project into sprints and provide assistance to the Project Manager on planning.
  • Develop support document for proper transition of jobs to support teams.
  • Assist in code migration using Repository Manager.
  • Manage conflicting requirements and identify priority of work

Environment: Informatica Power Center 9.1.0, IDQ, IBM AIX/Linux, Oracle 10g/11g, MS SQL Server 2005/ 2008, Mainframe, Autosys, Crystal Enterprise, Data Vault Methodolgy.

Confidential, Dublin, OH

Informatica/ETL Developer

Responsibilities:

  • Involved with the Business analysts in requirements gathering, and business analysis
  • Created Profile report used IDQ to know weakness and strengths of source data and also created Scorecards.
  • Understand existing DQ landscape to provide key insights on the scope and magnitude of DQ issues and supporting Processes and procedures
  • Assist in the design of an efficient reliable ETL mechanism for updating the data warehouse, data marts and downstream systems.
  • Involved in preparing the Design Specifications for ETL Coding and mapping standards.
  • Analyzed various Source Systems for Implementation.
  • Worked Extensively on Informatica tools Repository Manager, Designer and Workflow Manager and Workflow Monitor.
  • Identified data quality issues, anomalies, patterns, based on defined business rules and created metrics and score Cards by IDQ Profiling.
  • Designed Source to Target mappings to extract data from heterogeneous sources such as Oracle, Flat files, DB2 as source and load it to the target tables.
  • Involved in creating the backup of the repository.
  • Worked with various transformations such as Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored procedure, Sequence Generator, Rank.
  • Configured and used the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager.
  • Performed tuning of Informatica Mappings and sessions for optimum performance.
  • Used Workflow monitor to monitor tasks, workflows and also to monitor performance.
  • Developed and worked with SQL and PL/SQL scripts, UNIX script in coordination with pmcmd to start/stop workflows.
  • Extensively performed unit testing and coordinate for system testing and functional testing.
  • Helped to generate Report using Business Object.

Environment: Informatica Power Center 8.6, IDQ, UNIX (Sun Solaris 2.6), Windows NT, LINUX, Teradata v12, Oracle 10g, DB2 9.5, PL/SQL, Toad, Business Object 5.1, Autosys.

Confidential, Birmingham, Alabama

ETL Developer

Responsibilities:

  • Used Informatica Power Center 8.1.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
  • Extensively used various transformations like Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
  • Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads
  • Worked with slowly changing dimension Type1, Type2, and Type3.
  • Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
  • Created reusable transformations and mapplets and used them in mappings.
  • Extracted data from flat file, RDMS, Legacy AS400, and VSAM files.
  • Implemented Informatica recommendations, methodologies and best practices
  • Created sessions, workflows and worklets using workflow manager.
  • Worked on Informatica Designer to modify mappings to update the existing code resulting from review comments.
  • Used Expression, Normalizer, Update strategy transformations.
  • Worked on Lookup, Router, Unoin, Joiner Transformations.
  • Involved in Unit testing, and running workflows.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Worked extensively with the business intelligence team to in corporate any changes that they need in the delivered files.

Environment: Informatica 8.1.1, (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 10g, Windows XP, Sun solaris UNIX, DB

Confidential, Reston, VA

ETL Developer

Responsibilities:

  • Involved in complete Life Cycle of developing Enterprise Data Warehouse Application and, developing ETL Architecture using Informatica.
  • Interacted with Source system SME’s to analyze how various business processes have been tracked across the source tables.
  • Designed Data warehouse target tables by using Dimensional Modeling Techniques - Star and Snowflake Schemas. Created Dimensions and Fact tables using Erwin.
  • Extracted data from various data sources such as Oracle, Flat file, XML, DB2 and transformed and loaded into targets using Informatica.
  • Created various complex mappings using different transformations such as Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
  • Designed and developed initial and incremental data loads using Informatica.
  • Designed and Developed several mapplets and worklets for reusability.
  • Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
  • Developed sessions using different types of partitioning techniques like round robin, hash key portioning for better performance.
  • Implemented audit process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
  • Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
  • Created Shell scripts with PMCMD command and scheduled using Maestroscheduler for nightly batch processing.
  • Involved in Unit testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
  • Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
  • Provided Nightly batch loads support and implemented solutions to correct the data issues raised by end user during production support phase of the project.

Environment: Informatica Power Center 8.1, Oracle SQL, Pl/SQL 10g, Toad, Unix Maestro, XML, Flat file, Erwin, AS 400 DB2, Windows XP, UNIX, Shell Scripting.

Confidential, CT

ETL Developer

Responsibilities:

  • Worked Extensively on Informatica tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
  • Designed and developed various mappings and mapplets in Mapping designer and sessions and workflows in Workflow manager to extract data from SQL Server and load to Oracle database.
  • Involved in Data modeling and Design of star schema with confirmed and granular dimensions and FACT tables.
  • Extracted Erwin physical models into repository manager using Informatica.
  • Extensively used transformations such as Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, Look up (Target as well as Source), Update Strategy, Source Qualifier, Stored Procedure and Joiner.
  • Responsible for using the capabilities of Power Center namely list files, pmcmd, pmrep, Target override, Connected and Unconnected look up, Persistence lookup, Dynamic & Static lookup.
  • Created and ran Pre-existing and debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager.
  • Involved in fixing repository related, Reader process and External procedure problems.
  • Identified and tracked the slowly changing dimensions(SCD), heterogeneous Sources and determined the hierarchies in dimensions.
  • Developed Informatica Mappings, Re-usable Transformations, re-usable mappings and Mapplets for data load to data warehouse and database (oracle)
  • Set up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
  • Involved in writing Triggers on the source to attain Power center change data capture(CDC).
  • Extensive use of SQL commands with TOAD environment to create Target tables.
  • Perform review of Session log files to trace causes of bottlenecks.
  • Created Unit Test plans and involved in primary unit testing of mappings
  • Designed and developed a strategy for a specific and vital reporting need. Emphasis was on a design to support current and historic reporting. Data loading mappings were developed in Informatica.

Environment: Informatica Power center 7.1.2(Source Analyzer, warehouse designer, Mapping Designer, Mapplet, Transformations, Repository Manager, Work Flow Manager, Workflow Monitor, Oracle Power Connect), UNIX, Oracle 9i (SQL Plus, PL/SQL), SQL Assist 6.1, Win NT

Confidential

ETL/Oracle Developer

Responsibilities:

  • Extraction, Transformation and data loading were performed using stored procedures into the database. Involved in Logical and Physical modeling of the drugs database.
  • Based on the requirements created Functional design documents and Technical design specification documents for ETL.
  • Created tables, views, indexes, sequences and constraints.
  • Developed stored procedures, functions and database triggers using PL/SQL according to specific business logic.
  • Transferred data using SQL*Loader to database.
  • Involved in testing of Stored Procedures and Functions. Designed and developed table structures, stored procedures, and functions to implement business rules.
  • Used legacy systems, Oracle, and SQL Server sources to extract the data and to load the data.
  • Involved in design and development of data validation, load process and error control routines.
  • Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
  • Generated monthly and quarterly drugs inventory/purchase reports.
  • Coordinated database requirements with Oracle programmers and wrote reports for sales data.

Environment: Oracle 8i, SQL, PL/SQL, Windows 2000.

We'd love your feedback!