Position Overview & Specifications
Job Description for Sr. Database Developer:Work independently to develop the data warehouse based on the requirements using PostgreSQL, SQL Server, Azure Data Factory, and Data Bricks.Participate in architecture discussions and design sessions and fully understand the data requirements the Data Architect provides.Implement best practices for database performance tuning, indexing, and data partitioning. Conduct regular data maintenance tasks, including data purging and archiving, and ensure data consistency and integrity.Develop, implement, and maintain robust ETL processes using tools like Pentaho Data Integration to ensure flawless data integration across various systems.Monitor ETL job performance, tackle issues, and optimize workflows for efficiency.Use sophisticated SQL skills to build complex queries, stored procedures, functions, and triggers for data analysis and reporting.Collaborate with business analysts to understand reporting requirements and design effective Power BI data models.Consistency to coding policies, user documentation, and operational subject area as defined by software development policies.