| About Company Providing innovative, comprehensive, and end-to-end information technology and workforce management solutions that empower businesses to achieve digital transformation, enhance operational efficiency, and drive sustainable growth Job Description The Data Warehouse Engineer is responsible for designing, developing, and maintaining enterprise data warehouse infrastructure and ETL (Extract, Transform, Load) solutions that support strategic decision-making and operational efficiency. This role requires strong expertise in data integration, database management, and modern data engineering practices. The position collaborates closely with business stakeholders and cross-functional teams to gather requirements, implement scalable data solutions, and ensure the availability of high-quality, reliable data assets for business intelligence and analytics initiatives. Key Responsibilities ETL Development and Data Integration Design, develop, and maintain complex ETL workflows using enterprise tools such as Informatica Extract data from diverse source systems, apply transformation logic, and load into data warehouse environments Implement automated validation processes to ensure data accuracy and integrity Develop Python scripts and APIs for automation, data processing, and integration tasks Data Warehouse Design and Optimization Design and maintain efficient data warehouse structures (schemas, tables, views, materialized views) Perform performance tuning, including query optimization, clustering keys, and partitioning strategies Apply best practices in data modeling and architecture Utilize advanced platform features such as time travel, zero-copy cloning, and data sharing Ensure scalability, efficiency, and optimal system performance Business Intelligence Support and Collaboration Provide Level III technical support for BI and decision support tools Collaborate with business stakeholders to translate requirements into technical solutions Troubleshoot complex data issues Develop reports and visualizations using tools such as Power BI and Cognos Ensure data accuracy, usability, and efficiency for business users Data Pipeline Development and API Integration Design and implement scalable modern data pipelines Develop Python-based solutions for data ingestion and transformation Integrate systems through APIs and web services Leverage platform capabilities such as: Streams and Tasks Continuous data ingestion (e.g., Snowpipe) External functions for integrations Ensure reliability and scalability in a 24/7/365 enterprise environment Required Skills & Experience Bachelor's degree in Computer Science, Engineering, Business, or related field Minimum 5 years of experience in data warehousing, ETL development, and database management Strong expertise with Informatica and BI tools such as Snowflake, Power BI, and Cognos Advanced proficiency in SQL and cloud-based data warehouse technologies Hands-on experience with Snowflake architecture, administration, and optimization Experience using Python for data engineering tasks Knowledge of API development and system integration Strong analytical, problem-solving, and communication skills Demonstrated ability to collaborate effectively across teams Ability to obtain and maintain required gaming licenses in multiple jurisdictions Preferred Experience Advanced SQL and relational database expertise Deep knowledge of Snowflake ecosystem (SnowSQL, Snowpipe, Streams, Tasks, Data Sharing) Strong understanding of data modeling and architecture principles Experience with API development and integration frameworks Knowledge of governance frameworks such as COBIT and ITIL Solid understanding of Software Development Lifecycle (SDLC) and data engineering best practices |
Data Warehouse Engineer (Informatica) • CT, United States
Client is looking for a strong Market Data Analyst that has experience with customer segmentation, email campaigns and other targeted messaging strategies.Should be senior level with excellent comm... Show more
Clients need a single point of contact who actually understands hardware, not just a relationship manager who has to relay every technical question.Projects span hardware deployment, structured cab... Show more
POSITION :SALESFORCE DEVELOPER LOCATION :Hartford , Connecticut hybrid JOB DESCRIPTION :Specific Services Required :In the role of the Salesforce Developer, the following services are required :Mus... Show more
Job Description: Aggressive Aerospace company located close to New Haven, CT is looking for a CI Leader who can help the organization reach aggressive goals.This person will report directly to the ... Show more
Join a team that keeps European cars performing at their best Are you someone who enjoys staying active, working with your hands, and being part of a team that gets things done? As a Fulfillment As... Show more
Job SummaryWe are seeking a motivated and detail-oriented Data Entry Clerk to join our dynamic team! In this vital role, you will be responsible for accurately inputting, updating, and maintaining ... Show more
Legendary food and service begins with legendary people.We believe in earning the loyalty of our Team Members with our strong, diverse culture, well-done benefits and growth opportunities.It takes ... Show more
This is an on-site position supporting mission-critical infrastructure at premier data center facilities.Project-based or ongoing support.Remote hands and smart hands services.Perform hardware inst... Show more
Job Overview:As a Warehouse Worker/Order Selector at our optical store, you will play a critical role in ensuring accurate and efficient handling of eyeglasses, contact lenses, and optical supplies... Show more
Superprof is the leading tutoring platform in the USA, connecting passionate individuals with eager learners.We operate in over 41 countries, making education accessible to everyone, everywhere.Sup... Show more
Job Description**: As a Freight Handler at FedEx, you will be responsible for managing the movement of freight within the warehouse.This includes loading and unloading trucks, organizing freight, a... Show more
Join a team that keeps European cars performing at their best Are you someone who enjoys staying active, working with your hands, and being part of a team that gets things done? As a Fulfillment As... Show more
JOB SUMMARYThe Senior Software Engineer is a focused, mid-level professional who develops and maintains Sentinel U's learning platform using modern web technologies across the full stack.ESSENTIAL ... Show more
Hiring for a Supply Planner in West Haven!.The Supply Planner is responsible for ensuring the right quantities of products are available at the right time to meet customer demand while minimizing c... Show more
