We provide IT Staff Augmentation Services!

Informatica Developer Resume

SUMMARY:

  • Over 9+ Years of experience in Analysis, Design, Development, Testing, Implementation, Enhancement and Support of BI applications which includes strong experience in Data Warehousing (ETL & OLAP) environment as a Data Warehouse Consultant.
  • Experience in using ETL methodologies for supporting Data Extraction, Data Migration, DataTransformation and loading using Informatica Power center 9.6.1/9.1/8. 6.1/ 7. x/6.2, IDQ and Trillium.
  • Experience in Informatica Data Quality (IDQ - Informatica developer 9.6.1/9.1) for cleansing and formatting customer master data.
  • Experience in Informatica Analyst to analyze customer master data. used Informatica Analyst to perform profiling.
  • Created business rules and populated those rules Pass, Fail percentages and failed records(rule breaks) in DQP dashboard using Qlik view.
  • Create logical data object model, Customized data objects in Informatica developer.
  • Created reference tables for standardization.
  • Experience in Trillium to scrub, standardize and match customer address.
  • Used BCI to extract data from SAP R/3.
  • Good understanding of Ralph Kimball Dimensional Modeling using Star schema methodology and Bill Inmon Snow Flake schema methodology.
  • Strong understanding of OLAP and OLTP Concepts
  • Excellent in designing ETL procedures and strategies to extract data from different heterogeneous source systems like oracle 11g/10g, SQL Server 2008/2005, DB2 10, Flat files, XML, SAP R/3 etc.
  • Experience in SQL, PL/SQL, T-SQL and UNIX shell scripting.
  • Performed data modelling using Teradata.
  • Documented the process for rule analysis, designing, mapping, Unix SCP Process, DQP dash board, CM Synergy, rational change.
  • Migrated code using IBM CM Synergy process.
  • Created change requests and attached assigned task which created in IBM rational synergy and solution records for code migration in IBM Rational Change.
  • Experience with the data-modeling tool using Erwin.
  • Worked with Full Software Development Life Cycle (SDLC) involving Application Development and ETL/OLAP Processes.
  • Used 3rd generation programming languages like C++, COBOL & Java.
  • Used Informatica Metadata Manager and Metadata Exchange exhaustively to maintain and document metadata.
  • Dealt with Master data, Transaction data, Control data etc.
  • Extensively involved in creating Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers, Cursors, and Indexes with Query optimizations as part of ETL Development process.
  • Adept in UNIX operating system commands & Shell Scripting.
  • Experienced in Quality Assurance, Manual and Automated Testing Procedures with active involvement in Database/ Session/ Mapping Level Performance Tuning and Debugging.
  • Worked with Business Managers, Analysts, Development, and end users to correlate Business Logic and Specifications for ETLDevelopment.
  • Strong decision-making and interpersonal skills with result oriented dedication towards goals.
  • Worked in onsite-off shore model.
  • Worked extensively in Data analysis and quality assurance.
  • Participated in requirements gathering with business and functional teams and worked independently on given objects.
  • Performed performance tuning to work efficiently.
  • Knowledge of B2B data exchange and data transformation tool.
  • Experienced in Chemical, Finance, Materials, Sales and distribution, manufacturing, entertainment and healthcare domains.
  • Worked on Big data Editions

SOFTWARE

ETL Tools: Informatica Power center 9.6.1/9.1/8. x/7.x/6.x, Data Stage 7.5

Cleansing Tools: Informatica Data Quality (IDQ 9.6.1/9.5), Trillium

Reporting Tools: Crystal Report XI/10/9, Business Object XI, Cognos 8

Operating Systems: UNIX, Windows 98/ NT/2000/XP, Solaris

Database: Oracle 10g/9i, SQL Server, DB2,Teradata14.10

Database GUI Tools: TOAD

Web Development: HTML, XML

Programming Languages: Oracle SQL, PL/SQL, UNIX Shell Script, C, C++.

Supporting Tools: Microsoft Visio

Software: DB Artisan, Rapid Sql, IBM Rational Synergy, TWS

PROFESSIONAL EXPERIENCE

Confidential

Informatica developer

Responsibilities:

  • Experience in SQL, PL/SQL, T-SQL and UNIX shell scripting.
  • Performed data modelling using Teradata.
  • Documented the process for rule analysis, designing, mapping, Unix SCP Process, DQP dash board, CM Synergy, rational change.
  • Migrated code using IBM CM Synergy process.
  • Created change requests and attached assigned task which created in IBM rational synergy and solution records for code migration in IBM Rational Change.
  • Experience with the data-modeling tool using Erwin.
  • Worked with Full Software Development Life Cycle (SDLC) involving Application Development and ETL/OLAP Processes.
  • Used 3rd generation programming languages like C++, COBOL & Java.
  • Used Informatica Metadata Manager and Metadata Exchange exhaustively to maintain and document metadata.
  • Dealt with Master data, Transaction data, Control data etc.
  • Extensively involved in creating Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers, Cursors, and Indexes with Query optimizations as part of ETL Development process.
  • Adept in UNIX operating system commands & Shell Scripting.
  • Experienced in Quality Assurance, Manual and Automated Testing Procedures with active involvement in Database/ Session/ Mapping Level Performance Tuning and Debugging.
  • Worked with Business Managers, Analysts, Development, and end users to correlate Business Logic and Specifications for ETLDevelopment.
  • Strong decision-making and interpersonal skills with result oriented dedication towards goals.
  • Worked in onsite-off shore model.
  • Worked extensively in Data analysis and quality assurance.
  • Participated in requirements gathering with business and functional teams and worked independently on given objects.
  • Performed performance tuning to work efficiently.
  • Knowledge of B2B data exchange and data transformation tool.
  • Experienced in Chemical, Finance, Materials, Sales and distribution, manufacturing, entertainment and healthcare domains.
  • Worked on Big data Editions

Hire Now