Enterprise ETL and Apache Kafka Data Integration Specialist

What role will you play in the teamYou 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 doYou 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 responsibilityDevelop 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 SkillsBachelor'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 IncludedIndustry-standard medical insurance plan covering comprehensive family health and accidental benefits.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 LifeYour 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. .