We provide IT Staff Augmentation Services!

Informatica Consultant Resume

Boston, MA

EXPERIENCE SUMMARY:

  • IT professional with 8+years of experience in Data Warehousing using Informatica PowerCenter 9.x/8.x/7.x/6.x/5.x (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation Developer),Informatica PowerMart 7x/6x, Power Connect, Power Exchange.
  • Strong Working Experience with various clients ranging from Telecom, Financial, Life - Sciences (Pharma), Insurance and Web (domain-space) related industries.
  • Excellent analytical skills in understanding the client systems and Organizational Structure.
  • Provide high level optimization ideas for the ETL team to improve their code performance. This includes multi processing.
  • Research oriented, raise issues upfront and like to address them as soon as they have been identified
  • Experienced in complete life cycle Implementation of data warehouse.
  • Experienced in OLTP/OLAP system study, analysis and ER modeling, developing Database schemas like Star schema and Snowflake schema used in relational and multidimensional modeling by using Erwin.
  • Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
  • Involved in different database modeling techniques like Object Oriented Design and Modeling, Database Design and Modeling, etc.
  • Extensively worked with Oracle PL/SQL Stored Procedures, Triggers, Functions, and Packages and also involved in Query Optimization.
  • Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with databases like Oracle 11x/10g/9i/8x/7x, SQL Server 2005/2003/2000/7.0/6.5, Teradata, DB2, MSSQL, Excel sheets, Flat Files, Sybase, COBOL files and XML files.
  • Experienced in Installation, Configuration, and Administration of Informatica Power Center/Power Mart Client/Server.
  • Extensive experience in implementing CDC using Informatica Power Exchange 8.x/7.x.
  • Expertise in Administration tasks including Importing/Exporting mappings, copying folders over the DEV/QA/PRD environments, managing Users, Groups, associated privileges and performing backups of the repository.
  • Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
  • Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization, and also identifying performance bottlenecks.
  • Good exposure to Development, Testing, Debugging, Implementation, Documentation, End-user training and Production support.
  • Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
  • Experience in using the Informatica command line utilities like pmcmd to control workflows in non-windows environments.
  • Good knowledge about the architecture of the Teradata database. Developed Teradata loading and unloading utilities like Fast Load, Multiload and Fast Export. . And also Developed BTEQ scripts to load data from Teradata Staging area to Data Warehouse.
  • Experienced in developing SSIS packages for processing fact and dimension tables.
  • Well Experienced in doing Error Handling and Troubleshooting using various log files.
  • Expertise in using UNIX and writing Perl and UNIX shell scripts.
  • An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hard working and high level of motivation. A quick learner with an aptitude for taking responsibilities.

TECHNICAL SKILLS:

Data warehousing Tools: Informatica Power Center 8.x/7.x/6.x, Power Exchange, Data Profiler, Repository Server Administrator Console.

Databases: SQL Server, Oracle 10g/9i/8i, Teradata v2r6, DB2.

Languages: SQL, PL/SQL, C, C++, HTML.

Database Utilities: TOAD 8.0/7.1, SQL*Plus, SQL*Loader, SQL Navigator.

Reporting Tools: BO 6x (Business Objects).

Operating System: UNIX (Sun Solaris 8.0, AIX5.1) and Windows NT/2000.

Scripting Languages: Shell Scripting.

Other Tools: Erwin Data Modeler, SmartFTP, WinScp, Putty.

PROFESSIONAL EXPERIENCE:

Confidential, Boston, Ma

Informatica Consultant

Responsibilities:

  • Downloading the files as per the notification received from different sources.
  • Used Informatica 9.1 version to load data from flat files, Oracle.
  • Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
  • Worked with Parameter files, Incremental extraction.
  • Exported the IDQ Mappings and Mapplets to power center and automated the scheduling process.
  • Worked extensively with a large number of complex transformations like Normalizer, lookup's, aggregator etc.
  • Strong working experience in scheduling tool AutoSys.
  • Built complex mappings and complex shell scripts.
  • Carried out unit testing, integration testing and migration of mappings from development to test and to production environment.
  • Worked extensively on the production tickets that are of higher priority.
  • Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
  • Validating the data once it loaded into EDW.
  • Solving the issues raised by users.

