LiveCareer-Resume

tableau and etl informatica developer resume example with 5+ years of experience

Jessica
Claire
resumesample@example.com
(555) 432-1000,
, , 100 Montgomery St. 10th Floor
:
Summary

History of mining, warehousing and analyzing data at the company-wide level. Knowledgeable about the principles and implementation of CRISP-DM to make sure clients get what they need. Create team playing making sure we achieve every goal in every project. fast learner and hardworking.

Skills
  • Enterprise information architecture
  • AWS
  • Informatica 9.6/10.2
  • SSMS
  • Tableau
  • Oracle
  • Security Protocols
  • Reverse engineering skills
  • Quality analysis
  • Data mining
  • Data analytics
  • Warehouse models
  • Data management
Education and Training
Southern New Hampshire University Hooksett, NH Expected in 03/2021 Master of Science : Data Science - GPA :
Bridgewater State University Bridgewater, MA Expected in 03/2017 Bachelor of Science : Finance - GPA :
Experience
RR Donnelley - Tableau aND ETL Informatica Developer
City, STATE, 04/2018 - Current

Informatica Developer

  • Responsible for Business Analysis and Requirements Collection
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor
  • Identify Source data quality issue and resolve discrepancies
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse
  • Extracted the data from the flat files,CSV and other RDBMS databases into staging area and populated onto Data warehouse.
  • Used various transformations like Filter, Expression, Filter, Router, Update Sequence Generator, Sorter, Update strategy, Lookup, Joiner, and Union to develop robust mappings in the Informatica Designer
  • Created mapplets to use them in different mappings.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

TABLEAU DEVELOPER

  • Designed,developed,tested and maintained tableau function report based on user requirement.
  • Defined best practice for report development
  • Mastered the ability to design and deploy excellent graphic VIZ with drill down and drop down menu option and parameter to help users understand reports.
  • Used customer query to filter data source from oracle and SSMS based on client requirement and to improve dashboard performance.
  • Used dual axis for analyzed two measures for better VIZ based on requirement.
  • Responsible for creating calculated fields, combine fields,bins,sets,geo coding, and hierarchies.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
  • Restricted data for users using Row level security and User filters.
  • Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models
  • Developed Tableau workbooks from multiple data sources using Data Blending.
  • Developed Tableau workbooks from multiple data sources using Data Blending.
    AWS EXPERIENCE
  • Architecture experience in AWS technologies and administration including S3, EC2, IAM, VPC, Glacier, Lambda
  • Responsible for creating billing alarm, pricing tier options and AWS organization.
  • Responsible for cross replication, security and encryption.
  • Responsible for creating security groups, cloudfront.
  • Responsible for Ebs, snapshot backup and cloud watch.
  • Responsible for Database in AWS cloud, multi-AZ, redshift and database migration.
  • Responsible for Route 53 simple,weighted,latency,geolocation and failover policies.
  • Responsible for VPC SQS,SNS and Kinesis.
Ladders Group - Tableau and ETL Informatica
City, STATE, 02/2016 - 01/2018

Informatica Developer

  • Responsible for Business Analysis and Requirements Collection
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor
  • Identify Source data quality issue and resolve discrepancies
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse
  • Extracted the data from the flat files,CSV and other RDBMS databases into staging area and populated onto Data warehouse.
  • Used various transformations like Filter, Expression, Filter, Router, Update Sequence Generator, Sorter, Update strategy, Lookup, Joiner, and Union to develop robust mappings in the Informatica Designer
  • Created to use them in different mappings.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, , Assignment, Timer and scheduling of the workflow
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

TABLEAU DEVELOPER

  • Designed,developed,tested and maintained tableau function report based on user requirement.
  • Defined best practice for report development
  • Mastered the ability to design and deploy excellent graphic VIZ with drill down and drop down menu option and parameter to help users understand reports.
  • Used customer query to filter data source from oracle and SSMS based on client requirement and to improve dashboard performance.
  • Used dual axis for analyzed two measures for better VIZ based on requirement.
  • Responsible for creating calculated fields, combine fields,bins,sets,geo coding, and hierarchies.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
  • Restricted data for users using Row level security and User filters.
  • Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models
  • Developed Tableau workbooks from multiple data sources using Data Blending.
  • Developed Tableau workbooks from multiple data sources using Data Blending. AWS EXPERIENCE
  • Architecture experience in AWS technologies and administration including S3, EC2, IAM, VPC, Glacier, Lambda
  • Responsible for creating billing alarm, pricing tier options and AWS organization.
  • Responsible for cross replication, security and encryption.
  • Responsible for creating security groups, cloudfront.
  • Responsible for , snapshot backup and cloud watch.
  • Responsible for Database in AWS cloud, multi-AZ, redshift and database migration.
  • Responsible for Route 53 simple,weighted,latency,geolocation and failover policies.
  • Responsible for VPC SQS,SNS and Kinesis.
Pennywise - Tableau and ETL Informatica
City, STATE, 06/2015 - 01/2016

Informatica Developer

  • Responsible for Business Analysis and Requirements Collection
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor
  • Identify Source data quality issue and resolve discrepancies
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse
  • Extracted the data from the flat files,CSV and other RDBMS databases into staging area and populated onto Data warehouse.
  • Used various transformations like Filter, Expression, Filter, Router, Update Sequence Generator, Sorter, Update strategy, Lookup, Joiner, and Union to develop robust mappings in the Informatica Designer
  • Created to use them in different mappings.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, , Assignment, Timer and scheduling of the workflow
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

TABLEAU DEVELOPER

  • Designed,developed,tested and maintained tableau function report based on user requirement.
  • Defined best practice for report development
  • Mastered the ability to design and deploy excellent graphic VIZ with drill down and drop down menu option and parameter to help users understand reports.
  • Used customer query to filter data source from oracle and SSMS based on client requirement and to improve dashboard performance.
  • Used dual axis for analyzed two measures for better VIZ based on requirement.
  • Responsible for creating calculated fields, combine fields,bins,sets,geo coding, and hierarchies.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
  • Restricted data for users using Row level security and User filters.
  • Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models
  • Developed Tableau workbooks from multiple data sources using Data Blending.
  • Developed Tableau workbooks from multiple data sources using Data Blending. AWS EXPERIENCE
  • Architecture experience in AWS technologies and administration including S3, EC2, IAM, VPC, Glacier, Lambda
  • Responsible for creating billing alarm, pricing tier options and AWS organization.
  • Responsible for cross replication, security and encryption.
  • Responsible for creating security groups, cloudfront.
  • Responsible for , snapshot backup and cloud watch.
  • Responsible for Database in AWS cloud, multi-AZ, redshift and database migration.
  • Responsible for Route 53 simple,weighted,latency,geolocation and failover policies.
  • Responsible for VPC SQS,SNS and Kinesis.

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

  • Southern New Hampshire University
  • Bridgewater State University

Job Titles Held:

  • Tableau aND ETL Informatica Developer
  • Tableau and ETL Informatica
  • Tableau and ETL Informatica

Degrees

  • Master of Science
  • Bachelor of Science

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

*As seen in:As seen in: