We provide IT Staff Augmentation Services!

Etl Developer Resume

San Ramon, CA

SUMMARY:

  • ETL Developer with more than 8 years of IT experience in Analysis, Design, Testing, Development and Implementation of client/server applications.
  • Strong experience in performing ETL operations like Data Extraction, Data Transformation and Data Loading with Informatica Power Center 10.1/9.6.1/9.1.0/9.0/8.6.0.
  • Worked intensively with Informatica Powercenter Designer. Strong knowledge on Source Analyzer, Warehouse designer, Transformation Developer, Mapplet Designer and Mapping Designer.
  • Extensively used Informatica Workflow manager and Workflow monitor for creating and monitoring workflows, worklets and sessions.
  • Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
  • Identified the Facts and Dimensions using Erwin Data modeling tool to represent the Star Schema Data Marts.
  • Experience with ODS (Operational Data Store) to integrate data from different heterogeneous data sources in order to facilitate operational reporting in real - time or near real-time.
  • Used ODS as data source frequently for the purpose data warehouse.
  • Extensively performed unit testing and system or integration testing.
  • Experience in testing/validating the Source, Stage and Target (End-to-End).
  • Experience in writing Test cases and Testing Scripts for validating data.
  • Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
  • Very strong in implementation of data profiling, creating score cards, Creating reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency.
  • Involved in Migration of mapping from IDQ to PowerCenter.
  • Extensive experience in Informatica Power Center to implement Data Marts which involved creating debugging and executing Informatica Mappings, Sessions, Tasks and Workflow.
  • Experience in databases like Oracle 12c/11g/10g/9i/, SQL Server, Netezza, TeraData.
  • Strong problem-solving skills, ability to develop strategies for clients and provide detailed documents to clients.
  • Experience working with oracle EBS applications like ERP and CRM.
  • Experience interacting with Oracle EBS analysts to understand business process and provide technical support.
  • Experience in creating databases, users, tables, triggers, views, stored procedures, functions, joins, hash indexes in Teradata database.
  • Loading of data from different source systems into Oracle and Teradata Target database.
  • Excellent analytical and SQL writing skills to address different business scenarios.
  • Experience with workload automation tools like Autosys, Tidal and Redwood.
  • Exposure to full project life cycle development for implementation and integration.
  • Hands on experience in Production Support and Maintenance by resolving issues to meet all Data Warehouse service Level agreements (SLAs).
  • Extensive Experience on Production Support.
  • Experienced in gathering of User requirements and responsible to provide efficient end-user training and designing report specifications.

TECHNICAL SKILLS:

Data Warehousing: Informatica PowerCenter 10.1/9.6.1/9.0/8.6.1/ , Power Connect for Mainframe/SAP/Peoplesoft/MQSeries/IBM MQ, Informatica IDQ, Trackwise, SQL*Loader, Flat Files (Fixed, CSV, Delimited, XML, COBOL)

Dimensional Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Database and related tools: Oracle 12c/11g/10g/9i, MS SQL Server 2000/7.0, DB2, TOAD 8.5.1/7.5., Netezza, Teradata

BI & Reporting Tools and Other Tools: Business Objects and OBIEE, Qlikmart, Tableau, Autosys, Redwood

Languages: C, SQL, PL/SQL, SQL*Plus, Working knowledge of Unix Shell Scripting, Python

Operating Systems: Microsoft XP/NT/2000, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

ETL Developer

Responsibilities:

  • Analyze user requirements, current operational procedures, and functional specifications to develop ETL procedures that are consistent across application and systems.
  • Implemented Perform tuning and optimization of SQL queries, using Explain Plan and tkprof.
  • Implemented and maintained multiple ETL processes to synchronize data between different source systems and database.
  • Develop and Implement comprehensive data integration process, standardize the presentation of information derived from multiple sub ledger transaction systems and develop data necessary.
  • Developed ETL code, control files, metadata, and lineage diagrams for ETL programs.
  • Reviewed and altered database programs to increase operating efficiency.
  • Extracted structured and unstructured data from source systems, transforming it to business needs.
  • Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager and Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets.
  • Coordinated with Data Architect in designing and developing re-usable components for ETL processes.
  • Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
  • Developed database code for the feature enhancement in CCAR project.
  • Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs and Used Shell Scripts which compares the incoming file with the existing file and creates a log file with differences and the changed values are loaded into the target.
  • Created detailed Unit Test Document with all possible Test cases/Scripts and involved in Unit, Integration, System and Performance testing levels.
  • Experience working with XLM files as source to stage the data and to generate XML files using Informatica.

Environment: Informatica Power Center 10.1/9 .6.1, Oracle 12c/11g, UNIX , Python, Tidal Automation Tool , WinSCP, Putty .

Confidential, San Leandro, CA

ETL Developer