Environment: Informatica Power Center9.1, IDQ, Oracle 10g, Windows 2000, AutoSys, UNIX Shell scripting, ERWIN 4.0.

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

  • Responsible for gathering Business requirements and translate into technical requirements.
  • Involved in translating the functional requirements into technical mapping specifications and leveraged Informatica Power Center 8.6.1 to extract the data from AS/400 DB2 files, Oracle tables and flat files to populate billing, service order and plant interface files, which are then loaded into the Citizens DPI Billing system.
  • SQL*Loader scripts for bulk data loads to Oracle tables and extracting Oracle dumps from Verizon.
  • Experienced in writing Queries against DB2 on AS400 Environment.
  • Optimization/performance tuning techniques implemented to identify bottlenecks- Query tuning (Explain Plan, SQL Trace), table partitioning, memory tuning and cache management.
  • Expertise in debugging and production support.
  • Experience in writing Shell scripts for file manipulation, extraction and execution of Workflows
  • Extensive use of the STRSQL, AS/400 Query facilities in AS/400 and execution of SQL queries using PL/SQL Developer 7.1.0 and also used SQL Loader efficiently to load large volumes of flat file data.
  • Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
  • Developed mappings/sessions using Informatica Power Center 9.1/8.6.1 / Power exchange 8.5.1 for data loading.
  • FTP scripts and Extraction of Unstructured Data from various Verizon Data formats using Perl/Shell Scripts. XML/flat file formats also extracted successfully.
  • Responsible for managing Informatica Services like Repository Service, Integration Services, Reference Table Manager Services etc.
  • Designed and developed error handling and rekey mechanism in Informatica
  • Monitored daily loads and provided on call production support (L2) during data Loads.
  • Creating Change Control Requests as required by assigned projects and ensuring end to end extensive support as Data Analyst and address overall data quality, including the design of ETL strategies to source, match a Merge from various disparate systems
  • Creating Change Control Requests as required by assigned projects and ensuring end to end quality of assigned projects.
  • Installation & configuration of Informatica services for 64 bit OS.
  • Created repository & assigned grants to users to access the repository.
  • Experienced in creating xsds and landing XML extracts.
  • Used transformations like Joiner, Expression, Connected, Unconnected lookups, Filter, Aggregator, Stored Procedure, Rank, Update Strategy, Router, Sorter, Sequence generator etc.
  • Environment: ETL/Informatica PowerCenter 9.1/8.6.1/8.5.1, Informatica Power Exchange 8.6, Oracle 11g, PL/SQL, Telecordia,XML,Flat files, UNIX, Toad, SQL Developer, VSAM, CSV, XML files,AS400, DB2, Perl, Shell Scripting, HP Quality Center.

Confidential, Bridge Water, NJ

Informatica Developer

Responsibilities:

  • Understanding of the business requirements and enhancing the existing data warehouse architecture design for a better performance.
  • Participated in designing the data model using Erwin.
  • Used Informatica Designer to create, Load, Update mappings using different transformations to move data to different data marts in Data Warehouse.
  • Successfully Loaded Data into different targets from various source systems like Oracle Database, Flat files, ODS, SQL Server...etc into the Staging table and then to the target database Oracle and MDM.
  • Developed and documented data mappings, transformations and Informatica sessions.
  • Developed PL/SQL stored procedures and triggers in T-SQL for various data cleansing activities.
  • SQL*Loader was used to load the data from files.
  • Created source, target, transformations, sessions, batches and defined schedules for the sessions.
  • Used Shell Scripting to automate the loading process.
  • Also used Data Integrators to club data from different kind of sources.
  • Performed incremental aggregation to load incremental data into aggregate tables.
  • Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
  • Re-designed ETL mappings to improve data quality.
  • Done powerful data profiling and mapping capabilities by using Informatica Data Explorer, to empower data analysts to investigate and document data quality issues.
  • Involved in Version control of code from development to test and Production environments.
  • Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target, Mapplets, and Transformation objects.
  • Developed UNIX scripts along with Control M for scheduling the sessions and workflows.
  • Involved in Unit & Integration Testing of Mappings & Sessions.
  • Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
  • Involved in moving Mappings, Sessions and Workflows between development and production environments.
  • Partitioned sessions for concurrent loading of data into the target tables of Terra data.
  • Scheduled Sessions and Batch Processes based on demand, run on time, run only once using Informatica Server Manager.
  • Implemented Slowly Changing Dimensions Type 2.
  • Developed various reports using Cross Tab, Master Detail and different charts including Line, Column, Area, and Pie Charts for analysis.
  • Modified Universes and generated reports using Business Objects.
  • Integrated data mart with Hyperion BRIO reporting tool. Used BRIO object models.
  • Developed complex dashboard reports using Report Studio.
  • Designed & developed reports, Drilldown reports using Business Objects Reporter.
  • Designed reports with Slice and Dice & Drill down operations.
  • Prepared Test Cases.

