We provide IT Staff Augmentation Services!

Sr. Etl Informatica Developer Resume

Brea, CA

SUMMARY

  • Around 7+ years of IT experience in Requirement Analysis, Data Analysis, Application Design, Application Development, Implementation and Testing of Applications in Data warehousing and OLAP.
  • Strong business knowledge of Retail, Healthcare, Banking, and Insurance Domains using ETL tool Informatica Power Center v6.x, 7.x, 8.x, 9.x (Repository Manager, Mapping Designer, Workflow Manager, Mapplet Designer, Workflow Monitor, Source Analyzer, Transformations Designer, Warehouse Designer).
  • Have RDBMS concepts experience in Oracle 11g/10g/9i/8i, Oracle PL/SQL, SQL*Plus, SQL*Loader, IBM DB2 8.0/7.0, Sybase, Netezza, MS SQL Server 2000/2005/2008.
  • Extensive experience using Informatica power center, Netezza, Sybase, DB2, SQL, Oracle 10g/9i/8i, UNIX Shell Scripting, Bash Scripting, Windows, and as well as External Sources like flat files, COBOL sources.
  • Experience with complex Informatica mappings using transformations like Expression, Aggregator, Router, Joiner, Rank, Sorter, Stored Procedure, SQL, XML, Lookups, Normalizer, Sequence Generator and Update Strategy.
  • Data Modeling experience using Star Schema/Snowflake modeling, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling, and Oracle Designer.
  • Experience with reading from Mainframe datasets and Cobol Sources using Informatica Power Exchange.
  • Expertise on extraction of data from Flat files, SQL Server and Oracle and loaded them into Warehouse.
  • Have extensive experience in Data Warehousing with thorough knowledge of Oracle RDBMS.
  • Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts and Enterprise database design and support.
  • Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
  • Experience in Integration of various data sources like Oracle, DB2, SQL Server, XML files, Teradata and Flat Files into Staging Area
  • Worked with Slowly Changing Dimensions type 1, 2 and 3.
  • Use the Data Warehouse Administration Console (DAC) to configure, manage and load the Oracle Business Analytics Warehouse.
  • Experience in Database Design, Entity - Relationship modeling, Dimensional modeling like Star schema and Snowflake schema using Ralph Kimball methodology.
  • Experience in OBIEE10x / Siebel Analytics, including Designing and Configuring Repository, Creating/managing Dashboards, Answers, and Interactive dashboards.
  • Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
  • Worked in Production support team for maintaining the mappings, sessions and workflows to load the data in Data warehouse.
  • Experience in Oracle as Pl/SQL Developer
  • Experience in working as a Technical Coordinator of an offshore team.
  • Excellent problem solving skills with strong technical background and a quick learner and excellent team player with good inter-personal skills.

TECHNICAL SKILLS

ETL Tool: Informatica Power Center 6.x, 7.x, 8.x, 9.x

Databases: Oracle 9i/10g/11g, DB2, Sybase, SQL Server 2005, MS-Access, Teradata

Reporting Tool: Siebel Analytics/OBIEE

Utilities: Quest Toad for Oracle, SQL * Loader, Aqua Data Studio 8.x, SQL Developer

Operating Systems: Windows, Linux, UNIX.

Data Modeling Tool: Toad Data modeler and MS Visio.

Schedulers: DAC 10g/11g, Autosys and ROBOT

PROFESSIONAL EXPERIENCE

Confidential, Brea, CA

Sr. ETL Informatica Developer

Responsibilities:

  • Designed the Data model and Load strategy to get data from different systems and use it for the Online Registration database.
  • Prepared the Technical Specs, Reverse Engineered Logical designs using Erwin, Flow diagrams and Timeline sheets to facilitate development of Informatica Flows.
  • Implemented Star Schema for denormalizing data for faster data retrieval for Online Systems.
  • Designed and Developed Mappings, sessions and workflows in Informatica.
  • Extracted, transformed data from various sources such as Flat files, Oracle 11g and transferred data to the target data warehouse Oracle 11g and XLS files.
  • Explore prebuilt ETL metadata, including Informatica workflows and mappings and DAC metadata.
  • Used Informatica and the Data Warehouse Administration Console (DAC) to configure ETL metadata and run an execution plan to load Oracle E-Business Suite (EBS) data into the OBAW.
  • Created Autosys jobs for scheduling.
  • Designed and developed Informatica Mapping for data load and data cleansing.
  • Responsible for Pre and Post migration planning for optimizing Data load performance capacity planning and user support.
  • Participate in all phases of Software Development Life Cycle ( SDLC ) in project.
  • Performed migration of mappings and workflows from Development to Test and to Production Servers.
  • Worked extensively on transformations like Lookups, Aggregator, Update Strategy, Stored
  • Partitioned sources and used persistent cache for Lookup’s to improve session performance.
  • Worked closely with QA team during the testing phase and fixed bugs that were reported.
  • Worked with Data / Data Warehouse Architect on logical and physical model designs.
  • Performed impact analysis for systems and database modifications.
  • Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
  • Review, verify and validate requirements, designs the data validation test suite.
  • Expertise in conversions from SQL Server to Teradata.
  • Done extensive testing and wrote queries in SQL to ensure the loading of the data.
  • Design, implementation and documentation of test cases and addition of these test cases to the automated test scenarios.
  • Design, develop and maintain/enhance the QA automation scripts.
  • Defect prevention through early involvement with project teams.
  • Defect reporting and tracking.

