We provide IT Staff Augmentation Services!

Informatica Developer Resume

O Fallon, MO

SUMMARY:

  • Over 7+ years of IT experience in Data warehousing projects, primarily as specialist in performing Analysis, Design, Development, Testing, Implementation, Migration, Deployment, Enhancement and Maintenance of Informatica, Oracle, Teradata, DB2/UDB, Sybase and SQL Server environments.
  • Extensive knowledge on the SDLC development life cycle. Involved in different phases starting from Requirement Gathering to Production Deployments and warranty Support.
  • Hands on experience using query tools like TOAD, PLSQL developer, Teradata SQL Assistant and Query man.
  • Extensively worked on power center mapping designer, mapplet designer, transformation developer, warehouse designer, workflow manager, repository manager and workflow monitor.
  • Extensively worked on Informatica Data Quality and Informatica Power center throughout complete Data Quality and MDM projects .
  • Designed Datastage jobs using MQ stage by reading the service and creating the XPATH and used XSLT stage in reading the XPATH and using the same for data transformation.
  • Using the data Integration tool Pentaho for designing ETL jobs in the process of building Data warehouses and Data Marts.
  • Developed ETL process using Pentaho PDI to extract the data from legacy system.
  • Good Experience in creating cubes by using Pentaho Schema Workbench .
  • Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Normalizer, Source Qualifier, jaRouter, Filter, Expression, Aggregator, Joiner, Update Strategy.
  • Skilled in Database programming for Data Warehouses (Schemas), data modeling, Star Schema modeling, and Snowflake modeling.
  • Proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon and surrogate key assignment and CDC (Change Data Capture) using both datastage and informatica.
  • Strong skills in creating reusable components like shared containers and local containers for multiple project use.
  • Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
  • Expertise in PL/SQL and in writing Stored Procedures, Functions etc
  • Extensive experience in writing ETL Test Scenarios, Test Cases based on Source to Target Mapping Documents.
  • Experience in performance tuning of sources, transformations, targets, mapplets, mappings, worklets, workflows, sessions and batches
  • Worked with heterogeneous data sources like Oracle, Teradata Utilities, SQL Server 2008/2005, flat files, XML files, DB2 UDB, Main Frames, COBOL files, SFDC CRM, Web Services and Lotus Notes.
  • Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
  • Good knowledge in Shell Scripting, written several UNIX scripts for invoking data reconciliation
  • Good knowledge in Power exchange for salesforce and loading data into salesforce environments through Informatica using BULK API.
  • Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
  • Good understanding of source to target data mapping and Business rules associated with the ETL processes.
  • Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager
  • Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.
  • Documented and presented the production/support documents for the components developed when handing - over the application to the production support team
  • Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.
  • Ability to work simultaneously on multiple projects, work independently as well as a team member.

TECHNICAL SKILLS:

ETL Tools: IBM InfosphereDataStage / 8.0.1/8.1/9.1 (Parallel Extender), Informatica 9.1/9.0, pentaho, Informatica PowerCenter, Informatica Data Quality, Informatica Power Exchange, DVOInformatica MDM, Informatica developer IDQ 9.1/9.5.1 .

Data Bases: Oracle 11g/10g/9i/8.x/7x, SQL Server 2000/2005, Teradata V12,V14

Database Tools: Oracle Enterprise Manager, Quest TOAD, SQL*PLUS, SQL*Loader, SQL*Net, SQL Navigator Export/Import, Oracle Discoverer 10g

Programming Tools: C, C++, Java, SQL, PL/SQL, T-SQL, java script, Shell Scripting, Perl

Web Technologies: HTML, CSS, XML

Other Tools: MS-Word, Excel, Power Point 2003/2007

Operating System: Unix, Windows 95/98/NT/2000/XP/7/8

PROFESSIONAL EXPERIENCE:

Informatica Developer

Confidential, O’Fallon, MO

Responsibilities:

  • Involved in Business meetings to understand the business requirement specifications and implemented the ETL jobs using Informatica.
  • Involved in developing the source to target process and mapping documentation.
  • Participated in the review and approval of the technical transformation requirements document used to design and build the ETL modules in Informatica Designer.
  • Participated in daily status meeting.
  • Prepared a best practice document to use when designing jobs to gain optimum performance by using appropriate partitioning techniques.
  • Implemented slowly changing dimensions on customers table using SCD stage in Informatica.
  • Extensively worked on Informatica IDE/IDQ.
  • Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
  • Used IDQ’s standardized plans for addresses and names clean ups.
  • Worked on IDQ file configuration at user’s machines and resolved the issues.
  • Used IDQ to complete initial data profiling and removing duplicate data.
  • Created shared container to in corporate business logic and used in multi job.
  • Created and used job parameter set during developing jobs.
  • Developed parallel jobs using various stages transformer, join, look up and merge.
  • Created job sequencer to automate the job.
  • Knowledge of director client for troubleshooting.
  • Knowledge and worked with administrator client for creating new user and assigning role.
  • Involved in performance tuning of Data stage jobs and creating templates for future use.
  • Worked on programs for scheduling data loading and transformations using Data stage.
  • On Informatica extensively used the Filter, Copy, Funnel, Join, Merge, Aggregator, Column Generator, Sort, SCD and Remove Duplicate stages for providing transformation logic for the field as per the requirement.
  • Involved in the development of dimensional data models using ERwin as per the specified business requirements.
  • Used the Data Stage designer to develop processes for extracting, cleansing, transforming,integrating and loading data into data warehouse.
  • Developed and implemented strategies for slowly changing dimensions, surrogate key generation and for incremental data loading.
  • Performed performance tuning of jobs to improve the extraction, transformation and loading times of data.
  • Used Pl/SQL programming to develop store procedures and functions.
  • Performed Performance testing with different sets of node configuration, different queue and different volumes.

