We provide IT Staff Augmentation Services!

Etl Informatica Developer Resume

4.00/5 (Submit Your Rating)

Omaha, NE

SUMMARY:

  • Total of 8 Years of professional IT experience in Analysis, Design, Development, and implementation of various Data warehouse and software Applications.
  • Having extensive experience on Informatica Power Center with strong understanding and knowledge of Extraction, Transformation and Loading of Data from heterogeneous source system like Flat files, Excel, XML, Oracle, Teradata.
  • Developed Data Warehouse/Data Mart systems using various RDBMS (Oracle, MS - SQL Server, Teradata).
  • Extensively involved in ETL Datawarehousing using Informatica PowerCenter 7.x/8.x/9 Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor,(Mainframes & Teradata)
  • Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
  • Hands on experience in identifying and resolving performance bottlenecks in various levels like Sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse.
  • Very strong in SQL joins, Nested Queries, Unions, Multi-table joins.
  • Experience in migrating and integration SAP systems with SQL server (staging) and legacy (Mainframes) systems
  • Extensive experience inExtraction, Transformation and Loading(ETL) of data from multiple sources into Data warehouse usingInformatica.
  • Over 2yearsof Experience inDimensional Data Modeling usingStar and Snow Flake Schemausing Erwin7.1/4.5.
  • Experience inPerformance Tuningofsources, targets, mappingsand sessions.
  • Proficiency in data warehousing techniques forSlowly Changing dimension,Surrogate keyassignment andchange data capture.
  • Experience in integrationof variousrelationalandnon-relationalsourcessuch asOracle,SQL ServerTables,MQ Series,Flat files XMLs, .csv,Data Analysis and Modeling.
  • Proven experience and solid understanding of Data Warehousing, Decision Support Systems (DSS), Operational Data Store (ODS) and OLAP.
  • Experience in scheduling the batch jobs using workflow Control-M, Autosys and FTP methods.
  • Extensively worked with Informatica Mapping Variables, Mapping Parameters and Parameter Files.
  • Worked on Slowly Changing Dimensions - Type 1, Type 2 and Type 3 in different mappings as per the requirements.
  • Expertise in using SQL*Loader to load Data from external files to Oracle Database.
  • Experience in coding using SQL, SQL*Plus, PL/SQL, Procedures/Functions, Triggers and Packages.
  • Developed Batch jobs using UNIX shells scripts PMCMD commands, sftp commands to automate the process of loading, pushing and pulling data from different servers.
  • Excellent communication, leadership, interpersonal skills. Dedicated and Motivated in accepting various challenges imposed on me and showing enthusiasm in group work assigned to the team.

SKILLS:

ETL Tools: Informatica Power Center & 9.x.x/8.x.x, (Source Analyzer, Data Warehouse designer, Mapping Designer, Mapplet, TransformationsWorkflow Manager, Workflow Monitor, Work lets)

Database: Oracle 8i, 9i, 10g,11g, MS SQL Server 2005/2008/2012 ’ systems Mainframes, Teradata

Languages: SQL, PLSQL, Toad

OS: Windows XP/2003/2000/NT/7, UNIX

Data Modelling: Erwin Tool

Scheduling Tools: Autosys, Control-M

Project Management Tools: Microsoft Project, Microsoft Office, MS PowerPoint, MS Visio.

WORK EXPERIENCE:

Confidential, Omaha, NE

ETL Informatica Developer

Responsibilities:

  • Creating and Documenting the High level logical Designs by using the Business Requirements and converting them to ETL Technical specifications.
  • Used informatica as the ETL for extracting data from the flat files, Relational databases and transforming the data according to the target database and perform loading.
  • Worked on creating the Process Flows for each and every layer from staging the data to loading it into EDW.
  • Implemented the Pushdown Optimization strategy to balance the load across the Informatica Repository Server and Database Engine.
  • Created mappings using various transformations like source qualifier transformation, expression transformation, aggregator transformation, filter, lookup transformation, sorter transformation, joiner transformation, and Update strategy.
  • Tuned Performance in informatica mappings/sessions and the bottle necks are removed timely.
  • Tuned the SQL queries by partitioning the tables for Performance.
  • Worked on SQL tools like Teradata SQL to run SQL Queries and validate the data.
  • Schedule Informatica Jobs through Control Monitor scheduling tool.
  • Worked with the Architecture teams to create the Informatica and UNIX Profiling.
  • Worked on Creating the Shell Scripts for informatica jobs and respective process executions.
  • Participated in the team code reviews from time to time and ensured the code meet the Business Requirements.
  • Coordinating with the QA team to ensure that the test case scenarios are met by the design/development standards.
  • Worked on Data Profiling, analyzed all the Source Tables and respective fields, documenting data for validation, completeness and accuracy.
  • Worked on Creating and Documented the Data Quality Assessment and Strategies for the source data.
  • Prepared all documents necessary for knowledge transfer and project migration such as ETL strategy, Installed Documents, ETL processes etc.
  • Assisted the Information Delivery team (Reporting) with the required data for design and development of Reporting System using Business Objects.
  • Worked on various projects simultaneously and met the targeted timelines efficiently.

