DWH ETL Architect

  • Pune
  • 20-25 lakh
  • 11-15 years
  • 26 Jun 2015

  • IT/ Information Technology

  • IT/ Technology - Telecom Software, 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

Interested Candidate please help me with below ratings.Skill Expertise Level (1-5)

RDBMS as a Developer
Unix Platform
Unix Shell Scripting
SQL Tuning/ Optimization
PL/SQL Development
ETL Development (using ETL tool or Native)
BI Development (BI Products)
Data Modeling (3NF)
Data Modeling (Dimensional)
Hadoop Ecosystem
AWS Cloud