Data Integration Engineer

Innova Solutions is immediately hiring a Data Integration Engineer Position type: Permanent Duration: Fulltime Location: New York, US As a Data Integration Engineer, you will: We are seeking a skilled Data Integration Engineer with expertise in integrating databases, optimizing ETL processes, and implementing best practices for data management. The ideal candidate will have deep experience with MongoDB, along with proficiency in data modeling, query optimization, and performance tuning. You will play a critical role in designing, developing, and maintaining data integration pipelines that support efficient data movement and transformation across multiple systems Design and implement ETL (Extract, Transform, Load) processes to integrate data from diverse sources into MongoDB and other database systems. Develop and optimize MongoDB queries, indexes, and aggregations for performance and scalability. Collaborate with software engineers, data scientists, and business analysts to ensure seamless data flow and integration Implement best practices for database design, data normalization, and denormalization in MongoDB. Monitor, troubleshoot, and resolve performance issues related to database queries, indexing, and sharding. Work with schema design and data modeling for efficient storage and retrieval in MongoDB. Ensure data quality, consistency, and security across integrated systems. Develop and maintain documentation for data pipelines, integrations, and workflows. Stay up to date with MongoDB features, updates, and industry best practices to continuously improve data architecture. The Ideal Candidate must have: 3+ years of experience in data integration, ETL development, or database engineering. Strong hands-on experience with MongoDB, including data modeling, indexing, and aggregation framework. Proficiency in ETL tools and frameworks (e.g., Apache NiFi, Talend, Airflow, or custom scripts using Python). Solid understanding of query optimization techniques for high-performance data retrieval. Experience integrating structured and unstructured data from various sources (e.g., SQL, NoSQL, APIs, streaming data). Strong programming skills in Python, Java, or JavaScript for data processing. Knowledge of cloud platforms (AWS, Azure, GCP) and database scaling strategies. Experience working with JSON, BSON, and document-based data structures. Familiarity with data security, governance, and compliance best practices. Preferred/Desirable Skill MongoDB certification (e.g., MongoDB Developer or DBA Certification). Experience with data warehousing and BI tools (e.g., Snowflake, Power BI, Tableau). Familiarity with Kafka, Spark, or other real-time data processing frameworks. Knowledge of relational databases (e.g., PostgreSQL, MySQL, SQL Server) and hybrid database architectures Qualified candidates should APPLY NOW for immediate consideration! Please hit APPLY to provide the required information, and we will be back in touch as soon as possible. We are currently interviewing to fill this and other similar positions. If this role is not a fit for you, we do offer a referral bonus program for referrals that we successfully place with our clients, subject to program guidelines. ASK ME HOW. Thank you! Karthik Saraswathi Senior Manager PAY RANGE AND BENEFITS: Pay Range: $ 115,500 - 135,500 $ Per Year Pay range offered to a successful candidate will be based on several factors, including the candidate's education, work experience, work location, specific job duties, certifications, etc. Benefits: Innova Solutions offers benefits( based on eligibility) that include the following: Medical & pharmacy coverage, Dental/vision insurance, 401(k), Health saving account (HSA) and Flexible spending account (FSA), Life Insurance, Pet Insurance, Short term and Long term Disability, Accident & Critical illness coverage, Pre-paid legal & ID theft protection, Sick time, and other types of paid leaves (as required by law), Employee Assistance Program (E P). ABOUT IN