Data Warehouse Developer

Role Overview: As a Data Warehouse Developer II at Beacon Hill, you will play a key role in supporting the design, development, and optimization of enterprise data warehouse and ETL solutions. Your main focus will be on building and maintaining scalable, high-performing data pipelines using Informatica Data Management Cloud (IDMC). You will collaborate with business stakeholders and IT teams to translate requirements into technical solutions, ensuring data accuracy, integrity, and security compliance. Key Responsibilities: - Design, develop, test, and implement ETL solutions using Informatica IDMC - Build and maintain data integrations using mappings, taskflows, parameter files, and reusable transformations - Support data warehouse development, enhancement, and ongoing maintenance - Perform ETL and query performance tuning and optimization - Collaborate with business stakeholders and IT teams to translate requirements into technical solutions - Support migration and modernization efforts within the data warehouse environment - Participate in on-call support as required during business hours (CST) Qualifications Required: - Data warehousing process design, development, and performance tuning using Informatica tools (4+ years) - Strong hands-on experience with Informatica IDMC (3+ years) - Relational database experience (Oracle, DB2, SQL Server) (3+ years) - Strong SQL for data management and analysis (4+ years) - Ability to work independently with moderate supervision Additional Details: Beacon Hill Technologies, a premier National Information Technology Staffing Group, provides world-class technology talent across all industries utilizing a complete suite of staffing services. They cover a broad spectrum of IT positions, including Project Management and Business Analysis, Programming/Development, Database, Infrastructure, Quality Assurance, Production/Support, and ERP roles. Beacon Hill Technologies' dedicated team of recruiting and staffing experts consistently delivers quality IT professionals to solve customers' technical and business needs. Role Overview: As a Data Warehouse Developer II at Beacon Hill, you will play a key role in supporting the design, development, and optimization of enterprise data warehouse and ETL solutions. Your main focus will be on building and maintaining scalable, high-performing data pipelines using Informatica Data Management Cloud (IDMC). You will collaborate with business stakeholders and IT teams to translate requirements into technical solutions, ensuring data accuracy, integrity, and security compliance. Key Responsibilities: - Design, develop, test, and implement ETL solutions using Informatica IDMC - Build and maintain data integrations using mappings, taskflows, parameter files, and reusable transformations - Support data warehouse development, enhancement, and ongoing maintenance - Perform ETL and query performance tuning and optimization - Collaborate with business stakeholders and IT teams to translate requirements into technical solutions - Support migration and modernization efforts within the data warehouse environment - Participate in on-call support as required during business hours (CST) Qualifications Required: - Data warehousing process design, development, and performance tuning using Informatica tools (4+ years) - Strong hands-on experience with Informatica IDMC (3+ years) - Relational database experience (Oracle, DB2, SQL Server) (3+ years) - Strong SQL for data management and analysis (4+ years) - Ability to work independently with moderate supervision Additional Details: Beacon Hill Technologies, a premier National Information Technology Staffing Group, provides world-class technology talent across all industries utilizing a complete suite of staffing services. They cover a broad spectrum of IT positions, including Project Management and Business Analysis, Programming/Development, Database, Infrastructure, Quality Assurance, Production/Support, and ERP roles. Beacon Hill Technologies' dedicated team of recruiting and staffing experts consistently delivers quality IT professionals to solve customers' technical and business needs.