We provide IT Staff Augmentation Services!

Etl Developer Resume

Jersey City, NJ

Summary

  • Over Six (6) years of IT experience with extensive Data Warehousing implementations across Retail, Insurance,Financial and Communication Industries.
  • Data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 9.x/8.x.
  • Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
  • Experience in working with business analysts to identify, study and understand requirements and translated them into ETL code in Requirement Analysis phase.
  • Experience in creating High Level Design and Detailed Design in the Design phase.
  • Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
  • Extensively worked on the ETL mappings, analysis and documentation ofOLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
  • Well versed in OLTP Data Modeling, Data warehousing concepts.
  • Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
  • Experience in integration of various data sources like Oracle, SQL server and MS access and non-relational sources like flat filesinto staging area.
  • Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
  • Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
  • Experienced in UNIX work environment, file transfers, job scheduling and error handling.
  • Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
  • Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
  • Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, and packages.
  • Involved in Unit testing, Integration testing to check whether the data loads into target are accurate.
  • Experience in support and knowledge transfer to the production team.
  • Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.
  • Extensive functional and technical exposure. Experience working on high-visibility projects
  • Assign work and provide technical oversight to onshore and offshore developers
  • Excellent analytical/ communication skills and good team player.

TECHNICAL SKILLS:

ETL Tools : Informatica power center 7.x, 8.x, 9.x (Repository Manager, Designer, server manager, Workflow Manager, Admin console, Workflow Monitor).

Databases: Oracle 9i/10g/11g, SQL Server 2008/2005, My SQL 5.0

Oracle Tools: Quest TOAD, SQL Developer, Putty, FilaZilla, WinSCP

Other Tools: MS-Word, Excel, PowerPoint 2003/2007.

Operating systems: UNIX, HP, Windows NT/XP/7/8

Programming Skills: UNIX Shell scripting, SQL, PL/SQL.

Confidential, Salt Lake City ,UT

Role: ETL Developer

Responsibilities:

Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.

  • Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.
  • Analyzed the system for the functionality required as per the requirements and created System Requirement Specification document (Functional Requirement Document).
  • Involved in the development of the conceptual, logical and physical data model of the star schema.
  • Extensively used Informatica Client tools – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
  • Extensive experience in Design and Developing Informatica Packages for EquityCapital Market.
  • Designed and developed daily audit and daily/weekly reconcile process ensuring the data quality of the Data warehouse.
  • Developed various mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
  • Created and Configured Workflows, Workletss and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager
  • Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
  • Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
  • Prepared Run books providing guidelines to trouble shoot the errors occurred during the run time and instructions on how to restart the loads.

Environment: Informatica Power Center 9.x, Oracle11g, SQL developer, SQL server 2008, Toad, WinSCP, FileZilla, Unix, Putty.

Confidential, Jersey City, NJ

Role: Informatica Developer

Responsibilities:

  • Gathered requirements and developed mappings based on business requirements.
  • Extensively worked to load data from Oracle, MS SQL Server, flat files into the target Oracle database.
  • Implemented various Transformations: Joiner, sorter, Aggregate, Expression, Lookup, Filter, Update Strategy and Router.
  • Modified the existing mappings for the updated logic and better performance.
  • Worked on identifying Mapping Bottlenecks and improved session performance through error handling.
  • Worked on Mapplets and created parameter files wherever necessary to facilitate reusability.
  • Used Error Handling to capture error data in tables for handling nulls, analysis and error remediation Process.
  • Involved in massive data cleansing and data profiling of the production data load.
  • Tuning the complex mappings based on source, target and mapping, session level.
  • Avoided Duplicate issues through SQL override using look uptransformations.
  • Performed Unit Testing on the mappings.
  • Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
  • Actively participated in resolving Email tasks working on priority and non-priority issues.
  • Developed and Scheduled jobs for daily loads that invoked Informatica workflows & sessions associated with the mappings, SQL scripts to drop & recreate the indexes on source and target tables for batch process.
  • Ensured that integration testing and system testing followed with QA and change management procedures.

