- 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.
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
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 DeveloperConfidential - 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 AnalystConfidential - 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.
- 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.