Talent.com
Informatica powercenter with Teradata

Informatica powercenter with Teradata

CLOUDSCOUTS SOFTWARE SOLUTIONS LLCSpringfield, IL, US
job_description.job_card.30_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.part_time
job_description.job_card.job_description

Remote : Informatica powercenter developer with Teradata exp.

Most recent project must be Healthcare

10+ years and W2 role

H1b transfer is fine

H4 EAD,GC,USC

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 Teradata (v17+), including Fastload, TPT, and Multiload utilities.
  • 5+ years of Informatica PowerCenter administration experience.
  • 2+ years of Unix Shell (Bash / Korn) scripting experience.
  • Strong communication, collaboration, and mentoring skills.
  • Bachelor’s or advanced degree in IT, Computer Science, Mathematics, or a related field.
  • Strong organizational and time management skills.

Preferred Qualifications :

  • Residing in or near Springfield, IL.
  • 5+ years of data warehouse development experience.
  • 5+ years of data modeling experience using ERWIN or similar tools.
  • 2+ years of experience with Azure Data Factory and Snowflake.
  • Experience with scripting languages such as Python, R, or JavaScript (React).
  • Familiarity with Informatica Data Quality (IDQ), Address Doctor, and Metadata Manager.
  • 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.

    Key Responsibilities :

  • Design and implement ETL solutions using Informatica PowerCenter to extract, transform, and

    • load data from various agency sources.

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

    • efficiency.

  • Administer and support ETL environments, including development and production systems.
  • Perform repository backups, recovery operations, and system maintenance.
  • Develop 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.

    This is a remote position.

    serp_jobs.job_alerts.create_a_job

    Informatica Teradata • Springfield, IL, US