Asst Manager_ SQL SAC Developer

Qualifications:

Bachelor’s degree in Computer Science, Information Technology, or a related field.
Minimum of 3 to 9  years of experience in SQL development.
Proven experience with GCP BigQuery and ETL processes.
Strong knowledge of Signavio Process Intelligence would be preferred.
Proficiency in SAP Analytics Cloud (SAC) development would be preferred. 
Excellent problem-solving skills and attention to detail.
Strong communication and collaboration skills.
 

Key Responsibilities

SQL Development:
    Design, develop, and optimize complex SQL queries, stored procedures, and functions.
    Ensure data integrity and performance optimization of SQL databases.
    

Requirements Gathering:
    Work closely with business analysts and stakeholders to gather and document detailed requirements.
    Translate business requirements into technical specifications for database solutions.

System Design:
    Design database schemas, tables, views, indexes, and other database objects.
    Develop data models and database architecture to support business needs.
    Ensure scalability, reliability, and performance of database systems.

Development:
    Implement database solutions based on design specifications.
    Write efficient and maintainable SQL code.
    Develop and maintain ETL processes to integrate data from various sources.

Testing:
    Develop and execute unit tests to ensure the quality and functionality of SQL code.
    Collaborate with QA teams to support integration and system testing.
    Identify and fix defects in a timely manner.

Deployment:
    Prepare database scripts and deployment packages.
    Coordinate with DevOps and IT teams to deploy database changes to production environments.
    Ensure smooth and error-free deployment of database updates.

Maintenance and Support:
    Monitor database performance and troubleshoot issues.
    Provide ongoing support and maintenance for database systems.
    Implement database security measures and backup/recovery procedures.

Documentation:
    Create and maintain comprehensive documentation for database designs, processes, and procedures.
    Ensure documentation is up-to-date and accessible to relevant stakeholders. GCP BigQuery ETL:
    Develop and manage ETL processes using Google Cloud Platform’s BigQuery.
    Design and implement data pipelines to ingest, process, and store large datasets.
    Optimize BigQuery performance and cost-efficiency.

Signavio Process Intelligence:
    Utilize Signavio Process Intelligence to analyze and optimize business processes.
    Develop process models and dashboards to provide insights into process performance.
    Collaborate with business units to identify process improvement opportunities.

SAC Development:
    Design and develop dashboards and reports using SAP Analytics Cloud.
    Integrate SAC with various data sources to provide comprehensive analytics solutions.
    Ensure the accuracy and reliability of SAC reports and visualizations.