The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.
M8y57q5xl50dzv1104k

ETL Developer-Informatica

Job Description

ETL Developer-Informatica (IT -- Managed Care)

JOB DESCRIPTION

ETL Developers -- are you looking for a rewarding new position with an industry leader with a firm commitment to its employees? Join our team at MultiPlan! Founded in 1980, MultiPlan is a trusted partner to over 700 healthcare payers in the commercial health, property and casualty, and government markets, and saves these companies more than $14 billion annually. Approximately 50 to 75 million people have access to MultiPlan's PPO provider networks, which comprise 1.4 million healthcare providers nationwide.

We are currently seeking an experienced ETL Developer to work in either our Rockville, MD office or Bedford, MA office. We offer competitive compensation and fantastic benefits, as well as a collegial workplace in a business-casual dress environment. You'll also find plenty of options for professional development and advancement with us. If this sounds like the kind of career move you've been wanting to make, and if you meet our qualifications, we want to talk with you!

JOB RESPONSIBILITIES

The Informatica ETL Developer will be part of the ETL team responsible for developing and deploying Informatica ETL solutions. Primary responsibility will be to work closely with the Data Architects and ETL Architect to implement ETL solutions for the organization using Informatica, create technical specification documents and create test plans. Also provide bi-weekly on call support for the data warehouse backend jobs.

Your specific duties in this role will include:

  1. Develop Informatica objects - mappings, sessions, and workflows based on the prepared low level design documents.
  2. Debug mappings and identify errors and error rows so that they can be corrected and re-loaded into a target system.
  3. Review and analyze functional requirements and mapping documents.
  4. Performance tuning of Informatica Mappings, processes, and load routines.
  5. Technical coordination of cross-functional projects as assigned and interacts with all areas of the organization to achieve timely results.
  6. Provide off-hours and weekend support as needed.
  7. Collaborate, coordinate, and communicate across disciplines and departments.
  8. Ensure compliance with HIPAA regulations and requirements.
  9. Demonstrate Company's Core Competencies and values held within.
  10. The position responsibilities outlined above are in no way to be construed as all encompassing. Other duties, responsibilities, and qualifications may be required and/or assigned as necessary.

 

Job Requirements

JOB REQUIREMENTS

As an ETL Developer, you must be highly organized and detail-oriented, with strong analytical, problem solving, and prioritization skills. You should also be able to handle multiple tasks in a fast-paced, deadline-driven environment, both independently and as part of a team. It is also important that you display excellent verbal and written communication and interpersonal skills, as well as the ability to effectively present information and respond to questions from groups of managers and clients

Specific qualifications for the role include:

  • Minimum Bachelor's Degree
  • Minimum 5 years of Informatica and Relational Database experience.
  • 5+ years of experience working with large Enterprise Data Warehouse projects in the role of Informatica ETL developer.
  • Minimum 2 years experience of performing data analysis
  • Experience with or knowledge of Data Warehousing, reporting methodologies/ techniques and Business Intelligence reporting
  • Experience working with complex sql queries like Hierarchical, Aggregate Queries
  • Experience working with different database objects like tables, views, materialized views and partitions
  • Experience with SQL Server / Oracle databases
  • Solid working experience in Informatica Power Center.
  • Experience with Informatica IDQ and Informatica power exchange is a plus
  • Experience with many of the transformations of Informatica including complex lookups, stored procedures, update strategy, mapplets, etc.
  • Experience in gathering requirements, analyzing data, provide gap analysis and creating detail design documents and mapping documents.
  • Extensive knowledge of the Systems Development Life Cycle (SDLC) activities specific to data warehousing, data engineering solutions, data methodologies and software tools, including Informatica
  • Working knowledge of SQL, PL/SQL, UNIX Shell scripting.
  • Working knowledge of schedulers such as Autosys or Control M
  • Knowledge of health insurance industry is a plus
  • Communication (written, verbal and listening), organizational, prioritization, data analysis, planning, problem-solving and decision-making skills
  • Ability to quickly attain and understand new processes with strict attention to detail
  • Ability to meet strict deadlines, work on multiple tasks and work well under pressure
  • Ability to analyze data and arrive at a logical conclusion
  • Ability to assess ramification of issues and prioritize tasks based on business impact
  • Ability to use software, hardware and peripherals related to job responsibilities, including MS Office and software development applications
  • Must be able to work independently and have the ability to gain understanding of requirements/data specifications and any data discrepancies from interaction with others.
  • Effective interpersonal relations skills, ability to effectively collaborate with others and work as part of a team required.
  • Ability to work in a fast-paced and demanding environment
  • Ability to use software, hardware and peripherals related to job responsibilities, including MS Office and software development applications