Responsibilities:

  • Coordinate sessions with Business analyst for performing data analysis and gathering business requirements.
  • Developed technical specifications of the ETL process flow and created the high level and low level design documents.
  • Designed, developed and maintained Oracle database schemas, tables, standard views, materialized views, synonyms, indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors, and other database objects.
  • Created Informatica mappings using transformations like Source qualifier, Aggregator, Router, update strategy, XML and many more to migrate the OWB mapping and workflows to Informatica.
  • Developed Informatica mappings, sessions and workflows to populate the data into the dimension, fact, and lookup tables from different source systems (Oracle EBS, SQL Server, Flat files, Delimited files, XML files).
  • Experience in using XLM files as source to stage the data and also generate XML files using Informatica.
  • Developed PL/SQL packages, stored procedures, functions to extract the data from Oracle EBS and load it to the data warehouse.
  • Created PLSQL procedures using DBMS utilities to automate the process of enabling and disabling the indexes to improve the performance of data load.
  • Experience in writing complex SQL queries with sub-queries, analytical functions, scalar sub queries and inline views.
  • Extracting data from IBM MQ using XML parser transformation.
  • Parsing the X937 binary files to extract the check images and data.
  • Created Error handling mechanism to log the errors into centralized master and detail error log tables.
  • Involved in massive data profiling using IDQ Analyst and IDQ Developer prior to data staging.
  • Involved in Migration of mapping from IDQ to PowerCenter.
  • Developed Unix shell scripts to establish check rules for flat file sources before loading into the warehouse.
  • Created Unix shell scripts to automate the data load from flat files to target tables. This involved checking the data irregularities, calling the SQL loader and PLSQL packages, error handling, notification of failure/success.
  • Assisted SQA team in testing the code and identifying the bugs.
  • Used Autosys utility to schedule batch processing for both PLSQL and Informatica jobs and on call for supporting batch.
  • Experience in code check in and checkout in Version Control tool and changing the labels, version if necessary in Tortoise SVN Version Manager.
  • Performed UAT and provided on call and daily production support for Oracle, PL/SQL, ETL processes.

Environment: Informatica Power Center 10.1/ 9.6.1, Informatica IDQ, Oracle 12c/11g, PL/SQL, SQL Server, Toad, WinSCP, Putty, UNIX Scripting, Autosys Automation Tool .

Confidential, South San Francisco, CA

ETL Developer

Responsibilities:

  • Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across application and systems.
  • Used Meta Data Manager to gather data from different applications and flat files for users to do impact analysis of the changes in the source systems.
  • Unit testing and System Testing of Informatica mappings and Workflows.
  • Developed ETL code, control files, metadata, and lineage diagrams for ETL programs.
  • Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
  • Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject data.
  • Maintained Development, Test and Production mapping migration using Repository Manager.
  • Extensively performed unit testing and system or integration testing.
  • Generated UNIX Shell scripts for automated daily load processes.
  • Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence, Router, Update Strategy, Lookup transformations.
  • Developed and documented Informatica mappings and Informatica sessions as per the business requirement.
  • Created reusable sessions and executed them to load the data from the source system using Informatica Workflow Manager
  • Extracted client information data and history from Flat files, Oracle, SQL Server transformed and loaded into Oracle staging area.
  • Experience with ODS (Operational Data Store) to integrate data from different heterogeneous data sources in order to facilitate operational reporting in real-time or near real-time.
  • Exposure to TrackWise terminology & concepts, e.g., workflow, states, activities, and locking.
  • Experience with reviewing family tree of records, Data entry and updates in TrackWise.
  • Very strong in implementation of data profiling, creating score cards, Creating reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency.
  • Involved in Migration of mapping from IDQ to PowerCenter.
  • Wrote shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
  • Assisted SQA team in testing the code and identifying the bugs when needed.
  • Also assisted in dashboard SQA testing.
  • Scheduling Job chains using Redwood Automation tool.

Environment: Informatica Power Center 9.6.1, Oracle 11g, Oracle EBS, Informatica IDQ, SQL Server, DB2, Toad, UNIX Scripting, TrackWise , Tidal Automation Tool, Tableau .

Confidential, Beaverton, OR

ETL Developer

Responsibilities:

  • Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across application and systems.
  • Used Meta Data Manager to gather data from different applications and flat files for users to do impact analysis of the changes in the source systems.
  • Unit testing and System Testing of Informatica mappings and Workflows.
  • Developed ETL code, control files, metadata, and lineage diagrams for ETL programs.
  • Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
  • Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject data.
  • Maintained Development, Test and Production mapping migration using Repository Manager.
  • Extensively performed unit testing and system or integration testing.
  • Generated PL/SQL scripts and UNIX Shell scripts for automated daily load processes.
  • Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence, Router, Update Strategy, Lookup transformations.
  • Developed and documented Informatica mappings and Informatica sessions as per the business requirement.
  • Created reusable sessions and executed them to load the data from the source system using Informatica Workflow Manager.
  • Experience in creating databases, users, tables, triggers, views, stored procedures, functions, joins, hash indexes in Teradata database.
  • Extensively worked with BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
  • Loading of data from different source systems into Oracle and Teradata Target database.
  • Extracted client information data and history from Flat files, Oracle, SQL Server transformed and loaded into Oracle staging area.
  • Loading of data from different source systems into Oracle Target database.
  • Wrote shell scripts to work with flat files, to define parameter files and to create pre and post session commands.

Environment: Informatica Power Center 8.6.1/9.1.0, Oracle, DB2 UDB, UNIX , Teradata, Scripting KSH , Unix, Qlikmart .

Confidential

ETL Developer

Responsibilities:

  • Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all application and systems.
  • Documentation of technical specification, business requirements, functional specifications for the development of Informatica mappings to load data into various tables and defining ETL standards.
  • Worked on Informatica Power Center 8.1 tool - Source Analyzer, warehouse designer, Mapping Designer & Mapplets, and Transformations.
  • Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
  • Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject data.
  • Maintained Development, Test and Production mapping migration using Repository Manager.
  • Extensively performed unit testing and system or integration testing.
  • Generated PL/SQL scripts and UNIX Shell scripts for automated daily load processes.
  • Extensively worked in Oracle SQL Query performance tuning and created DDLs, database objects like Tables, Indexes and Sequences etc., by working closely with DBAs.
  • Developed several forms and reports in the process. Also converted several standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control.
  • Designed tables, indexes and constraints using TOAD and loaded data into the database using SQL*Loader.
  • Worked on OBIEE reports to do Enhancements.
  • Tuning of informatica jobs with oracle as backend database.

Environment: Informatica 8.6.1, Business Objects, Oracle, SQL*Plus, TOAD, UNIX, Windows XP, OBIEE.

Hire Now