HIH Software Engineering Advisor (Tec3269)

Teamware Solutions

Job Location:

Hyderabad - India

Monthly Salary: Not Disclosed

Posted on: 6 hours ago

Vacancies: 1 Vacancy

Job Summary

Key Responsibilities:

Design develop and maintain ETL processes using Informatica Power Center to load data into the Teradata data warehouse
Optimize and fine-tune Teradata queries database structures and data loading strategies to ensure high performance and scalability.
Create and maintain data mappings workflows and sessions in Informatica for data extraction transformation and loading.
Collaborate with data architects analysts and stewards to define the data requirements and ensure the availability and accuracy of the data for business users
Monitor and troubleshoot data pipelines resolving issues related to data integrity performance and job failures
Develop and implement data validations and quality checks to ensure the accuracy and reliability of the data warehouse
Document technical specifications processes and workflows related to Teradata and Informatica development
Assist in capacity planning performance tuning and security management
Partner with other teams and stake holders for any clarifications needed for the timely deliverables.
Integrate AI-driven solutions for data quality monitoring anomaly detection and predictive analytics within ETL workflows.
Collaborate with AI/ML teams to enable data pipelines that support model training and inference

Qualifications:

Bachelor’s degree in the related field.
8 years of experience in developer role.
6 years of hands-on experience with Teradata database development including query optimization.
6 years of experience with Informatica Power Center in developing and managing ETL processes
Experience with AI-driven data quality tools or anomaly detection frameworks is a plus
Knowledge of AI/ML concepts and their application in data engineering workflows.
Strong knowledge of SQL and proficiency in writing complex queries stored procedures and macros in Teradata
Experience with data warehousing concepts
Ability to handle large datasets and optimize ETL performance for data loading and transformation
Experience with data pipeline scheduling
Experience with continuous integration and continuous delivery (CI/CD) tools like GitHub Jenkins etc.
Excellent problem-solving skills and attention to details
Strong communication and collaboration skills

Required Skills:

ETL

Key Responsibilities:Design develop and maintain ETL processes using Informatica Power Center to load data into the Teradata data warehouseOptimize and fine-tune Teradata queries database structures and data loading strategies to ensure high performance and scalability.Create and maintain data mapp...

Key Responsibilities:

Design develop and maintain ETL processes using Informatica Power Center to load data into the Teradata data warehouse
Optimize and fine-tune Teradata queries database structures and data loading strategies to ensure high performance and scalability.
Create and maintain data mappings workflows and sessions in Informatica for data extraction transformation and loading.
Collaborate with data architects analysts and stewards to define the data requirements and ensure the availability and accuracy of the data for business users
Monitor and troubleshoot data pipelines resolving issues related to data integrity performance and job failures
Develop and implement data validations and quality checks to ensure the accuracy and reliability of the data warehouse
Document technical specifications processes and workflows related to Teradata and Informatica development
Assist in capacity planning performance tuning and security management
Partner with other teams and stake holders for any clarifications needed for the timely deliverables.
Integrate AI-driven solutions for data quality monitoring anomaly detection and predictive analytics within ETL workflows.
Collaborate with AI/ML teams to enable data pipelines that support model training and inference

Qualifications:

Bachelor’s degree in the related field.
8 years of experience in developer role.
6 years of hands-on experience with Teradata database development including query optimization.
6 years of experience with Informatica Power Center in developing and managing ETL processes
Experience with AI-driven data quality tools or anomaly detection frameworks is a plus
Knowledge of AI/ML concepts and their application in data engineering workflows.
Strong knowledge of SQL and proficiency in writing complex queries stored procedures and macros in Teradata
Experience with data warehousing concepts
Ability to handle large datasets and optimize ETL performance for data loading and transformation
Experience with data pipeline scheduling
Experience with continuous integration and continuous delivery (CI/CD) tools like GitHub Jenkins etc.
Excellent problem-solving skills and attention to details
Strong communication and collaboration skills

Required Skills:

ETL