Sr. SQL/Tableau Developer Resume Philadelphia, PA - Hire IT People

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.