1,429 Informatica Powercenter jobs in the United States

Job Description:

• 7+ years of experience in Informatica Powercentre.
• Knowledge of PL/SQL is Must with hands-on experience.
• Understanding the Business Requirements & ETL specification DocumentExtraction, Transformation and Loading (ETL) of data by using Informatica PCDesigned various mappings for extracting data from various sources involving flat files and relational tables.
• Good Concept of Data warehouse to be available.
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy.
• Checked and tuned the performance of Informatica Mappings.
• Testing and maintaining of Informatica Mappings Resolving if any issues in transformations and mappings with the help of technical specifications.
• Checked and tuned the performance of Informatica Mappings.
• Resolve and debugging any development issues.
• Involved in Creating Sessions, Workflows Using Workflow ManagerInvolved in testing the mappings (UNIT testing) and preparation of test cases.
• Ensuring proper Dependencies of loads (Incremental and Complete loads).

MUST HAVE:

• 7+ years of experience in Informatica Powercentre.
• Knowledge of PL/SQL is Must with hands-on experience.
• Understanding the Business Requirements & ETL specification Document Extraction, Transformation and Loading (ETL) of data by using Informatica PCDesigned various mappings for extracting data from various sources involving flat files and relational tables.
• Good Concept of Data warehouse to be available.

A leading IT services provider is seeking a Senior Data Engineer with deep experience in distributed computing, ETL design, and modern data platforms. This role is ideal for a technically strong professional who enjoys solving complex data problems, optimizing performance, and leading hands-on development efforts across enterprise-scale data environments.

Design, develop, and optimize data integration solutions using Informatica PowerCenter and PowerExchange CDC

Build and manage ETL workflows , ensuring high data quality and system reliability

Work with large-scale distributed systems using Apache Spark and PySpark

Develop data pipelines and transformations using Python

Perform complex SQL queries and work with NoSQL databases such as PostgreSQL, DB2, and Snowflake

Leverage AWS cloud services for data platform deployments and processing

Utilize workflow schedulers like Airflow for task automation

Lead debugging, tuning, and troubleshooting of ETL jobs and data flows

Participate in Agile / POD-based development, manage tickets, and conduct gap analysis

Maintain documentation for mappings, sessions, workflows, and processes

Provide mentorship and technical leadership to junior engineers

10+ years of experience in big data and distributed computing

7+ years of hands-on experience with Informatica PowerCenter

Advanced proficiency with PySpark, Apache Spark, and Python

Strong experience in SQL and NoSQL technologies (e.g., DB2, PostgreSQL, Snowflake)

Proficiency in data modeling and designing scalable ETL workflows

Familiarity with Airflow or similar workflow orchestration tools

Hands-on experience with AWS data platforms

Strong analytical and problem-solving skills

Experience in DevOps, CI/CD , and containerization tools (e.g., Docker, Kubernetes) is a plus

About the job Informatica PowerCenter Developer (10596-1) Waltham, MA

Informatica, Informatica Powercentre, PL/SQL, ETL, PCS, Data Warehouse

If you post this job on a job board, please do not use company name or salary. Experience level: Mid-senior Experience required: 7 Years Education level: Bachelors degree Job function: Information Technology Industry: Information Technology and Services Pay rate : Total position: 1 Relocation assistance: No Visa sponsorship eligibility: No

Note:

• Only U.S. Citizens and Green Card Holders are eligible to apply.

• 7+ years of experience in Informatica Powercentre.
• Knowledge of PL/SQL is Must with hands-on experience.
• Understanding the Business Requirements & ETL specification DocumentExtraction, Transformation and Loading (ETL) of data by using Informatica PCDesigned various mappings for extracting data from various sources involving flat files and relational tables.
• Good Concept of Data warehouse to be available.
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy.
• Checked and tuned the performance of Informatica Mappings.
• Testing and maintaining of Informatica Mappings Resolving if any issues in transformations and mappings with the help of technical specifications.
• Checked and tuned the performance of Informatica Mappings.
• Resolve and debugging any development issues.
• Involved in Creating Sessions, Workflows Using Workflow ManagerInvolved in testing the mappings (UNIT testing) and preparation of test cases.
• Ensuring proper Dependencies of loads (Incremental and Complete loads).