Environment: Informatica Power Center 9.6/9.5/9.1 Oracle 11g/10g, OBIEE 10g, SQL Server 2008, XML, Flat Files,Autosys,Toad, Sybase, Shell Scripting.

Confidential, Buffalo, NY

Sr. Informatica Developer

Responsibilities:

  • Analyzed existing functional specifications and worked extensively with the business community and database administrators to identify the data load issues and proposed ETL framework.
  • Extensively used Informatica PowerCenter for extracting, transforming and loading data from relational sources and non-relational sources.
  • Extensively used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joiner while migrating data from various heterogeneous sources like Oracle, Sybase, DB2, XML and Flat files to Oracle.
  • Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for Data Load.
  • Built and load data from external source (ERP) using Informatica Power Exchange.
  • Handled slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
  • Designed complex UNIX scripts and automated it to run the workflows daily, weekly and Monthly.
  • Hands on experience in Analyzing Requirements, Design, Development, Implementation and Testing using Agile methodology.
  • Strong experience in health care claims processing, billings and payments
  • Interacted with Senior Management to identify key Dimensions and Measures for business performance.
  • Setting up and Sessions and Workflows to schedule the loads at required frequency using Power Center Workflow manager.
  • Created connected and Un-Connected transformations to lookup the data from Source and Target Tables.
  • Monitoring the ETL jobs and fixing the Bugs.
  • Monitored the ETL Production Jobs and coordinated with offshore team to delegate tasks and monitor the day-to-day progress status and resolve the technical bugs and issues.
  • Involved in doing Unit Testing, Integration Testing and System Testing.

Environment: Informatica PowerCenter 8.6, Oracle 10g/9i, DB2, XML, Sybase, Flatfiles, SQL, PL/SQL, Autosys, TOAD, Unix, Windows.

Confidential, Freeport, ME

Informatica Developer

Responsibilities:

  • Involved in requirement gathering and document reporting requirements
  • Involved in creating target tables for optimized and integrated customer and account related data.
  • Implemented Staging Area to improve performance for OLAP and OLTP systems.
  • Developed Source to Target Mappings using Informatica Power Center Designer to load data from various source systems like Oracle, MS SQL server, Teradata and Flat files to target database, implementing the business rules
  • Implemented slowly changing dimension (Type 1, 2 and 3) through Informatica for different backup requirements.
  • Developed Mappings, Sessions and Workflows using Informatica PowerCenter tool 8.1.1.
  • Developed and Designed Repository based on the Requirements, Understanding the design considerations for star schemas/ snow flake schema and its relationships.
  • Scheduled mappings daily, monthly and weekly basis based on requirements.
  • Integrated the developed Data Warehouse into OBIEE administration tool for reporting purpose.
  • Identified all impacted ETL mappings/Jobs and modified source/target connections and made the system into Netezza specific
  • Involved in installation and configuration of Informatica and DAC.
  • Review, verify and validate requirements, designs the data validation test suite.
  • Design, implementation and documentation of test cases and addition of these test cases to the automated test scenarios.
  • Made Netezza specific changes in ETL mappings/jobs and performed unit testing.
  • Design, develop, implement, and maintain Automation Testing Framework for data validation.
  • Define, review and implement data validation improvement processes across the Enterprise Data Warehouse Organization.
  • Develop, execute and maintain test plans for the product releases.
  • Design, develop and maintain/enhance the QA automation scripts.
  • Track and report on test status for project.
  • Defect prevention through early involvement with project teams.
  • Defect reporting and tracking.
  • Work with Junior QA Analysts and Engineers to mentor them in the area of testing best practices and methodologies.
  • Identify and execute the manual test coverage.
  • Developed and Designed Repository based on the Requirement, Understanding the design considerations for star schemas/ snow flake schema and its relationships.
  • Performed upgrading of Informatica repository from version 8.1.1 to 8.6.1.
  • Performed Unit Testing and worked with the end user at various stages of the test cycles.

Environment: Informatica PowerCenter 8.6.1/8.1.1 ,Teradata, OBIEE 10g, Oracle 10g/11g, Unix,, MS EXCEL, MS SQL Server, Windows XP Professional.

Confidential

Informatica Developer

Responsibilities:

  • Installed and configured Repository to handle metadata for ETL process in Informatica 6.2
  • Created Source and Target Definitions through Informatica Designer for Extraction, Transformation and Loading process.
  • Integrated data sources into the Staging area in the Data warehouse for Cleansing purpose.
  • Involved in building of the Data Warehouse which included the designing the Data Mart and building the Star Schema.
  • Involved in development of various mappings using Informatica against the fact to summary tables.
  • Created Reusable Transformations and Mapplets to use in Multiple Mappings.
  • Created Sessions and Workflows using Informatica Workflow Manager for data movement through Mappings.
  • Wrote Stored Procedures using PL/SQL for Incremental updates.

Environment: Informatica 6.2, MS SQL Se

Hire Now