Looking for local Irvine, CA based consujltsnts.
In-person interview required.
About R Systems:
R Systems is a leading digital product engineering company that designs and develops chip-to-cloud software products, platforms, and digital experiences that empower its clients to achieve higher revenues and operational efficiency. Our product mindset and engineering capabilities in Cloud, Data, AI, and CX enable us to serve key players in the high-tech industry, including ISVs, SaaS, and Internet companies, as well as product companies in telecom, media, finance, manufacturing, and health verticals. We Are Great Place to Work Certified in 10 countries with a full-time workforce [India, USA, Canada, Poland, Romania, Moldova, Indonesia, Singapore, Malaysia & Thailand]! We are recognized as one of the Best Tech Brands 2024 by the Times Group and India's Top 500 Value Creators 2023 by Dun & Bradstreet.
Company Link:
Job Description:
Title: ETL Developer / PL/SQL Specialist Informatica (On-Prem & Cloud)
Location: Irvine, CA (Onsite) - In- person interview
ETL Developer / PL/SQL Specialist with 9 10 years of experience in enterprise data integration and data warehousing environments. This role requires deep hands-on expertise in PL/SQL development, strong experience with Informatica (On-Prem and Cloud), and the ability to act as a functional consultant by engaging directly with business stakeholders. The candidate will also provide technical oversight to offshore teams, ensuring high-quality delivery aligned with architectural and performance standards.
9 10 years of experience in ETL development, data warehousing, and enterprise database engineering with strong PL/SQL expertise.
Architect and develop complex PL/SQL solutions (procedures, packages, triggers, dynamic SQL) with advanced performance tuning and optimization.
Design and implement scalable ETL solutions using Informatica PowerCenter (On-Prem) and Informatica Intelligent Cloud Services (IICS).
Build and optimize mappings, workflows, and transformations for large-scale data warehouse environments.
Engage directly with business stakeholders to gather requirements and translate them into technical ETL and database designs.
Provide technical oversight and code reviews for offshore teams, ensuring quality, standards compliance, and timely delivery.
Support data quality, validation, reconciliation, production monitoring, troubleshooting, and release management activities.
Strong foundation in Oracle databases, dimensional modeling, ETL best practices, Unix/Linux environments, and batch scheduling tools.
Why Join R Systems?
- Frequent Internal Hackathons: Engage in dynamic competitions with exciting prizes to keep your skills sharp.
- Cultural Celebrations: Strengthen our familial bonds through shared celebrations, fostering a sense of community.
- Diverse Project Exposure: Work on a variety of projects across sectors like Healthcare, Banking, e-commerce, and Retail, collaborating with leading global brands.
- Centre of Excellence (COE): Benefit from technical guidance and upskilling opportunities provided by our team of technology experts, helping you navigate your career path.
- E-Learning Platform: Gain access to comprehensive e-learning platforms coupled with a robust mentorship program to enhance your skills.
- Open Door Policy: Embrace a culture of mutual support, respect, and open dialogue, promoting a collaborative work environment.
If you are passionate and excited about working in a fast-paced, innovative environment, we would love to hear from you!
#LI-AP2
R Systems is an equal opportunity employer that does not discriminate against any employee or job applicant because of race, color, religion, national origin, sex, physical or mental disability, age, or any other characteristic protected by law. We strive to build a team that reflects the diverse communities we serve, and we actively encourage applications from individuals of all backgrounds and experiences. Our commitment to equal opportunity extends to all aspects of employment, including recruitment, hiring, training, promotion, and benefits.
Employers have access to artificial intelligence language tools ( AI ) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Never miss an opportunity! Create an alert based on the job you applied for.
