Know ATS Score
CV/Résumé Score
  • Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: Informatica ETL Lead Developer Remote.
United States Jobs Expertini

Urgent! Informatica ETL Lead Developer - Remote Job Opening In Bloomington – Now Hiring UnitedHealth Group

Informatica ETL Lead Developer Remote



Job description

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives.

The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best.

Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities.

Come make an impact on the communities we serve as you help us advance health optimization on a global scale.

Join us to start Caring.

Connecting.

Growing together.


We are seeking a highly experienced Informatica Extract Transform Load (ETL) Developer to join our Enterprise Data Warehouse (EDW) team.

This role is responsible for being a lead in designing, developing, and maintaining robust ETL processes using Informatica PowerCenter and Teradata.

The ideal candidate will have expert understanding of data integration, performance tuning, and data warehousing best practices, with a focus on supporting healthcare-related data systems.

The selected candidate will lead a small team of developers from a project delivery perspective while being responsible for their own development.

You’ll enjoy the flexibility to work remotely * from anywhere within the U.S. as you take on some tough challenges.

Primary Responsibilities:

  • Develop and lead the design and implementation of new and existing interfaces solutions using Informatica PowerCenter to extract, transform, and load data (ETL) from multiple data agency sources

  • Automate data staging processes and optimize ETL job scheduling for performance and efficiency

  • Learn and grow in business understanding to support development of ETL solutions

  • Administer and support ETL environments, including development and production systems

  • Perform repository backups, recovery operations, and system maintenance

  • Oversee and lead the development of mappings, mapplets, sessions, and workflows using a wide range of Informatica transformations

  • Monitor and troubleshoot ETL jobs across development, testing, and production environments

  • Write and optimize complex SQL queries and Unix Shell scripts for data marts and interfaces in Teradata

  • Collaborate with stakeholders to define requirements, document technical solutions, and support project planning

  • Participate in unit, integration, and system testing

  • Provide technical support, mentoring, and guidance to team members

  • Communicate project status and deliverables to leadership and clients

  • Continuously learn and apply new technologies to enhance system performance and capabilities
  • You’ll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.

    Required Qualifications:

  • 7+ years of experience with Informatica PowerCenter and ETL development

  • 5+ years of experience writing complex SQL and performance tuning

  • 5+ years of experience with Enterprise Relational Database Management systems (Teradata, DB2, Oracle, or SQL Server)

  • 3+ years of experience leading the design and implementation of ETL solutions using Informatica PowerCenter

  • 3+ years of Informatica PowerCenter administration experience

  • Proven solid communication, collaboration, and mentoring skills

  • Proven solid organizational and time management skills
  • Preferred Qualifications:

  • 5+ years of data warehouse development experience

  • 5+ years of data modeling experience using ERWIN or similar tools

  • 3+ years of Unix Shell (Bash/Korn) scripting experience

  • 2+ years of experience with Azure Data Factory and Snowflake

  • Experience with scripting languages such as Python, R, or JavaScript (React)

  • Experience with Medicaid, Medicare, or healthcare data systems

  • Experience working in Agile environments

  • Knowledge of BI and data integration technologies across relational and multidimensional systems

  • Familiarity with Informatica Data Quality (IDQ), Address Doctor, and Metadata Manager

  • Residing in or near Springfield, IL
  • *All employees working remotely will be required to adhere to UnitedHealth Group’s Telecommuter Policy.

    Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc.

    In addition to your salary, we offer benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and k contribution (all benefits are subject to eligibility requirements).

    No matter where or when you begin a career with us, you’ll find a far-reaching choice of benefits and incentives.

    The salary for this role will range from $89, to $, annually based on full-time employment.

    We comply with all minimum wage laws as applicable.


    Application Deadline: This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected.

    Job posting may come down early due to volume of applicants.

    At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone.

    We believe everyone–of every race, gender, sexuality, age, location and income–deserves the opportunity to live their healthiest life.

    Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes.

    We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes — an enterprise priority reflected in our mission.

    UnitedHealth Group is an Equal Employment Opportunity employer under applicable law and qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations.

    UnitedHealth Group is a drug - free workplace.

    Candidates are required to pass a drug test before beginning employment.


    Required Skill Profession

    Computer Occupations



    Your Complete Job Search Toolkit

    ✨ Smart • Intelligent • Private • Secure

    Start Using Our Tools

    Join thousands of professionals who've advanced their careers with our platform

    Rate or Report This Job
    If you feel this job is inaccurate or spam kindly report to us using below form.
    Please Note: This is NOT a job application form.


      Unlock Your Informatica ETL Potential: Insight & Career Growth Guide


    • Real-time Informatica ETL Jobs Trends in Bloomington, United States (Graphical Representation)

      Explore profound insights with Expertini's real-time, in-depth analysis, showcased through the graph below. This graph displays the job market trends for Informatica ETL in Bloomington, United States using a bar chart to represent the number of jobs available and a trend line to illustrate the trend over time. Specifically, the graph shows 448 jobs in United States and 5 jobs in Bloomington. This comprehensive analysis highlights market share and opportunities for professionals in Informatica ETL roles. These dynamic trends provide a better understanding of the job market landscape in these regions.

    • Are You Looking for Informatica ETL Lead Developer Remote Job?

      Great news! is currently hiring and seeking a Informatica ETL Lead Developer Remote to join their team. Feel free to download the job details.

      Wait no longer! Are you also interested in exploring similar jobs? Search now: .

    • The Work Culture

      An organization's rules and standards set how people should be treated in the office and how different situations should be handled. The work culture at UnitedHealth Group adheres to the cultural norms as outlined by Expertini.

      The fundamental ethical values are:
      • 1. Independence
      • 2. Loyalty
      • 3. Impartiality
      • 4. Integrity
      • 5. Accountability
      • 6. Respect for human rights
      • 7. Obeying United States laws and regulations
    • What Is the Average Salary Range for Informatica ETL Lead Developer Remote Positions?

      The average salary range for a varies, but the pay scale is rated "Standard" in Bloomington. Salary levels may vary depending on your industry, experience, and skills. It's essential to research and negotiate effectively. We advise reading the full job specification before proceeding with the application to understand the salary package.

    • What Are the Key Qualifications for Informatica ETL Lead Developer Remote?

      Key qualifications for Informatica ETL Lead Developer Remote typically include Computer Occupations and a list of qualifications and expertise as mentioned in the job specification. Be sure to check the specific job listing for detailed requirements and qualifications.

    • How Can I Improve My Chances of Getting Hired for Informatica ETL Lead Developer Remote?

      To improve your chances of getting hired for Informatica ETL Lead Developer Remote, consider enhancing your skills. Check your CV/Résumé Score with our free Tool. We have an in-built Resume Scoring tool that gives you the matching score for each job based on your CV/Résumé once it is uploaded. This can help you align your CV/Résumé according to the job requirements and enhance your skills if needed.

    • Interview Tips for Informatica ETL Lead Developer Remote Job Success
      UnitedHealth Group interview tips for Informatica ETL Lead Developer   Remote

      Here are some tips to help you prepare for and ace your job interview:

      Before the Interview:
      • Research: Learn about the UnitedHealth Group's mission, values, products, and the specific job requirements and get further information about
      • Other Openings
      • Practice: Prepare answers to common interview questions and rehearse using the STAR method (Situation, Task, Action, Result) to showcase your skills and experiences.
      • Dress Professionally: Choose attire appropriate for the company culture.
      • Prepare Questions: Show your interest by having thoughtful questions for the interviewer.
      • Plan Your Commute: Allow ample time to arrive on time and avoid feeling rushed.
      During the Interview:
      • Be Punctual: Arrive on time to demonstrate professionalism and respect.
      • Make a Great First Impression: Greet the interviewer with a handshake, smile, and eye contact.
      • Confidence and Enthusiasm: Project a positive attitude and show your genuine interest in the opportunity.
      • Answer Thoughtfully: Listen carefully, take a moment to formulate clear and concise responses. Highlight relevant skills and experiences using the STAR method.
      • Ask Prepared Questions: Demonstrate curiosity and engagement with the role and company.
      • Follow Up: Send a thank-you email to the interviewer within 24 hours.
      Additional Tips:
      • Be Yourself: Let your personality shine through while maintaining professionalism.
      • Be Honest: Don't exaggerate your skills or experience.
      • Be Positive: Focus on your strengths and accomplishments.
      • Body Language: Maintain good posture, avoid fidgeting, and make eye contact.
      • Turn Off Phone: Avoid distractions during the interview.
      Final Thought:

      To prepare for your Informatica ETL Lead Developer Remote interview at UnitedHealth Group, research the company, understand the job requirements, and practice common interview questions.

      Highlight your leadership skills, achievements, and strategic thinking abilities. Be prepared to discuss your experience with HR, including your approach to meeting targets as a team player. Additionally, review the UnitedHealth Group's products or services and be prepared to discuss how you can contribute to their success.

      By following these tips, you can increase your chances of making a positive impression and landing the job!

    • How to Set Up Job Alerts for Informatica ETL Lead Developer Remote Positions

      Setting up job alerts for Informatica ETL Lead Developer Remote is easy with United States Jobs Expertini. Simply visit our job alerts page here, enter your preferred job title and location, and choose how often you want to receive notifications. You'll get the latest job openings sent directly to your email for FREE!