Data Warehouse Developer

We are seeking an experienced Data Warehouse Developer to design, develop, and maintain scalable data warehouse solutions that support enterprise analytics, reporting, and data-driven decision-making. This role requires strong expertise in ETL/ELT development, data modeling, SQL optimization, and cloud-based data platforms.The ideal candidate is a collaborative problem solver with a passion for building high-performing, reliable data solutions in a fast-paced Agile environment.Key Responsibilities:Design, develop, and maintain enterprise data warehouse architectures and data martsBuild and optimize ETL/ELT pipelines to integrate data from multiple source systemsDevelop and maintain dimensional and relational data models, including star and snowflake schemasWrite, optimize, and troubleshoot complex SQL queries, stored procedures, and database viewsEnsure data quality, consistency, and integrity through validation, monitoring, and testing processesCollaborate with data engineers, BI developers, analysts, and business stakeholders to gather requirements and deliver scalable solutionsSupport enterprise reporting, dashboarding, and analytics initiativesImplement database performance tuning strategies including indexing and partitioningManage data security, access controls, and compliance standardsCreate and maintain technical documentation for data models, pipelines, and warehouse architectureParticipate in Agile ceremonies including sprint planning, daily standups, and retrospectivesRequired Qualifications:5+ years of experience as a Data Warehouse Developer or in a similar data engineering roleAdvanced proficiency in SQL and database developmentStrong hands-on experience with Informatica IDMC CDI and CAISolid understanding of data warehousing concepts and dimensional modeling techniquesExperience working with large-scale datasets and performance optimizationFamiliarity with Agile/Scrum development methodologiesStrong analytical, troubleshooting, and problem-solving skillsPreferred Qualifications:Experience working with cloud data platforms such as AWSExposure to machine learning or advanced analytics workloadsUnderstanding of data governance, metadata management, and data lineage concepts