What are the responsibilities and job description for the Ab Initio ETL Developer :: Hybrid :: W2 Position position at Trebecon LLC?
Role: Ab Initio ETL Developer
Location: Morris Plains, NJ -Hybrid
Experience: 8 Years
Job Summary
We are seeking a highly skilled Ab Initio ETL Developer with strong expertise in data engineering, Kafka, and Python development. The ideal candidate will have hands-on experience building scalable ETL pipelines, working with large datasets, and supporting data integration initiatives in pricing or related business domains.
The candidate should possess excellent problem-solving abilities, strong communication skills, and the capability to collaborate effectively with cross-functional teams in a fast-paced environment.
Key Responsibilities
- Design, develop, and maintain ETL workflows using Ab Initio.
- Build scalable and high-performance data integration pipelines.
- Work with Kafka for real-time data streaming and event-driven architectures.
- Develop automation and data processing scripts using Python.
- Perform data extraction, transformation, validation, and loading activities.
- Collaborate with business and technical teams to gather requirements and deliver data solutions.
- Ensure data quality, performance optimization, and system reliability.
- Support troubleshooting, debugging, and production issue resolution.
- Participate in code reviews, documentation, and best practice implementation.
- Work on pricing or similar business data domains to support analytics and reporting initiatives.
Required Skills
- Strong hands-on experience in Ab Initio ETL development.
- Experience with Kafka and real-time data processing.
- Strong Python scripting/programming skills.
- Solid understanding of data engineering concepts and ETL architecture.
- Experience with SQL and relational databases.
- Knowledge of data validation, performance tuning, and optimization techniques.
- Strong analytical and problem-solving skills.
- Excellent verbal and written communication skills.
Preferred Skills
- Experience in pricing, financial, retail, or similar data domains.
- Exposure to cloud platforms and modern data architectures.
- Experience with Agile development methodologies.