We provide IT Staff Augmentation Services!

Senior Informatica Consultant Resume

SUMMARY

  • 15+ years of experience in complete Software Development Life Cycle (SDLC).
  • Extensive experience in Data Warehousing, ETL, Data Modeling, and Physical and Logical Database designing for Insurance, Pharmaceutical and Financial Industries.
  • Experience in Data warehousing ETL using Informatica Power Center 9.1/7.1.2/6.2/5.1 , Informatica Power Mart 6.2/5.1, Informatica Data Quality 8.5, DB2 - AIX64 9.5.2, Oracle 9.x/8i/8.0/7.x, MS SQL Server 2008 R2, OLTP, OLAP, Data Reports and Erwin.
  • Expert database development skills using DB2, Oracle PL/SQL to write stored procedures, stored functions, packages and triggers.
  • ETL experience. With Design, Development of Complex Mappings with multiple data sources.

TECHNICAL SKILLS

RDBMS: Oracle 9.i/8.x/7.x, DB2-AIX 64 9.5.2/8.0 , Teradata 7.0/8.1, SQL Server 2008 R2/2008/2005, MS Access 2010, Sybase 3.0/4.9

Data Warehousing: Informatica Power Center 9.1/ 7.1.3/6.2/5.1 , Informatica Data Quality 9.1, Power mart 6.2/5.1/4.7, ETL, Data mart, OLAP, OLTP.

Utilities: TOAD 7.3/7.2, SQL Navigator 3.1/4.5, MS Visio, MSOffice, Erwin4.0, Rapid SQL 7.3.3, DBArtisian 8.1.5

Reporting Tools: Business Objects 5.0/4.1, Crystal Report 8.5, Cognos 7.3/8.1, Report Net.

Languages: SQL, PL/SQL, UNIX Shell Scripting, Perl, C, C++, Visual Basic 5.0, Java, HTML, COBOL

Operating Systems: Sun Solaris 2.6/2.7, HP-UX and IBM AIX 4.2/4.3, Win 3.x/95/98/NT 4.0, SCO UNIX, Red Hat Linux.

Modeling Technologies: Unified Modeling Language (UML), ER diagrams, Data Modeling.

PROFESSIONAL EXPERIENCE

Confidential

Senior Informatica consultant

Environment: Informatica Power Center 9.6.1, Oracle 11g, UNIX AIX 5.3, Toad 3.2, Windows 7 Enterprise, Tidal Scheduler 5.3.1, Oracle SQL developer 2.1, Windows Server Enterprise, Windows 7 Enterprise.Worked in implementing different projects, Liquidity Risk Management project (LRMS), Regulatory reporting project, OFSAA feeds and Treasure Data Mart.

Responsibilities:

  • Analyzing the data for defects and fixing the defects.
  • Understand system flow and process flow to fix the production issues.
  • Participated in troubleshooting and facilitated transition to system test, UAT and production phases.
  • Created and Schedules jobs in Tidal.
  • Created deployment documents, artifacts, and Run book.
  • Involved high level architecture and design of database components.
  • Design and build new database components (stored routines, triggers) to meet the requirements.
  • Interact with business analysts to understand the business requirements.
  • Developed Informatica mappings and re-usable transformations.
  • Developed data transfer strategy from various legacy data sources
  • Created Migration Documentation and Process Flow for mappings and sessions.
  • Developed Informatica SCD type-I, Type-II mappings. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, Mapplets and others.
  • Worked on Informatica Partitioning when dealing with huge volumes of data.

Confidential, Bridgewater NJ

Lead ETL Informatica Engineer

Environment: Informatica Power Center 9.5.1, Oracle 11g, UNIX AIX 5.3, Oracle SQL developer 2.1, Toad, Windows Server Enterprise, Windows 7 Enterprise.

Responsibilities:

  • Designed and Developed Technical Billing Data Mart for reports.
  • Designed Product data model, developed process to bring the data in EDW for Data Mart Reports and Executive Dash Board Reports.
  • Worked as Informatica Administration. Created users, folders, folder migration, taking Repository backup.
  • Interact with and guide Informatica developers with data transformations and data mappings.
  • Design and review high level architecture and design of database components.
  • Analyze Business Requirements from BRD, created conceptual, logical and physical database design and created Technical Design Documents.
  • Installed Informatica clients and servers, setup connectivity’s, set up process including parameter files.
  • Providing support, guidance in the deployment of the solution in various environments such as integration, QA, and production.
  • Interact with and guide with Informatica Developers with data transformations and data mappings.
  • Wrote Informatica deployment documents and mapping documents.
  • Designed the weekly and daily batches with complex dependencies and scheduled them.
  • Prepared the recovery process in case of workflow failure due to Database issues or Network issues.
  • Setup and administer Power Center.
  • Performed tuning of Informatica sessions by implementing database partitioning, increasing block size, data cache size, sequence buffer length, target based commit interval and SQL overrides.
  • Performance tuning by session partitions, dynamic cache memory, and index cache.
  • Design Informatica Interfaces, Primarily responsible for ETL design, coding and testing strategy.
  • Extensively worked on various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
  • Creating Database objects to support the development of Dashboard reports to allow users access to source reference data

Confidential, Newark NJ

Lead ETL and Architect

Environment: Informatica Power Center 9.1, DB2-AIX64 9.5.2, UNIX AIX 5.3, DBArtisian 8.1.5, SQL server 2008, Oracle 11g, Toad, Windows 2008.

Responsibilities:

  • Created Mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Normalizer, Filter and Router transformations, Union Transformations etc.
  • Analyze Business Requirements from BRD, created conceptual, logical and physical database design and created Technical Design Documents.
  • Ran scripts through UNIX shell programs for batch scheduling.
  • Developed and enhanced UNIX, SQL scripts for metadata management.
  • Create High level and low level detailed technical Design documents from BRDs
  • Created PL/SQL stored procedures for various needs of the transformations while loading the data.
  • Provided production support after rolling application out and provided complete production support.
  • Did Complete Production support, flexible with work schedules depending upon production issue.
  • Analyzing the data for defects and fixing the defects.
  • Used Informatica Data Quality for data validation. Oversaw troubleshooting, data cleansing and data integrity.
  • Used SQL scripts to extract data and load into DB2 database. Extensively worked in DB2 stored procedures.
  • Maintained multiple databases and customized reports based on user requirement.
  • Helped in developing best practices for the GI data warehouse.
  • Participated in troubleshooting and facilitated transition to system test, UAT and production phases.
  • Planned, organized and supervised team activities.
  • Participated in most of the user sessions regarding the requirements and design of the system especially about specification of the reports.
  • Created Session and Batches using workflow manager according to the frequency, interdepends.
  • Created Unit Test plans and involved in primary unit testing of mappings I created.
  • Develop SQL queries and support ad hoc requests for data.
  • Optimize the PL/SQL code by tuning queries to enhance performance.
  • Created PL/SQL Stored Procedures for various needs of the transformations while loading the data.
  • Designed and developed preprocessors for the incoming data from various sources.
  • Provided DBA and database support to the team through production rollout.

Hire Now