Previous Job
ETL Developer
Ref No.: 18-03802
Location: Hamilton, New Jersey
NTT DATA has an immediate need for an ETL Developer to support our client in Hamilton, NJ.

To apply for this position, please follow the link below or send your resume directly to For more information please call Shawn Mills at 732-362-2596.

Project Description:
The ETL Developer will be part of the State of New Jersey Data Warehouse implementation team which is an enterprise data warehouse that contains information extracted from several state transactional systems, ranging from New Jersey Medicaid / Children's Health insurance Program (CHIP) to NJ Family Assistance Management Information System (FAMIS) all the way to diverse programs such as Heating Assistance. As part of the Replacement Medicaid Management Information System (RMMIS) project, the new Medicaid Warehouse will support Data Warehouse functions for the RMMIS and the also the migrated functions of the existing legacy repository. In addition custom reporting capabilities through Cognos Analytics and Advanced Analytics tools will round out the offering in statistics, healthcare analytics, Fraud and Abuse detection and Management and Reporting products.

  • Create mapping documents by analyzing the data and SQL queries.
  • Develop and/or execute test cases and scripts for ETL modifications.
  • Develop and maintain technical documentation which must be accessible to the State online, in real-time, and searchable, including:
    • Full data dictionary
    • Meta Data
    • Data Mappings and Profiles
    • Schemas
    • ETL processes and detailed modifications
    • Data modeling/relationships/attributes/legacy
  • Optimize performance so that interface jobs do not slow down or cause the slowdown of other processes such as other jobs, reporting queries, analytics, ETL, or research.
  • Help with SIT testing and collaborate with the team to test requirements.
  • Able to juggle multiple priorities and ensure availability to questions and clarifications from developers, other analysts.
  • Bachelor's degree in related field or equivalent experience.
  • 10+ years of experience working as a ETL developer and a minimum of 5 years involving Informatica PowerCenter, IDQ, PowerExchange.
  • Exposure to Cognos reporting environment is preferable.
  • Knowledge of health insurance, HMO and managed care principles including Medicaid and Medicare regulation is preferable but not required.
  • Familiarity with Medicaid Eligibility and Enrollment is preferable but not required.
  • Experience working with large data repositories and/or relational databases in a Data warehouse environment is must.
  • Exposure to Master Data Management environment is preferable.
  • Solid experience with Structured Query Language (SQL) required. Ability to learn/adapt to new analytic toolsets (such as Cognos) is a must.
  • Expertise in MS Excel, with proficiency using formulas, PivotTables, linked worksheets, graphing and other reporting and presentation features.
  • Ability to analyze data, and apply investigative skills in resolving issues.
  • Ability to produce clear, written operational instructions and supporting documentation.
  • Knowledge of MDM processes is a nice to have.
  • Ability to work on multiple projects simultaneously with minimal supervision.
  • Excellent computer, organization, and project management skills.
  • Exceptional written and oral communication skills.
  • Highly self-motivated and directed with keen attention to detail.

NTT DATA Services is a leading IT services provider and global innovation partner with 130,000 professionals based in over 50 countries. NTT DATA recently acquired Dell Services. NTT DATA Services emphasizes long-term commitment and combines global reach and local intimacy to provide premier professional services, including consulting, application services, business process, IT outsourcing, and cloud-based solutions. We are a part of NTT Group, one of the world's largest technology services companies, generating more than $100 billion in annual revenues and partner to 80% of the Fortune 100. Visit to learn how our consultants, projects, managed services, and outsourcing engagements deliver value for a wide range of businesses and government agencies.

The Company is an equal opportunity employer and makes employment decisions on the basis of merit and business needs. The Company will consider all qualified applicants for employment without regard to race, color, religious creed, citizenship, national origin, ancestry, age, sex, sexual orientation, genetic information, physical or mental disability, veteran or marital status, or any other class protected by law. To comply with applicable laws ensuring equal employment opportunities to qualified individuals with a disability, the Company will make reasonable accommodations for the known physical or mental limitations of an otherwise qualified individual with a disability who is an applicant or an employee unless undue hardship to the Company would result.