We provide IT Staff Augmentation Services!

Informatica Developer Resume

3.00/5 (Submit Your Rating)

Irvine, TexaS

SUMMARY:

  • To pursue a challenging and growth - oriented career in a progressive organization and to enhancethe level of my technical knowledge and ability to work in-group.
  • Around 6+ years of IT Experience in Analysis, Design, Development, Implementation and Troubleshooting in the areas of Informatica.
  • Expansive involvement in Extraction, Transformation, loading (ETL) of data from heterogeneous sources into Data Warehouses and Data Marts using Informatica Power Center Tools (Repository Manager, Designer, Workflow manager and Workflow Monitor).
  • Extensively worked on Informatica Designer Tools (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer) and Workflow Manager Tools (Task Developer, Worklet and Workflow Designer).
  • Experience in interacting with business users to clarify requirements and translate the requirements into technical specifications.
  • Experience in debugging and implementing various techniques in tuning the graphs to improve the performance as part of Quality Analysis.
  • Worked on Deployment groups for code migration to multiple environments.
  • Working knowledge on Informatica Salesforce integration.
  • Experienced in the aspects of Data Cleansing, Data profiling and Data Analysis. Profound knowledge in Technical Design and Documentation.
  • Expertise in different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
  • Expertise in developing and maintaining overall Test Methodology and Strategy, Documenting Test Plans, Test Cases and editing, executing Test Cases and Test Scripts.
  • Have acquired ability to gather and define Business requirements to meet User/Customer expectations.
  • Ability to adopt New technologies.
  • Experienced in working with Onsite-Offshore model and handled multiple projects.
  • Working experience in a traditional Waterfall Based as well as Agile Methodologies of Software Development Life Cycle.
  • Experience in writing, testing, and implementation of the cursors, procedures, and functions at database level using PL/SQL and DB2.
  • Involved in writing various UNIX shell scripts for writing automated scripts for scheduled queue process and PMCMD commands.
  • Extensively worked on Data Extraction, Transformation, and Loading with RDBMS, Flat files and datasets. Extensively worked with SQL, UNIX Shell Scripting, Perl Scripting & Performance tuning to improve performance.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.1, 9.6/9.1/8.6/8.1/ , Siperian/Informatica 10.0/9.1

OBIEE, BI: Framework manager, Query studio, Report studio

Programming Languages: SQL, PL/SQL, HTML, Basic UNIX SHELL SCRIPTING

Database: Oracle 9i/10g/ 11g, Teradata, DB2, Siebel, MS SQL Server 2010/ 2005, Netezza

Operating System: Windows 98/NT/2000/XP/7, UNIX

Programming Tools: SQL*PLUS, SQL* Loader, Siebel AnalyticsTOAD 10.0, Putty

Office Tools: MS PowerPoint, MS Word, MS Excel

Scheduling tools: DAC,Control M, Skybot, Robot, Crontab, UC4

Defect Management: HP Quality Centre, HP ALM, JIRA, Service Now

Internet Tools: HTML, XML, XSLT

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, Texas

Informatica Developer

Responsibilities:

  • Followed Agile-Scrum methodology to design, develop, test and deliver the code.
  • Modify existing business logic in Informatica ETL flows.
  • Involved in performance tuning and optimization of mapping to manage very large volume of data.
  • Worked on Informatica Utilities Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer .
  • Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Router, Sorter, Expression, Normalizer, Sequence Generator and Update Strategy. Develop complex ETL mappings on Informatica 10.x platform as part of the Risk Data integration efforts.
  • Implemented SCD Type 1 and SCD Type 2 for loading data into data warehouse dimension tables.
  • Implemented error handling for invalid and rejected rows by loading them into error tables.
  • Extensively worked on batch framework to run all Informatica job scheduling.
  • Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
  • Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
  • Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
  • Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
  • Created Stored Procedures, Functions, Packages and Triggers using PL/SQL .
  • Implemented restart strategy and error handling techniques to recover failed sessions.
  • Used Unix Shell Scripts to automate pre-session and post-session processes.
  • Did performance tuning to improve Data Extraction, Data process and Load time.
  • Worked with data modelers to understand financial data model and provided suggestions to the logical and physical data model.
  • Designed presentations based on the test cases and obtained UAT signoffs.
  • Documented test scenarios as a part of Unit testing before requesting for migration to higher environment levels and handled production deployments.
  • Recorded defects as a part of Defect tracker during SIT and UAT
  • Identified performance bottlenecks and suggested improvements.
  • Performed Unit testing for jobs developed, to ensure that it meets the requirements.
  • Handled major Production GO-LIVE and User acceptance test activities.
  • Created architecture diagrams for the project based on industry standards.
  • Defined escalation process metrics on any aborts and met SLA for production support ticket.

Environment: Informatica 10.1.1, 9.5, Oracle, XML, SQL Server 2008, Web services, DB2 Mainframe, DAC(Scheduler).

