Expert Engineer, Database
Aeries TechnologyThis job is no longer accepting applications
Job Description
Job description
About The Role:
- Designing and implementing data models that align with business requirements; creating and managing database objects such as tables, views, and schemas within Snowflake.
- Developing and maintaining ETL processes to move data into and out of Snowflake; integrating data from various sources, ensuring data quality, and transforming data to meet business needs.
- Optimizing queries and data warehouse performance for efficiency and scalability; monitoring and troubleshooting performance issues to ensure optimal system responsiveness.
- Implementing and managing security measures to protect data within Snowflake; setting up and maintaining user roles, privileges, and access controls to ensure data security and compliance.
- Integrating Snowflake with other data sources and tools to facilitate seamless data flow and analysis; collaborating with other teams to ensure data integration aligns with overall business goals.
- Automating routine tasks and processes to improve efficiency; orchestrating data workflows and dependencies to ensure timely and accurate data processing.
- Monitoring system health, performance, and resource utilization; conducting regular maintenance tasks such as backups, updates, and patches to keep the system running smoothly.
About You:
- In-depth knowledge and hands-on experience with Snowflake architecture, features, and capabilities.
- Proficiency in creating and managing data objects, such as databases, tables, and views in Snowflake.
- Strong SQL skills for querying, data manipulation, and performance optimization within the Snowflake environment.
- Experience in designing, developing, and maintaining ETL processes for data integration using tools like Snowflake's native features and Apache Airflow.
- Knowledge of data modelling principles and experience in designing effective and efficient data models.
- Proficiency in scripting languages such as Python or Java for automating tasks and implementing custom solutions.
- Knowledge of data security best practices and experience implementing security measures within Snowflake; understanding of compliance requirements relevant to the organization's industry.
- Experience in automating routine tasks and orchestrating data workflows; familiarity with tools like Apache Airflow or similar workflow orchestration tools.
- Ability to collaborate with cross-functional teams, including data scientists, analysts, and business stakeholders.
- Strong problem-solving skills and the ability to troubleshoot complex data issues.
- Effective communication and teamwork skills and possess the ability to communicate clearly and effectively in oral and written form.
Role: Database Developer / Engineer
Industry Type: IT Services & Consulting
Department: Engineering - Software & QA
Employment Type: Full Time, Permanent
Role Category: DBA / Data warehousing
Education
UG: Any Graduate
PG: Any Postgraduate
More Info
About Company
ATG is a Global Business Services (GBS) company offering outsourcing solutions, business process management, and technological advancements to organizations seeking higher operational effectiveness, greater flexibility, and cost savings. We help create a virtual extension of our clients’ enterprise with an operational framework which is simple, flexible and resilient. ATG enables its clients to extend current capabilities and build value-added services by providing global access to resources and diverse skill sets, including best practices in multiple processes and technology domains. Our services are designed to aid businesses improve their operational efficiencies, performance and reduce costs.
