We provide IT Staff Augmentation Services!

Etl/informatica Developer Resume

Baltimore, MD

PROFESSIONAL SUMMARY:

  • Around 5 years of IT experience in Analysis, Design, Development and Deployment of technical solutions to business requirements.
  • Extensively worked on Data Warehouse Full Life Cycle Projects for Health Care, Financial, and Retail industries.
  • 4+ years of Strong Data Warehousing ETL experience using Informatics Power Center 9.6.1/9.5/9.1/9.0/8.6 (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Informatica Server, Repository Manager)
  • Experience in all the phases of ETL such as Extraction, Cleaning, Transformation and Loading using Informatica.
  • Experience in using Oracle 11g/10g for performing ETL functions using stored procedures.
  • Extensive experience and exposure on several areas of the data warehousing and Business including requirements gathering, data warehouse architecture design, development, quality planning & assurance, data analysis and implementation.
  • Working knowledge with Informatica CDC for daily loads.
  • Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
  • Excellent understanding of the System Development Life Cycle. Involved in analysis, design, development, testing, implementation, and maintenance of various applications.
  • Extracted data from various sources ranging from various RDBMS like Oracle, MS SQL Server, DB2, Teradata and Sybase, and Flat Files to load data into data marts and data warehouse.
  • Expertise in working with TOAD for creation of Tables, Materialized views and normal views.
  • Proficiency in working with PL/SQL stored procedures, packages, and triggers.
  • Actively involved in Performance Tuning, maintaining Staging area, Backup and Recovery process, product support on various platforms.
  • Implementations of change data capture using Power Exchange for daily loads.
  • Performed data quality checks using data quality tools.
  • Experience in UNIX environment, file transfers and job scheduling.
  • Experience in doing Tuning of Teradata Queries using Explain plan.
  • Good experience working with large databases and performance tuning.
  • Efficient in Optimizing, Debugging and testing SQL queries and stored procedures.
  • Excellent working knowledge of Shell Scripting and job scheduling on platforms like UNIX.
  • Good experience on FACETS CTP (Claims Test Pro) and FACETS Testing.
  • Able to interact effectively with other members of the Business, Quality Assurance, Users and other teams involved with the System Development Life cycle.
  • Automation of the business process using Control M, Autosys and Tidal.
  • Designed and coded application components in an Agile environment utilizing a test driven development approach.
  • Excellent analytical, functional, design and development skills with excellent communication skills and the ability to interface with the executives and perform independently as well as team environments.
  • Resolving production issues for any scheduled jobs failures and reporting issues to the concerned teams.

TECHNICAL SKILLS:

ETL TOOL: Informatica 8.6, 9.1, 9.5.1, 9.6.1,10.1

DATABASES: Oracle 9i/10g/11g, SQL Server 2008, My SQL, Teradata

PROGRAMMING LANGUAGES: UNIX Shell Scripting, SQL

SCHEDULING TOOLS: Control M, AutoSys

ENVIRONMENT: Windows XP/2000, UNIX, LINUX/Perl

OTHER SOFTWARE: TOAD, Putty, WinSCP, SQL Developer, Tera data/BTEQ, HTML, Java Script

OTHER APPLICATION: HP Quality Center 9/10, Citrix, SOAP and REST Services

METHODOLOGIES: E-R Modeling, Star Schema, Snowflake Schema

PROFESSIONAL EXPERIENCE:

ETL/Informatica Developer

Confidential, Baltimore, MD

