99 Informatica Power Centre With Teradata jobs in India

Greetings from Tata Consultancy Services

We are hiring for an Informatica Power Centre-Teradata professional.

The ideal candidate will have experience with:

• Informatica PowerCenter: Developing, deploying, and managing data integration solutions.
• Database (DB) Experience: Proficiency in designing, implementing, and maintaining databases.
• Structured Query Language (SQL): Writing efficient and effective SQL queries to extract and manipulate data.
• Unix Commands: Utilizing Unix commands to navigate and manage files, directories, and processes.
• PL/SQL: Creating and executing stored procedures and functions in a database environment.
• Teradata: Working with Teradata databases to design, implement, and maintain data warehousing solutions.
• Oracle: Experience with Oracle databases, including data modeling, implementation, and management.

Candidates with the following skills will be given preference:

• Insurance Domain Knowledge: Understanding of the insurance industry, including business processes and regulatory requirements.
• Good Communication Skills: Effective verbal and written communication skills to interact with stakeholders.
• Ability to Work Independently: Self-motivated and able to work independently with minimal supervision.
• Team Player/Multi-tasking: Ability to collaborate with team members and prioritize tasks effectively.
• Aptitude to Learn New Technologies: Willingness to adapt to new technologies and learn quickly.

This is an exciting opportunity to leverage your technical expertise and contribute to our team's success.

Transform Data with Precision and Speed

We are seeking a skilled Informatica PowerCenter professional to join our team at Tata Consultancy Services (TCS). This role involves working with Teradata/Oracle, leveraging Synapse Analytics with PySpark and Cosmos DB.

• Design and implement data pipelines using Informatica PowerCenter, focusing on Extract, Transform, and Load (ETL) logic.
• Collaborate with cross-functional teams to deliver high-quality solutions, utilizing Unix scripting expertise.

• Mastery of Informatica PowerCenter and hands-on experience with Teradata.
• Strong understanding of ETL concepts and ability to work with large datasets.
• Proficiency in Unix scripting and experience with job scheduling tools such as Control-M and ESP scheduler.
• Familiarity with DevOps practices, code deployment using Bitbucket, and Agile methodologies.
• Experience with JIRA and Confluence for project management and collaboration.

• A dynamic work environment with opportunities for growth and development.
• Collaborative teams focused on delivering exceptional results.
• A competitive compensation package and benefits.

Job Title: Junior Informatica ETL IDC Developer with Python Knowledge

Position: Junior Informatica ETL IDC Developer

Experience: 1 – 4 years

Location: Remote

Employment Type: Full-time

We are seeking a highly skilled Junior Informatica ETL IDC Developer with 1-4 years of experience in designing, developing, and maintaining ETL workflows using Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS/IDMC). The ideal candidate should have basic Python scripting skills to enhance automation, data processing, and cloud integrations.

This role involves working closely with data engineers, analysts, and business teams to ensure seamless data integration, transformation, and loading into data warehouses/lakes.

1. ETL Development & Maintenance:

• Design, develop, and test Informatica PowerCenter mappings, workflows, and sessions.
• Work with Informatica Cloud (IICS/IDMC) for cloud-based ETL solutions (CDI, Mass Ingestion).
• Optimize ETL jobs for performance and scalability.

1. Python Scripting for Automation & Enhancements:

• Use Python (Pandas, NumPy, PySpark) for advanced data transformations and validations.
• Automate file processing, logging, and error handling using Python scripts.
• Integrate Python with Informatica workflows for custom logic.

1. Data Integration & Cloud ETL:

• Extract and load data from SQL databases, flat files, APIs, and SaaS applications.
• Work with AWS S3, Snowflake, Redshift, or BigQuery for cloud data warehousing.
• Assist in real-time data pipeline development using Kafka, REST APIs.

1. Troubleshooting & Performance Tuning:

• Debug and fix ETL job failures.
• Optimize SQL queries and mappings for efficiency.

1. Collaboration & Documentation:

• Work with cross-functional teams to gather requirements.
• Document ETL processes, data flows, and mappings.

• 1-4 years of hands-on experience in Informatica PowerCenter (Mappings, Workflows, Sessions).
• Exposure to Informatica Intelligent Cloud Services (IICS/IDMC) is a plus.
• Basic Python scripting skills (Pandas, NumPy, file handling, API calls).
• SQL proficiency (Joins, Aggregations, Stored Procedures).
• Familiarity with cloud platforms (AWS/Azure/GCP) & data warehouses (Snowflake, Redshift).
• Understanding of ETL best practices, data modeling, and SCDs.
• Knowledge of scheduling tools (Autosys, Control-M) is a bonus.

• Informatica Cloud Certification (IICS/IDMC).
• Experience with PySpark for big data processing.
• Knowledge of CI/CD pipelines (Git, Jenkins, Airflow).

Opportunity to work on cutting-edge cloud ETL & data integration projects.

Career growth into Senior ETL Developer, Cloud Data Engineer, or Data Architect.

Exposure to Python automation, AI/ML in ETL, and modern data stacks.

Interested candidates can share their resume to the HR department via email.

This is a remote full-time position for a Junior Informatica ETL IDC Developer with 1-4 years of experience in designing, developing, and maintaining ETL workflows using Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS/IDMC).

We are seeking a skilled professional to work closely with data engineers, analysts, and business teams to ensure seamless data integration, transformation, and loading into data warehouses/lakes.

• ETL Development & Maintenance:
• Design, develop, and test Informatica PowerCenter mappings, workflows, and sessions.
• Work with Informatica Cloud (IICS/IDMC) for cloud-based ETL solutions (CDI, Mass Ingestion).
• Optimize ETL jobs for performance and scalability.
• Python Scripting for Automation & Enhancements:
• Use Python (Pandas, NumPy, PySpark) for advanced data transformations and validations.
• Automate file processing, logging, and error handling using Python scripts.
• Integrate Python with Informatica workflows for custom logic.
• Data Integration & Cloud ETL:
• Extract and load data from SQL databases, flat files, APIs, and SaaS applications.
• Work with AWS S3, Snowflake, Redshift, or BigQuery for cloud data warehousing.
• Assist in real-time data pipeline development using Kafka, REST APIs.
• Troubleshooting & Performance Tuning:
• Debug and fix ETL job failures.
• Optimize SQL queries and mappings for efficiency.
• Collaboration & Documentation:
• Work with cross-functional teams to gather requirements.
• Document ETL processes, data flows, and mappings.

• 1-4 years of hands-on experience in Informatica PowerCenter (Mappings, Workflows, Sessions).
• Exposure to Informatica Intelligent Cloud Services (IICS/IDMC) is a plus.
• Basic Python scripting skills (Pandas, NumPy, file handling, API calls).
• SQL proficiency (Joins, Aggregations, Stored Procedures).
• Familiarity with cloud platforms (AWS/Azure/GCP) & data warehouses (Snowflake, Redshift).
• Understanding of ETL best practices, data modeling, and SCDs.
• Knowledge of scheduling tools (Autosys, Control-M) is a bonus.

• Informatica Cloud Certification (IICS/IDMC).
• Experience with PySpark for big data processing.
• Knowledge of CI/CD pipelines (Git, Jenkins, Airflow).

We offer career growth opportunities into Senior ETL Developer, Cloud Data Engineer, or Data Architect. You will have the opportunity to work on cutting-edge cloud ETL & data integration projects, expose yourself to Python automation, AI/ML in ETL, and modern data stacks.