We provide IT Staff Augmentation Services!

Etl Developer & Data Analyst / Data Integration Resume

Waltham, MA

SUMMARY

  • Over 9 years of experience Data Analysis, Design, Development of various business applications in different platforms in DW/BI, Integration and Data Migration with a sound knowledge of Retail Industry, Education and Communication domains.
  • Have worked Sr.Developer on multiple skills such as Informatica (8.x and 9.x), SSIS, Talend Open Studio, Pentaho Data Integrator, Cognos BI Tool (10.2), Tableau & Power BI Business Intelligence and Analytics Tools, Autosys, UNIX, PL/SQL, Oracle 10g/11g, MySQL, MSSQL Server.
  • Experience in report generation and data analysis with different sources using Microsoft excel, Pivots, Tableau.
  • Analyzed the dashboard and reporting options on Power BI & Tableau in comparison with ANVIZENT tool to assist with a decision on a selection of appropriate dashboard tool for the client.
  • Extensive professional Information Technology experience with expertise in the field of Enterprise Data Warehousing, Data Integration, and Data/Code Migration.
  • Extensive exposure to Business Intelligence projects with experience in building Enterprise Data Warehouse, Data Marts, and Operational Data Stores.
  • Expertise in design and development of mappings to handle all types of slowly changing dimensions SCD type 1, type2 and type3.
  • Involved in different phases of Data Warehouse Life Cycle including business reporting requirements gathering, source system analysis, logical/physical data modeling, ETL design/development, project deployment, production support.
  • Involved in designing the bottlenecks at the mapping level and, session level.
  • Involved in development of Power Exchange source for CDC process.
  • Involved in developing the system test cases for system testing.
  • Extensive Expertise with error handling and Batch processing.
  • Database experience of Oracle 11g/10g/9i, SQL Server.
  • Extensive experience in Performance tuning of sources, targets, mappings, sessions and SQL queries.
  • Good Experience in using Informatica Power Center ETL tool v 8.6.1/9.1.1 , Informatica Power Exchange 8 with industry best practices & knowledge in Reporting tools like Tableau & Power BI
  • Solid understanding of Ralph Kimball & Bill Inmon’s Methodologies.
  • Experience in dimensional modeling (Star Schema & Snow Flake Schema).
  • Good Knowledge of UNIX (Solaris) systems and Scheduling tools like AUTOSYS
  • Good knowledge of Oracle RDBMS v10g/9i/8i with proficiency in writing SQL queries and PL/SQL procedures.
  • Extensive experience in Shell scripting.
  • Familiar with Informatica IDQ Concepts, knowledge on Teradata, Big Data, and Hadoop.
  • Expertise in performing Unit Testing, Integration Testing and Regression Testing.
  • Knowledge with TOAD, SQL Developer and SQL Navigator, Teradata utilities (SQL, BTEQ, Fast Load, Multi Load, Tpump), SQL Server Management to test, modify and analyze data, create indexes, and compare data from different schemas.
  • Excellent communication and interpersonal skills, very good team player and self - starter with the ability to work independently and as part of a team, strong effort, time management, good analytical reasoning and high adaptability to new technologies and tools.

TECHNICAL SKILLS

ETL/Data Integration Tools: Informatica Power Center 9.5.1/9.1/8.6.1 , Informatic IDQ 9.X, Talend Open Studio, Pentaho Data Integrator

RDBMS: Oracle 11g/10g/9i, Teradata, SQL Server, MySql

Tools: SQL*Plus, TOAD, PL/SQL Developer, Autosys

Business Intelligence & Analytical Tools: Cognos BI Tool(10.2),Tableau, Power BI

Operating Systems: Windows, UNIX, LINUX.

Other Skills: C Language, BigData and Hadoop 2.2, Predictive Analytics like (What-If-Analysis, Goal Seek, Data Table), Microsoft tools like Word, Power Point, Excel and Microsoft Excel Macros.

PROFESSIONAL EXPERIENCE

