About the role
Experience Required: 6+ Years
Location: Hyderabad, India
Job Type: Full-time / Permanent
Work Mode: [Onsite / Hybrid / Remote – select as per requirement]
Job Summary:We are seeking an experienced ETL Developer with expertise in Informatica PowerCenter, Teradata, and SQL to join our data engineering team in Hyderabad. The candidate will be responsible for designing, developing, and maintaining robust ETL workflows and pipelines to support business intelligence, analytics, and data warehousing solutions.
Key Responsibilities:- Design, develop, test, and deploy ETL processes using Informatica PowerCenter.
- Develop and optimize complex SQL queries and scripts in Teradata and other relational databases.
- Understand business requirements and translate them into effective ETL solutions.
- Perform data profiling, data validation, and data cleansing.
- Collaborate with data analysts, data architects, and business stakeholders to deliver high-quality data pipelines.
- Ensure ETL workflows are optimized for performance and handle large volumes of data efficiently.
- Troubleshoot ETL failures, performance issues, and data discrepancies.
- Participate in code reviews, documentation, and version control.
- Informatica PowerCenter – advanced development experience
- Teradata – strong SQL skills and performance tuning knowledge
- SQL – strong proficiency in writing complex queries, stored procedures, and debugging
- Experience in data warehousing concepts, star/snowflake schema
- ETL performance tuning and debugging experience
- Hands-on with scheduling tools (e.g., Autosys, Control-M – preferred)
- Experience with version control tools (e.g., Git, SVN)
- Bachelor’s degree in Computer Science, Information Systems, or a related discipline
- 6+ years of hands-on experience in ETL development using Informatica
- 4+ years of experience working with Teradata
- Strong understanding of data integration and transformation best practices
- Excellent analytical, troubleshooting, and communication skills
- Exposure to cloud data platforms (AWS, Azure, or GCP)
- Knowledge of Informatica Cloud or IICS
- Experience with shell scripting or Python
- Exposure to Agile methodologies