Informatica developer Jobs in Irving, TX

Grow your career as a Data Developer with an innovative global bank in Irving, TX. Contract role with strong possibility of extension and/or conversion. Will require working a hybrid schedule 2-3 days onsite per week. *Not open to third party employment or sponsorship*

Join one of the world's most renowned global banks and trusted brand with over 200 years of continuously evolving financial services worldwide. You will work alongside some of the smartest minds in the industry who are excited to share their knowledge and to learn from you.

Contract Duration: 6+ Months

Required Skills & Experience

• 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.

Desired Skills & Experience

• 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.

What You Will Be Doing

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.