Confidential, Waltham, MA

ETL Developer & Data Analyst / Data Integration

Responsibilities:

  • Worked with client and Developed Load Strategy for loading HUB (staging area) and then DWH tables from the source repository.
  • Analysed and interprets the existing Stored Procedures, Materialized Views, Functions, and views from legacy system.
  • Design, build, or enhance Informatica mappings, according to standards, in support of requirements provided by the project by using Informatica Power Center.
  • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment Performed low-level data analysis, cleansing activities
  • Performed data profiling, cleansening activities by using Informatica Power Center.
  • Interacted with Business Analysts, some end users to understand the specific use cases
  • Interacted with BA team and Involved in detailed designed documents preparation.
  • Perform data analysis and build data transformation & data mapping documents.
  • Lead discussions / facilitate JAD sessions with technical developers, data modelers, and business SMEs to provide solution.
  • Involved in Data Extraction from Oracle SQL Loader Designed and developed mappings using Informatica Power Center.
  • Building Informatica Workflows and Worklets using Informatica client Tools. Developed Mapping using transformation like Aggregator, Update Strategy, Lookups, Source Qualifier, Joiner, Union, Expression Source/Target Definitions and complex SQL Queries
  • Extensively used Transformations like Source Qualifier, Expression, Filter, Aggregator, joiner, and lookup, Sequence Generator, Router, Sorter and Stored Procedures, Used debugger to test the mappings and unit tested mappings in Informatica Power Center.
  • Performance tuning of the mappings as well as the tuning of SQL queries for better performance at Informatica Power Center level and Database level.
  • Worked on preparing test cases for component testing, Supporting Testing Team.Prepared the transformation matrix for future reference. Preparing Unit Test cases for Unit Testing and assisted with QA team and UAT team for providing development support.
  • During the UAT, interacted directly with business stakeholders, provided clarifications for their questions on the data and use cases
  • Assisted UAT team and QA team in coming up with validation scripts to perform the validations as expected to cover all scenarios
  • Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for developed Informatica Mappings.
  • Worked as business analyst to analyze and compared features analysis between BI tools like Tableau, Qlickview, Sisense and Microsoft Power BI.
  • Involved in feature wise testing and compatibility of different BI tools for heterogeneous Tools.
  • Analysed and interprets the existing Stored Procedures, Materialized Views, Functions, and views.
  • Technologies Involved: Informatica Power Centre 9.6, Oracle 11g, PL/SQL Developer, Unix

Confidential, Atlanta, GA

ETL Developer / Data Migration

Responsibilities:

  • Understanding Functional view from the Onshore Technical Architects.
  • Performed low-level data analysis, cleansing activities
  • Performed data profiling activities
  • Interacted with Business Analysts, some end users to understand the specific use cases
  • Preparing the Technical Documents which includes (Technical and detail).
  • Working Closely with Technical Architects on the functional requirement gathering.
  • Assign task to team members with in module and coordinate with them complete assign task.
  • Monitor team member’s performance and helps them when they needed.
  • Works on Unix scripts which would trigger the jobs based on dependencies.
  • Responsible for Coding/Development.
  • Working on Informatica Workflow and mapping development and also database development.
  • Working on the scheduling of the jobs, this would execute jobs based on dependencies, which saved many hours for Technical Architects.
  • Monitoring all the sessions that are scheduled, running completed and failed. Debugging the workflows that failed.
  • Provide Warranty period support for the projects which went live i.e. monitor and maintain the jobs scheduled.
  • Built reusable transformations and mapplets to use in multiple mappings in Informatica Power center.
  • Involved in Data Extraction from Oracle and Flat Files using SQL Loader Designed and developed mappings using Informatica Power Center.
  • Involved in fixing of invalid Mappings, Performance tuning, testing of Stored Procedures and Functions, Testing of Informatica Sessions, Batches and the Target Data.
  • Created mapping variables, mapping parameters, workflow variables and session parameters in Informatica.
  • Preparing Unit Test cases for Unit Testing and assisted with QA team and UAT team for providing development support.
  • During the UAT, interacted directly with business stakeholders, provided clarifications for their questions on the data and use cases
  • Assisted UAT team and QA team in coming up with validation scripts to perform the validations as expected to cover all scenarios
  • Responsible for Unit Test Execution (Component and Assemble testing).
  • Working on SQL server and Oracle which is validating the code built on Informatica.
  • Came with different approach for the implementation of toughest logic.
  • Working on Onsite offshore model.
  • During the warranty period, provided post production support to clarify stakeholders questions within the stipulated SLAs
  • Technologies Involved: Informatica Power Center 9.6/9.5.1/9.1.0 , MS SSIS, Oracle 11g (SQL and PL SQL), MS SQL Server, UNIX, putty, Windows, Toad, SQL Developer and Error Handling.

