Data Engineer

Data Engineer

Design, develop, and maintain data solutions for data generation, collection, and processing. Create data pipelines, ensure data quality, and implement ETL (extract, transform, and load) processes to migrate and deploy data across systems.

Must have skills: Amazon Athena, PySpark

Minimum 3 years of experience is required

15 years full time education is required

As a Data Engineer, you will design, develop, and maintain data solutions that facilitate data generation, collection, and processing. Your typical day will involve creating data pipelines, ensuring data quality, and implementing ETL processes to migrate and deploy data across various systems. You will collaborate with cross-functional teams to understand data requirements and contribute to the overall data strategy of the organization, ensuring that data solutions are efficient, scalable, and aligned with business objectives.

We are looking for a skilled Data Engineer to join a data migration project. In this developer-focused role, you will build and optimize ETL pipelines to migrate and transform data from legacy on-prem systems to AWS, leveraging native AWS transformation technologies.

Key Responsibilities:

• Implement end-to-end ETL pipelines using AWS native services like Athena, Step Function, EventBridge, Glue (PySpark, SQL), and Lambda for data extraction, transformation, and loading.
• Use pre-created utility for seamless migration, handling high-volume datasets with error handling and retry mechanisms.
• Collaborate with the Solution Designer to test pipelines for performance, and deploy with help of DevOps engineer.
• Monitor and troubleshoot pipelines using CloudWatch, optimize for cost and process scalability, and document code for team handover.
• Support data quality validation and incremental loads to maintain data integrity during the hydration process.
• Engage with multiple teams and contribute on key decisions. Provide solutions to problems for their immediate team and across multiple teams.

Professional & Technical Skills:

• Proficiency in AWS Athena, AWS Glue, Pyspark, SQL, ETL, Unix, Iceberg, Astronomer, DW concepts
• Strong understanding of data pipeline architecture and design principles.
• Experience with data warehousing solutions and ETL processes.
• Familiarity with cloud computing services and data storage solutions.
• Ability to troubleshoot and optimize data workflows for performance.

Additional Information:

• The candidate should have minimum 3 years of experience in Amazon Athena.
• This position is based at our Pune office.
• A 15 years full time education is required.

Equal Employment Opportunity Statement

We believe that no one should be discriminated against because of their differences. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, military veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by applicable law. Our rich diversity makes us more innovative, more competitive, and more creative, which helps us better serve our clients and our communities.