Job Description

Hybrid, Mumbai

About Us

We empower enterprises globally through intelligent, creative, and insightful services for data integration, data analytics and data visualization.
Hoonartek is a leader in enterprise transformation, data engineering and an acknowledged world-class Ab Initio delivery partner.
Using centuries of cumulative experience, research and leadership, we help our clients eliminate the complexities & risk of legacy modernization and safely deliver big data hubs, operational data integration, business intelligence, risk & compliance solutions and traditional data warehouses & marts.
At Hoonartek, we work to ensure that our customers, partners and employees all benefit from our unstinting commitment to delivery, quality and value. Hoonartek is increasingly the choice for customers seeking a trusted partner of vision, value and integrity

How We Work?

Define, Design and Deliver (D3) is our in-house delivery philosophy. It's culled from agile and rapid methodologies and focused on 'just enough design'. We embrace this philosophy in everything we do, leading to numerous client success stories and indeed to our own success.
We embrace change, empowering and trusting our people and building long and valuable relationships with our employees, our customers and our partners. We work flexibly, even adopting traditional/waterfall methods where circumstances demand it. At Hoonartek, the focus is always on delivery and value.

Experience Between 12 Years and 18 years
Skills and Competencies

Technical Skills: Expertise in data warehousing concepts, database management (SQL/NoSQL), ETL tools (e.g., Informatica, Talend, Azure Data Factory), and cloud platforms (e.g., AWS, Azure, GCP).

Data Modelling: Strong knowledge of dimensional modelling, star schema, and snowflake schema design.

Data Governance: Knowledge of data privacy regulations (GDPR, HIPAA) and governance frameworks.

Communication: Ability to translate complex technical concepts into business-friendly terms.

Problem-Solving: Strong analytical skills to troubleshoot data and performance issues effectively.
Qualification

BE/B.Tech. in Computer Science with hands on knowledge of T-SQL, PL/SQL, Azure DW, Azure Data Factory
Key Responsibilities
1.
Data Architecture Design:
o
Design the overall architecture for the enterprise data warehouse, ensuring scalability, performance, and data integrity.
o
Define standards and best practices for data modelling, storage, and access patterns.
o
Develop logical and physical data models, data flow diagrams, and database design that support business needs.
2.
ETL Process Development:
o
Lead the design and development of ETL (Extract, Transform, Load) processes to integrate data from various sources into the data warehouse.
o
Establish ETL workflows that ensure efficient, error-free, and high-performance data extraction and transformation.
o
Optimize ETL processes for maximum performance and minimal downtime during data loads.
3.
Data Integration and Transformation:
o
Ensure the smooth integration of structured and unstructured data from disparate systems, including on-premises and cloud-based solutions.
o
Define data transformation rules to clean, normalize, and enrich data before loading it into the warehouse.
o
Oversee the integration of real-time and batch data pipelines for continuous data ingestion.
4.
Data Quality and Governance:
o
Establish data quality standards and implement processes to ensure the accuracy, consistency, and reliability of data.
o
Collaborate with the data governance team to define and enforce data governance policies across the organization.
o
Implement monitoring and validation systems to detect and resolve data anomalies or discrepancies.
5.
Collaboration with Stakeholders:
o
Work closely with business analysts, data scientists, and BI developers to understand their data requirements and align the architecture to support these needs.
o
Partner with IT teams to ensure seamless integration between data systems and support application development initiatives.