Environment: Informatica Power Center 9.5.1 & 9.6.1, Teradata 14.01, MS SQL Server, Flat files, UNIX, Windows 7, Control Monitor Job Scheduler.

Confidential, Denver, CO

Jr. ETL Informatica Developer

Responsibilities:

  • work closely with Lead systems analyst to identify system requirements and changes as and when they happen.
  • Co-ordinate with Business users to understand the product and bring to table novel methods to implement business requirements.
  • Interacted with various technical people and gathered the business requirements and translated them into technical specifications for Developers.
  • Documented business requirements/ Functional requirements and discussed issues to be resolved and translated user input into ETL design documents.
  • Work with data analysts to implement Informatica mappings and workflows to meet business requirements.
  • Involved in ETL process at development environment.
  • Creating PL/SQL stored procedures & triggers in the database.
  • Extracted data from various sources like Oracle and flat files and loaded into the target Oracle 10 g database.
  • Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Router, Sorter, Expression and Update Strategy.
  • Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages.
  • Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
  • Created and Executed workflows and Worklets using Workflow Manager to load the data into the Target Database.
  • Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
  • Extensively participated in System/Integration. Developed Session Parameter files for the workflows.
  • Worked extensively on the Oracle database for data extraction, cleaning and reporting for healthcare provider projects.

Environment: Informatica Power Center 9.0.1, Oracle 11g, MS-SQL server, and other legacy systems, TOAD, HP Quality Center, Autosys, MS Office Suite

Confidential, Boston, MA

ETL Informatica Developer

Responsibilities:

  • Worked with business analysts to identify appropriate sources for data warehouse and prepared the functional and technical designs, test cases, and user guides.
  • Helped in developing Star Schema by following referential integrities among Facts and Dimensions.
  • Implemented slowly changing and rapidly changing dimension methodologies; created aggregate fact tables for the creation of ad-hoc reports.
  • Created and maintained surrogate keys on the master tables to handle SCD type 2 changes effectively.
  • Mentored Informatica developers on project for development, implementation, performance tuning of mappings and code reviews.
  • Developed Informatica jobs and automated data loads using UNIX shell scripts.
  • Involved in debugging mappings, recovering sessions and developing error-handling methods.

Environment: Informatica Power Center 8.6, DB2, Oracle 10g, TOAD 9.x, Shell Scripting, Oracle SQL *Loader, PL/SQL, UNIX, Windows-XP, Visio, Autosys.

Confidential, Piscataway, NJ

Informatica Developer

Responsibilities:

  • Study the existing system to identify the issues and problems facing business users.
  • Worked on Informatica client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
  • Identified all the dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
  • Analyzed and Created Facts and Dimension Tables in the Star-Schema.
  • Extracted data from flat files and oracle database, applied business logic to load them into the Customer Data Warehouse (CDW).
  • Developed the Informatica Mappings, Mapplets, Sessions and Workflows to populate the Customer Data Warehouse (CDW) tables.
  • Created mappings using fact and dimensional tables from Data modeling
  • Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
  • Performed the uploading and downloading of flat files from UNIX server.
  • Tuned performance of Informatica sessions for large data files by implementing pipeline partitioning and increasing block size, data cache size, sequence buffer length and target based commit interval and resolved bottlenecks.
  • Installed Informatica Client tools on client machines and Created Repository as well as assigned permissions for user groups.
  • Created ETL process to generate XML files from oracle tables using Informatica
  • Extensively worked with XML files as the Source and Target, used transformations like XML Generator and XML Parser to transform XML files
  • Converted the old PL/SQL Procedures to Informatica mappings.
  • Tune the SQL Queries for Performance Issues.
  • Scheduled the Jobs fit in the available time window.

Environment: Informatica Power Center 8.1, Oracle 10g, UNIX, SQL Server 2008, Flat files (Sources), XML (Source), TOAD (Query Tool), and PL/SQL.

Confidential, Fairfield, CT

Informatica Developer

Responsibilities:

  • Designed and created required mappings for consistency check to compare like data elements across the files to assure the consistency of data.
  • Interacted with business analysts to understand the business requirements, needs and the data flow.
  • Created the target table structures across the oracle database according to the requirements for respective mappings.
  • Extracted the data from fixed width flat files and oracle database, applied business logic and loaded them into respective targets.
  • Worked extensively across fixed width flat files, handled the null records, exceptional records, space records and gained hands on with data level accuracy.
  • Created mappings using various transformations like source qualifier, expression, filter, router, update strategy, lookup, aggregator and sequence generator.
  • Generated and routed the data into various target definitions which consists of delimited flat files and table records.
  • Used various functions like round, replace and diff kinds of date functions to compare the data elements across the feeds for consistency.
  • Created flexible mappings/sessions using parameters and used SQL queries in the workflow level respectively.
  • Created tasks and workflows in the workflow manager and monitored the session properties in the work flow monitor.

Environment: Informatica Power Center 8.1.1, Oracle 10g, SQL Server 2005, Windows XP, UNIX, SQL Developer, SQL, PL/SQL, Oracle SQL *Loader, QTP.

We'd love your feedback!