We provide IT Staff Augmentation Services!

Sr. Informatica/ Etl Developer Resume

Washington D, C

SUMMARY:

  • 14 years of total IT experience in the Business Requirements Analysis, Application Design, Data Modeling, Development, Implementations and Testing of Data Warehousing and Database business systems for Pharmaceutical, Healthcare, Financial and Insurance industries.
  • 9 years of strong experience in Data Warehousing and ETL using Informatica PowerCenter 9.5.1/9.1/8.6/8.1/8.0/7.1.3/7.1.1/7.0/6.2/5.1, Informatica PowerMart 6.2/5.1/1.7/1.5, Warehouse Designer, Power Exchange 9.5.1, PowerConnect for SAP/Peoplesoft/Oracle Apps/Siebel/DB2, Power Analyzer, Datamart, OLAP, OLTP, IMS Data (Rx Data, Xponent, Xponent Plantrak), Autosys, Maestro, Control - M.
  • 4 years of strong Business Analysis experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
  • 4 years Data modeling experience using Erwin 4.5/4.0/3.5.5/3.5.2, Star Schema Modeling, Snowflake modeling, FACT and Dimensions tables, Physical and logical data modeling.
  • 3 years of Data Cleansing experience using Trillium 7.6/6.5 (Macher, Parser, Converter & Geocoder), Firstlogic 4.2/3.6, UNIX Shell Scripting and SQL coding
  • 4 years of Business Intelligence experience using Business Objects 6.5/6.0/5.1/5.0, Cognos Series 7.0, Data Reports, Seagate Crystal Reports 6.x/5.x/4.x/3.x, OBIEE, Developer 2000, MS Access Reports
  • 7 years of Database experience on Oracle 10g/9i/8i/8.x/7.x, Teradata V2R5/V2R4/V2R3, DB2, MS SQL Server 2000/7.0/6.5, MS Access 7.0/2000, SQL, PL/SQL, SQL*Plus, SQL*Loader, Developer 2000, Netezza, Sun Solaris 2.x, IBM AIX, and HP-UX
  • SAP Configuration experience in SD (Pricing Requirements, Master Data, and Intervals), MM (Movement Types, Fields and Master Data), FI/CO and Transportation (Routes and Stages)

TECHNICAL SKILLS:

Data Warehousing: Informatica PowerCenter 9.5.1/9.1/8.6/8.1/8.0/7.1.3/7.1/7.0/6.2, Informatica Powermart 5.1.1/5.0/4.7.2, Informatica Administrator, Power exchange 9.5.1, Powerconnect for SAP/Peoplesoft/Oracle Apps/Siebel/DB2, Autosys, Maestro, Control M, Trillium, Firstlogic, IMS Data, Metadata, Data Mining, Datamart, OLAP, OLTP, SQL* Plus, SQL*Loader

Data Modeling: Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.0/3.0

Business Intelligence: Business Objects XI/6i/6.0/5.1/5.0, Cognos Series 7.0, OBIEE, Data Reports, Seagate Crystal Reports 6.x/5.x/4.x/3.x, Developer 2000, MS Access Reports

Programming: Unix Shell Scripting, SQL, PL/SQL, SQL*Plus 3.3/8.0, Visual Basic 6.0/5.0, HTML, DHTML, XML

Databases: Oracle 10g/9i/8i/8.0/7.0, MS SQL Server 2000/7.0/6.5, Teradata V2R5/V2R4, DB2, MS Access 7.0/ 97/2000, Netezza

Environment: Sun Solaris 2.6/2.7, HP-UX, IBM AIX 4.2/4.3, OS/390, MS-DOS 6.22, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win NT 4.0, SCO Unix

ERP: SAP R/3, SAP SD, SAP BW, Siebel/DB2/SAP, Siebel 7.0/2000

PROFESSIONAL EXPERIENCE:

Confidential, Washington, D.C

Sr. Informatica/ ETL Developer

