WorkboxIn

AWS Data Engineer

EXL · Bengaluru, Karnataka · Full-time

Key Responsibilities • Design, develop, and optimize scalable ETL/ELT pipelines for data ingestion and transformation. • Build and maintain robust data pipelines using AWS cloud services. • Partner with Business Intelligence (BI), AI/ML, and Infrastructure teams to deliver reliable and scalable data platform solutions. • Develop efficient SQL queries and Python scripts for data processing, automation, and analytics. • Create and maintain technical documentation, including solution designs, data flow diagrams, and operational guides. • Develop comprehensive unit tests and perform code reviews to ensure high-quality, reliable, and maintainable code. • Monitor, troubleshoot, and optimize data pipelines to ensure performance, scalability, and reliability. • Work on multiple projects simultaneously while managing priorities in a fast-paced environment. • Follow coding standards, best practices, and data governance guidelines. Required Skills & Qualifications • 3–5 years of hands-on experience in Data Engineering. • Strong experience in designing and developing ETL/ELT pipelines. • Proficiency in SQL and Python programming. • Hands-on experience with AWS services, including: • Amazon Redshift • AWS Lambda • Amazon S3 • AWS Glue (preferred) • AWS IAM • Amazon CloudWatch • Experience with workflow orchestration tools such as Apache Airflow (preferred). • Understanding of data warehousing concepts and dimensional data modeling. • Knowledge of version control systems such as Git. • Experience writing unit tests and following software development best practices. • Strong analytical, problem-solving, and debugging skills. • Excellent communication and documentation skills. • Ability to manage multiple tasks and work effectively in a collaborative environment. Preferred Skills • Experience with CI/CD pipelines and DevOps practices. • Knowledge of Spark, PySpark, or Databricks is an advantage. • Exposure to AI/ML data pipelines and feature engineering. • Familiarity with Agile/Scrum development methodologies. • AWS Certification (Developer Associate or Data Engineer Associate) is a plus. Key Competencies • AWS Data Engineering • ETL/ELT Development • SQL & Python • Amazon Redshift • AWS Lambda • Amazon S3 • Data Warehousing • Unit Testing • Technical Documentation • Problem Solving • Team Collaboration • Multitasking • Agile Development Educational Qualification • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field. • Relevant AWS certifications will be an added advantage.