15 Oct
|
ADP Private
|
Hyderabad
15 Oct
ADP Private
Hyderabad
Job Summary
We are seeking a skilled Data Engineer to join our team, specializing in building and maintaining modern data pipelines using ETL/ELT methodologies. The ideal candidate will have extensive experience in transforming unstructured data into structured datasets, creating CI/CD automation, and ensuring high-quality, validated data for analytical purposes.
Key Responsibilities
- Data Pipeline Development: Design, develop, and maintain robust ELT pipelines using databricks as Mandate.
- Data Modeling & Transformation: Apply advanced SQL techniques (CTE’s, Window functions, joins, aggregations) to build clean, actionable, and scalable data models.
- Automation & CI/CD: Develop and maintain automated CI/CD deployment pipelines for dbt projects using Git to ensure smooth production deployments.
- Data Quality & Validation: Perform comprehensive validation between source and target tables, utilizing Q-Test for test case creation, execution, and defect tracking.
- Automation:
Python scripts for validation and automation.
- Version Control: Git, Pull requests, Code reviews.
- Data Migration: Hands-on experience with migrating data between heterogeneous systems (Excel, Flat Files, XML, JSON) and SQL servers.
- Analytical Skills: Strong problem-solving skills with the ability to adapt quickly in quick-paced environments.
- Production Support: Troubleshoot and resolve production issues, data discrepancies, and job failures to ensure data reliability.
- Stakeholder Collaboration: Coordinate with business users and stakeholders to gather requirements and translate them into technical solutions.
- Documentation: Create technical documentation, demo documents, and wiki pages for all developed jobs and queries.
- Cloud Platform: AWS
Visualization: Databricks / React (Nice to have) / APIs for react
📌 AWS Data Engineer (Hyderabad)
🏢 ADP Private
📍 Hyderabad