Highlights
Design complex data systems, optimize SQL queries, and build scalable ETL pipelines.
Description
Job Summary
pJoin apexanalytix as a Data Platform Developer to design, develop, and maintain large-scale data systems. You will work on complex SQL queries, ETL pipelines, and ensure high performance and scalability of data-driven solutions.
Responsibilities
- Design and develop advanced SQL queries, views, functions, and stored procedures.
- Create and optimize data transformation and validation logic.
Required Skills
- Advanced SQL development and optimization
- Relational databases and large-scale datasets
- Data transformation and validation logic using SQL
- Data processing and scripting (Python, Java)
- Workflow orchestration tools like Airflow or Dagster
Required Skills Explained
{'html': '
- Advanced SQL development and optimization skills to design, develop, and maintain complex SQL queries, views, functions, and stored procedures.
- Experience with relational databases and large-scale datasets for building and optimizing data transformation, validation, and processing logic.
- Knowledge of ETL/ELT pipelines for batch and incremental workloads using tools like Airflow or Dagster.
- Proficiency in implementing complex data transformations and validation logic using SQL and other programming languages such as Python, Java, C#.
- Understanding of SQL performance tuning, indexing, and optimization techniques to ensure high performance with large datasets.
'}
Who is this for
pThis role is ideal for candidates with a background in data engineering and architecture. You should be proficient in SQL, experienced in ETL pipelines, and familiar with workflow orchestration platforms.
Why This Job is a Good Opportunity
{'html': 'ulliWork on cutting-edge data systems that drive innovation in procure-to-pay solutions for global clients.liCollaborate with diverse teams including Analytics, Engineering, and Product to shape the future of technology-driven business processes.liBenefit from a company culture that values growth and development through comprehensive training programs and mentorship opportunities.liEnjoy competitive benefits packages and initiatives like BeWell@apex that focus on holistic employee well-being.'}
Interview Preparation Tips
{'html': '
- Prepare examples of how you have successfully designed, developed, and maintained large-scale data systems in previous roles.
- Demonstrate your hands-on experience with SQL performance tuning and optimization techniques through relevant projects or case studies.
- Showcase your ability to work effectively with ETL/ELT pipelines and workflow orchestration tools like Airflow or Dagster.
- Highlight any specific programming languages or data processing tools you are proficient in, such as Python, Java, or dbt.
'}
Career Growth in This Role
{'html': "pThe Data Platform Developer role offers a robust pathway for career advancement within the Software Development department. As you gain expertise and demonstrate your capabilities, opportunities to take on more complex projects and lead cross-functional teams may arise. The company values growth, providing resources such as mentorship programs, internal training portals, and assistance with education and certifications. This environment supports not only technical but also professional development, ensuring that individuals can progress in their careers while contributing to the company's success."}
Explore More Opportunities
Skills
Frequently Asked Questions
What is the work schedule like?The position follows a flexible schedule from 5:30 PM to 2:30 AM IST.
What kind of documentation skills are required?Clear documentation of SQL logic, data pipelines, and dependencies is essential for this role.
Is there room for growth in the position?Yes, we offer career development opportunities through our mentorship program and training portal.
