Overview
Skills
Job Details
Job Title: PL/SQL Informatica Developer
Location: Charlotte, NC Onsite Only (No Remote)
Interview Locations: Dallas, TX or Charlotte, NC (in-person)
Contract Rate: $55/hr
Visa Policy: No OPT/CPT allowed
Role Overview
We are seeking a skilled PL/SQL Informatica Developer to join clients Technology team on-site in Charlotte, NC. This role emphasizes the design, development, and deployment of ETL solutions using Informatica and PL/SQL, while adhering to compliance and process standards typical of financial institutions.
Key Responsibilities
- Design, develop, test, and optimize ETL workflows using Informatica PowerCenter or Informatica IDMC and Oracle PL/SQL, ensuring data accuracy and performance.
- Define technical specifications and translate business requirements into efficient PL/SQL code, complex queries, stored procedures, and performance-tuned operations.
- Ensure adherence to quality, security, and compliance policies throughout the development lifecycle.
- Participate in system upgrades, deployments, and production support; may require support during off-hours or weekends during critical deployments.
- Assist less experienced team members by providing troubleshooting support, code reviews, and technical guidance.
- Support integration projects across data warehouse environments and engage with cross-functional teams (e.g., business analysts, QA, infrastructure) to ensure seamless delivery.
Required Qualifications
- At least 4 5+ years of software development experience, including substantial work in Informatica (PowerCenter/IDMC) and Oracle PL/SQL development.
- Proficiency in writing and optimizing complex SQL queries, stored procedures, and managing large-scale data operations.
- Proven capability to maintain code quality, security, and compliance standards, especially within regulated industries like banking.
- Strong debugging and issue resolution skills, including production troubleshooting and ETL pipeline support.
- Experience with technical documentation and technical specifications for enterprise systems.
Preferred Qualifications
- Prior experience in the financial services industry.
- Exposure to Agile methodologies and familiarity with modern DevOps practices (version control, CI/CD).
- Experience with UNIX/Linux scripting and scheduling tools like Autosys or similar platforms.
Summary Table
Attribute | Details |
Rate | $55/hr |
Location | Charlotte, NC (Onsite only) |
Interview | In-person in Dallas, TX or Charlotte, NC |
Visa Eligibility | No OPT/CPT candidates accepted |
Primary Skills | Informatica (PowerCenter/IDMC), Oracle PL/SQL, ETL, SQL tuning |
Desirable Experience | Financial services, Agile/DevOps, scripting, enterprise compliance |