• Please submit the candidate's resume in PDF format.
• Please remove the candidate's LinkedIn URL from the resume; otherwise, the profile will not be considered.
• Please note that TCS does not consider former full-time employees (FTEs) for rehire. Additionally, individuals who have previously worked at TCS as contractors must observe a minimum waiting period of six months before being eligible for re-engagement.

• This will be a Hybrid role
• Identify and troubleshoot system outages, installation issues, and application code errors running Java applications in AWS.
• Generate and install security certificates and PGP keys.
• Work with the Control-M tool or equivalent to create and schedule batches and to create calendars and daily schedules for critical batches.
• Restore Informatica Power Center services and manage users and governance controls.
• Configure, maintain, and troubleshoot Redhat Jboss, Fuse, Apache, and Tomcat HTTP servers.
• Perform system troubleshooting by reading and deciphering app logs, and system logs from Splunk.
• Configure, deploy, verify, and troubleshoot SSL certificates.
• Read/understand/improve scripts related to the application, batches, and/or web services.
• Identify installation issues and application code errors running in JBoss/ Tomcat/ Informatica/ Control M.
• Provide options, recommendations, and additional actions related to resolving issues, mitigating risks, and resolving escalated items.
• Work with configuration management tool Jenkins to automate tasks such as code check-in software build.
• Manage, monitor, and configure the Splunk application monitoring tool.
• Support releases and adherence to change control standards.
• Perform scheduled maintenance activities such as patching, performance tuning, and backups.
• Execute daily batch scripts, days, evenings, weekends, and holidays as required.
• Perform capacity planning and scalability planning.
• Work with JIRA Service Desk to manage Incidents and Change Processes.
• Availability to work in rotation shifts mode.
• Adhere to all security, change control, and MHBE Project Management Office (PMO) policies, processes, and methodologies.

• A minimum of three (3) years performing day-to-day Informatica PowerCenter operations, functions, administration, or troubleshooting tasks.
• A minimum of three (3) years of experience as a Batch Operator using Control-M or equivalent.
• A minimum of two (2) years of experience working in a PostgreSQL DB or equivalent environment.
• Experience working in the health insurance marketplace, healthcare, or health and human services domains.
• Demonstrable analytical experience and ability to work in a complex system environment.
• Demonstrable experience with application and batch integration.
• Familiarity with Database and SQL functions.
• Ability to troubleshoot system issues by collaborating with a team of system operations professionals.
• Ability to work in a multidisciplinary team and effectively communicate with different functions.

• A minimum of five (5) years of experience supporting day-to-day operations functions of a complex enterprise system.
• A minimum of five (5) years of experience as a Batch Operator or equivalent, supporting day-to-day configurations and operations of various batch jobs in a complex enterprise system.
• A minimum of three (3) years of experience in identifying and troubleshooting system outages, installation issues, and application code running JBoss/Tomcat applications in AWS.
• Experience demonstrating critical thinking, providing options, recommendations, and additional actions relating to resolving issues, mitigating risks, and resolving escalated items in supporting a large or complex infrastructure/systems.
• Experience with operating, configuring, and troubleshooting Control-M or equivalent batch applications.
• Experience managing web-based systems hosted on the AWS platform.
• Working knowledge of Electronic Data Interchange (EDI) operations.
• Understand java runtime environment concepts such as heap memory, thread dumps, garbage collection, etc.
• Experience working with the Project Management Office (PMO) processes, policies, and procedures.