Confidential, Memphis, Tennessee

Informatica Developer

Responsibilities:

  • Working on building new data warehouse for customer data information.
  • Experienced working with team leads, Interfaced with business analysts and end users.
  • Worked with data modelers to understand financial data model and provided suggestions to the logical and physical data model.
  • Document unit test cases and provide QA support to make testers understand the business rules and code implemented in Informatica.
  • Defined and configured schema, staging tables, and landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries.
  • Used Cleanse Functions to Cleanse and Standardize while data is loading into stage tables.
  • Enabled delta detection to extract the Incremental Data.
  • Defined the Systems, Trust Scores and Validation rules.
  • Created the Match/Merge rule sets to get the right master records.
  • Performed data steward operations by editing the records using data manager and merge manager.
  • Used Hierarchy Manager tool, for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
  • Implemented IDD applications and created subject area groups, subject areas, subject area child, IDD display packages in hub.
  • Import & Export of ORS using Metadata manager.
  • Configured Address Doctor which can cleanse Customer Address Data.
  • Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Router, Sorter, Expression, Normalizer, Sequence Generator and Update Strategy, data standardization, address validator etc.
  • Implemented SCD Type 1 and SCD Type 2 for loading data into data warehouse dimension tables.
  • Implemented error handling for invalid and rejected rows by loading them into error tables.
  • Implementing the Change Data Capture Process using Informatica Power Exchange.
  • Involved in Performance Tuning of ETL code by addressing various issues during extraction, transformation and loading of data.
  • Worked with Support team to migrate the ETL code to Production servers from development servers by creating a mapping document and Request for Change (RFC) of the process.
  • Involved in Knowledge Transfer sessions to Support team after completion of UAT signoff.
  • Handled Production issues and monitored Informatica workflows in production.
  • Extensively worked on batch framework to run all Informatica job scheduling.

Environment: Informatica Power Center 9.1, Informatica MDM 9.1, Oracle, PL/SQL,DB2,RALLY, HP Quality Control, Informatica Power Exchange 9.1.

Confidential

Informatica Developer

Responsibilities:

  • Designed developed and managed the workflow processes to reflect business requirements with several adapters, exceptions and rules.
  • Worked on CDC (Change Data Capture) to implement SCD (Slowly Changing Dimensions).
  • Tuned the SQL queries used in the SQL override, Lookup Override of the Source Qualifier and Lookup transformations.
  • Worked with data modelers to understand financial data model and provide suggestions to the logical and physical data model.
  • Involved in creation of initial data set up in the Production environment and involved in code migration activities to Production.
  • Provided administrative functions like creating repositories, backing up repositories, setting up users, assigning permissions and setting up folders in Repository manager.
  • Wrote shell script utilities to detect error conditions in production loads and take corrective actions, wrote scripts to backup/restore repositories, backup/restore log files.
  • Migrated Informatica objects from development to QA and production using deployment tool.
  • Provided production support and involved with root cause analysis, bug fixing and promptly updating the business users on day-to-day production issues.

Environment : Informatica PowerCenter 9.1, Oracle 11g, PL/SQL, SQL*Plus, Windows, UNIX, AUTOSYS.

Confidential

Informatica Developer

Responsibilities:

  • Worked on building new data warehouse for customer data information.
  • Experienced working with team leads, Interfaced with business analysts and end users.
  • Worked with data modelers to understand financial data model and provided suggestions to the logical and physical data model.
  • Document unit test cases and provide QA support to make testers understand the business rules and code implemented in Informatica.
  • Defined and configured schema, staging tables, and landing tables, base objects foreign-keyRelationships, look up systems and tables, packages, query groups and queries/custom queries.
  • Used Cleanse Functions to Cleanse and Standardize while data is loading into stage tables.
  • Enabled delta detection to extract the Incremental Data.
  • Defined the Systems, Trust Scores and Validation rules.
  • Created the Match/Merge rule sets to get the right master records.
  • Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Router, Sorter, Expression, Normalizer, Sequence Generator and Update Strategy, data standardization, address validator etc.
  • ImplementedSCD Type 1 and SCD Type 2 for loading data into data warehouse dimension tables.
  • Implemented error handling for invalid and rejected rows by loading them into error tables.
  • Implementing the Change Data Capture Process using Informatica Power Exchange.
  • Involved in Performance Tuning of ETL code by addressing various issues during extraction, transformation and loading of data.
  • Worked with Support team to migrate the ETL code to Production servers from development servers by creating a mapping document and Request for Change (RFC) of the process.
  • Involved in Knowledge Transfer sessions to Support team after completion of UAT signoff.
  • Handled Production issues and monitored Informatica workflows in production.
  • Extensively worked on batch framework to run all Informatica job scheduling.

Environment: Informatica Power Center 9.1, Informatica MDM 9.1, Oracle, PL/SQL, DB2, RALLY, HP Quality Control, Informatica Power Exchange 9.

We'd love your feedback!