Responsibilities:

  • Implemented standards for naming Conventions, Mapping Documents, Technical Documents and Migration form.
  • Understand the business requirements, Develop, Design specifications for enterprise applications using Informatica, Oracle database and Flat File sources.
  • Analysis of the End user requirements and involved in Modeling the ETL Schema.
  • Worked on Designing, developing and unit test in Informatica mappings for extraction, Transformation and Loading of data from source.
  • Worked on Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
  • Created the registrations using informatica power exchange.
  • Deployed the supplemental logs for registrations in different environments.
  • Implemented the Change Data Capture using informatica power exchange for facets data.
  • Maintained the condense jobs for all the registrations in informatica power exchange.
  • Used ETL to extract and load data from different data bases and flat files to Oracle.
  • Created Complex Mappings/Workflows as per the Business Logic.
  • Experience with high volume datasets from various sources like COBOL, Text Files, XML and Relational Tables.
  • Performed tests on various features of agile development process.
  • Involved in designing of Informatica Mappings by translating the business requirements.
  • Involved in Performance Tuning and optimization of Informatica mappings and session.
  • Implemented ABAC (Automated Balance and Audit Controlling) process to resolve errors.
  • Created the Error handling Mechanisms and reconciliation procedures.
  • Deployed the code across different test environments.
  • Performed Code Review with the team members.
  • Created Work Assignment requests to migrate the code from one environment to other.
  • Worked on creating JCL’s using mainframes and scheduling the JCL’s in test environments.
  • Used Dimensions tool for Raising Migration Requests.
  • Used HPQC - ALM Quality Center for Defect Tracking.

Environment: Informatica Power Center 9.5.1, Power Exchange Navigator 9.5.1, Oracle 11g/10g, SQL Server, Sybase, Solaris, Dimensions, Team Track, UNIX, Shell Programming, SQL Server 2005/2008, Mainframe 3270, Magic Tickets, HPQC - ALM, Window 7, COBOL, JCL.

Confidential, Atlanta, GA

Sr. Informatica Developer/ Admin

Responsibilities:

  • Experience in designing and implementing ETL using Informatica Power Center 8.6.
  • Working as Informatica Administrator/Developer.
  • Worked on administrator role like migration of objects in all phases DEV, QA and PROD.
  • Performed Upgrading Informatica Power center Version 7.3.1 to Informatica Power center 8.6.
  • Monitoring the Jobs and support to resolve Issues.
  • Created Technical Design Specifications and Support Manuals.
  • Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
  • Extensively used Lookup, Joiner, Sorter, Aggregator, Update Strategy, Router and Source Qualifier Transformations for creating complex mappings.
  • Created Mapplet for complex logics and used them in different Mappings.
  • Performance tuning of the Informatica mappings using various components like Parameter files, Variables.
  • Ensures proper configuration of the Power Center Domain components.
  • Experience in Configuring nodes, Repository services and Integration services.
  • Experience in Create, backup, restore for Informatica Repositories.
  • Creating Folders and managed user and user group access to objects.
  • Code review of mappings, sessions and workflows of various applications.
  • Involved in Testing, Debugging, Validation and Performance Tuning of data warehouse, helped in developing optimum solutions for data warehouse deliverables.
  • Installed all necessary updates and patches for the ETL environments on timely basis.
  • Created and maintained all databases required for development, testing and production usage.
  • Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process.
  • Coordinate deployments that include Informatica deployments as well as probably Unix Shell Script and Database DDL deployments.
  • Worked on Repository Queries in support of developments and Production statistics.
  • Added and updated ODBC and TNS entries.
  • Preparing weekly and monthly progress report.

Environment: Informatica Power Center 9.1/8.6, Unix Shell Scripting, WinSCP, Putty, OBIEE, XML, DB2, MS Excel, Oracle 10g, PL/SQL, SQL Server, Windows NT 4.0, Erwin 4.5

Confidential, Madison, WI

Sr. Informatica Developer

