Data Integration Engineer
Role details
Job location
Tech stack
Job description
- 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.
Requirements
- We are seeking a skilled Data Integration Engineer with expertise in integrating databases, optimizing ETL processes, and implementing best practices for data management., * 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
Benefits & conditions
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 (EAP).