We provide IT Staff Augmentation Services!

Etl Developer Resume

Portland, OR

SUMMARY:

  • 8 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions.
  • Experience in Data Warehousing tools including Informatica for extraction, transformation and loading (ETL) of data from multiple sources.
  • Well versed with Data Warehousing Architecture on the Design, Development, Extraction, Transformation and Loading of data using Informatica Power Center 9.1/9.5/9.6 as an ETL tool.
  • Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, FACT and Dimension tables, Physical and logical data modeling using Erwin.
  • Used Big Data Edition to integrate with Hadoop Distributed File Systems.
  • Hands on experience in developing Business Objects out of the ERPs like SAP R/3, SAP BW/BI Tables and Programs.
  • Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable
  • Having excellent knowledge on Data Warehousing and BI concepts.
  • Extensive experience in design and creating data warehouse, data marts using Informatica Power Center.
  • Experience in Data Warehouse development working with Extraction/Transformation/Loading using Informatica Power Center with Oracle, DB2, Sql Server, SalesForce(SFDC) & Teradata.
  • Strong knowledge in RDBMS Concepts, Dimensional Data Modeling (Star Schema, Snow - flake Schema, FACT and Dimension tables), Logical, Physical Data Modeling and XML files.
  • Involved in the Software Development Life Cycle (SDLC) with Analysis, Design, Development, Testing, Deployment and Maintenance.
  • Worked on the latest version of SAP Business Objects Enterprise (Information Design Tool, Dashboard Designer, Web Intelligence, Crystal Reports Enterprise, Explorer) on Business Objects BI Platform 4.0.
  • Experience with migration of data and upgrading to newer versions of Informatica.
  • Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump) and Teradata parallel support
  • Implemented Real time CDC for DB2, Oracle databases in Informatica Power Exchange. Developed Real-Time Prototype scenario using Informatica Power Center and Power Exchange.
  • Involved in handling tickets, monitoring, troubleshooting and maintenance for Day to day Activities.
  • Understand the business rules completely based on High Level documents specifications and implements the data transformation methodologies.
  • Deployed workflows as an application to run them and tuned the mappings for better performance.
  • Extensive experience working on Reporting tools - Micro strategy, Crystal reporting, Cognos and Tableau.
  • Installed and configured Power Center 9.0.1 and 9.5 on UNIX and LINUX platforms.
  • Developed Power Exchange data maps and used CDC techniques to capture the changed data that were used to pull the data from files on the Mainframe /VSAM files.
  • Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators, Stored Procedures and Normalizes.
  • Worked in configuration management/versioning to migrate updated mappings, sessions and workflows in XML form to rational clear case environment and promote the code from one environment to other.
  • Expertise in RDBMS, database Normalization and Denormalization concepts and principles
  • Created landing, base and staging tables according to the data model and number of source systems.
  • Worked on end-to-end implementation of automated data integrity profiling, monitoring and reporting tool.
  • Advanced experience using Informatica power center version 9.6 and used critical transformations such as transaction control, Java transformation and XML Generator.
  • Experienced on writing SQL, MySQL queries to extract data from various source tables to perform database testing.
  • Knowledge in back end testing and writing SQL queries and Joins using Oracle, MySQL
  • Experience with major databases including Netezza, Teradata, Oracle, DB2 and SQL Server.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i, SQL Server 2012/2010/2008 R2/2008 MS Access 9.0/7.0, Teradata 12/13, My SQL.

ETL Tools: Informatica 9.6.1/9.5.1/9.5/9.1 products (Power Center)

BI/OLAP Tools: Cognos 10, Tableau, SAP Business Objects 4.1, Xi3.1, Xir2, UDT

Operating Systems: Window 9X/NT/2K/XP, UNIX, Linux.

Data Modeling: Logical/Physical Data Modeling, IBM Rational Rose, Microsoft Visio 2004, 2007, 2010.

Programming Languages: SQL, PL/SQL, C, C++, VB.NET, C#.

