Psiog Digital is a pure play software services specialist focusing on delivering technology services & solutions in the areas of operational efficiency & customer experience.

Headquartered in Chennai, India, Psiog services global customers in North America, EMEA, ANZ & APAC across a variety of industries such as Manufacturing, Energy & Utilities, Hi-Tech, Financial Services, Retail and Automobile. Psiogs core expertise is in building, implementing, testing, integrating & maintaining applications leveraging a variety of cutting-edge tools &
technologies.

Key service offerings for the mid-market segment are :

- Application Development & Maintenance

- Outsourced Product Development

- Testing & Automation

For further information about the company, please visit http ://www.psiog.com/

Years of experience : 4 to 8

Job Description :

Mandatory Skills :

- Strong ETL/ELT and SQL development expertise using cloud-based data solutions (Azure SQL, Synapse, Snowflake, Redshift, Databricks)

- Extensive hands-on experience with Databricks, including :

1. Cluster design, configuration, scaling, and performance optimization

2. Implementing Delta Lake, data ingestion, transformation, and job orchestration

3. Managing cost efficiency and autoscaling policies

4. Integrating Databricks with Azure Data Factory, Power BI, and other downstream tools

5. Implementing Unity Catalog for data governance and access control

- Design and develop star schema and data vault models; build scalable and reusable ETL/ELT pipelines

- Design/Develop using best-practice techniques across data modeling, table-driven transformation, and parameterized, dynamic ETL/ELT jobs

- Establish and maintain reporting dashboard solutions for enterprise analytics

- Exposure to programming languages (Python, Scala, Java)

Preferred Skills :

- Strong understanding of Databricks architecture (control plane, data plane, cluster policies, job clusters vs all-purpose clusters)

- Experience implementing data governance, security, and monitoring using Unity Catalog, Azure Key Vault, and role/row-based access

- Knowledge of CI/CD for Databricks (e.g., using Azure DevOps, GitHub Actions, or Terraform)

- Advanced SQL and experience with ETL tools (ADF, Matillion, Informatica, SSIS)

- Familiarity with event-based integrations, API-led connectivity, and microservices

- Exposure to data observability and lineage tracking using tools like Purview or Collibra

What Psiog Offers :

- Opportunity to be part of the Technology Advisory Council (TAC) a niche technology focused group with a defined roadmap for professional and competency growth

- Exposure to enterprise data management projects across diverse technologies, domains, and customers

- Role across multiple projects enabling architecture reviews, technical mentoring, and solution leadership

- Research, evaluate, and recommend tools and processes to ensure high-quality software delivery

- Implement and enforce best practices across data architecture and development lifecycle

- Scope to experiment, innovate, and drive thought leadership in modern data platform technologies including Databricks, Azure Fabric, and Snowflake