• This will be a Hybrid role
• Identify and troubleshoot system outages, installation issues, and application code errors running Java applications in AWS.
• Generate and install security certificates and PGP keys.
• Work with the Control-M tool or equivalent to create and schedule batches and to create calendars and daily schedules for critical batches.
• Restore Informatica Power Center services and manage users and governance controls.
• Configure, maintain, and troubleshoot Redhat Jboss, Fuse, Apache, and Tomcat HTTP servers.
• Perform system troubleshooting by reading and deciphering app logs, and system logs from Splunk.
• Configure, deploy, verify, and troubleshoot SSL certificates.
• Read/understand/improve scripts related to the application, batches, and/or web services.
• Identify installation issues and application code errors running in JBoss/ Tomcat/ Informatica/ Control M.
• Provide options, recommendations, and additional actions related to resolving issues, mitigating risks, and resolving escalated items.
• Work with configuration management tool Jenkins to automate tasks such as code check-in software build.
• Manage, monitor, and configure the Splunk application monitoring tool.
• Support releases and adherence to change control standards.
• Perform scheduled maintenance activities such as patching, performance tuning, and backups.
• Execute daily batch scripts, days, evenings, weekends, and holidays as required.
• Perform capacity planning and scalability planning.
• Work with JIRA Service Desk to manage Incidents and Change Processes.
• Availability to work in rotation shifts mode.
• Adhere to all security, change control, and MHBE Project Management Office (PMO) policies, processes, and methodologies.

• A minimum of three (3) years performing day-to-day Informatica PowerCenter operations, functions, administration, or troubleshooting tasks.
• A minimum of three (3) years of experience as a Batch Operator using Control-M or equivalent.
• A minimum of two (2) years of experience working in a PostgreSQL DB or equivalent environment.
• Experience working in the health insurance marketplace, healthcare, or health and human services domains.
• Demonstrable analytical experience and ability to work in a complex system environment.
• Demonstrable experience with application and batch integration.
• Familiarity with Database and SQL functions.
• Ability to troubleshoot system issues by collaborating with a team of system operations professionals.
• Ability to work in a multidisciplinary team and effectively communicate with different functions.

• A minimum of five (5) years of experience supporting day-to-day operations functions of a complex enterprise system.
• A minimum of five (5) years of experience as a Batch Operator or equivalent, supporting day-to-day configurations and operations of various batch jobs in a complex enterprise system.
• A minimum of three (3) years of experience in identifying and troubleshooting system outages, installation issues, and application code running JBoss/Tomcat applications in AWS.
• Experience demonstrating critical thinking, providing options, recommendations, and additional actions relating to resolving issues, mitigating risks, and resolving escalated items in supporting a large or complex infrastructure/systems.
• Experience with operating, configuring, and troubleshooting Control-M or equivalent batch applications.
• Experience managing web-based systems hosted on the AWS platform.
• Working knowledge of Electronic Data Interchange (EDI) operations.
• Understand java runtime environment concepts such as heap memory, thread dumps, garbage collection, etc.
• Experience working with the Project Management Office (PMO) processes, policies, and procedures.

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.

• Experience and understanding of delivery in Agile (Scrum).
• Should be flexible to work with onshore and offshore model.
• Good communications and problem solving and analytical skills.
• Able to communicate with customers and understand the business requirements and able to do the customer facing role.
• Responsible to design, develop and test the ETL code/application Perform code reviews and product quality is meeting customer expectations
• Responsible for troubleshooting issues and provide mitigation
• Informatica Powercentre,
• Guidewire PolicyCenter
• 8-10 Years' experience
• Bachelor's degree in Computer Science, Engineering, or related field (or equivalent experience)Strong problem-solving skills and ability to work independently and as part of a team.
• Excellent communication skills and ability to collaborate effectively with stakeholders
• Must have ETL tool informatica, Control-M, Orcale SQL, Tableau publisher, Unix scripting, conversion experience
• Technical Lead, Mainframe, ETL tool informatica, Control-M, Orcale SQL, Tableau publisher, Unix scripting