ETL Developer
Job Description
Perform advanced extract, transform, and load (ETL) data into the client's data warehouse solution. Design, develop, and test ETL processes for the data warehouse. Develop and document ETL processes to extract data from existing systems into the data warehouse. Document the as-is schemas currently in use at the client. Perform other analysis and documentation tasks as required to facilitate and support the client's Enterprise Data Warehouse. Perform other duties as assigned to maintain IT operations.
Candidate Skills and Qualifications
7 years of required hands-on experience with data warehouse development (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server, etc., preferably Oracle.
7 years of required experience with Oracle PL/SQL.
7 years of required experience with working successfully with technical and non-technical groups and managing multiple responsibilities.
7 years of required communication, analytical, and interpersonal skills at all levels.
7 years of required technical writing skills.
Preferred Qualifications:
6 years of preferred experience with more than one type of RDBMS (DB2, SQL Server, Oracle).
4 years of preferred experience in Public Sector delivery.
4 years of preferred experience writing dynamic SQL.
4 years of preferred experience with the Informatica product suite in the Informatica cloud.
Job Type: Contract
Pay: $60.00 - $70.00 per hour
Benefits:
Dental insurance
Health insurance
Paid time off
Vision insurance
Schedule:
8 hour shift
Experience:
Informatica: 1 year (Preferred)
SQL: 1 year (Preferred)
Data warehouse: 1 year (Preferred)
Work Location: Remote