Informatica​/Oracle Developer - Hybrid

Responsibilities

• Design, implement and perform performance tuning of Informatica ETL processes.
• Develop, modify PL/SQL queries, SQL views, stored procedures, database triggers, and SQL queries in Oracle.
• Create and modify database tables based on business requirements and specifications.
• Perform performance tuning and understand explain plans.
• Handle normalization, renormalization and star schema modeling.
• Develop and run unit test cases and perform unit testing.
• Work independently with minimum supervision.
• Coordinate with a distributed team.
• Communicate status updates regularly to management.
• Work on a W2 basis without sponsorship (no C2C).

• Informatica ETL
• Oracle PL/SQL
• Data modeling and data warehousing
• Python (optional)
• Experience with Oracle database (including explain plans, normalization, star schema)

• Charlotte, NC or Dallas, TX (Hybrid: 3 days on-site per week)

Expert level.

We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. We are an Allegis Group company specializing in full‑stack technology services and talent services. We help clients activate ideas and solutions to take advantage of new opportunities.

The company is an equal‑opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.