Data Warehouse Developer /architects Job in Maatrom Hr Solution

Job Description

• Develop and lead the enterprise data strategy for the enterprise data platform.
• Architect, implement and deploy systems using AWS services such as Athena, Glue, Lambda, S3, DynamoDB NoSQL, Relational Database Service (RDS), Amazon EMR and Amazon Redshift.
• Develop domain driven data model.
• Build data access strategy to securely democratize data with the data hub and enable research and, modeling.
• Supporting data layer enabled API platform.
• Participate in enterprise level design board discussions.
• Technical leadership/mentoring for the data team.
• The role requires working knowledge in setting, provisioning and querying:
• Relational data stores: PostgresQL, MySQL, Amazon RDS, Amazon Aurora
• NoSQL data stores: MongoDB, AWS DynamoDB
• Data warehouse: Amazon Redshift
• Amazon RDS Proxy

• Architect design patterns that support data ingestion, data movement, transformation, aggregation, machine learning and data science.
• Develop and enforce data governance model for data lineage, metadata management, data quality, data security, reporting & analytics and regulatory compliance.
• Oversee the migration of data from legacy systems to new distributed data stores.

QUALIFICATIONS

• Bachelor s degree in Computer Science, Engineering, Mathematics or a related field or equivalent professional or military experience
• Extensive hands on experience in leading large-scale full-cycle MPP enterprise data warehousing (EDW) projects
• 8+ years of development and/or DBA experience in Relational Database Management Systems (RDBMS)
• 5+ years of hands-on experience in implementation and performance tuning MPP database Amazon Redshift. Teradata, Vertica, Netezza, Greenplum
• Experience designing database environments, analyzing production deployments, and making recommendations to optimize performance
• Bachelor s degree in Computer Science or related field
• AWS certified:
  • Developer Associate
  • SysOps Administrator Associate
  • DevOps Engineer Professional
  • Solutions Architect Associate
  • Solutions Architect Professional
  • AWS Certified Cloud Practitioner
• Ability to evaluate and plan migrations to Amazon Redshift
• Excellent SQL and strong hands-on scripting (bash, perl or python) ability
• Experience implementing AWS services in a variety of distributed computing, enterprise environments