We provide IT Staff Augmentation Services!

Senior Informatica Developer Resume

SUMMARY:

  • 7.6 years of experience in Information Technology including Data warehouse/Data Mart development using ETL/Informatica Power Center
  • Experience in integration of various Operational Data Source (ODS) with Relational Databases Oracle and worked on integrating data from flat files like fixed width and delimited.
  • Extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
  • Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
  • Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
  • Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
  • Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
  • Extensively worked on Informatica Power Center 9.1.0, 8x, 7x.
  • Experience in Relational Databases like Oracle 11g/10g/9i/8i
  • Experience with Programming languages like SQL, PL/SQL, Unix Shell Scripting.
  • Knowledge in writing Stored Procedures, Functions, Packages.
  • Knowledge in Creating and maintaining Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequence, Table Partitions, Synonyms and Database Links.
  • Knowledge on UNIX Shell Scripting. Designed various shell scripts for processing and scheduling Informatica workflows in different conditions.
  • Highly Motivated to take independent responsibility as well as ability to contribute and be a productive team member

TECHNICAL SKILLS:

Data warehousing: Informatica 9.1.0/8.x/7.x (Power Center/Power Mart/Power Exchange) (Designer, Workflow Manager, Workflow Monitor

Programming: Unix Shell Scripting, SQL, PL/SQL

Databases: Oracle 10g/9i/8i, MS Access 7.0/2000, SQL, PL/SQL

Environment: MS Windows 2003/2000/XP/98, LINUX, UNIX (Sun Solaris, HP-UX, AIX)Job Scheduling

PROFESSIONAL EXPERIENCE:

Confidential

Senior Informatica Developer

Responsibilities:

  • Involve in requirement gathering session with business users for a new/change requirement.
  • Analyze the requirement and prepare Technical Specification doc.
  • Analyze the incoming data from different source systems.
  • Work with Data Modeler to finalize data model.
  • Involve in development activities for the new or change requirement based on Technical Specification doc using Informatica 9.1.0, Shell script and Oracle database.
  • Preparation of Program Specifications and parameterization of sessions and creation of workflows and command tasks.
  • Responsible for developing STMs(Source to Target Mappings) for the newly created mappings.
  • Perform UNIT test for new/change developed code.
  • Involve in code deployment from one environment to another.
  • Responsible for Production Monitoring after new code deployment.

Environment: Informatica PowerCenter 9.1.0, Oracle 11i, SQL/PLSQL, TOAD, MS Office, UNIX Shell Scripting, MS Excel, Redwood.

Confidential

Senior Informatica Developer

Responsibilities:

  • Interacted with various business people and gathered the business requirements and translated them into technical specifications.
  • Prepared Technical Design Documents based on the Functional/Business requirements from the Business Users on the Mapping Documents.
  • Designed data model using Visio for the use of Business Analysts.
  • Created users and groups, configured profiles and privileges, Configured shared folders for re-usable objects.
  • Extensively worked on Informatica Power Center - Designer, Workflow Manager and Workflow Monitor.
  • Designed the ETL processes using Informatica Power Center 9 to extract, transform and load data from multiple input sources like Oracle, flat files and XML to target Oracle database.
  • Created complex mappings using various transformations such as Rank, Joiner, Expression, Lookup (Connected/Unconnected), Aggregate, Filter, Update Strategy, Sequence Generator etc to implement the user requirements.
  • Implemented Type II Slowly Changing Dimensions Methodology to keep track of historical data.
  • Created Reusable Transformations and Mapplets in the designer using transformation developer and mapplet designer according to the business requirements.
  • Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
  • Extensive work experience in SQL and PL/SQL by writing Stored Procedures, Functions, Packages and Triggers Tuned the Performance of the targets, sources, mappings and sessions by eliminating the bottlenecks.
  • Created and scheduled workflows using Workflow Manager to load the data into the Target Database.
  • Worked with Autosys Scheduler to run the Informatica session on a daily/weekly/monthly basis.
  • Performed Unit Testing and Integration Testing of Mappings and Workflows.
  • Migrating jobs across Development, QA, Production environments.

Environment: Informatica PowerCenter 8.6.1, Oracle 11i, 10g, SQL*Loader, SQL/PLSQL, Flat Files, TOAD, MS Office, UNIX Shell Scripting, MS Excel.

Confidential

Informatica Developer

Responsibilities:

  • Retrieving data from various sources like Web Interface, Share Drive and FTP in a timely manner
  • After Decrypting, copying the data in the INPUT share drive.
  • Processing this Input file in the TS2 web interface.
  • After processing for the first time the status mail is generated, which contains the log file for the product and stores which needs the maintenance
  • Maintenance for the particular products and store is done in DATMAN tool with the help of RDC (Reference Data Client) & Hierarchy web interfaces.
  • After the maintenance, the master data is again processed along with the staging records.
  • This time status mails need to be generated with zero maintenance required.
  • The different customer server cubes are refreshed the next day.
  • The accuracy check is performed again on the server cubes.
  • After the data is visible, we can check if any further maintenance is required.

Environment: Informatica 8x/7x, Oracle 9i, UNIX, Cron Jobs, Flat Files, Toad, MS Office.

Confidential

Informatica Developer

Responsibilities:

  • Analyze the Mapping Documents sent, prepare relevant doubt sheets and get clarifications. Analyze the incoming data from different source systems.
  • Develop the mapping logic and finally develop actual mappings using Informatica, Shell script and Oracle database.
  • Preparation of Program Specifications and parameterization of sessions and creation of workflows and command tasks.
  • Worked on enhancements, read the already developed code in UNIX and INFORMATICA and then made changes as per requirements.
  • Developed and supported the Extraction, Transformation, and load process (ETL) for data migration using Informatica power centre.
  • Responsible for developing Source to Target Mappings.
  • Extensively used Informatica Client tools- Source Analyzer, Warehouse Designer, Mapping Designer.
  • Developed Informatica mappings for data extraction and loading worked with Expression, Lookup, Filter and Sequence generator and Aggregator Transformations to load the data from source to target.
  • Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation.
  • Developed mappings, sessions for relation and flat source and targets.
  • Imported data from various source (Oracle, Flat file, XML) and transformed and loaded into targets using Informatica.
  • Created and scheduled Session, jobs based on demand, run on time
  • Monitored Workflows and Sessions while providing PROD support.
  • Identified the facts and dimensions and designed the relevant dimension and fact tables.

Environment: Informatica 8x/7x, Oracle 9i, UNIX, Cron Jobs, Flat Files, Toad, MS Office.

Confidential

Informatica Developer

Responsibilities:

  • Developed and supported the Extraction, Transformation, and load process (ETL) for data migration using Informatica power center.
  • Extensively used Informatica Client tools- Source Analyzer, Warehouse Designer, Mapping Designer.
  • Developed Informatica mappings for data extraction and loading worked with Expression, Lookup, Filter and Sequence generator and Aggregator Transformations to load the data from source to target.
  • Involved in Production support work for all the tasks and schedulers running in PROD environment.
  • Performance tuning of the Database.
  • Data Loading during SQA support through Informatica as per schedule.
  • Involved in Data Validation of the final data loaded in SIT/UAT environment.
  • Error logging, defect tracking and Defect fix in Quality Center.
  • Quality center maintenance.
  • Release processes follow up.

Environment: Informatica 7x, Oracle 9i, Flat Files, Toad, MS Office.

Hire Now