We provide IT Staff Augmentation Services!

Informatica Developer Resume

Atlanta, GA

SUMMARY

  • Around 6 Years of IT experience in development and design of ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution using Informatica 8.x, SQL Server and Oracle10g.
  • Strong Experience in using Dimensional Data Modeling, Star Join Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables.
  • Proven track record in planning, building, and managing successful large-scale Data Warehouse and decision support systems Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging
  • Extensively worked on Informatica Designer Components-Source Analyzer, Warehouse Designer, Mapping Designer &Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
  • Experience in writing UNIX shell scripts to support and automate the ETL process.
  • Knowledge in Data Analyzer tools like Informatica Power Exchange (Power Connect) to capture the changed data.
  • Extensive experience creating procedures in T-SQL 2008.
  • Extensive knowledge in all areas of Project Life Cycle including requirements analysis, system analysis, design, development, documentation, testing, implementation and maintenance.
  • Good Experience in writing, testing and implementation of the triggers, stored procedures, functions, views, materialized views, Cursors at database level using SQL, PL/SQL for Oracle 9i/10G and SQL SERVER 2005,2008.
  • Experience in using the Informatica command line utilities like pmcmd, pmrepserver and pmrepagent to execute or control sessions, tasks, workflows and deployment groups in non-windows environments
  • Extensively worked on Teradata tools & utilities like Fast Load, Multi Load, TPump, Fast Export, Teradata Parallel Transporter (TPT) and BTEQ.
  • Automated Informatica flow of loading data by using Autosys scheduler.
  • Expertise in Query Analyzing, performance tuning and testing.
  • Experienced in using database interface tools like Toad and PL/SQL Developer.
  • Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/ 8.x/7.x

DATABASES: Oracle 11g/10g/9i/8i, DB2, MS SQL Server 2005/2008, Sybase, Teradata, MS Access, Netezza.

Scheduling Tools: Autosys, Control-M.

Oracle Tools: SQL PLUS, SQL Developer, TOAD, SQL Loader.

Data Modeling: Star-Schema Modeling, Snowflake Modeling, FACT and Dimension Tables.

Business Intelligence: COGNOS 8 BI.

Languages: PL/SQL, SQL, TOAD, UNIX Shell Scripting.

Operating Systems: UNIX/LINUX, Windows 95/98/00/NT/XP, WindowsServer2003/2007.

PROFFESIONAL EXPERIENCE

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

  • Worked closely with business analyst and Data Warehouse architect to understand the source data and need of the Warehouse.
  • Translate customer requirements into formal requirements and design documents.
  • Involved in creating the design and technical specifications for the ETL process based on Functional specifications.
  • Written Informatica mapping for dropping and recreating the indexes of database tables.
  • Development of address cleansing Mapplet and mapping using First logic plug-in.
  • Worked extensively with Extraction, Transformation and Loading of data from Multiple Sources (oracle, Netezza, Teradata, fixed width and delimited flat files) to ORACLE usingInformatica.
  • Worked on Scheduling workflows and sessions usingInformaticascheduler and have implemented decision task and email task for tracking the successful completion
  • Handled the creation of tables, views, triggers, stored procedures, functions, sequences in the database using SQL and PL/SQL scripts.
  • Experience in using Teradata tools like Fast Load, Multi Load, TPump, Fast Export, Teradata Parallel Transporter (TPT) and BTEQ.
  • Extensively used T-SQL in creating Procedure.
  • Implemented complex mapping such as SLOWLY CHANGING DIMENSIONS (Type II).
  • Worked on various types of transformations like Expression, Joiner, update strategy, Aggregator, Filter and Lookup.
  • Created UNIX scripts for parsing and modifying data and experience in using AUTOSYS job scheduler for automation of UNIX shell scripts and batch scheduling.
  • Facilitate end-user procedures development.

Environment: Informatica Power Center 9.0.1/8.6.1(Power Center Designer, workflow manager, workflow monitor), Oracle 11g,DB2,TARADATA,NETEZZA,XML,SQLServer2008,UNIX,TOAD,AUTOSYSCOGNOS.

