Logo of Huzzle

Informatica IICS

image

Virtusa

Feb 7

  • Job
    Full-time
    Senior Level
  • Data
    IT & Cybersecurity
  • Chennai

AI generated summary

  • You should have strong ETL development experience with Informatica, AWS services, SQL skills, data modeling expertise, and performance monitoring, plus knowledge in data transformation and healthcare is a plus.
  • You will develop ETL processes using Informatica and AWS tools, manage data pipelines, ensure performance monitoring, execute unit tests, and handle data transformation tasks.

Requirements

  • Experience working with Informatica Power Center or Informatica Cloud Optional experience on Informatica Data Qualit Product 360 PIM Power Exchange Other BI tools
  • Experience and proficiency with Relational Databases Postgres etc
  • Experience of ETL Development with Informatica AWS Glue Spark Python
  • Extensive experience developing ETL process with Informatica toolset
  • Experience with Glue MSK and Kinesis in AWS
  • Experience with several AWS Services such as AWS API Gateway AWS Lambda and DynamoDb and ElasticSearch OpenSearch
  • Highly experienced in Data modelling and Data Pipeline development
  • Experience in building and supporting ETL batch process including Delta Full loads
  • Knowledge of Data Transformation Complex Match and Merge process is a must
  • Experience in writing and executing Junit or similar unit tests
  • Well versed with multi threaded applications file based integrations and database integrations
  • Strong SQL skills
  • Strong experience in performance monitoring and SLAs for ETL jobs
  • Demonstrated ability to learn new technologies and learn quickly
  • Healthcare experience is a plus

Responsibilities

  • Experience working with Informatica Power Center or Informatica Cloud Optional experience on Informatica Data Quality Product 360 PIM Power Exchange Other BI tools
  • Experience and proficiency with Relational Databases Postgres etc
  • Experience of ETL Development with Informatica AWS Glue Spark Python
  • Extensive experience developing ETL process with Informatica toolset
  • Experience with Glue MSK and Kinesis in AWS
  • Experience with several AWS Services such as AWS API Gateway AWS Lambda and DynamoDb and ElasticSearch OpenSearch
  • Highly experienced in Data modelling and Data Pipeline development
  • Experience in building and supporting ETL batch process including Delta Full loads
  • Knowledge of Data Transformation Complex Match and Merge process is a must
  • Experience in writing and executing Junit or similar unit tests
  • Well versed with multi threaded applications file based integrations and database integrations
  • Strong SQL skills
  • Strong experience in performance monitoring and SLAs for ETL jobs
  • Demonstrated ability to learn new technologies and learn quickly
  • Healthcare experience is a plus

FAQs

What tools and technologies should I be proficient in for this job?

You should have experience with Informatica Power Center or Informatica Cloud, AWS Glue, Spark, Python, as well as proficiency in relational databases like Postgres. Familiarity with BI tools, AWS services such as API Gateway, Lambda, DynamoDB, and ElasticSearch/OpenSearch is also required.

Is healthcare experience necessary for this role?

While healthcare experience is a plus, it is not a mandatory requirement for this position.

What is the expected experience level with ETL processes?

Extensive experience in developing ETL processes with the Informatica toolset is required, including building and supporting batch processes for delta and full loads.

Are there specific SQL skills required?

Yes, strong SQL skills are essential for this role, as they are crucial for performance monitoring and ETL job management.

What is the team and company culture like at Virtusa?

Virtusa values teamwork, professional and personal development, and provides a collaborative environment that fosters new ideas and excellence among its employees.

Will I need to write unit tests as part of my responsibilities?

Yes, experience in writing and executing JUnit or similar unit tests is expected in this role.

Is there a focus on performance monitoring in this position?

Yes, strong experience in performance monitoring and meeting SLAs for ETL jobs is a key requirement for this role.

Will I need to manage multi-threaded applications?

Yes, you should be well-versed in multi-threaded applications, as well as file-based and database integrations.

How does Virtusa approach equal employment opportunities?

Virtusa was founded on principles of equal opportunity and does not discriminate based on race, religion, color, sex, gender identity, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by law.

Is it necessary to learn new technologies for this job?

Yes, a demonstrated ability to learn new technologies quickly is important for success in this position.

Business transformation that lasts starts with Engineering First.

Technology
Industry
10,001+
Employees
1996
Founded Year

Mission & Purpose

Virtusa Corporation provides digital engineering and technology services to Forbes Global 2000 companies worldwide. Our Engineering First approach ensures we can execute all ideas and creatively solve pressing business challenges. With industry expertise and empowered agile teams, we prioritize execution early in the process for impactful results. We combine logic, creativity and curiosity to build, solve, and create. Every day, we help clients engage with new technology paradigms, creatively building solutions that solve their most pressing business challenges and move them to the forefront of their industry.