Data Warehouse Architect

Essen Consulting
  • Pulwama
  • 12-17 lakh
  • 12-18 years
  • 22 Jun 2015

  • Project/ Program Management IT

  • IT/ Technology - Hardware & Networking, IT/ Technology - Software/ Services, IT/ Technology - Data Center/ Manage Infrastructure Services
Job Description

Architect technical solutions to satisfy BI needs as per BI Strategy
Conceptualize, design, and implement database migration, ETL migration, job scheduling tool migration. Present viable solution architecture and options to re-mediate and optimize software
Conduct POCs on proposed solutions or technologies Utilize open source, Hadoop, and AWS wherever feasible as per tech policy Mentor, coach, and cross-train junior team members
Develop ETL code using SQL, PL/SQL and UNIX scripting (No third-party proprietary ETL tool used)
Support existing production ETL, Database, and BI environments. Additionally, support Hadoop cluster and AWS. Support data warehousing databases (Postgres, AWS Redshift) as a DBA
Troubleshoot and fix production tickets based on priority and take tactical and strategic actions
Perform database design, schema change management, and database administration tasks (backups/ restores). Perform proactive and reactive monitoring and performance tuning of operating systems, databases and application code. Review requirements and data models, and translate into ETL design processes that effectively populate data warehouse and data mart tables
Automate repetitive tasks to improve productivity and efficiency Conceptualize, design, and implement innovative solutions using open source, Hadoop, and Cloud Computing technologies
Communicate with the Business Analyst and Data Analyst to fully understand requirements, provide feedback, and request clarification, as needed Follow configuration and change management processes Maintain source code in GIT Produce quality software products, utilizing best practice methodology and technology Participate in daily standups and weekly status reporting.

- Person should be Hands-on with the technologies

- Highly competent in following:

o ETL development
o BI
o Client Management

Job Posted By

About Organisation

Essen Consulting