Senior Informatica / SQL Developer
Through our dedicated associates, Conduent delivers mission-critical services and solutions on behalf of Fortune 100 companies and over 500 governments - creating exceptional outcomes for our clients and the millions of people who count on them. You have an opportunity to personally thrive, make a difference and be part of a culture where individuality is noticed and valued every day. Position Summary We are seeking a highly skilled Informatica/SQL Developer with at least 9 years of hands-on experience in building, optimizing, and supporting complex ETL solutions. The ideal candidate will be proficient in Informatica PowerCenter (9.x / 10.4), Oracle/PL-SQL, ETL automation, and end-to-end data analysis. Healthcare domain experience is a strong plus.
Key Responsibilities
- Design, develop, and maintain Informatica PowerCenter ETL workflows, mappings, and sessions.
- Perform complex data analysis, data profiling, and root cause investigation for data quality issues.
- Develop high-performance Oracle SQL and PL/SQL procedures, functions, and packages.
- Optimise, troubleshoot, and tune ETL jobs and database queries for maximum performance.
- Implement and enhance automation of ETL processes, including scheduling, monitoring, and exception handling.
- Work across the full Waterfall SDLC, including requirements analysis, design, development, testing, deployment, and production support.
- Collaborate with business analysts, QA, architects, and other stakeholders to deliver accurate and reliable data solutions.
- Prepare technical documentation, mapping sheets, job design documents, and support guides.
- Provide on-call support for production ETL jobs as required.
Required Qualifications
- 9+ years of experience in ETL development using Informatica PowerCenter (9.x / 10.4).
- Strong expertise in Informatica workflows, mappings, transformations, and performance tuning.
- Advanced skills in SQL and Oracle PL/SQL.
- Strong understanding of data warehousing concepts and dimensional modeling.
- Experience with ETL job automation, scheduling tools, and monitoring frameworks.
- Solid experience working in Waterfall SDLC environments.
- Strong analytical and problem-solving skills with the ability to work on complex data issues.
- Excellent communication and documentation skills.
Preferred Qualifications
- Informatica PowerCenter certification.
- Experience with Unix shell scripting or other automation tools.
- Exposure to version control tools such as Git, SVN, or Bitbucket.
Education
- Bachelor’s degree in Computer Science, Information Technology, Engineering, or related field.
Pay Transparency Laws in some locations require disclosure of compensation and/or benefits-related information. For this position, actual salaries will vary and may be above or below the range based on various factors including but not limited to location, experience, and performance. In addition to base pay, this position, based on business need, may be eligible for a bonus or incentive. In addition, Conduent provides a variety of benefits to employees including health insurance coverage, voluntary dental and vision programs, life and disability insurance, a retirement savings plan, paid holidays, and paid time off (PTO) or vacation and/or sick time. The estimated salary range for this role is $96,250 - $125,000 Conduent is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, creed, religion, ancestry, national origin, age, gender identity, gender expression, sex/gender, marital status, sexual orientation, physical or mental disability, medical condition, use of a guide dog or service animal, military/veteran status, citizenship status, basis of genetic information, or any other group protected by law. For US applicants: People with disabilities who need a reasonable accommodation to apply for or compete for employment with Conduent may request such accommodation(s) by submitting their request through this form that must be downloaded: click here to access or download the form. Complete the form and then email it as an attachment to [email protected]. You may also click here to access Conduent's ADAAA Accommodation Policy. Apply tot his job Apply To this Job