DATA WAREHOUSE DEVELOPER II (13+ YEARS EXPERIENCE) @ ENCORE C
Encore C is currently seeking a highly experienced Data Warehouse Developer II for a long-term contract position located in Madison, Wisconsin. This role is specifically open to H1B candidates and requires a professional with at least 13 years of extensive experience in Data Warehousing and SQL technologies. The successful candidate will be responsible for designing, developing, and maintaining robust data warehouse solutions to support complex business requirements.
Candidates must possess at least 3 years of hands-on experience with Informatica IDMC and demonstrate high proficiency in working with various database systems including Oracle, DB2, and SQL Server. This position offers a unique opportunity to contribute to large-scale data projects in a dynamic environment. Applicants are expected to manage end-to-end ETL processes and ensure data integrity across multiple platforms while working closely with stakeholders to deliver high-quality data architecture and business intelligence solutions.
Candidates must possess at least 3 years of hands-on experience with Informatica IDMC and demonstrate high proficiency in working with various database systems including Oracle, DB2, and SQL Server. This position offers a unique opportunity to contribute to large-scale data projects in a dynamic environment. Applicants are expected to manage end-to-end ETL processes and ensure data integrity across multiple platforms while working closely with stakeholders to deliver high-quality data architecture and business intelligence solutions.
Key Requirements
Minimum of 13 years of professional experience in Data Warehousing.
Minimum of 13 years of experience with SQL development and optimization.
At least 3 years of hands-on experience with Informatica IDMC.
Deep technical proficiency in Oracle database environments.
Expertise in working with IBM DB2 systems.
Significant experience in Microsoft SQL Server management.
Must be a valid H1B visa holder (position restricted to H1B candidates).
Proven ability to design and implement complex ETL processes.
Strong understanding of data modeling and architecture principles.
Excellent analytical, communication, and problem-solving skills for a long-term contract environment.