ETL Developer
Confidential client · Full-time
Overview
We are looking for an experienced ETL Developer to design and build data integration solutions that support large-scale data warehousing projects. You will work with tools like Informatica PowerCenter and PowerExchange CDC to develop efficient data workflows and optimize database performance.
Key Responsibilities
- Design, develop, and test ETL solutions using Informatica PowerCenter (v10.2+) and PowerExchange CDC for Oracle.
- Develop and optimize SQL queries and workflows for large data sets in Teradata and Oracle.
- Perform data analysis, transformation, conceptual data modeling, and metadata management.
- Write and maintain Unix/Linux shell scripts and troubleshoot Informatica environment issues.
- Tune SQL and ETL processes to improve performance and reduce cycle times.
- Contribute to the design and development of data warehouse projects.
Requirements
- 5-7 years of experience with Informatica, Teradata, Oracle PL/SQL, and Unix.
- Strong knowledge of Teradata architecture and tools including SQL Assistant, BTEQ, MLOAD, FLOAD, FASTEXPORT, and TPump.
- Proficiency in Oracle and data modeling with a solid understanding of data warehousing concepts.
- Experience implementing PowerExchange CDC for Oracle.
- Ability to write, tune, and rewrite complex SQL queries.
- Competence in Unix/Linux shell scripting.
- Good written and verbal communication skills.
Nice to Have
- Exposure to big data technologies.
- Experience in application building or support on Teradata.
We'll score your resume against this role and send you a free assessment. Sampoorna's team follows up directly with strong matches.