Job Title : AWS Python Data Engineer (Snowflake & Teradata)

Experience : 5+ Years

Location : Bangalore (Hybrid/On-site)

Employment Type : Contract / Full-Time

Shift : Second Shift (1:00 PM - 10:00 PM IST)

Client : US-Based Client

Notice Period : Immediate to 1 - 2 Weeks Preferred

Job Summary :

We are looking for a skilled AWS Python Data Engineer with 5+ years of experience in designing, developing, and maintaining scalable data engineering solutions. The ideal candidate should have strong expertise in AWS Cloud Services, Python, Snowflake, Teradata, and SQL with hands-on experience in building robust ETL/ELT pipelines, cloud-based data integration, and data warehousing solutions. The candidate will work closely with cross-functional teams to develop high-performance data pipelines, optimize data processing, and support business intelligence initiatives for a US-based client.

Key Responsibilities :

- Design, develop, and maintain scalable data pipelines using Python and AWS cloud services.

- Develop and optimize ETL/ELT processes for large-scale data migration and transformation.

- Build and maintain data warehouse solutions using Snowflake and Teradata.

- Develop reusable Python scripts for data processing, automation, and orchestration.

- Optimize SQL queries for high-performance data retrieval and reporting.

- Integrate data from multiple sources into cloud-based data platforms.

- Develop and maintain data models to support reporting and analytics.

- Monitor, troubleshoot, and resolve production issues related to data pipelines.

- Ensure data quality, integrity, governance, and security across the data ecosystem.

- Collaborate with business analysts, architects, and development teams to gather and implement data requirements.

- Implement performance tuning for Snowflake and Teradata databases.

- Participate in code reviews and follow best coding practices.

- Prepare technical documentation and support deployment activities.

- Work in an Agile development environment and participate in sprint planning, stand-ups, and retrospectives.

- Provide production support and continuous improvements for existing data solutions.

Required Skills :

Programming :

- Python

- SQL

- Shell Scripting (Good to Have)

Cloud Platform :

- Amazon Web Services (AWS)

- AWS S3

- AWS Lambda

- AWS Glue

- AWS IAM

- AWS CloudWatch

- AWS EC2

- AWS Step Functions (Preferred)

Data Warehousing :

- Snowflake

- Teradata

Database :

- SQL

- Stored Procedures

- Query Optimization

- Performance Tuning

Data Engineering :

- ETL/ELT Development

- Data Integration

- Data Transformation

- Data Modeling

- Data Migration

- Data Validation

- Data Quality

DevOps & Version Control :

- Git

- CI/CD Pipelines

- Jenkins (Preferred)

Development Methodology :

- Agile

- Scrum

Required Qualifications :

- 5+ years of experience in Data Engineering.

- Strong hands-on experience with Python programming.

- Experience working with AWS cloud services.

- Strong expertise in Snowflake Data Warehouse.

- Hands-on experience with Teradata.

- Excellent SQL programming and query optimization skills.

- Experience building scalable ETL/ELT data pipelines.

- Good understanding of cloud-native data architectures.

- Strong analytical and problem-solving skills.

- Excellent communication and collaboration abilities.

Preferred Skills :

- Experience with Apache Airflow.

- Knowledge of Docker and Kubernetes.

- Experience with Terraform or Infrastructure as Code.

- Exposure to data orchestration tools.

- Experience with data visualization tools like Power BI or Tableau.

- Knowledge of REST APIs and JSON data processing.

- Experience working with US-based clients.