Data Engineer Jobs in USA, TX, Irving | Rose International Job

We are seeking a highly experienced Senior Data Developer to join our technology team. With 5-10 years of experience, the ideal candidate will be an expert in designing and developing data solutions across both Oracle (relational) and MongoDB (NoSQL) environments. This role is a hybrid of data modeling and hands-on development, requiring a deep understanding of how to structure data effectively and the technical skills to build, optimize, and maintain the database code that interacts with it. You will be a key player in ensuring our data architecture is robust, scalable, and perfectly aligned with our application and business needs.

Data Modeling and Design:

Design, develop, and maintain conceptual, logical, and physical data models for both Oracle and MongoDB platforms.

Translate complex business requirements into efficient and scalable relational (Oracle) and document-based (MongoDB) data structures.

Create and manage data dictionaries, ensuring clear documentation of data elements, relationships, and lineage.

Database Development:

Develop complex and efficient

SQL, PL/SQL

packages, stored procedures, functions, and triggers in an Oracle environment.

Write sophisticated queries, including complex joins, subqueries, and analytical functions to support application logic.

Develop and optimize queries and aggregation pipelines in MongoDB (MQL) to support high-performance application features.

Performance Tuning and Optimization:

Proactively monitor, analyze, and optimize database performance in both Oracle and MongoDB.Analyze query execution plans, create appropriate indexes, and refactor code to ensure optimal efficiency and response times.

Work closely with application developers to guide them on best practices for database interaction and query writing.

Data Integration and Management:

Design and build ETL processes and data pipelines for moving and transforming data between Oracle, MongoDB, and other enterprise systems.

Ensure the integrity, consistency, and security of data across all platforms.

Assist with data migration strategies and execution.

Required QualificationsBachelor's degree in Computer Science, Information Technology, or a related field.5-10 years of progressive experience in a data-centric development role.

Expert-level proficiency in Oracle, including advanced SQL and PL/SQL development.

Strong, hands-on experience with MongoDB, including data modeling, MQL, and the aggregation framework.

Proven experience in data modeling, with a portfolio of projects demonstrating skills in both relational and NoSQL design.

Strong analytical and problem-solving skills, with a talent for identifying and resolving complex data-related issues.

Ability to work independently and collaboratively in a fast-paced, agile environment.

Preferred SkillsExperience with data modeling tools such as Erwin, ER/Studio, or Lucidchart.

Knowledge of cloud database services (e.g., Oracle Cloud, MongoDB Atlas, AWS RDS).Proficiency in a scripting language like Python or Bash for automation.

Experience with ETL tools (e.g., Informatica, Talend, SSIS).Familiarity with version control systems, particularly Git.

Experience in the financial services or banking industry is a plus.•Only those lawfully authorized to work in the designated country associated with the position will be considered.•Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.•