We provide IT Staff Augmentation Services!

Etl Developer Resume

5.00/5 (Submit Your Rating)

PROFESSIONAL SNAPSHOT:

  • Over 6 years of experience in IT industry including 3+ years of hands on experience using MuleSoft ESB and Enterprise Application Integration(EAI).
  • Implemented ESB Integration Services using MuleSoft ESB and enterprise application (EAI) using MuleSoft 3.x.
  • Aided in troubleshooting Mule ESB (debuggers / flow analyzers), deployment, and tuning.
  • Worked with different runtime environments of Mule ESB varying from 3.4.1 to till date 3.8.0.
  • Extensively worked on Enterprise edition of MULE ESB also configured MULE API manager.
  • Used RAML to create the REST Confidential in API Manager.
  • Customized the integration workflows using an ESB framework also with Mule Soft MMC and enterprise release.
  • Utilized Mulesoft features like Dataweave, API designer and various connectors to ensure robust and loosely coupled integration layer every time.
  • Developed Mule flows to integrate Data from various sources into Database from ActiveMQ topics and queues.
  • Developed an Integration Component with third party application using Mule ESB and Experience in integrating Cloud applications like SFDC using Mule ESB.
  • Created various RAML resources to implement REST Based Confidential as a part of project implementation.
  • Orchestrated full Software Development Life Cycle (SDLC) starting from collecting Business specifications, Analysis, Design and Development, Testing and documenting the entire life cycle using various methodologies like Agile, SCRUM, Waterfall and Test Driven Development.
  • Worked on XML related technologies like XSL, XSD, XSLT, WSDL, XSD.
  • Expertise in Informatica Developer, PowerCenter 9.X/8.X and Knowledge of Data Warehousing Concepts.
  • Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
  • Expertise in ETL tools: Informatica, Oracle SQL and PL/SQL, Teradata and Unix
  • Involved in the full development lifecycle from requirements gathering through development and support using Informatica Power Center, Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
  • Experience in integration of various data source definitions like Oracle, Flat Files, SQL Server and Teradata.
  • Created complex mappings using Web Service Consumer, Transaction Control, XML Parser, XML Generator, JAVA, Stored procedure, Unconnected Lookup, Aggregator, Router and Update strategy transformations for populating target systems in efficient manner.
  • Developed mappings, transformations, worklets and workflows. Used Informatica Source Analyzer, Mapping Designer and Warehouse Designer for Extraction, Transformation and Loading with the desired slowly changing dimension tables.
  • Used Parameterization for Workflows, Sessions etc.
  • Created complex SQL queries, procedures, triggers and functions as per the client requirement by using TOAD tool in Oracle 11G.
  • Worked in Teradata Standalone Load and Unload Utilities like FastLoad, MultiLoad, Tpump and FastExport.
  • Value added enhancements for existing applications.
  • Team played and self-starter with good attitude and ability to work independently and as part of team.

IT SKILLS PROFILE

Mule Runtime: 3.8.1 and earlier versions

Anypoint versions: 6.0.3 and earlier versions

Version Controlling tools: SVN, GIT and stash

ETL Tool: Informatica 10.X/9.X / 8.X

Languages: Oracle SQL, PL/SQL, C++ and Java

RDBMS/Back End: Oracle 11G/10G, SQL Server 2008, DB2 and Teradata

Scheduling: Control-M

Interfacing tools: Putty

Operating System: Windows 2000/NT/XP/2007/2010, UNIX

PROFESSIONAL EXPERIENCE

Confidential

MuleSoft Developer

Technology: Mule ESB, API’s using RAML, CloudHub and Munits.

Responsibilities:

  • Involved in Requirement Gathering, analysis, design and development of the project.
  • Executed the development process SDLC using Agile methodology, which included iterative application development, monthly Sprints, stand up meetings, and customer reporting.
  • Worked on RAML and REST based Web services for Mule ESB flows, also on Mule Soft MMC and Enterprise release capabilities.
  • Used Git hub for version and source control also involved in unit testing and writing the MUnit Test cases for the flow flows.
  • Developed Soap based web services (Contract First approach) for different application modules and used tools like SoapUI for testing.
  • Mapped data from CSV to XML and vice-versa using Dataweave and Datamapper and responsible for API designing using REST and SOAP services.
  • Installation and configuration of Development Environment using Anypoint studio with Mule application server on cloud and premises.
  • Created http inbound & outbound flows, routing, orchestration, transformations and Security of MULE ESB application using OAuth.
  • Involved in ORACLE writing SQL queries & PL SQL - Stored procedures, functions, triggers, cursors, object types, views. Scheduled Ctrl-M jobs to run them.
  • Created API’s structure in API manager Using RAML.
  • Used connectors like SAP, SFDS, HTTP, HTTPS and VM etc.
  • Used components like WS:Consumer, Java Component, loggers, data Mapper, data weave, Message Enrichers to accomplish different task.
  • Used Scatter-Gather to make parallel calls to different flows.
  • Worked on creating Muints for testing the flows.

Confidential

ETL Developer

Environment: Informatica 9x, SQL Server 2008, Unix

Responsibilities:

  • Involved in the discussion with clients for requirements gathering and analysis
  • Create Informatica mappings to build business rules to load data.
  • Involved in quality assurance of data, automation of processes.
  • Used Informatica power center to extract, transform and load data from multiple input sources like SQL Server and flat files to target data base SQL Server and flat files.
  • Optimizing/Tuning mappings for better performance and efficiency.
  • Develop and execute application Unit test plans to validate programming changes and document the results.
  • Participate in the Agile/Scrum process including daily meetings, planning sessions, story pointing and retrospectives. Provide updates on accomplishments, barriers and remaining work effort.

Confidential

ETL Developer

Environment: Informatica 9x, SQL Server 2008, Unix

Responsibilities:

  • Involve in the discussion with clients for requirements gathering and analysis
  • Create Informatica mappings to build business rules to load data.
  • Involved in quality assurance of data, automation of processes.
  • Used Informatica power center to extract, transform and load data from multiple input sources like SQL Server and flat files to target data base SQL Server and flat files.
  • Optimizing/Tuning mappings for better performance and efficiency.
  • Develop and execute application Unit test plans to validate programming changes and document the results.
  • Participate in the Agile/Scrum process including daily meetings, planning sessions, story pointing and retrospectives. Provide updates on accomplishments, barriers and remaining work effort.

Confidential

Oracle Developer

Environment: Oracle 10G, Unix

Responsibilities:

  • To analyze the requirements and to provide the possible solutions to the business in the new functionalities.
  • Involved in the development of new service types for Confidential tele services (Wire line: Leased lines and data center)
  • Worked on Account creation process from KENAN front end.
  • Provide support for billing and provisioning issues in Production environment during scheduled bill runs and order entry.
  • Delivering assured quality products by conducting reviews
  • Involved in automation of critical manual configurations and validations.
  • Reviewing / analyzing change requests raised by clients and estimating the effort and reviewing developments/changes done by the team members.

We'd love your feedback!