We provide IT Staff Augmentation Services!

Informatica Developer Resume

Beaverton, OR

SUMMARY:

  • 7+ years of IT experience in the field of Data warehousing in tools like Informatica 8x, 9x, 10x Power Center, Power Exchange (5.x/8.x), Oracle, SQL Server, AWS,TDM, SSIS and UNIX Shell Scripting.
  • Technical proficiency in the Data Warehousing teamed with Data Analysis, Data Modeling, Business Requirements Analysis, Application Design, Development & testing, Data profiling, data standardization & Quality Control and full life cycle Implementation of Data Warehouse.
  • Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services.
  • Extensively worked on Informatica Data Quality and Informatica Power center throughout complete Data Quality.
  • Develop client proposals and present at stakeholder meetings. Forecast future trends and orient strategies to capture maximum benefits. Coordinate with sales executives to better align company goals and tactics.
  • Experienced in implementing Organization DevOps strategy in various operating environments of Linux and windows servers along with cloud strategies of Amazon Web Services.
  • Experienced with Informatica Power Exchange (5.x/8.x) for Loading/Retrieving data from mainframe systems.
  • Experience in installation and configuration of core Informatica Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows.
  • Involved in Requirement gathering, Data Analysis, Application Design, Data Modeling, Application Development, Implementations and Data Quality in different Data warehouse Projects.
  • Experience in designing error and exception handling procedures to identify, record and report errors.
  • Extensive Experience in developing and performance tuning of informatica mappings
  • Experience in using Automation Scheduling tools like Autosys and Control - M.
  • Created source to target mapping documents for input into ETL specifications by Identifying, analyzing data sources
  • Extensively used SQL and PL/SQL for development of Procedures, Functions and Packages
  • Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
  • Created transformations such as Joiners, Lookups, Filters, Aggregator, Sequence Generators, according to the business rules
  • Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting
  • Experience in testing the data using debugging mapping method. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
  • Used SQL tools to run SQL queries to view and validate the data loaded into the warehouse and troubleshoot data issues.
  • Effective working relationships with client team to understand support requirements, and effectively manage client expectations.

TECHNICAL SKILLS:

ETL Tools: Informatica 10.X/9.X/8.x (Power Center), BODS, Teradata SQL Assistant, TOAD, Putty

Data Modeling: Physical Modelling, Logical Modelling, Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes

Databases: Oracle 12g/11g/10g/9i, MS SQL Server, MS Access

Languages: SQL, PL/SQL, Data Structures, Unix Shell Script

Tools: SQL plus, PL/SQL Developer, SQL* Loader

Operating Systems: Windows NT/2000/2003/XP/Vista/7, Unix, Linux

PROFESSIONAL EXPERIENCE:

Informatica Developer

Confidential - Beaverton, OR

Responsibilities:

  • Gathering Business requirements and creating technical specifications along with creating Internal and External Design documents
  • Create Technical specification documents and work with Business Analysts on analysis of multiple source systems data as part of ETL mapping exercise
  • Created various mappings using different transformations in LDO's such as Union, Sorter, Joiner, Expression, Aggregator etc., transformations
  • Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
  • Created Batch scripts to call Informatica workflow's for number of times. Created different jobs using batch scripting to call the workflow by using Command tasks.
  • Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer
  • Executed Sessions, Sequential and concurrent batches for proper execution of mappings.
  • Attended status meetings with project managers, escalated issues when necessary, attended meetings for issues resolution.
  • Intimate about errors which is not relating to ETL and assigned to the concern person which is responsible for that error.
  • Used parameters/variables for Powercenter mappings, sessions and workflows.
  • Worked in Error Handling strategy. If any errors occurred the mapping should fail.
  • Worked extensively with sources and target like Flat files, SQL Server tables
  • To build efficient ETL components to meet the technical requirements

Environment: Informatica Power Center (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Autosys, DB2, Oracle 12g, Siebel, TOAD, SQL*Plus, Windows, UNIX, Shell Scripting.

Informatica Developer

Confidential, McLean, VA

Responsibilities:

  • Responsible for technical Design Document and Details mapping document
  • Develop the mappings using needed Transformations in Informatica tool according to technical specifications
  • Developed design documentation and implementation proposal for extraction of data from W data warehouse.
  • Supporting the ETL Inbound for heterogeneous sources using ETL CDC (Change Data Capture) Mappings and scripts in Informatica Power center.
  • Developed modules to extract process & transfer the customer data using Teradata utilities.
  • Experienced with Informatica Power Exchange for Loading/Retrieving data from mainframe systems.
  • Created Fast Export scripts for extracting and formatting customer data from data warehouse in a mainframe file.
  • Created FTP Id to set up transmission path between mainframe and UNIX machine.
  • Experience in several facts of MDM implementations including Data Profiling, Data extraction, Data validation, Data Cleansing, Data Match, Data Load, Data Migration, Trust Score validation.
  • Develop client proposals and present at stakeholder meetings. Forecast future trends and orient strategies to capture maximum benefits. Coordinate with sales executives to better align company goals and tactics
  • Developing Informatica ETL jobs to extract data from Source and to load into the Oracle.
  • Implemented Informatica error handling, dynamic parameter file generations and coding best practices

Environment: Informatica Power Center, Oracle 11g, SQL, PL/SQL, XML, MS Access, Web services, Java, UNIX, DB2, Shell Script, SSIS.

Informatica Developer

Confidential

Responsibilities:

  • Extract, transform and Load data from different sources into Oracle database using Informatica as ETL tool.
  • Experience in BTEQ scripts
  • Have designed history logics and written good SQLs in Teradata.
  • Have involved in solving complications in the production level issues.
  • Have involved SIT and UAT defects closing.
  • Worked extensively in shell scripting and click stream analysis
  • Involved in Tuning the Informatica objects to increase the Performance of the Informatica loads.
  • Written the scripts needed for the business requirements (BTEQ Scripts).
  • Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
  • Transformed bulk amount of data from various sources to Teradata database by using BTEQ scripts.
  • Extracted data from various Sources like Oracle, Excel Spread sheets, XML, Sybase, Teradata and Flat Files.
  • Created Unix Shell Scripts for ETL jobs, session log cleanup, dynamic parameter and maintained shell scripts for data conversion
  • Have helped in re-building of Jobs based on requirement.

Environment: DWH, PL/SQL, UNIX Shell Scripting, Informatica Power Center, Oracle 11g, SQL Server, UNIX.

Informatica Developer

Confidential

Responsibilities:

  • Developing Informatica ETL jobs to extract data from Source and to load into the Oracle.
  • Develop the mappings using needed Transformations in Informatica tool according to technical specifications
  • Responsible for technical Design Document and Details mapping document
  • Extensively used Informatica Power Center and created mappings using transformations like SourceQualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
  • Used Informatica reusability at various levels of development.
  • Fixed the invalid mappings and troubleshoot the technical problems of the database.
  • Attended weekly status meetings and provide detailed status report to the client..
  • Develop informatica mappings and workflows for new change requests.
  • Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
  • Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
  • Preparing Test Results, Unit testing, Defect Fixing

Environment: Informatica Power Center, PowerBuilder, Oracle, Oracle SQL Developer, Quest-Toad, Shell Scripts, SQL*Loader, UNIX and Windows.

Hire Now