Data Warehouse Developer

InnoSoul•Austin, TX

1d•Hybrid

About The Position

The Worker is responsible for performing computer systems analysis or development work. Work involves coordinating, planning and analysis of user requirements, procedures, and problems to automate processing or to improve existing systems. This role may also be responsible for the following: We would like the Database Administrator to have the following skillsets and understanding: 1. Azure Expertise: · Deep understanding of Microsoft Azure services, particularly Azure SQL Database and other database offerings. · Experience with Azure DevOps, including CI/CD pipelines and automation. · Familiarity with Azure Resource Manager (ARM) templates, Azure CLI, and PowerShell scripting. 2. Azure Data bricks expertise Deep understanding of Azure data bricks and warehouse concepts 3. MDM Expertise: · Deep understanding of Informatica MDM and working with data profiling 4. Devops Expertise: · Experience implementing DevOps practices, such as Continuous Integration/Continuous Deployment (CI/CD). · Understanding of version control systems (e.g., Git) and collaboration with development teams to integrate database changes seamlessly. · Experience with containerization and orchestration (e.g., Docker, Kubernetes). · Deployment exposure in SalesForce and MuleSoft environment. 5. Database Management: · Proficient in database administration, maintenance, tuning, and optimization for Oracle, Postgre SQL, Sybase and other databases. · Knowledge of database backup, recovery, and disaster recovery procedures. · Experience in database security, including data encryption, authentication, and authorization. 6. Development and Automation: · Proficiency in Oracle and Postgresql and ability to write complex SQL queries and stored procedures. · Hands-on experience with automation tools and Infrastructure as Code (IaC) practices. · Ability to create, manage, and monitor database deployment and migration strategies. · Monitoring and Performance Tuning: · Familiarity with monitoring tools and performance analysis to optimize database performance. · Expertise in identifying and resolving database performance issues, such as bottlenecks and slow queries. 7. Soft Skills: · Problem-Solving: Strong analytical skills to diagnose and troubleshoot complex database issues. · Collaboration: Ability to work in a cross-functional team environment, collaborating with developers, system administrators, and other stakeholders. · Communication: Clear and effective communication skills to document processes and explain technical details to non-technical stakeholders. · Project Management: Ability to manage multiple projects and prioritize tasks effectively.

Requirements

4 Years Required Experience in Data warehouse aggregation and integration of data across multiple applications
4 Years Required Experiencing in assessing existing databases and multiple information sources for the purpose of integrating existing data while improving data access, storage, data transparency and operational functions.
4 Years Required Working knowledge of data warehouse end-to-end implementation processes, from business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, and performance tuning.
4 Years Required Enterprise Portal Application working knowledge
4 Years Required Excellent communication skills verbally and in writing used when leading development activities, presenting to leadership, and training less experienced developers.
3 Years Required Experience with user journey mapping, story boarding, creating mockups and wireframes, application usability design, fast prototyping, and proof-of-concept development.
2 Years Required Performance management dashboard development.

Nice To Haves