Environment: Informatica Power Center 9.1/9.0, Visio, IDQ 9.1/9.5.1 Hotfix 2.0, SQL Server 2008,Windows 7, UNIX AIX, Teradata V12R5.

Informatica Developer

Confidential, Dallas, TX

Responsibilites:

  • Responsible for Business Analysis and Requirements Collection.
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Involved in migration of the mapps from IDQ to power center
  • Parsed high-level design specification to simple ETL coding and mapping standards.
  • Designed and customized data models for Data warehouse supporting data from multiple sources on real time
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Created mapping documents to outline data flow from sources to targets.
  • Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin tode sign the business process, dimensions and measured facts.
  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
  • Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
  • Used various transformations like Filter, Expression, Sequence Generator, Update,Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
  • Developed mapping parameters and variables to support SQL override.
  • Created mapplets to use them in different mappings.
  • Developed mappings to load into staging tables and then to Dimensions and Facts.
  • Used existing ETL standards to develop these mappings.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
  • Modified existing mappings for enhancements of new business requirements.
  • Used Debugger to test the mappings and fixed the bugs.
  • Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.
  • Performed Performance testing with different sets of node configuration, different queue and different volumes
  • Used sandbox for testing and migrated the code to deployment instance after testing.
  • Integration using web sphere cast iron and informatica cloud for data migration in to the cloud.
  • Prepared the DML’s for maintenance tables, review, and test and execute them.
  • Used Tortoise SVN version control tool for version controlling and movement of code to upper environments like SIT, UAT, Preproduction and Production.

Environment: Informatica Power Center 9.1/9.0, Microsoft Visio, IBM AIX 4.2/4.1, SQLServer, Oracle11G, Autosys Scheduler, Unix, Windows, HP ALM

Informatica Developer

Confidential, Minnesota

Responsibilites:

  • Developed Informatica mappings, re-usable transformations, re-usable mappings and mapplets for data load to data warehouse and database.
  • Multi source Extraction Transformation and Loading into the target structures usingInformatica.
  • Worked closely with multiple business units and a data solutions engineer to identify keyinformation that will enhance business decision-making.
  • Performance tuned mapping, sessions and database.
  • Extensively used ETL to load data from different source systems like Flat files into the Staging table and load the data into the target database.
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager
  • Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
  • Wrote stored procedures to accomplish tasks.
  • Created sessions to move the data at specific intervals and on demand.
  • Responsible for monitoring all the sessions that are running, scheduled, completed and failed.
  • Debugged the mapping for failed session to fix data and code issues.
  • As a part of daily loading into the warehouse, used UNIX shell scripting to triggers the workflows in a particular order.
  • Involved in coding UNIX shell scripting to execute pre/post session commands.
  • Analyzed and Created Facts and Dimension Tables.
  • Used different Data Warehouse techniques like Star-Schema, Snow-Flake Schema.

Environment: InformaticaPower Center 9.1/9.0, Oracle 11g/10g, Autosys Scheduler, Web Services, PL/SQL, UNIX,Autosys.

Informatica Developer

Confidential, MA

Responsibilites:

  • Gathered business requirements from Business Analyst.
  • Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
  • Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load
  • Installed and Configured the Informatica Client tools.
  • Worked on loading of data from several flat files to XML Targets.
  • Designed the procedures for getting the data from all systems to Data Warehousing system.
  • Created the environment for Staging area, loading the Staging area with data from multiple sources.
  • Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
  • Used workflow manager for session management, database connection management and scheduling of jobs.
  • Created UNIX shell scripts for Informatica ETL tool to automate sessions.
  • Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.

Environment: Informatica Power Center 5.1.2/7.1, Erwin 4.5, Oracle 9i, Windows NT, Flat files, SQL, Relational Tools, Clear Case, UNIX (HP-UX, Sun Solaris, AIX) and UNIX Shell Scripts.

Informatica Developer

Confidential

Responsibilites:

  • Participated in the Data Model design and designed it according to the Business Requirements.
  • Conducted and Participated in code review sessions.
  • Created Design Specification Documents including source to target mappings for Mainframe/Operational Source/financial systems to Stage, Stage to ODS and form ODS to Data warehouse tables.
  • Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer, which populated the data into the target Star Schema on Oracle 11g.
  • Partially involved in writing the UNIX Shell Scripts, which triggers the workflows to run in a particular order as a part of daily loading into the Warehouse.
  • Created different SCD-II mappings using changed data capture (CDC) processes.
  • Provided Operational support for Production issues, and for business users and documented issues and resolutions.

Environment: Informatica Power Center 9.1/8.6.1, Oracle 10g, SQL, PL/SQL, TOAD, UNIX Shell Scripting, Windows XP, UNIX.

Hire Now