Environment: Informatica Power Center 9.x, Oracle11g, SQL developer, MS SQL server 2008, Toad, WinSCP, FileZilla, Unix, Putty.

Confidential, Atlanta GA

Role: Informatica Developer

Responsibilities:

  • Involved in Project Life Cycle of application access issues to Implementation phase.
  • Working closely with Architects, Lead and Project Manager for the applications proving support on the databases and applications
  • Gathering requirements from Business Analyst’s in understanding the Databases and Structures required in star schema data model.
  • Designed, developed and tested mappings/sessions/workflows to move data from source to staging for data loading.
  • Good knowledge for working with parameterized DB connections using UNIX scripts to view processed data.
  • Worked on identifying Mapping Bottlenecks in Mappings and improved session performance by including partition points, modifying target load order and emphasizing more on SQL override in Lookup, Filter, Expression and Update strategy transformations.
  • Used reusable UNIX shell scripts command in Pre/Post Sessions.
  • Performed performance tuning on Informatica sessions, and mappings.
  • Ensured that system testing and change management procedures are followed with an ability to prioritize and manage multiple tasks with effective time management skills.
  • Precisely documented all data for further reference .

Environment: Informatica Power Center 8.x, Oracle 10g/9i, MS SQL Server 2005, Toad 7.0, Windows 2000, Unix, Putty.

Confidential, Boston MA

Role: ETL Developer

Responsibilities:

  • Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
  • Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
  • Extensively involved in Data Extraction from Oracle using PowerExchange when there was change in the source data sets.
  • Created mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
  • Read\Wrote XML Messages from\to MQ Series Queues.
  • Created Mapplets, reusable transformations and used them in different mappings
  • Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean up and update purposes.
  • Validation of Informatica mappings for source compatibility due to version changes at the source.
  • Trouble shooting of long running sessions and fixing the issues.
  • Implemented daily and weekly audit process for the Claims subject area to ensure Data warehouse is matching with the source systems for critical reporting metrics.
  • Developed shell scripts for Daily and weekly Loads and scheduled using Unix Maestro utility.
  • Involved in writing SQL scripts, stored procedures and functions and debugging them.
  • Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
  • Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
  • Worked with reporting team to help understand them the user requirements on the reports and the measures on them. Helped them in creating canned reports.
  • Migrated repository objects, and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
  • Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.
  • Scheduler, Control, Decision, Session in the workflow manager.

Environment: Informatica Power Center 8.1.1, oracle 9i/8i, PL/SQL, SQL Server 2005, Unix, Unix Shell Script, Putty.

Confidential , Bangladesh

Role: ETL Developer

Confidential is a financial company whose main objective is to provide value added services. The main objective of the system is extracting the data and loading into mart. Involved in ETL (Extraction, Transformation and Loading) and Business Intelligence processes

Responsibilities:

Analyzed specifications and identified source data needs to be moved to Data Mart, participated in the design team and user requirement gathering meetings.

  • Performed major role in understanding the business requirements and designing and loading data into data warehouse. Designed star schema using Dimension modeling using the ER-win design tool.
  • Extensively used ETL (Informatica) to load data from source (Flat files) to target Oracle database.
  • Lookup, Aggregator, sequence, joiner and other transformations are used in populating data process.
  • CreatedInformatica Mappings with PL/SQLprocedures/functionsto build business rules to load data.
  • Involved in scheduling the Informatica Workflows.
  • Conducted Performance tuning of application by modifying the SQL statements and using Explain Plan and TOAD Software.
  • Used the Oracle stored functions/procedure/Packages.
  • Involved in developing the requisite reports (list, grouped list, cross-tabs etc.) using Business Objects.

Environment: Informatica Power Center 7.x,Oracle 8i, PL/SQL, SQL Server, Toad, Business Objects 5.1, Windows 2000, MS Access.

Hire Now