Senior Data Developer
Pay Rate: $66.00 - $70.00 Negotiable based upon years of experienceGlobal Financial Firm located in Irving, TX has an immediate contract opportunity for an experienced Senior Data DeveloperResponsibilities:
- 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.
- Bachelor'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.
- Experience 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.