Process: Data Profiling, Data Quality, Data Services, Change-Data-Capture (CDC), Push Down Optimization (PDO).

Schedulers: Control M, Autosys.

Other Tools: Toad, Oracle SQL Developer, Embarcadero Rapid SQL, Putty, MS Project Planner, Citrix Environments.

PROFESSIONAL EXPERIENCE:

Confidential, Portland, OR

ETL Developer

Responsibilities:

  • Evaluate and prioritize business requirements and determine cost effective solutions that meet business goals while maintaining best practices of software design.
  • Created new mappings, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
  • Developed various transformations like expression, aggregator, joiner, source qualifier, router, lookup, update strategy, sequence generator, Union, Stored procedure and filter.
  • Used Debugger to test the mappings and fix the bugs developing sessions and workflows to loading data from source to target tables.
  • Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
  • Created Universes for report generation using SAP BOBI 4.0 Information Design Tool module Design, build and publish a set of webi reports and SAP BOBI 4.0 dashboard with interactive analytical capabilities
  • Extract data from SAP BW/BexQuery for SAP BOBI 4.1 multi source Universe/IDT.
  • Extract, Transformed and Load data from multiple data sources by SAP Data Service 4.0 ETL Tool
  • Developed Tableau visualizations and dashboards using Tableau Desktop.
  • Extensively worked on building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Worked on Java based application (ICAS). As part of support team deployed patches timely and also handles JVM setup and operations.
  • Good Understating SOAP UI calls and XML.
  • Created shell scripts for Data Validations, converting excel to csv.
  • Understanding business requirements and the design.
  • Worked on Upgrading process from Informatica 9.1 to Informatica 9.6
  • Used stored procedures, functions to check any changes in data from ETL and update all the relevant tables, to improve the efficiency.
  • Used Debugger to test the mappings and fix the bugs developing sessions and workflows to loading data from source to target tables.
  • Significant experience & demonstrated proficiency in all aspects of database programming on T SQL and Oracle SQL/PLSQL and/or related technologies that encapsulate SQL, including Cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Table Indexing.

Environment: Informatica Power Center 9.5/ IDR/ IDQ, Teradata 14.10, Netezza, Hadoop, Unix/ Linux, Scheduling tools Maestro & ESP.

Confidential, Dallas, TX

ETL Developer

Responsibilities:

  • Referenced Functional Specification documents to understand the functional requirements to prepare the Technical Design documents
  • Analyzed project requirements and participated to prepare the project plan at the task level
  • Compared DB2 and Teradata databases properties/ metrics/ features to migrate DB2 warehouse to Teradata warehouse
  • Worked closely on Infrastructure upgrades (Informatica, Teradata)
  • Involved in meetings with key stakeholders of the business and discussed on strategies and roadmaps for Informatica Power Center Grid implementation.
  • Prepared design documents as per the analysis of DB2 stored procedures
  • Created the Teradata Set/ Multiset tables as per the data model/ requirements specifications
  • Developed complex mappings to convert DB2 stored procedures into ETL mappings using Informatica Power Center to load data into Teradata
  • Implemented Real time CDC for DB2 in Informatica.
  • Developed Real-Time Advanced Prototype scenario using Informatica PowerCenter and PowerExchange for complex CDC requirements like filter on source.
  • Tested and implemented appropriate Teradata loader utilities as per the load volume/ job requirements for better performance
  • Designed delta or Incremental load process for all the ETL jobs
  • Developed the error Logic for streamlining, automating the data loads for cleansing incorrect data and developed Auditing mechanism to maintain the load statistics of transactional records
  • Worked on performance Tuning of the mappings to handle increasing data volume
  • Design and review documents including Software Requirement Specifications to ensure all the requirements are covered
  • Creation of Unit Test Cases (UTC’s), Unit Test Scripts and captured unit test results
  • Involved in ETL, Unix and DDL’s code migration from one environment to other
  • Reviewed complex mappings using multiple transformations, sessions, workflows in Informatica and lead the ETL team