BENEFITS

As an ETL Developer with MultiPlan, you will be part of an organization with a proud 30-year legacy of experience and growth. We realize that our employees are instrumental to our success, and we reward them accordingly with very competitive compensation and benefits packages, an incentive bonus program, as well as recognition and awards programs. Our work environment is friendly and supportive, and we offer flexible schedules whenever possible, as well as a wide range of live and web-based professional development and educational programs to prepare you for advancement opportunities.

Your benefits will include:

  • Medical, dental, and vision coverage
  • Life insurance
  • Optional and dependent life insurance
  • Short- and long-term disability
  • 401(k)
  • Paid time off
  • Paid company holidays
  • Tuition reimbursement
  • Flexible Spending Account
  • Employee Assistance Program

Opportunity. Recognition. Satisfaction. Grow your career with MultiPlan!

Apply now!

 

As an Equal Opportunity Employer, the Company will provide equal consideration to all employees and job candidates without regard to sex, age, race, marital status, sexual orientation, religion, national origin, citizenship status, physical or mental disability, political affiliation, service in the Armed Forces of the United States, or any other characteristic protected by federal, state, or local law.

Job Snapshot

Location US-MD-Rockville
Employment Type Full-Time
Pay Type Year
Pay Rate N/A
Store Type Engineering & Aerospace
Apply

Company Overview

MultiPlan

At MultiPlan, our employees are instrumental to our success and we reward them accordingly. We offer a very competitive compensation and benefits package, an incentive bonus program, service recognition awards and an employee recognition program that honors individuals whose achievements go above and beyond even our high expectations. We invite you to search our listing of current Career Opportunities. One of our top priorities is the career development of our employees. Learn More

Contact Information

US-MD-Rockville
Snapshot
MultiPlan
Company:
US-MD-Rockville
Location:
Full-Time
Employment Type:
Year
Pay Type:
N/A
Pay Rate:
Engineering & Aerospace
Store Type:

Job Description

ETL Developer-Informatica (IT -- Managed Care)

JOB DESCRIPTION

ETL Developers -- are you looking for a rewarding new position with an industry leader with a firm commitment to its employees? Join our team at MultiPlan! Founded in 1980, MultiPlan is a trusted partner to over 700 healthcare payers in the commercial health, property and casualty, and government markets, and saves these companies more than $14 billion annually. Approximately 50 to 75 million people have access to MultiPlan's PPO provider networks, which comprise 1.4 million healthcare providers nationwide.

We are currently seeking an experienced ETL Developer to work in either our Rockville, MD office or Bedford, MA office. We offer competitive compensation and fantastic benefits, as well as a collegial workplace in a business-casual dress environment. You'll also find plenty of options for professional development and advancement with us. If this sounds like the kind of career move you've been wanting to make, and if you meet our qualifications, we want to talk with you!

JOB RESPONSIBILITIES

The Informatica ETL Developer will be part of the ETL team responsible for developing and deploying Informatica ETL solutions. Primary responsibility will be to work closely with the Data Architects and ETL Architect to implement ETL solutions for the organization using Informatica, create technical specification documents and create test plans. Also provide bi-weekly on call support for the data warehouse backend jobs.

Your specific duties in this role will include:

  1. Develop Informatica objects - mappings, sessions, and workflows based on the prepared low level design documents.
  2. Debug mappings and identify errors and error rows so that they can be corrected and re-loaded into a target system.
  3. Review and analyze functional requirements and mapping documents.
  4. Performance tuning of Informatica Mappings, processes, and load routines.
  5. Technical coordination of cross-functional projects as assigned and interacts with all areas of the organization to achieve timely results.
  6. Provide off-hours and weekend support as needed.
  7. Collaborate, coordinate, and communicate across disciplines and departments.
  8. Ensure compliance with HIPAA regulations and requirements.
  9. Demonstrate Company's Core Competencies and values held within.
  10. The position responsibilities outlined above are in no way to be construed as all encompassing. Other duties, responsibilities, and qualifications may be required and/or assigned as necessary.

 