Confidential

ETL Developer / Material Management System

Responsibilities:

  • Involved in design and development of data warehouse environment, liaison to business users and/or technical teams gathering requirement specification documents and presenting and identifying data sources, targets, and report generation.
  • Worked on Informatica Power Center 8.6.1 tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
  • Using Informatica Designer designed Mappings, which populated the Data into the Target Star Schema
  • Optimized Query Performance, Session Performance, and Reliability did performance tuning of Informatica components for daily and monthly incremental loading tables.
  • Extensively used Normalizer, Router, Lookup, Aggregator, Expression and Update Strategy Transformations.
  • Created complex workflows, with multiple sessions, worklets with consecutive or concurrent sessions. Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager
  • Used Workflow Manager for creating validating, testing and running sequential and concurrent batches. Implemented source and target based partitioning for existing workflows in production to improve performance so as to cut back the running time.
  • Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
  • Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
  • Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
  • Involved in migrating Informatica ETL application and Database objects through various environments such as Development, Testing, UAT and Production environments.
  • Documented and presented the production/support documents for the components developed when handing-over the application to the production support team
  • Monitoring and running the jobs with help of Autosys Tool
  • Analysing business impact before the production outage activity and notifying it to the business.
  • Investigating and resolving the Service Now Tickets
  • Monitoring and improving performance of various ETL jobs to transfer data from transaction to ODS and ODS to DWH system
  • Providing technical knowledge transfer to the team.
  • Analyzing business activity, developing, and deploying business solutions
  • Interact with clients, understand their requirements and propose them the valuable and feasible solution
  • Created asset software which can reduce repetitive tasksand Do daily Checklist for deliverables.Working in SLA / SLE timeline and met 98% expectation
  • Involved in the data analysis for source and target systems and a good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
  • Used debugger to test the mappings and unit tested mappings.
  • Involved in Performance Tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
  • Technologies Involved: Informatica Power Center 8.6/9.1.0, Oracle 11g (SQL and PL SQL), UNIX, and Autosys.

Confidential

Business Systems Analyst

Responsibilities:

  • Interact with clients, understand their requirements and propose them the valuable and feasible canon solutions.
  • Evaluation difficulty in Canon solutions and providing feedback to a development team.
  • Managing clients and maintaining a relationship with Top level contacts and frequently attending meetings.
  • Activity report generation from Canon iCan and giving detailed analyzed pivoted report to the management for activity tracking and lead generations.
  • Strategy making for new business acquisitions and involved in client presentations for new and upgraded Canon solutions.
  • RAK survey Analysis and presenting the detailed report to clients.
  • To provide information about the new technology up gradations.
  • Preparation of Technical Design Documents and solution presentations
  • Analysis of Market comparing with competitors and assisting with the business cases.
  • Planning and monitoring of product deployment
  • Translating and simplifying requirements.
  • Requirement analysis, management, and Communication.
  • Handled client queries and provided appropriate validation reports for analysis purpose.
  • Technologies Involved: Oracle(SQL), Microsoft Excel, Canon iCan, uniFLOW

Hire Now