We provide IT Staff Augmentation Services!

Sr.etl Developer Resume

2.00 Rating

Indianapolis, IN

SUMMARY

  • A Certified Power Center developer and Professional wif 8+ years of experience in software design and development, and Project Implementation in the area of ETL Development using Informatica.
  • Expertise in using Informatica Power Center 8.5.0/8.6/9.1.0/9.5/9.6, SQL, UNIX, Shell scripting.
  • Having good experience in DWH Technologies like Metadata Management, Dimensional Modeling, Star Schema data modeling, and Snow flaking.
  • Extensive experience in developing ETL processes to Extract, Transform and Load data from various sources like Oracle, Teradata, Netezza, XML Files, FLAT files, EXCEL sheets and Archive systems into Data Warehouses.
  • Worked wif all the Transformations like Lookup, Aggregator, Mapplets Expression, Filter, Update Strategy, stored procedure, Sequence Generator, Sorter, Rank and Router.
  • Implemented slowly changing dimensions Type2, Type1 and Type3.
  • Yielding hand at using of Stored Procedures wif huge varieties of PL/SQL Programs.
  • Expertise in SQL and PL/SQL program developing and expertise at complex Code units, Database Triggers, views, Sequences, Functions, Packages, Procedures and using the latestfeatures to optimize Performance.
  • Performance Tuning of SQL and PL/SQL code using techniques like Bulk Collection, Merge Statement, inline Views, parallelization, using Hints etc.
  • Designed Mappings using B2B Data Transformation Studio.
  • Used Data Transformation Studio to transform unstructured data to structured forms
  • Used major components like Serializers, Parsers, and Streamers in Data Transformation Studio for Conversion of EXCEL sheets, XML files to other formats.
  • Extreme experience wif Tasks like Event Wait, Event Raise, Assignment, Decision, Command, Timer Tasks etc.
  • Expertise in Error Handling Strategies, Trouble Shooting, Unit Testing and system testing, QA and Writing Technical Specification Documents and designing test cases.
  • Expertise in data Migration among different databases and also extensively worked wif Oracle, Paradox, ParAccel, Netezza, DB2, My SQL and Vertica databases.
  • Highly Expertise in writing UNIX scripting and also having Hands on experience wif both LINUX environment and Windows.
  • Having fine experience wif Teradata and Teradata utilities like BTEQ, FLOAD, and MLOAD.
  • Good experience of Job scheduling tools like Autosys, Control - M, and Tidal.
  • Worked wif Informatica Data Quality (IDQ) toolset, and responsible for IDQ development around data profiling, Cleansing, Parsing, Standardization, Validation, Matching and Data quality exception monitoring and handling.
  • Having good noledge of MDM Informatica and MDM Hub configurations-Data modeling & Data Mappings (Landing, Staging and Base Objects), Data validation, Match and Merge rules, writing and customizing user exits.
  • Experienced wif Informatica Power Exchanger and Extracted, merged various kinds of data, and wide range of data using Power exchange connectors.
  • Having strong experience in full life cycle development of Data Warehousing Project. Hands on experience wif both AGILE and SCRUM methods and Ability to work in teams wif flexibility.

TECHNICAL SKILLS

Database: Oracle 9i,10g,11g, Paradox, Teradata, Netezza, Db2, MySQL, etc.

ETL Tools: Informatica 8.5.0/8.6/9.1.0/9.5/9.6, IDQ, B2B and MDM.

Operating System: Windows XP, Linux, Windows NT, Unix Scripting.

Languages/Utilities: SQL, PL-SQL, BTEQ, Fastload, Multiload, C, C++, XML.

Reporting Layer: SAP BO.

Supporting Tools: SQL*Plus, SQL*Loader, TOAD, PLSQL Developer, iSetups, little noledge on Report Builder (6i, 2.5), Forms Builder 6i.

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Sr.ETL Developer

Responsibilities:

  • Understanding the business requirements and analyzing the Data.
  • Extracting the source data from various databases like Oracle, DB2 and also from XML files, and Flat files by Using Informatica power center client.
  • Handling the client calls, status meetings etc.
  • By using Informatica Designer to develop process for extraction, transformation and loading into database Warehousing.
  • Created UNIX shell scripts for Informatica Mapping run, FTP, archival etc.
  • As per various requirements we are using multiple transformations like Expression, Source Qualifier, Filter, Router, Sorter, Lookup, Joiner, Aggregator etc.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Worked wif deployment team for migration process.
  • Prepared migration document to move the mappings from development to testing and tan to production Repositories.
  • Created Mapplets for reusability of similar logic multiple times in the mapping.
  • Created parameters and variables for extraction of data.
  • Created various tasks like Session, Email, Event Wait, Command Task etc.
  • Involved in unit testing and prepared test result document.
  • Design the Autosys jobs and schedule the data load strategy.
  • Analyzed defects raised by users and fixed them.

