Mid-Level Data Engineer

At Stefanini, we believe in the power of collaboration. We co-create innovative solutions in partnership with our clients, combining cutting-edge technology, artificial intelligence, and human creativity. We are at the forefront of business problem solving, delivering real impact on a global scale. By joining Stefanini, you become part of a global journey of transformation. We are committed to creating a positive impact not only on business, but also in the lives of our employees. If you are looking for an opportunity for professional growth in a company that values innovation, respect, autonomy, and partnership, you will find it here! Join us and be part of the change! What we expect you to accomplish: We are looking for a Mid-Level Data Engineer to work on the migration of tables and pipelines from the Cloudera Hadoop environment to AWS, acting end-to-end — from initial assessment to production stabilization. Responsibilities: Map the current environment: assess jobs, pipelines, and HQL queries in Cloudera, as well as Shell Script orchestration routines. Convert HQL queries to Amazon Athena, AWS Glue, or Amazon EMR, choosing the most appropriate service per use case (cost, performance, access pattern). Redesign Shell Script orchestration routines into managed AWS services such as Step Functions, Lambda, EventBridge, and MWAA/Airflow. Model the destination data lake in Amazon S3 (raw/trusted/refined zones) and, where applicable, in Amazon Redshift.