We provide IT Staff Augmentation Services!

Etl, Data Analyst Resume

4.00/5 (Submit Your Rating)

SUMMARY:

  • Highly skilled professional having 16+ years of experience in system analysis, design, development, and implementation of enterprise applications. Experience in Big Data Technology stack, Frame work Manager, Data warehousing, ETL, Data Analyst, BI reports,BSS support, and Project Management.
  • Expertise in Big Data solutions in building scalable distributed data processing solutions with Hadoop, HBase, Hive, & Pig.
  • Working on Cloudera Manager Bigdata Hadoop Distributor.
  • Knowledge on Hortonworks and Ubuntu Hadoop Distributors.
  • Working as a Hadoop Developer in all phases of Hadoop and HDFS development.
  • Experience in Lambda Architecture.
  • Workingon HDFS, MapReduce and Hadoop Ecosystem Pig, Hive, Oozie, HBase, Zookeeper and Sqoop.
  • Well versed with developing and implementing MapReduce jobs using Hive and Pig to work on Big Data.
  • Understanding of Spark processing Framework such as Spark and Spark Sql.
  • Experience in NoSQL database like HBase.
  • Procedural knowledge in cleansing and analyzing data using HiveQL, Pig Latin, and custom MapReduce programs.
  • Experience in writing custom UDFs for extending Hive and Pig core functionalities.
  • Ability to develop Pig UDF'S to pre - process the data for analysis.
  • Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems such as Oracle, MS Sql, and My Sql and vise versa.
  • Knowledge on creating workflows using Oozie.
  • Working on different file formats such as Avro,Json,XML and Parquet.
  • Working on Data visualization using Tableau
  • Experience in Data wrangling such as reformatting data values or layout, correcting erroneous or missing values, and integrating multiple data sources.
  • Worked on Data wrangling methodologies using Trifacta and Talend.
  • Worked on implementing ETL methodologies using SSIS, and Talend, and Knowledge on Informatica Power Center.
  • Extensive experience as a DWH Technical Analyst, provided Business Intelligence and Data Warehouse solutions using Microsoft Data Tools, IBM Cognos FM, and BI reports (Cognos Report studio, Tableau, Power BI).
  • Experienced in Data modeling knowledge of Ralph Kimball’s Dimensional Data Modeling using Star Schema and Snow-Flake Schema.
  • Worked on IBM Cognos Framework Manager, Query Studio, Report Studio, work space Advance and Cognos Administration.
  • Experienced on various Databases MySQL, Oracle, and MS sql.
  • Extensive experience with SQL in designing data base objects such as Tables, functions, procedures, triggers, Views and CTE’s.
  • Experienced in Erwin data Modeling iterations (Schematic/ Logical/ Physical) Forward and reverse-engineering process.
  • Experienced in Project Management, and Vendor Management,Agile Scrum master, Business analyst and Data Analyst, and knowledge on SDLC and STLC.
  • Certified Scrum Master,ISTQB,and trained on PMI-ACP.
  • Quick learner and Good Team player.
  • Having Excellent analytical, problem solving, communication skills and a committed team player with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio 2008/ 2012, SQL Profiler, SSRS, SSIS, and SSAS

ETL: SSIS, Talend

BI Reports: Cognos, Tableau, SSRS, Power BI

Analysis Tools: SSAS

Databases: SQL Server 2008/ 2012, My SQL, Oracle10G/11G

Data Modeling tool: CA Erwin Data modeler, IBM Cognos Framework Manager

Database Management tools: Oracle SQL Developer

Operating Systems: Unix/Linux, Windows XP, Windows2000/98/95, Windows 7/8/10

Languages: C, SQL

Big Data: Hadoop, Pig, Hive, Sqoop, HBase, MapReduce, Flume, Hive, Cloudera Manager, Horton works, and Ubuntu

Data Wrangler Tool: Trifacta

Project Management Tools: JIRA

PROFESSIONAL EXPERIENCE

Confidential

ETL, Data Analyst

Responsibilities:

  • Understanding of Spark processing Framework such as Spark and Spark Sql.
  • Experience in NoSQL database like HBase.
  • Procedural knowledge in cleansing and analyzing data using HiveQL, Pig Latin, and custom MapReduce programs.
  • Experience in writing custom UDFs for extending Hive and Pig core functionalities.
  • Ability to develop Pig UDF'S to pre - process the data for analysis.
  • Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems such as Oracle, MS Sql, and My Sql and vise versa.
  • Knowledge on creating workflows using Oozie.
  • Working on different file formats such as Avro,Json,XML and Parquet.
  • Working on Data visualization using Tableau
  • Experience in Data wrangling such as reformatting data values or layout, correcting erroneous or missing values, and integrating multiple data sources.
  • Worked on Data wrangling methodologies using Trifacta and Talend.
  • Worked on implementing ETL methodologies using SSIS, and Talend, and Knowledge on Informatica Power Center.
  • Extensive experience as a DWH Technical Analyst, provided Business Intelligence and Data Warehouse solutions using Microsoft Data Tools, IBM Cognos FM, and BI reports (Cognos Report studio, Tableau, Power BI).
  • Experienced in Data modeling knowledge of Ralph Kimball’s Dimensional Data Modeling using Star Schema and Snow-Flake Schema.
  • Worked on IBM Cognos Framework Manager, Query Studio, Report Studio, work space Advance and Cognos Administration.
  • Experienced on various Databases MySQL, Oracle, and MS sql.
  • Extensive experience with SQL in designing data base objects such as Tables, functions, procedures, triggers, Views and CTE’s.
  • Experienced in Erwin data Modeling iterations (Schematic/ Logical/ Physical) Forward and reverse-engineering process.
  • Experienced in Project Management, and Vendor Management,Agile Scrum master, Business analyst and Data Analyst, and knowledge on SDLC and STLC.
  • Certified Scrum Master,ISTQB,and trained on PMI-ACP.
  • Quick learner and Good Team player.
  • Having Excellent analytical, problem solving, communication skills and a committed team player with ability to interact with individuals at all levels.

We'd love your feedback!