Environment: Informatica 9.5 & 9.6, B2B, Oracle11g, Paradox, Netezza, DB2, Teradata, UNIX.

Confidential, Malvern, PA

Sr. ETL Developer/Data analyst

Responsibilities:

  • Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB Triggers, and Indexes.
  • Worked wif BA teams to finalize the requirements.
  • Developed SQL*loader scripts to load data in the custom tables and also Created Materialized views & normal Views where business requirements are needed.
  • Used Parameter Files to define values for parameters and variables used in mappings.
  • Created High level & low level design for the ETL process.
  • Fine tuning the PL/SQL code for performance and ETL code for performance gain.
  • Involved in creating test cases.
  • Mappings were designed using different transformations to cater the slowly changing dimensions.
  • Developed several reusable transformations and Mapplet that were used in other mappings
  • Responsible for data analysis, data cleansing, data matching, exception handling, and reporting and monitoring Capabilities of IDQ.
  • Evaluated various technologies to employ data quality solutions.
  • Involved in translating the ETL requirements into physical design.
  • Chalk out extensive error handling and reporting strategy.
  • Created shell scripts to preprocess the source provided data files.

Environment: Informatica 9.6, IDQ Toolkit, Oracle 10g, Netezza, XML, Teradata, Linux.

Confidential, Bridgeport, CT

Sr. ETL Developer

Responsibilities:

  • Implemented ETL solution using Informatica.
  • Analyzing Source System data and preparing low-level documentation.
  • Worked wif Informatica - Source Analyzer, Target Designer, Warehouse Designer, Mapping Designer, Mapplet, Transformations, and workflow manger.
  • Developed data Mappings between source systems and warehouse components by Mapping Designer through using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, Joiner, Aggregate transformation and expression as per the business requirements.
  • Worked on the development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports.
  • Created Mapplets for reusable business process and extensively used ETL to load data from Oracle and Flat files to Data Warehouse.
  • Used Pre and Post Session SQL statements to drop and recreate the indexes.
  • Prepared UNIX Shell Scripts and these shell scripts were scheduled in AUTOSYS for automatic execution at the Specific timings
  • Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the Mapping of the failed sessions

Environment: Oracle 9i, Paradox, Informatica 9.1, UNIX.

Confidential, Deerfield, IL

ETL Developer

Responsibilities:

  • Analysis of existing Source System, Business Flow & Target System using given Functional Document.
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Designed the Mappings according to the Mapping Design Document.
  • Developed ETL mappings, transformations using Informatica Power Center.
  • Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression.
  • Mappings were designed to cater the slowly changing dimensions.
  • Developed mapping parameters and variables to support SQL override.
  • Created UNIX shell scripts to customize the server scheduling jobs.
  • Involved into source code review, the mappings created by my team members.
  • Involved in migration of Informatica power center 8.6 to 9.0.
  • Created directory structures wif back up of 8.6 repository and imported to 9.5 version as a part of version Upgrade.
  • Involved in creating test cases.
  • Developed several reusable transformations and Mapplets that were used in other mappings.

Environment: Informatica 8.6 and 9.0, XML, Oracle 9i, Oracle 10g, UNIX.

Confidential, Houston, TX

ETL Developer

Responsibilities:

  • Understanding the business functionality & Analysis of business requirements.
  • Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
  • Used PL/SQL to validate data and to populate billing tables.
  • Involved in source data profiling.
  • Extensively worked in data Extraction, Transformation and Loading from source target system using BTEQ, FASTLOAD and MULTILOAD.
  • Used Power center client to develop processes for extracting, transforming and loading data into Data Warehouse Database.
  • Extensively worked wif XML files as the Source and Target, used transformations like XML Generator and XML Parser to transform XML files, used Oracle XML type data type to store XML files.
  • Developed various transformations using lookup, sorter, and aggregator as per requirements.
  • Involved in creating Design Documentation to describe program development.
  • Defined and worked wif mapping parameters and created Mapplets.
  • Did performance tuning to improve Data Extraction, Data process and load time.
  • Prepared the Test case Document and captured the test results.
  • Involved in deployment activities to deploy the code from one environment to another environment.

Environment: Informatica 9.0, Oracle 9i, UNIX.

Confidential

Jr.ETL Developer and Data analyst

Responsibilities:

  • Understanding the Business requirement document (BRD) and Data mapping document (DMD) completely and Implemented data transformation methodologies.
  • Loading CSV, fixed length files (TP) data to ETL tables using Informatica.
  • Using Data mapping document, Implements Business logic to ETL tables.
  • Extracting, Transforming and Loading the data from Source to ETL tables and UDS, UDB tables.
  • Developed Informatica mappings to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy and Router transformations.
  • Involved in preparation of Technical Design Documents (TDD).
  • Scheduled job using Workflow Scheduler.

Environment: Informatica 8.5 and 8.6, SAP BO Oracle 9i, Windows NT.

We'd love your feedback!