Environment: Informatica Power Center 9.1, Power Exchange 9.1, Teradata 13.10, DB2 8.1, Sybase and UNIX.

Client: Hitachi, New York, NY JAN'14 - SEP'15

ETL consultant

Responsibilities:

  • Created new mappings, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
  • Used Informatica power center 9.6.1 to Extract, Transform and Load data into Microsoft SQL Data Warehouse from various sources like JD Edwards and ERP data.
  • Worked on Upgrading process from Informatica 9.1 to Informatica 9.6
  • Developed various transformations like expression, aggregator, joiner, source qualifier, router, lookup, update strategy, sequence generator, Union, Stored procedure and filter.
  • Used stored procedures, functions to check any changes in data from ETL and update all the relevant tables, to improve the efficiency.
  • Worked with different sources such as ERP data, JDE (AS400), Excel Sheets and Flat Files.
  • Used Debugger to test the mappings and fix the bugs developing sessions and workflows to loading data from source to target tables.
  • Worked with different sources such as ERP data, JDE (AS400), Excel Sheets and Flat Files.
  • Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
  • Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
  • Was responsible for all the ETL work - Upgrading and installing Informatica tool.
  • Worked on Micro strategy reporting tool - Scheduling and running cubes
  • Point of Contact for the all the ETL Processes involved in Business Intelligence team.

Confidential

ETL Developer

Responsibilities:

  • Understanding business requirements and the design
  • Automated the jobs thru ESP scheduling tool using Change Man control, which runs every day by maintaining the data validations.
  • Created new mappings, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
  • Developed various transformations like expression, aggregator, joiner, source qualifier, router, lookup, update strategy, sequence generator, Union, Stored procedure and filter.
  • Worked on UNIX shell scripting.
  • Significant experience & demonstrated proficiency in all aspects of database programming on Oracle SQL/PLSQL and/or related technologies that encapsulate SQL, including Cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Table Indexing.
  • Used Oracle PL/SQL stored procedures to check any changes in data from ETL and update all the relevant oracle tables, to improve the efficiency.
  • Worked with different sources such as Oracle, Teradata, and flat files.
  • Used Debugger to test the mappings and fix the bugs developing sessions and workflows to loading data from source to target tables.
  • Good understanding in financial concepts likes Investment planning and risk involved in it.
  • Involved in analysis of different Risks in Capital Market.
  • Involved in data modeling and design
  • Worked on Bteq’s for one of the projects to handle performance.
  • Involved in the conversion from Maestro to ESP scheduler.
  • Involved in on call support rotation and handling incidents and tickets.

Confidential

Business Analyst

Responsibilities:

  • Selecting a particular base state, the requirements were documented in story cards as ‘delta’ changes. These changes could either be positive or negative.
  • The front end of the Agency system moved from green screens to a new GUI
  • Design the architecture for the management of the requirements in Rational Requisite Pro. This architecture later served as the base for all the upcoming state roll outs.
  • Engineer a process for handling regulatory changes in the requirements management tool. Through this process, the tool must reflect the changes brought about by the regulatory changes and also maintain a version of the previous requirements.
  • Rules extraction and rules management through Rational Requisite Pro.
  • Analyze requirements, develop User Stories / Use-Case diagrams, Activity/ Class Diagrams and Conceptual flow diagrams using Unified Modeling Language (UML) Techniques & Microsoft Visio
  • Script Business Requirement Documents (BRDs), Functional Requirement Document (FRD), Systems Requirements Specification (SRS) Technical Requirement Documents (TRD’s)
  • Worked with QA Team in drafting Test Cases, Test Plans, User Acceptance Testing (UAT) to ensure software meets system/business requirements
  • Subject matter expert on several work streams to provide technical perspective to role management and provisioning enhancements plans.
  • Evaluated client delivered requirements and built test cases to demonstrate functionality outlined in requirements.
  • Led technical presentation and demo to key stakeholders and creating highly-detailed Use Cases for identity management.

Environment: Java IBM db2, Oracle, UNIX, Control M Scheduling tool

Hire Now