EDW Developer (Teradata / Informatica)
Job Title: EDW Developer Experience: 3–5 Years Level: L2 Domain: Data / Enterprise Data Warehouse Primary Skills: Teradata, Informatica Database: AS400 DB2, Teradata, Oracle, SQL Server, PostgreSQL Operating Systems: AS400, AIX, Linux, Windows
Job Overview
We are looking for an experienced EDW Developer with 3–5 years of experience in Enterprise Data Warehousing, Teradata and Informatica technologies.
The candidate should have hands-on experience in data integration, ETL development, SQL, data processing and supporting Global Data Warehouse (GDW) and Data Mart projects.
Key Responsibilities
- Develop, maintain and support Enterprise Data Warehouse (EDW) solutions.
- Work on Global Data Warehouse (GDW) and Data Mart development.
- Develop and support ETL workflows using Informatica Data Integration tools.
- Work with Teradata databases for data processing and SQL development.
- Perform data extraction, transformation, loading and validation activities.
- Work with different databases, including AS400 DB2, Teradata, Oracle, SQL Server and PostgreSQL.
- Support data quality, data profiling and data validation activities.
- Troubleshoot data integration and database-related issues.
- Collaborate with business analysts, data architects and development teams.
Mandatory / Core Technical Skills
- 3–5 years of experience in Data Warehousing / EDW development.
- Hands-on experience with Teradata.
- Knowledge of Teradata IntelliFlex.
- Experience with Informatica Data Integration suite of tools.
- Knowledge of Informatica BDM, IDQ and IDL.
- Strong SQL and database concepts.
- Understanding of ETL and data integration processes.
- Experience working with GDW and Data Marts.
Database Technologies
- AS400 DB2
- Teradata
- Oracle
- Microsoft SQL Server
- PostgreSQL
Additional Technical Skills
Data & Analytics:
- SAS
- Microsoft R
- Spark
- Cloudera Data Science Workbench
- Hive, Impala and HUE
- Kafka
Sourced from a public career listing. Jobverse is an aggregator, not the employer.