Confidential, San Jose, CA

ETL Developer

Responsibilities:

  • Participated in the analysis, design, development, and testing of ETL development projects. Also, was involved in assignments that required Data analysis to help out other team members to prepare new project requirements.
  • Used Informatica Power Center 8.6.1/8.1.3 for Extraction, Transformation, & Loading of data from multiple sources to multiple targets.
  • Extensively involved in developing ETL processes, loading and validating data from source systems into the data warehouse using Informatica and/or Oracle Data integrator (ODI) and Oracle SQL, PL/SQL procedures.
  • Worked extensively using Informatica designer components - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
  • Worked extensively using T-SQL.
  • Used Teradata tools & utilities like Fast Load, Multi Load, TPump, Fast Export, Teradata Parallel Transporter (TPT) extensively.
  • Extensively used Informatica functions LTRIM, RTRIM, IIF, DECODE, ISNULL, TO DATE, DATE COMPARE in Transformations.
  • Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
  • Used AUTOSYS for scheduling the workflow.
  • Converted existing PL/SQL procedures/packages to ETL Mappings using Informatica Power Center.
  • Performed Unit Testing and Integration Testing on the mappings.
  • Involved in Implementing SLOWLY CHANGING DIMENSIONS - Type I & II in different mappings as per the requirements.

Environment: Informatica Power Center 8.6.1/8.1.3, Oracle 10g, Teradata, MS Access, SQL Server 2008,Sybase,PL/SQL,UNIX,TOAD,COGNOS,AUTOSYS.

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

  • Analyze the source systems data and the current reports at the client side to gather the requirements for the Data Warehouse Data Model.
  • Developed mappings using Source qualifier, Aggregators, Connected & unconnected Lookups, Stored Procedures, Filters, Sorter & Update strategy Transformations using Power Center.
  • Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
  • Responsible for testing the mappings and ensure that the mappings do the transformations as proposed.
  • Involved in Creating tasks, Worklets, workflows to load the data
  • Scheduled, Run and Monitored sessions using workflow manager and workflow monitor.
  • Troubleshoot problems by checking Sessions and Error Logs. Also used Debugger for complex problem troubleshooting.
  • Used PMCMD commands for stopping and starting workflows and tasks.
  • Worked closely in preparation of technical documentation of transformation components.
  • Participates in design and development reviews
  • Developed UNIX to automate different tasks involved as part of loading process and scheduling.
  • Performed Unit Testing and Integration Testing on the mappings.
  • Involved in maintaining effective relations with co-workers and business People.

Environment: Informatica Power Center 8.1.3, Oracle 9i, Data Stage, SQL* Loader, Windows 2000, DB2, Teradata, MS Access, UNIX.

Confidential, Columbus, Ohio

ETL Develop

Responsibilities:

  • Responsible for business analysis and requirements collections.
  • Prepared the DDL’s for the staging/work tables and coordinated with DBA for creating the development environment and data models.
  • Developed ETL mappings, Transformations and Loading using Informatica Power Center 7.1.2.
  • Used PL/SQL with Informatica Power Center 7.1.2 for Oracle 8i database.
  • Performance tuning and bottleneck resolution.
  • Created and Implemented Reusable Sessions like E-mail.
  • Designed and documented the validation rules, error handling and test strategy of the mapping.
  • Written different varieties of loading scripts for loading the data in to DB and developed scripts to extract data in to files.
  • Developed UNIX shell scripts to automate the Data Load processes to the target DW.
  • Involved in design and creation of Fact tables and Dimensions.
  • Used Informatica tool to handle complex mappings and extensively used various Transformations including Source Qualifier, Aggregator, Lookup, Filter, Update Strategy, Expression, Sequence generator and Sorter.
  • Done various optimization techniques in Aggregator, Lookup and Joiner transformation.

Environment: Informatica Power Center 7.1.2., Oracle 8i, TOAD, SQL Server, Flat Files, Windows XP, UNIX, MS Visio.

Hire Now