Enterprise ETL And Apache Kafka Data Integration Specialist
An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.
Posted over 15 days ago, so the role may have closed. Confirm on the employer's page when you apply, or see similar jobs.
Job Description
What role will you play in the team
You will serve as an essential data integration specialist dedicated to building resilient enterprise-grade data pipelines. Your primary focus centers on unifying disparate enterprise databases into centralized data warehouses using advanced ETL frameworks and real-time messaging systems to drive downstream analytical models.
What you will do
You will engineer, test, and deploy complex data integration workflows using Informatica, Talend, and Apache Kafka. You will cleanse, transform, and load massive streams of structured and unstructured data, ensuring strict data fidelity, low-latency delivery, and comprehensive error-handling mechanisms across all production pipelines.
Key responsibility
- Develop and maintain high-performance ETL workflows utilizing Informatica and Talend for enterprise data warehousing.
- Establish real-time data streaming architectures using Apache Kafka and Apache Nifi for continuous ingestion.
- Write highly optimized SQL queries, stored procedures, and database triggers for MySQL and PostgreSQL systems.
- Perform rigorous data profiling, cleansing, and validation to ensure absolute integrity across all integrated data sources.
- Integrate API endpoints and webhooks to synchronize third-party SaaS data into central analytical repositories.
- Document end-to-end data lineage, mapping specifications, and pipeline operational runbooks for compliance.
Required Qualification and Skills
- Bachelor's degree in Information Technology, Software Engineering, or related quantitative discipline.
- Minimum of 0 to 1 years of professional experience specializing in ETL Tools, Informatica, Talend, and Apache Kafka.
- Proficiency in Database Management, SQL, PostgreSQL, MySQL, and MongoDB environments.
- Familiarity with Big Data Technologies including Hadoop and Spark for distributed data handling.
- Working knowledge of Python for scripting automation and API data extraction tasks.
- Strong problem-solving abilities with keen attention to data schema design and performance tuning.
Benefits Included
- Performance-linked annual incentives and quarterly merit bonuses.
- Dedicated learning budget for advanced courses in data engineering, cloud platforms, and ETL optimization.
- Supportive work environment with regular team-building events and recreational facilities.
- Paid time off, sick leaves, and structured retirement contribution schemes.
A Day in the Life
Your morning involves monitoring Kafka message queues and resolving failed Informatica data transformation tasks. Afterward, you will design a new data ingestion workflow for a newly acquired client database using Talend. The afternoon is dedicated to writing optimized SQL scripts and collaborating with database administrators on indexing strategies.
Skills
SQLPostgreSQLMySQLMongoDBBig Data TechnologiesHadoopSparkApache KafkaInformaticaTalendPythonIf a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.
About Company
Jobaaj is India’s premier job portal, offering a comprehensive suite of services that include recruitment, training, placements, and career management solutions. With a dedicated focus on the Accounting, Finance, Data, and Consulting sectors, Jobaaj bridges the gap between skilled professionals and dynamic opportunities. Through an innovative approach and a commitment to excellence, Jobaaj ensures that job seekers and employers alike find the perfect match to drive mutual success.
Guided by a vision to create a close-knit professional community, Jobaaj aspires to help one crore individuals secure their dream jobs by 2030. By combining industry expertise with in-house tools like AI-powered portals, Resume Builder, and LinkedIn Optimizer, the platform provides candidates with the resources needed to stand out in an increasingly competitive job market. Jobaaj also offers mentorship programs and skill-enhancement training, equipping individuals with the knowledge and experience required to excel in their chosen fields.
Under the leadership of an experienced team, Jobaaj operates as a holistic ecosystem that goes beyond traditional job portals. From guiding students in identifying their ideal career domains to offering hands-on internships and facilitating placements, Jobaaj delivers a seamless journey for professionals at every stage. This unique approach, supported by years of firsthand industry experience, ensures personalized solutions that cater to the specific needs of clients and candidates.
Ranked as one of India’s top job portals, particularly in the Finance and Accounting sectors, Jobaaj stands out as a trusted platform for both job seekers and recruiters. With a mission to revolutionize the recruitment landscape, Jobaaj continues to expand its connected ecosystem, creating value for its community and shaping the future of employment in India.
Similar Jobs
View allNew Data Science Analytics & Machine Learning roles in Jaipur.
One email a day. Unsubscribe any time.

