Profile

Jyotsana Singh

Azure Data Engineer at Teradata

9.3

Years of Experience

Education

kurukshetra university, tagore baal niketan

Companies

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

    2021 - Present

    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

45 Skills

Amazon Athena

Amazon Relational Database Service (RDS)

Amazon S3

Amazon Web Services (AWS)

analytics

Apache Spark

architectures

Attention to Detail

Azure

Big Data

Big Data Analytics

Collaboration

Communication

Data Analytics

Data Engineering

Data Migration

Data Pipelines

Docker

etl tools

Extract, Transform, Load (ETL)

Integration

Interpersonal Skills

Microsoft Azure

NumPy

Pandas

Pandas (Software)

PostgreSQL

Presentations

pyspark

Python

requirements analysis

Software Engineer

SQL

sql server

SQL Server Integration Services (SSIS)

SQL Server Reporting Services (SSRS)

SSIS

SSRS

Stored Procedures

T-SQL

Tableau

Technical Writing

Transact-SQL (T-SQL)

Web

Web Services

Education

  • img

    2010 - 2014

    kurukshetra university

    Bachelor of Technology (B.Tech.)

    Information Technology

  • img

    2008 - 2010

    tagore baal niketan

    High School

    Science