Strong working knowledge of Tableau Software, Power BI, Power Apps, Oracle APEX.
Strong working knowledge of Azure AD B2C, Azure ADF.
Strong scripting experience using Python for data integration.
Familiarity with Informatica MDM, Informatica data Governance.
Strong working knowledge of the following DFPS systems/programs (including but not limited to): IMPACT, ABCS.
Technical Documentation including Design Documents, Standards, and Configuration Plans.
Experience as a participant in agile software development teams.
Experience with Federal, State, or Local government data reporting; with strong understanding of state government.
Working knowledge of Web Content Accessibility Guidelines (WCAG) 2.0 / Sec 508
Azure Expertise: Deep understanding of Microsoft Azure services, particularly Azure SQL Database and other database offerings.
Azure Expertise: Experience with Azure DevOps, including CI/CD pipelines and automation.
Azure Expertise: Familiarity with Azure Resource Manager (ARM) templates, Azure CLI, and PowerShell scripting.
Azure Data bricks expertise Deep understanding of Azure data bricks and warehouse concepts
MDM Expertise: Deep understanding of Informatica MDM and working with data profiling
Devops Expertise: Experience implementing DevOps practices, such as Continuous Integration/Continuous Deployment (CI/CD).
Devops Expertise: Understanding of version control systems (e.g., Git) and collaboration with development teams to integrate database changes seamlessly.
Devops Expertise: Experience with containerization and orchestration (e.g., Docker, Kubernetes).
Devops Expertise: Deployment exposure in SalesForce and MuleSoft environment.
Database Management: Proficient in database administration, maintenance, tuning, and optimization for Oracle, Postgre SQL, Sybase and other databases.
Database Management: Knowledge of database backup, recovery, and disaster recovery procedures.
Database Management: Experience in database security, including data encryption, authentication, and authorization.
Development and Automation: Proficiency in Oracle and Postgresql and ability to write complex SQL queries and stored procedures.
Development and Automation: Hands-on experience with automation tools and Infrastructure as Code (IaC) practices.
Development and Automation: Ability to create, manage, and monitor database deployment and migration strategies.
Monitoring and Performance Tuning: Familiarity with monitoring tools and performance analysis to optimize database performance.
Monitoring and Performance Tuning: Expertise in identifying and resolving database performance issues, such as bottlenecks and slow queries.
Soft Skills: Problem-Solving: Strong analytical skills to diagnose and troubleshoot complex database issues.
Soft Skills: Collaboration: Ability to work in a cross-functional team environment, collaborating with developers, system administrators, and other stakeholders.
Soft Skills: Communication: Clear and effective communication skills to document processes and explain technical details to non-technical stakeholders.
Soft Skills: Project Management: Ability to manage multiple projects and prioritize tasks effectively.

Responsibilities

Data warehouse aggregation and integration of data across multiple applications
Assessing existing databases and multiple information sources for the purpose of integrating existing data while improving data access, storage, data transparency and operational functions.
Data warehouse end-to-end implementation processes, from business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, and performance tuning.
Enterprise Portal Application working knowledge
Leading development activities, presenting to leadership, and training less experienced developers.
User journey mapping, story boarding, creating mockups and wireframes, application usability design, fast prototyping, and proof-of-concept development.
Performance management dashboard development.
Deep understanding of Microsoft Azure services, particularly Azure SQL Database and other database offerings.
Experience with Azure DevOps, including CI/CD pipelines and automation.
Familiarity with Azure Resource Manager (ARM) templates, Azure CLI, and PowerShell scripting.
Deep understanding of Azure data bricks and warehouse concepts
Deep understanding of Informatica MDM and working with data profiling
Experience implementing DevOps practices, such as Continuous Integration/Continuous Deployment (CI/CD).
Understanding of version control systems (e.g., Git) and collaboration with development teams to integrate database changes seamlessly.
Experience with containerization and orchestration (e.g., Docker, Kubernetes).
Deployment exposure in SalesForce and MuleSoft environment.
Proficient in database administration, maintenance, tuning, and optimization for Oracle, Postgre SQL, Sybase and other databases.
Knowledge of database backup, recovery, and disaster recovery procedures.
Experience in database security, including data encryption, authentication, and authorization.
Proficiency in Oracle and Postgresql and ability to write complex SQL queries and stored procedures.
Hands-on experience with automation tools and Infrastructure as Code (IaC) practices.
Ability to create, manage, and monitor database deployment and migration strategies.
Familiarity with monitoring tools and performance analysis to optimize database performance.
Expertise in identifying and resolving database performance issues, such as bottlenecks and slow queries.
Strong analytical skills to diagnose and troubleshoot complex database issues.
Ability to work in a cross-functional team environment, collaborating with developers, system administrators, and other stakeholders.
Clear and effective communication skills to document processes and explain technical details to non-technical stakeholders.
Ability to manage multiple projects and prioritize tasks effectively.