Specialist - Data Engineering

LTIMindtree • Dallas, TX

66d

About The Position

Seeking a Senior Specialist with 7 to 11 years of experience in Oracle PLSQL and ANSISQL to develop and optimize database solutions. The role involves developing, maintaining, and optimizing complex PLSQL programs and scripts using Oracle PLSQL and ANSISQL standards. The specialist will design and implement efficient database solutions to support business requirements, perform data analysis and validation to ensure data integrity and accuracy, and collaborate with cross-functional teams to gather requirements and translate them into technical specifications. Additionally, the role requires utilizing Dimensional Data Modeling techniques to enhance data warehousing and reporting capabilities, monitoring and tuning database performance to ensure high availability and reliability, and documenting database designs, processes, and procedures to maintain a knowledge base and support compliance. Staying updated with the latest developments in Oracle DB technologies and best practices is also essential.

Requirements

• 7 to 11 years of experience in Oracle PLSQL and ANSISQL.
• Experience in developing, maintaining, and optimizing complex PLSQL programs.
• Strong understanding of Dimensional Data Modeling techniques.
• Ability to perform data analysis and validation.
• Experience in monitoring and tuning database performance.

Nice To Haves

• Experience with MS SQL.
• Familiarity with Flexcube technical.
• Knowledge of performance tuning and shell scripting.

Responsibilities

• Lead the development and implementation of PLSQL packages, procedures, and functions.
• Conduct code reviews and provide guidance to junior team members on best coding practices.
• Troubleshoot and resolve complex database issues and performance bottlenecks.
• Collaborate with data architects and business analysts to design dimensional models that support analytics.
• Participate in database migration, upgrade, and patching activities.
• Ensure adherence to coding standards, security policies, and compliance requirements.
• Mentor and train team members to enhance their skills in Oracle PLSQL and data modeling.
• Coordinate with stakeholders to prioritize and manage database development tasks effectively.

What This Job Offers

• Career Level: Senior
• Industry: Professional, Scientific, and Technical Services
• Number of Employees: 5,001-10,000 employees