As a Data Engineer, you are required to:
Design, build, and maintain data pipelines that efficiently process and transport data from various sources to storage systems or processing environments while ensuring data integrity, consistency, and accuracy across the entire data pipeline.
Integrate data from different systems, often involving data cleaning, transformation (ETL), and validation. Design the structure of databases and data storage systems, including the design of schemas, tables, and relationships between datasets to enable efficient querying. Work closely with data scientists, analysts, and other stakeholders to understand their data needs and ensure that the data is structured in a way that makes it accessible and usable.
Stay up-to-date with the latest trends and technologies in the data engineering space, such as new data storage solutions, processing frameworks, and cloud technologies. Evaluate and implement new tools to improve data engineering processes.
Qualification: Bachelor's or Master's in Computer Science & Engineering, or equivalent. Professional Degree in Data Science, Engineering is desirable.
Experience level: At least 3 - 5 years hands-on experience in Data Engineering, ETL.
Desired Knowledge & Experience:
Spark: Spark 3.x, RDD/DataFrames/SQL, Batch/Structured Streaming Knowing Spark internals: Catalyst/Tungsten/PhotonDatabricks: Workflows, SQL Warehouses/Endpoints, DLT, Pipelines, Unity, AutoloaderIDE: IntelliJ/Pycharm, Git, Azure Devops, Github CopilotTest: pytest, Great ExpectationsCI/CD Yaml Azure Pipelines, Continuous Delivery, Acceptance TestingBig Data Design: Lakehouse/Medallion Architecture, Parquet/Delta, Partitioning, Distribution, Data Skew, CompactionLanguages: Python/Functional Programming (FP)SQL: TSQL/Spark SQL/HiveQLStorage: Data Lake and Big Data Storage Designadditionally it is helpful to know basics of:
Data Pipelines: ADF/Synapse Pipelines/Oozie/AirflowLanguages: Scala, JavaNoSQL: Cosmos, Mongo, CassandraCubes: SSAS (ROLAP, HOLAP, MOLAP), AAS, Tabular ModelSQL Server: TSQL, Stored ProceduresHadoop: HDInsight/MapReduce/HDFS/YARN/Oozie/Hive/HBase/Ambari/Ranger/Atlas/KafkaData Catalog: Azure Purview, Apache Atlas, InformaticaRequired Soft skills & Other Capabilities:
Great attention to detail and good analytical abilities.
Good planning and organizational skills
Collaborative approach to sharing ideas and finding solutions
Ability to work independently and also in a global team environment.