Job Requirements

JOB REQUIREMENTS

As an ETL Developer, you must be highly organized and detail-oriented, with strong analytical, problem solving, and prioritization skills. You should also be able to handle multiple tasks in a fast-paced, deadline-driven environment, both independently and as part of a team. It is also important that you display excellent verbal and written communication and interpersonal skills, as well as the ability to effectively present information and respond to questions from groups of managers and clients

Specific qualifications for the role include:

  • Minimum Bachelor's Degree
  • Minimum 5 years of Informatica and Relational Database experience.
  • 5+ years of experience working with large Enterprise Data Warehouse projects in the role of Informatica ETL developer.
  • Minimum 2 years experience of performing data analysis
  • Experience with or knowledge of Data Warehousing, reporting methodologies/ techniques and Business Intelligence reporting
  • Experience working with complex sql queries like Hierarchical, Aggregate Queries
  • Experience working with different database objects like tables, views, materialized views and partitions
  • Experience with SQL Server / Oracle databases
  • Solid working experience in Informatica Power Center.
  • Experience with Informatica IDQ and Informatica power exchange is a plus
  • Experience with many of the transformations of Informatica including complex lookups, stored procedures, update strategy, mapplets, etc.
  • Experience in gathering requirements, analyzing data, provide gap analysis and creating detail design documents and mapping documents.
  • Extensive knowledge of the Systems Development Life Cycle (SDLC) activities specific to data warehousing, data engineering solutions, data methodologies and software tools, including Informatica
  • Working knowledge of SQL, PL/SQL, UNIX Shell scripting.
  • Working knowledge of schedulers such as Autosys or Control M
  • Knowledge of health insurance industry is a plus
  • Communication (written, verbal and listening), organizational, prioritization, data analysis, planning, problem-solving and decision-making skills
  • Ability to quickly attain and understand new processes with strict attention to detail
  • Ability to meet strict deadlines, work on multiple tasks and work well under pressure
  • Ability to analyze data and arrive at a logical conclusion
  • Ability to assess ramification of issues and prioritize tasks based on business impact
  • Ability to use software, hardware and peripherals related to job responsibilities, including MS Office and software development applications
  • Must be able to work independently and have the ability to gain understanding of requirements/data specifications and any data discrepancies from interaction with others.
  • Effective interpersonal relations skills, ability to effectively collaborate with others and work as part of a team required.
  • Ability to work in a fast-paced and demanding environment
  • Ability to use software, hardware and peripherals related to job responsibilities, including MS Office and software development applications

BENEFITS

As an ETL Developer with MultiPlan, you will be part of an organization with a proud 30-year legacy of experience and growth. We realize that our employees are instrumental to our success, and we reward them accordingly with very competitive compensation and benefits packages, an incentive bonus program, as well as recognition and awards programs. Our work environment is friendly and supportive, and we offer flexible schedules whenever possible, as well as a wide range of live and web-based professional development and educational programs to prepare you for advancement opportunities.

Your benefits will include:

  • Medical, dental, and vision coverage
  • Life insurance
  • Optional and dependent life insurance
  • Short- and long-term disability
  • 401(k)
  • Paid time off
  • Paid company holidays
  • Tuition reimbursement
  • Flexible Spending Account
  • Employee Assistance Program

Opportunity. Recognition. Satisfaction. Grow your career with MultiPlan!

Apply now!

 

As an Equal Opportunity Employer, the Company will provide equal consideration to all employees and job candidates without regard to sex, age, race, marital status, sexual orientation, religion, national origin, citizenship status, physical or mental disability, political affiliation, service in the Armed Forces of the United States, or any other characteristic protected by federal, state, or local law.
Mrt3c768phnp0gk12d2
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
ETL Developer-Informatica Apply now