Logo of Huzzle

Home

Matches

Explore

Manage

My SQL

image

Cognizant

1mo ago

  • Job
    Full-time
    Senior & Expert Level
  • Data
    Software Engineering
  • Chennai

AI generated summary

  • You should have strong PL/SQL, ETL, and Unix skills, Payer domain expertise, and experience with Informatica PowerCenter. Strong problem-solving, collaboration, and communication skills are essential.
  • You will develop and maintain ETL processes, design data warehouses, write complex SQL queries, automate tasks with Unix scripting, troubleshoot data integrity, and optimize performance.

Requirements

  • Possess strong experience in PL/SQL Data Warehousing Concepts Informatica Scheduler ETL SQL Data Integration Informatica PowerCenter and Unix Shell Scripting.
  • Have domain expertise in Payer to understand and address specific business requirements.
  • Demonstrate proficiency in developing and maintaining ETL processes using Informatica PowerCenter.
  • Exhibit strong analytical and problem-solving skills to troubleshoot and resolve data integration issues.
  • Show ability to work collaboratively with cross-functional teams in a hybrid work environment.
  • Display excellent communication skills to effectively convey technical information to non-technical stakeholders.
  • Have a proactive approach to learning and staying updated with the latest industry trends and technologies.

Responsibilities

  • Develop and maintain ETL processes using Informatica PowerCenter to ensure seamless data integration and transformation.
  • Design and implement data warehousing solutions to support business intelligence and analytics.
  • Utilize PL/SQL to write complex queries and stored procedures for data manipulation and retrieval.
  • Oversee the scheduling and execution of ETL jobs using Informatica Scheduler to ensure timely data processing.
  • Collaborate with cross-functional teams to gather and analyze business requirements for data integration projects.
  • Provide technical expertise in Unix Shell Scripting to automate data processing tasks and improve efficiency.
  • Monitor and troubleshoot ETL processes to ensure data accuracy and integrity.
  • Optimize SQL queries for performance and scalability in large data environments.
  • Ensure compliance with data governance and security policies in all data integration activities.
  • Participate in code reviews and provide constructive feedback to team members to maintain code quality.
  • Develop and maintain documentation for ETL processes data flows and system configurations.
  • Conduct performance tuning and optimization of ETL processes to enhance system performance.
  • Support the deployment and maintenance of data warehousing solutions in a hybrid work model.

FAQs

What is the experience level required for this position?

The ideal candidate should have 6 to 10 years of experience.

What specific technical skills are required for this job?

Strong experience in PL/SQL, Data Warehousing Concepts, Informatica Scheduler, ETL, SQL Data Integration, Informatica PowerCenter, and Unix Shell Scripting is required.

Is there any travel required for this role?

No travel is required; the work model is hybrid with day shifts.

What kind of domain experience is preferred for this position?

Domain expertise in Payer is preferred to understand and address specific business requirements.

What kind of tasks will the Sr. Developer be responsible for?

The responsibilities include developing and maintaining ETL processes, designing data warehousing solutions, writing complex PL/SQL queries, and monitoring ETL processes.

Will there be opportunities for collaboration with other teams?

Yes, the role involves collaborating with cross-functional teams to gather and analyze business requirements for data integration projects.

What are the expectations regarding communication skills?

Candidates are expected to display excellent communication skills to effectively convey technical information to non-technical stakeholders.

Is experience with Informatica PowerCenter necessary?

Yes, proficiency in developing and maintaining ETL processes using Informatica PowerCenter is essential.

Will the role involve performance tuning of ETL processes?

Yes, the candidate will be responsible for conducting performance tuning and optimization of ETL processes to enhance system performance.

Is there an emphasis on documentation in this role?

Yes, developing and maintaining documentation for ETL processes, data flows, and system configurations is part of the responsibilities.

image

Cognizant

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.