Responsibilities:

  • Requirement Gathering and Data Analysis of all supporting systems.
  • Designed Informatica mappings and data flows.
  • Understand Business Requirements and translate into Technical Specifications.
  • Developed Informatica processes to facilitate Daily, Weekly and monthly loading of data.
  • Maintained staging area between source and target, performed all cleansing operations, aggregations etc.
  • Extracted data from different source systems - Oracle, Teradata, DB2, My SQL, Flat Files and XML Files.
  • Developed ETL programs using Informatica Power center 9.6.1/9.5.1 to implement the business requirements.
  • Involved in enhancements and maintenance activities of the Enterprise Data Warehouse.
  • Communicated with business customers to discuss the issues and requirements.
  • Used most of the Transformations available in Informatica - Source Qualifier, Filter, Router, Lookup (Connected & Un Connected), Expression, Update Strategy, Transaction Control and Sequence Generator.
  • Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
  • Developed complex mappings using Lookup, SQL, Stored Procedure, and Filter while always striving to achieve the best performance.
  • Used Debugger wizard to troubleshoot data and error conditions.
  • Developed an ETL strategy to integrate disparate legacy sources to eliminate redundancy and create a single view of the Customer data for accurate business analysis.
  • Using Informatica Power Center created mappings, sessions and workflows to load data from multiple Source databases and flat files into target Oracle.
  • Used Parameters, Variables and Parameter Files for various Database Relational Connections to eliminate migration issues.
  • Extensively worked on all the transformations like Filter, SQL, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank, Union, Joiner, Source Qualifier, etc.,
  • Used different transformations for Extraction/Transformation, data cleansing and loading data into staging areas and Presentation Tables.
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
  • Has a very good knowledge of FACETS tool and Healthcare domain, Worked on the various modules like Subscriber/Member, Groups, Enrollment, Claims, Billing, Accounting, Provider, MTM and Utilization Management.
  • Good experience on FACETS CTP (Claims Test Pro) and FACETS Testing.
  • Translated business requirements into data warehouse design.
  • Developed and scheduled the Jobs using Autosys Scheduler.
  • Used UNIX Shell Scripts to automate daily and weekly runs and execute post session commands.
  • Created sessions and workflows for processing and to populate the dimensions and facts in the star schema.
  • Wrote and maintained numerous system utilities and web based applications with Perl.
  • Worked on Perl templates which delivered content to various sites for customers.
  • Worked with connected and unconnected look-up for implementing complex logic.
  • Designing ETL strategy for both Initial and Incremental & CDC Loads.
  • Worked extensively on SQL, PL/SQL and UNIX shell scripting.
  • Expertise in using Teradata Utilities BTEQ, M-Load, F-Load, TPT and F-Export in combination with Informatica for better Load in to Teradata Ware House.
  • Involved in the scrum discussions and agile methodology of development of the process of the project.
  • Developed unit test cases and ensured that the results are right before moving to QA and Production.
  • Worked with QA team on daily basis to follow up on the bugs and made sure the code is bug free before migrating to Production.
  • Worked on Ruby scripting language.
  • Developed and tested features in an Agile environment using Ruby.

Environment: Informatica Power Center 9.6.1/9.5.1 , Oracle 11g, PL/SQL, Teradata, UNIX, Shell Scripting, XML, Erwin r9.5.2/9.6, TOAD v12.0., AutoSys, BTEQ, Control M, FACETS, Perl, Ruby

ETL/Informatica Developer

Confidential

Responsibilities:

  • Worked with various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
  • Involved in the development of Informatica mappings and tuned for better performance.
  • Extensively used ETL to load data from flat files to Oracle.
  • Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
  • Adjusted in Data Model and SQL scripts to create and alter tables.
  • Worked extensively on SQL, PL/SQL and UNIX shell scripting.
  • Analyzed the source system of ETL Maps.
  • Designed and developed the fact/dimension entities.
  • Co-ordination with Client Business & Systems team for QA.
  • Performed the tuning of ETL SQLs, Designed ETL mapping based on Existing ETL logic.
  • Compared actual results to expected results and suggested changes to mappings owned by others.
  • Worked on new data model to form the single security master for all the Data Marts and retrofit the existing and new securities in the FACT tables.
  • Designed and developed IDQ mappings for address validation / cleansing, doctor master data matching, data conversion, exception handling, and report exception data.
  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
  • Used Type 1 and Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
  • Worked as a fully contributing team member with independent planning & execution responsibilities.

Environment: Informatica Power center 9.5/9.1, Netezza 7.1, Oracle 10g, SQL, PLSQL, Oracle SQL Developer, HP Quality center, MS Office, Oracle OBIEE 10g 10.1.3.4.1/11 g, and Linux.

Jr Informatica Developer

Confidential

Responsibilities:

  • Translated business requirements into data warehouse design.
  • Designed and maintained logical and physical enterprise data warehouse schemas using Erwin
  • Used Star Schema approach for designing of Data Warehouse.
  • Integrated different systems using Informatica server configuration. Extracted data from Flat files, Oracles Server, MS-Access and Loaded data into Oracle database using Informatica.
  • Created Source definitions, Target definitions, Mappings, Transformations, Reusable Transformations, mapplets using Informatica Designer tool which includes Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and mapplet Designer.
  • Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, and sequence generator, joiner Transformation.
  • Created sessions, database connections and batches, Scheduled and monitored transformation processes using Informatica Server Manager.
  • Used Informatica repository manager to backup and migrate metadata in development, test and production systems.

Environment: Informatica Power Center 9.5.1/9.1.1/8.6 , Business Objects, UNIX, SQL, PL/SQL, TOAD v11.6/ v12.0, Oracle 10g.

Hire Now