Familiarity in ETL tools, Databases such as Teradata or SQL Server, Azure, Azure Data Factory, SQL
4-6 years overall experience and at least 3 years working as Data Engineer
Masters/Bachelors in computer science/Engineering, Business Analytics, Information System, or other related disciplines.
Proficient in ETL tools such as SSIS, Azure Data Factory is required Excellent communication, relationship skills and a strong team player
Good to have deep understanding of statistical modelling, machine learning, or data mining, text mining concepts and a track record of solving problems with these methods.
Experienced in big data techniques (such as Hadoop, MapReduce, Hive, Pig, Spark) is a plus.
Job Responsibilities
Engage in both exploratory data analysis to identify trends and data patters
Perform data preparation and data cleaning part of data migration project.
Understand Source data and support Source to Target mapping rules
Design and implement the ETL framework for the data warehouse
Build the Data Ingestion framework and ingest data from source files to load into Staging layer
Perform data profiling and identify any data quality issues and report to source systems
Using best practices build the ETL components as per mapping rules to move data into ODS; SOR layer and Data marts
Ensure the ETL jobs are set up; configured and scheduled
Perform Unit testing on ETL components built and provide unit test results. Support System
Integration testing and User Acceptance testing and fix any issues
