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