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.