ETL developer Job at Ampcus, Orlando, FL

  • Ampcus
  • Orlando, FL

Job Description

Job-ID32874748Reference26-13494Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.Strong Key Skills:SQL, Snowflake, Python, Good communicationRole Overview:As a Development Lead, you will drive the end-to-end lifecycle of data ingestion, transformation, and distribution.You will provide onsite presence and technical leadership to offshore team, enforce best practices for code quality and testing, collaborate with enterprise architects to align data pipelines with critical business intelligence and analytics requirements.You will also be working hands-on developing critical data pipeline artefacts.Key Responsibilities:Develop data/ETL pipelines and assess review the artefacts generated by a team of Data Engineers working from Offshore. Conduct code reviews, facilitate agile ceremonies, and oversee project delivery timelines.Design scalable, robust, and fault-tolerant batch and real-time data ingestion pipelines. Establish coding standards and integration design patterns.Oversee the Extraction, Transformation, and Loading (ETL) or Streaming Data processes across heterogeneous source systems (e.g., APIs, relational databases, flat files, and cloud storage) to centralized data warehouses and data lakes.Implement data profiling, Data reconciliation processes, validation frameworks, and automated testing procedures to ensure data integrity, consistency, and compliance.Partner with data architects, Data admins, product owners, and business analysts to translate complex business requirements into technical specifications.Troubleshoot critical data pipeline bottlenecks, optimize SQL queries, and manage incident resolution.Required Qualifications:Bachelor’s degree in computer science, Information Technology, or a related field.6+ years of experience in data warehousing, data engineering, or ETL/ELT development, with at least 1–2 years in a technical lead or senior engineering capacity.Advanced proficiency in SQL and scripting languages like Python or Java.Hands-on experience with modern data integration platforms (e.g., AWS Glue, Apache Spark, or Kafka).Deep understanding of data modeling (snowflake schemas), real-time streaming architectures, and performance tuning large datasets.Exceptional communication, stakeholder management, and project management capabilities.Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.

Job Tags

Similar Jobs

Glens Falls Hospital

Nuclear Medicine Technologist (Sign-On Bonus for Full-Time & Part-Time Positions, Shift-Differential Job at Glens Falls Hospital

 ...daytime hours and effortless access to top-notch outdoor recreation. Why Choose Glens Falls Hospital? Stable Schedule: Full-time, Monday-Friday, 8:00 AM - 4:00 PM. No...  ...competitive benefits offerings, as it is a core part of providing a strong overall employee... 

The Wellington Agency

Full-time live-in Nanny Job at The Wellington Agency

 ...Full-Time Live-In Nanny Needed In Wellington, Florida Couple is seeking an experienced, and engaging full-time live-in nanny for their children in Wellington, Florida. The nanny will provide attentive, loving care for two young children, ages 3 years and 8 months.... 

Virtual Vocations Inc

Executive Functioning Coach Job at Virtual Vocations Inc

 ...Seeking an experienced Executive Functioning Coach for a part-time remote position, where the specialist will provide individualized coaching to clients, focusing on enhancing their organization, planning, and time management skills while maintaining professional boundaries... 

Delta Workforce

Recruiter (Remote) Job at Delta Workforce

 ...Delta Workforce is a staffing agency specializing in the manufacturing sector. We are currently seeking a Recruiter to help us fill open positions and support our clients across Michigan. Key Responsibilities: Conduct phone interviews to screen and qualify candidates... 

Virtual Vocations Inc

Executive Function Coach Job at Virtual Vocations Inc

 ...To support the development of lifelong learning skills, the part-time Learning Coach will conduct small group workshops and coaching sessions for parents of students in grades 3-12, leveraging evidence-based programs and strategies in a remote contract role.Key responsibilities...