consultant resume example with 5+ years of experience

Jessica Claire
, , 609 Johnson Ave., 49204, Tulsa, OK 100 Montgomery St. 10th Floor
Home: (555) 432-1000 - Cell: - - : - -

6+ years experienced ETL Developer with a proven track record of designing, testing & debugging new & existing ETL as well as reporting processes. Demonstrated the capability of figuring out the requirements, accessing data situation and collaborating with the cross functional teams to design a data warehousing system to meet business needs. Adept at developing Cloud based solutions for integrating & migrating data from on-premise to cloud.

Technical Skills

ETL Tool - Informatica Power center 9.5, 10.2, Azure Data Factory

Databases - SQL Server, Oracle, Azure SQLDB

Languages - Structured Query language (SQL), Unix, Python, Pyspark

Tools - Databricks Notebook, SQL developer, PuTTY, WinSCP, Beyond Compare Tool, TOAD, JIRA, Azure Boards

Project Management - Agile development methodologies, Waterfall Model, V-Model

08/2020 to 03/2023
Consultant Parametric Technology Corporation San Diego, CA,

Role - Azure Data Engineer/ ETL Developer

Development of Solution for alternate method of verifying data file integrity from more common implementations of customized solutions for each vendor across Medica Health Insurance data repository servers.

  • Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
  • Understand business use cases, integration business, write business & technical requirements documents, logic diagrams, process flow charts, and other application related documents.
  • Designed and developed ETL pipeline in Azure cloud which gets customer data from API and process it to Azure SQLDB.
  • Orchestrated all Data pipelines using Azure Data Factory and built a custom alerts platform for monitoring.
  • Created Databricks Job workflows which extracts data from SQL server and upload the files to sftp using pyspark and python.
  • Involved in full lifecycle of projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support.
  • Used various transformations like Source qualifier, Aggregators, lookups, Filters, Sequence generators, Routers, Update Strategy, Expression, Sorter, Normalizer, Stored Procedure, Union etc.
  • Worked closely with the business analyst's team to solve the Problem Tickets, Service Requests. Helped the 24/7 Production Support team.
  • Worked on handling the change data capture (CDC) data from the source and load into Data Mart by following slowly changing dimensions (SCD) type II process.
  • Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process.
04/2019 to 07/2020
Associate Consultant Korn/Ferry International Bothell, WA,

Role - ETL Developer

Implementing Commercial and Personal Farm, Auto & Property Line of Businesses by replacing the existing policy Administration, Billing Systems with Guide wire Policy Center, Billing Center & Claim Center for Wawanesa Mutual Insurance Company.

  • Involved in building the ETL Framework, Source to Target mappings to load data into Data warehouse system.
  • Co-ordinated with Informatica Admin team to promote code from lower Environment using Informatica Deployment Groups.
  • Created ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation.
  • Involved in Root cause Analysis (RCA) and come up with solution for frequent repetitive errors in Production Environment and make the application stable.
  • Designed and Maintained complex ETL Mappings and performed unit testing on the developed code.
  • Participated in meetings with cross functional teams and co-ordinate in fixing bugs in application.
  • Developing the test plan, conducting testing and dealing with business partners to perform end-user testing.
  • Involve in post-production support
04/2017 to 04/2019
Senior Associate B. Riley Financial, Inc. Chicago, IL,

Role - ETL Developer

  • Developed standard and reusable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
  • Prepared design documents consisting of data flow from Source to Target for all the mappings that are developed using Informatica.
  • Extensively used transformations like Connected & Unconnected Lookups, Aggregator, Filter, Router, Expression, Joiner, Sequence generator etc.
  • Prepare SQL Queries to validate Data in Source and target databases according to the business needs.
  • Provide weekly status reports to the Team Lead.
  • Involved in Unit Testing and preparing the Unit Test Cases as per the requirements.
Expected in 05/2016 to to
Bachelor of Technology : Electronics And Communication Engineering
Jawaharlal Nehru Technological University - India,

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Jawaharlal Nehru Technological University

Job Titles Held:

  • Consultant
  • Associate Consultant
  • Senior Associate


  • Bachelor of Technology

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: