Atleast 12 -- 15 years of Experience.
E/B.Tech/M.C.A Eduction Required.
Communicate with the Business Analyst and Data Analyst to fully understand requirements, provide feedback, and request clarification, as needed.
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.
Skills and Experience
Architect technical solutions to satisfy BI needs as per BI Strategy Conceptualize, design, and implement database migration, ETL migration, job scheduling tool migration.
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.