Responsibilities:

  • Interacted with business users, data architects, application developers to develop a data model.
  • Developed ETL mappings in Informatica PowerCenter Designer using various transformations like Source Qualifier, Normalizer, Router, Expression, Filter, Connected and Unconnected Lookup, Update Strategy, Sequence Generator etc.
  • Developed reusable transformation and mapplets.
  • Developed reports, based on business requirements, using Cognos Powerhouse.
  • Created different steps of reconciliation to match the records count and validations.
  • Expertise in the optimization of the performance of the Designed workflows processes in Informatica and to identify the bottlenecks in different areas after the full volume system run.
  • Extensive use of Command tasks, Decision tasks, email tasks in the workflow design.
  • Used debugger to test the mapping and fixed the bugs
  • Developed the Test Scripts and performed the Unit Tests on the ETL mappings.
  • Created and scheduled UNIX scripts to control the ETL processes.
  • Developed test cases, conducted unit tests, and migrated Code from development to test and production environment.
  • Worked with HP Quality Center to interact with testing team.

Environment: Informatica Power Center 8.6, Work Flow Manager, Work Flow Monitor, Maestro, Unix Shell Scripting, XML, DB2, MS Excel, Oracle 10g, PL/SQL, SQL Server, Windows NT 4.0, Erwin 4.5

Confidential, Boston, MA

Sr. Informatica Developer

Responsibilities:

  • Involved in requirement gathering from business users and documenting the requirements.
  • Prepared the Functional and Technical Documentation.
  • Involved in all phases of SDLC from requirement, design, development, testing, training and support for production environment.
  • Lead the team of ETL developers in designing the Data Warehouse.
  • Developed Informatica mappings using the Oracle, SQL Server and Netezza Datawarehouse.
  • Extracted, Transformed and Loaded data into Netezza using Informatica mappings in this process used different transformations (Aggregator, Joiner, Lookup, Update Strategy, Source Qualifier, Filter, Router and Expression, etc.).
  • Used Normalizer transformation extensively to normalize the data from the Oracle environment.
  • Designed and developed the Informatica workflows and sessions.
  • Implemented Stored Procedures and Functions to implement the Complex Business logics in Oracle and SQL Server.
  • Created different steps of reconciliation match the records count.
  • Expertise in the optimization of the performance of the Designed workflows processes in Informatica and to identify the bottlenecks in different areas after the full volume system run.
  • Extensive use of Command tasks, Decision tasks, email tasks in the workflow design.
  • Created Batch Jobs to execute the Scripts.
  • Created the Data Flow Diagrams to check the dependency.
  • Created and maintained the shell scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
  • Improved performance of the jobs using various performance tuning techniques.
  • Successful code migration from DEV to Testing & Production environment
  • Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.

Environment: Informatica Power Center 8.5/8.1, Erwin, Unix Shell Scripting, Cognos, Netezza, SQL Server, MS Access, MS Excel, Flat Files, Oracle 10g, PL/SQL, Toad, Windows NT 4.0, Sun Solaris 2.6.

Confidential, NY

Senior DW Informatica Developer

Responsibilities:

  • Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.
  • Developed ETL mappings in Informatica PowerCenter Designer using various transformations like Source Qualifier, Normalizer, Expression, Connected and Unconnected Lookup, Update Strategy, Sequence Generator etc.
  • Exported Info sources from SAP BW as targets for the Informatica mappings using PowerCenter Connect
  • Worked with IMS Data to compare the productivity of the products.
  • Created Mapplets and used them in different Mappings for maintaining the standards.
  • Created parameter files using mappings.
  • Used debugger to test the mapping and fixed the bugs
  • Used Session Task, Command Task, and Event Raise/Event Wait etc. to develop Workflows.
  • Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development by applying Ralph Kimball methodology of dimensional modeling.
  • Developed the Test Scripts and performed the Unit Tests on the ETL mappings.
  • Identified proper partitioning methods for performance enhancements.
  • Developed and scheduled Workflows using workflow designer in Workflow manager and Mastro.
  • Involved in analyzing source systems and designing the processes for Extracting Transforming and Loading the data to Data marts.
  • Wrote the shell scripts to process the PL/SQL procedures and wrote the PL/SQL program (Functions, Procedures) for data extracting, transforming and loading.
  • Involved in Performance tuning for better performance.

