Data Warehouse / Business Inteligent
Data Warehouse, PL/SQL, SQL
2 - 7 years
Posted Date :
-- Conceptualize, design, and implement database migration, ETL migration, job scheduling implementations. Present viable solution architecture and options to remediate and optimize software.
-- Develop ETL/ ELTL code using SQL, PL/SQL, Java, AWS and Hadoop command-line, and UNIX scripting (No third-party proprietary ETL tool used).
-- Support existing production environments end to end (Data Sourcing, Data Stores, Applications, Clusters, BI).
-- Support large scale MPP databases (Postgres, AWS Redshift, Greenplum) as a DBA.
-- Provide development and operational services on HortonWorks Hadoop (HDP 2.2). Should be proficient in writing and reviewing Pig, Hive, and MapReduce code.
-- Drive architectural best practices and guidelines on AWS (RDS, Redshift, EC2, S3, etc.)
-- 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.
-- Lead Agile development as a Scrum Master.
ITBMS is a global IT services company, offering a wide array of solutions customized for a range of key verticals and horizontals. Our unique approach includes implementing solutions to integrate your processes, as well as deploying the best business practices needed to harness the power of information systems more effectively in a global organisation.