Environment: Informatica Power center 8.1.1, DB2, SQL Server 2000, Oracle 10g/9i, BO XIR2, Windows 2000, UNIX (AIX), ERWin 4.2, Hyperion BRIO reporting.

Confidential, Dallas, TX

ETL/Informatica Developer

Responsibilities:

  • Involved in translating the functional requirements into technical mapping specifications and leveraged Informatica Power Center 8.6.1 to extract the data from AS/400 DB2 files, Oracle tables and flat files to populate billing, service order and plant interface files, which are then loaded into the Citizens DPI Billing system.
  • SQL*Loader scripts for bulk data loads to Oracle tables and extracting Oracle dumps from Verizon.
  • Experienced in writing Queries against DB2 on AS400 Environment.
  • Optimization/performance tuning techniques implemented to identify bottlenecks- Query tuning (Explain Plan, SQL Trace), table partitioning, memory tuning and cache management.
  • Expertise in debugging and production support.
  • Experience in writing Shell scripts for file manipulation, extraction and execution of Workflows
  • Extensive use of the STRSQL, AS/400 Query facilities in AS/400 and execution of SQL queries using PL/SQL Developer 7.1.0 and also used SQL Loader efficiently to load large volumes of flat file data.
  • Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
  • Developed mappings/sessions using Informatica Power Center 9.1/8.6.1 / Power exchange 8.5.1 for data loading.
  • FTP scripts and Extraction of Unstructured Data from various Verizon Data formats using Perl/Shell Scripts. XML/flat file formats also extracted successfully.
  • Responsible for managing Informatica Services like Repository Service, Integration Services, Reference Table Manager Services etc.
  • Designed and developed error handling and rekey mechanism in Informatica
  • Monitored daily loads and provided on call production support (L2) during data Loads.
  • Creating Change Control Requests as required by assigned projects and ensuring end to end extensive support as Data Analyst and address overall data quality, including the design of ETL strategies to source, match a Merge from various disparate systems
  • Creating Change Control Requests as required by assigned projects and ensuring end to end quality of assigned projects.
  • Installation & configuration of Informatica services for 64 bit OS.
  • Created repository & assigned grants to users to access the repository.
  • Experienced in creating xsds and landing XML extracts.
  • Used transformations like Joiner, Expression, Connected, Unconnected lookups, Filter, Aggregator, Stored Procedure, Rank, Update Strategy, Router, Sorter, Sequence generator etc.

Environment: Informatica Power Center 8.6.1, DB2(AS400),Oracle 11g,SQL Server 2008, SQL,PL/SQL, TOAD, Unix, Unix Shell Script, Erwin, Business objects XI Release 2.

Confidential, Tampa, Florida

Informatica Developer

Responsibilities:

  • Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application Owners.
  • Prepared the High-level Design document to provide an overview of the technical design specification system required for Application Enhancements.
  • Designed and Developed mappings needed for enhancement of project.
  • Worked with Informatica Power center V8.1/7.1 Mapping Designer, Workflow Manager, Workflow Monitor and Admin Console.
  • Created Informatica Mappings to populate the data into dimension and Fact tables.
  • Exported and Imported mappings between different Informatica folders and also Repositories.
  • Used different transformations like Aggregator, Lookup, Filter, Expression, Router, Update Strategy and Sequence Generator.
  • Informatica Debugger is used to test the mappings and fixed bugs.
  • Provided Production Support for IDS DSS and created Unix Shell Scripts to delete data that is older than 3 years from fact tables.
  • Experience in working with Informatica Service and Repository Service.
  • Experience with Informatica V8 support in a high availability grid environment.
  • Familiar with Data Warehouse Architecture, design methodologies and Best practices.
  • Experience with server log files, editing UNIX scripts, FTPing files and checking space on server.
  • Scheduled Informatica sessions and workflows using Informatica Scheduler.
  • Performance and fine tuning of Informatica mappings.
  • Used Informatica designer for designing mappings and mapplets to extract data from SQL Server,
  • Sybase and Oracle sources.
  • Experience in writing DB2 scripts and gave them to DBA's for implementing in Production database tables.
  • Loaded data into data marts on a daily basis.
  • Created new repositories and new folders within the repositories using Repository Manager.
  • Experience with Designer, Workflow Manager, Workflow Monitor and Repository Manager.
  • Involved in System testing and User Acceptance Testing.
  • Changed existing Universes to accomplish the changes in business requirements.

Environment: Informatica 8.1/7.1, Micro Strategy 8.0, SAS, Oracle10g, Sybase, Windows, Linux and HP-UNIX.

Hire Now