Environment: Informatica Power Center 8.5/8.1, PowerConnect for SAP, Maestro, Unix Shell Scripting, XML, DB2, MS Access, MS Excel, Flat Files, Oracle 10g, SSIS, PL/SQL, Windows NT 4.0, Sun Solaris 2.6. Erwin 4.5

Confidential, TX

Senior ETL Analyst

Responsibilities:

  • Interacted with business analysts, data architects, application developers to develop a data model.
  • Designed the Data models for Data mart. Created Logical and Physical Data models using Erwin.
  • Installed and configured Power Center 8.0/7.1.3 on client machine.
  • Designed Logical flowcharts, sequence diagrams, state diagrams and data flow diagrams.
  • Research Sources and identify necessary Business Components for Analysis.
  • Extensively used ERwin for data modeling and Dimensional Data Modeling.
  • Created the (ER) Entity Relationship diagrams & maintained corresponding documentation for corporate data dictionary with all attributes, table names and constraints.
  • Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
  • Working with different Sources like ORACLE, FLAT FILES, XML FILES, DB2.
  • Created Stored Procedures to calculate employee commission.
  • Developed Workflows and session to load data into targets.
  • Created and Modified UNIX jobs.
  • Created Informatica mappings with PL/SQL Procedures / Functions to build business rules to load data.
  • Created Schema objects like Indexes, Views, and Sequences.
  • Designed and developed Oracle PL/SQL Procedures.
  • Created Test Plan and Test Strategy using the design documents.
  • Implemented Unit testing and Integrated testing.
  • Participated in weekend reviews with team members and Business People.

Environment: Informatica Power Center 8.0/7.1.3, PowerConnect for SAP, Maestro, IWR, Unix Shell Scripting, XML, DB2, MS Access, MS Excel, Oracle 10g, PL/SQL, Windows NT 4.0, Sun Solaris 2.6. Erwin 4.5

Confidential, Plough, NJ

Senior Informatica Developer

Responsibilities:

  • Designing functional specifications and technical specifications
  • Installed and Configured Informatica Power Center 7.1 client tools and connected with each database in Data Warehouse using repository server.
  • Analyzed IMS Data using IMS tools such as Xponent and Xponent Plantrak, regarding segmentation & profiling.
  • Carried out ETL using Informatica and PL/SQL
  • Used debugger to test the mapping and fixed the bugs.
  • Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance by using various data and index caches.
  • Responsible for creating the customized user interface using Cognos 6.5/7.0 Upfront and monitored, configured upfront servers and process.
  • Created standard and Ad hoc reports using Cognos.
  • Scheduling and Loading data process and monitoring the ETL Process.
  • Developed reusable Mapplets and Transformations
  • Created various UNIX Shell Scripts for job automation of data loads.
  • Consolidation, Cleansing, Integration, ETL, and customization of data.
  • Extensively used PowerConnect for SAP R/3 to source master data, line item and schedule line item tables into Teradata.
  • Executed sessions, tasks, sequential and concurrent batches for proper execution of mappings.
  • Customized the Source Qualifier in Informatica to extract required data from SAP R/3.
  • Migrated Mappings, Sessions and Common Objects from Development to Test and to Production.
  • Optimized Informatica mappings for Performance at transformation level, mapping level and Session level.
  • Using Workflow Manager for Creating, Validating, Testing and running the Batches and Sessions and scheduling them to run at specified time.

Environment: Informatica Power Center 7.1, PowerConnect for SAP, Cognos Powerhouse, IWR, Unix Shell Scripting, MS Access, MS Excel, Oracle 10g, PL/SQL, Windows NT, Sun Solaris 2.6. Erwin 4.0

Confidential

Oracle Developer

Responsibilities:

  • Business Analysis and Requirements Gathering.
  • Designed and developed SQL Stored Procedures.
  • Used Pro*C programs to generate various programs to validate.
  • Developed Oracle forms screens for entering the customer data.
  • Designed and developed UNIX shell scripts and Crontabs to automate.
  • Extensively worked on SQL*LOADER, import and export utilities.

Environment: Oracle 7.3, PL/SQL, SQL*Loader, SQL, Forms 4.5, Sun Solaris, Windows NT

Hire Now