Logo of Huzzle

Informatica PowerCenter

image

Cognizant

2d ago

  • Job
    Full-time
    Mid & Senior Level
  • Data
    IT & Cybersecurity
  • Hyderabad, +1

AI generated summary

  • You need expertise in Informatica PowerCenter, Unix Shell Scripting, Appworx and Informatica Scheduler, PL/SQL, Data Warehousing, and 4-8 years in Production Support. Store Operations knowledge is a plus.
  • You will develop and maintain ETL processes, optimize SQL queries, automate workflows, ensure data quality, document specifications, collaborate with teams, and troubleshoot integration issues.

Requirements

  • Informatica PowerCenter expertise
  • Unix Shell Scripting
  • Appworx Scheduler
  • PL/SQL
  • Data Warehousing Concepts
  • Informatica Scheduler
  • 4 to 8 years of experience in Production Support
  • Domain knowledge with Store Operations and Food Services is a plus

Responsibilities

  • Develop and maintain ETL processes using Informatica PowerCenter to ensure data integration and transformation.
  • Utilize PL/SQL to write and optimize complex queries for data extraction and manipulation.
  • Implement and manage External Schedulers to automate and streamline data workflows.
  • Apply Data Warehousing Concepts to design and maintain efficient data storage solutions.
  • Use Appworx Scheduler to schedule and monitor ETL jobs for timely data processing.
  • Perform SQL queries to retrieve and analyze data from various sources.
  • Integrate data from multiple sources to create comprehensive datasets for analysis.
  • Develop Unix Shell Scripts to automate repetitive tasks and improve system efficiency.
  • Collaborate with cross-functional teams to understand data requirements and deliver solutions.
  • Troubleshoot and resolve issues related to ETL processes and data integration.
  • Ensure data quality and integrity through rigorous testing and validation.
  • Document technical specifications and maintain up-to-date records of ETL processes.
  • Stay updated with the latest industry trends and technologies to continuously improve data solutions.

FAQs

What is the primary technology required for this job?

The primary technology required for this job is Informatica PowerCenter.

What are the minimum years of experience required for this position?

A minimum of 4 years of experience is required for this position, with up to 8 years preferred.

Is experience in PL/SQL necessary for this role?

Yes, experience in PL/SQL is necessary for writing and optimizing complex queries for data extraction and manipulation.

Will I be responsible for data integration using ETL processes?

Yes, you will be responsible for developing and maintaining ETL processes to ensure data integration and transformation.

Is knowledge of Data Warehousing Concepts important for this job?

Yes, understanding Data Warehousing Concepts is essential for designing and maintaining efficient data storage solutions.

Do I need to work with external schedulers?

Yes, you will need to implement and manage External Schedulers to automate and streamline data workflows.

Do I need to have experience in Store Operations and Food Services?

While it's not mandatory, experience in domain knowledge with Store Operations and Food Services is considered a plus.

Will I be collaborating with other teams?

Yes, you will collaborate with cross-functional teams to understand data requirements and deliver solutions.

Are troubleshooting and resolving ETL issues part of the responsibilities?

Yes, troubleshooting and resolving issues related to ETL processes and data integration are key responsibilities of this role.

Is documentation of technical specifications expected?

Yes, you are expected to document technical specifications and maintain up-to-date records of ETL processes.

Will there be opportunities to learn about new technologies?

Yes, you will be encouraged to stay updated with the latest industry trends and technologies to continuously improve data solutions.

Consulting
Industry
10,001+
Employees

Mission & Purpose

Cognizant is a multinational technology company that provides a wide range of IT services and solutions to organisations worldwide. Their primary focus is on helping businesses transform and thrive in the digital age. Cognizant's mission and purpose are centred around delivering innovative and cutting-edge technology solutions that drive client success. They offer services such as digital strategy, consulting, technology implementation, and IT outsourcing, enabling companies to adapt to evolving market dynamics, enhance operational efficiency, and deliver exceptional customer experiences. Cognizant's ultimate goal is to empower their clients with the tools, insights, and capabilities needed to navigate complex technological landscapes and achieve their business objectives in an increasingly digital world.