We provide IT Staff Augmentation Services!

Sr. Sql/tableau Developer Resume

Philadelphia, PA

SUMMARY:

  • 9+ years of experience in Data warehousing.
  • Strong knowledge in ETL operations.
  • Extensive knowledge on SSIS, SSRS.
  • Practice knowledge with Tableau 10x.
  • Deep understanding of big data with Hadoop technologies.
  • Always a self - learner and a good team player with strong communication skills.

TECHNICAL SKILLS:

Data Bases: SQL/PLSQL, TSQL, Oracle, Teradata

Programming Languages: Core Java, Python

ETL Tools: Informatica

Hadoop Technologies: HDFS, Spark, Scala, Hive, Pig, Scoop, Oozie, Zookeeper

Reporting Tools: Tableau

Scripting Language: VB Script, Java Script

PROFESSIONAL EXPERIENCE:

Confidential - Philadelphia, PA

Sr. SQL/Tableau Developer

  • Developing ETL Scripts and perform testing and data analysis in an SQL Server environment.
  • Created and maintained Tableau dashboards as per end user specifications for BDI.
  • Profiled and optimized queries to ensure performance in SQL Server.
  • Collected, processed, analyzed and reported on metrics and quality control data to meet specific customer reporting requirements.

Sr. ETL /Hadoop Developer

Confidential - Denver, CO
  • Part of development team which built the Near Real Time Click-stream ingestion framework.
  • Developed many ETL ingestion frameworks using SQL and TSQL.
  • Performance tuning and hardening the existing jobs to reduce the resource consumption.
  • Working with the business to resolve the issues during UAT and the issues in production.
  • Experienced in using the spark application master to monitor the spark jobs and capture the logs for the spark jobs
  • Implemented Spark using Scala and Spark SQL for faster testing and processing of data.
  • Used Spark and Spark-SQL to read the parquet data and create the tables in hive using the Scala API

Sr. ETL Analyst

Confidential - Denver, CO
  • Responsible for gathering and analyzing the business requirements.
  • Involved in designing the data models and created conceptual, physical data models with the help of MS Visio.
  • Extensive hands-on experience in extracting, transforming, and loading data from variety of data sources.
  • Handled exporting data from various data bases like Oracle, Teradata or Flat File Systems and performed required data transformations before loading into desired targets.
  • Performed data ingestion from Hadoop Systems to Teradata and vice versa with the help of Hive and Sqoop.
  • Involved in Performance Tuning at all levels of ETL.
  • Experienced on working with Reporting tools like OBIEE / Tableau to prepare dashboards and visualize database.

Confidential

ETL Developer

  • Capturing and validating business requirements from customers.
  • Extensive knowledge on Designing, Managing and Morning the workflows by Informatica Power Center Tool.
  • Experience on Data Ingestion of Fast Load, Multi Load, Fast Export and BTEQ.
  • Experienced with UNIX shell Scripts.
  • Involved in data quality validations on profiling files and databases, identifying business rules and requirements.

Hire Now