Collabera - Richmond, VA
posted 3 months ago
The ETL Lead Developer will play a crucial role in the design, development, and maintenance of ETL processes using Intelligent Data Management Cloud (IDMC) and Informatica PowerCenter. This position requires a deep understanding of data warehousing architecture and the ability to work with complex data transformation functions. The ideal candidate will have extensive experience in ETL development, focusing on extracting, converting, and loading data efficiently and accurately. The role involves collaborating with various stakeholders to understand data requirements and ensure that the ETL processes align with business needs. Additionally, the ETL Lead Developer will be responsible for automating ETL workflows and optimizing performance to handle large volumes of data effectively. The candidate will also be expected to write complex SQL queries and apply business logic to cleanse, aggregate, and format data. A strong background in coding languages such as Java, XML, and SQL is essential, as well as familiarity with warehousing architecture techniques including MOLAP, ROLAP, ODS, DM, and EDW. The position is hybrid, allowing for a combination of remote and on-site work, and is offered as a 12-month contract. The successful candidate will be part of a dynamic team focused on leveraging data to drive business insights and decision-making.