Profile

Jyotsana Singh

Azure Data Engineer at Microsoft

9.6

Years of Experience

Education

kurukshetra university, tagore baal niketan

Companies

microsoft, teradata, nagarro, lt, hcl

Reach out to Jyotsana Singh via Email, InMail and SMS drip

by installing Chrome extension

Jyotsana's contact details

Email

Email (Verified)

jyoXXXXXXXXXXXXXXXXXXXXom

Email

Mobile Number

+91XXXXXXXX41

Experience

  • img

    2022 - Present

    microsoft

    Azure data engineer

  • img

    2021 - 2022

    teradata

    Lead Data Engineer

  • img

    2017 - 2021

    nagarro

    Assosciate team Lead

    Technical Stack : PySpark, Python , Alteryx, Tableau, Exasol ,Postgres, Docker • Experienced in building and optimizing ‘big data’ data pipelines, architectures and data sets. • Designed data integrations and data quality framework. • Developed Alteryx workflows to load the data from SFTP and perform transformations like Record ID, Dynamic Input, Multi row field, joins, summary etc. • Expertise in creating solution driven views and dashboards by developing different chart types including Line Charts, Bar Charts, Pie Charts, Scatter Plots, Histograms, Heat Maps, Box & Whisker and Scatter Charts etc. in Tableau Desktop.

  • img

    2014 - 2017

    lt

    Software Engineer

    Technical Stack : SQL Server, SSIS and SSRS 1. Expertise in SQL Server Integration Services(SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services(SSAS) 2. Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc. 3. Worked on SSIS Package, DTS Import/Export for transferring data from Database (Text format data) to SQL Server 4. Experience in report creation using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional , Table, Matrix, Chart and Sub Reports. 5. Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL 6. Worked Extensively on ETL process using SSIS package. 7. Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files. 8. Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player. 9. Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure

  • img

    2013 - 2013

    hcl

    Industrial Trainee

    Data and functional level testing of the developed reports.

Experience

47 Skills

Amazon Athena

Amazon Relational Database Service (RDS)

Amazon S3

analytics

Apache Spark

architectures

Attention to Detail

Azure

Big Data

Big Data Analytics

C (Programming Language)

C++

Data Analytics

Data Engineering

Data Pipelines

Data Science

Data Scientist

Docker

etl tools

Excel

Extract, Transform, Load (ETL)

Integration

J2EE

Java

Machine Learning (ML)

Microsoft Azure

Microsoft Excel

Microsoft PowerPoint

microsoft sql server

Networking

NumPy

Pandas

Pandas (Software)

PostgreSQL

PowerPoint

pyspark

Python

requirements analysis

SQL

sql server

SQL Server Integration Services (SSIS)

SQL Server Reporting Services (SSRS)

SSIS

SSRS

statistics

Tableau

Web

Education

  • img

    2010 - 2014

    kurukshetra university

    Bachelor of Technology (B.Tech.)

    Information Technology

  • img

    2008 - 2010

    tagore baal niketan

    High School

    Science