Autokartz Internet Pvt. Ltd.
We have openings with one of our client for “Data Engineer” .
Experience : 2-5 Years
Work Location : Delhi
Mode of Hiring : Contract to Hire
Notice Period : Immediate or 15 Days Job Details
- ETL background is mandate
- Advanced SQL
- SQL Scripting
- Data Exploration & Extraction :
- Explore the database to understand the database architecture, table relations.
- Explore the data elements which we need to extract, identify join element and conditions between tables.
- Install Datashop client on the customer network.
- Configure the Datashop Client to extract data from the database, to transfer a file from the customer network.
- Data Profiling Data profiling is the task to study the source data with the following intent
- Data Mapping: Understand the data at a record level and on the whole, identify fields from source data which will be mapped or derived schema. Identify data operations which needs to be performed like data standardization, mapping, data cleaning, data extraction using regexes, concatenations, joins, and filters.
- Data Analysis: Study the data to identify gaps in data like missing data points which are imperative for the project and downstream usage, bad data, inconsistent records, missing records. Work in collaboration with all teams to ensure the right data set is delivered for downstream usage.
- Data Integration Write efficient SQL scripts to perform data operations identified during data profiling.
- Data Quality Check Data Quality check to be performed covering below points :
- Data Completeness
- Data Correctness
- Data Integrity
Only registered candidates can apply