Apache Nifi Kafka Engineer

Position Description :

We are seeking a highly experienced Senior Data Engineer with a strong background in building end-to-end ETL and ELT data pipelines and working across both AWS and GCP cloud platforms. The ideal candidate will have deep expertise in Big Data ecosystems, real-time and batch processing, and experience working with large-scale distributed systems.

Your future duties and responsibilities :

• Design, develop, and deploy end-to-end scalable data pipelines for ingesting, transforming, and storing structured, semi-structured, and unstructured data.
• Work with large-scale data processing frameworks like PySpark, Spark SQL, and Spark Streaming to enable real-time and batch analytics.
• Optimize and manage ETL pipelines, data lakes and data warehouses on AWS (S3, Athena, Redshift, RDS, Glue, EMR) and GCP (BigQuery, DataProc, GCS).
• Build and optimize ETL / ELT workflows for ingesting, transforming, and delivering high-volume data from diverse sources to data lakes and data warehouses
• Develop data integration workflows using tools like Apache NiFi, Kafka, Sqoop, Hadoop, HDFS, Hive, Airflow.
• Implement CDC, SCD Type 1, SCD Type 2, and real-time ingestion patterns.
• Leverage Hive for data querying and performance tuning using Partitioning, Bucketing, and Compression techniques.
• Handle multiple data formats including Parquet, ORC, Avro, JSON, XML, and CSV.
• Collaborate with Data Scientists, Analysts, and Product teams to translate business requirements into technical solutions.
• Mentor junior engineers, conduct technical interviews, and contribute to building a high-performance data engineering team.
• Exposure to CI / CD pipelines and container orchestration (Docker, Kubernetes).
• Participate in Agile discussions, client meetings, sprint planning, and demos.

Required qualifications to be successful in this role :

Must-Have Skills :

CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodation for people with disabilities in accordance with provincial legislation. Please let us know if you require reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.

Skills :