11+ Data architecture Jobs in Chennai | Data architecture Job openings in Chennai

Role Overview:

We are seeking a talented and experienced Data Architect with strong data visualization capabilities to join our dynamic team in Mumbai. As a Data Architect, you will be responsible for designing, building, and managing our data infrastructure, ensuring its reliability, scalability, and performance. You will also play a crucial role in transforming complex data into insightful visualizations that drive business decisions. This role requires a deep understanding of data modeling, database technologies (particularly Oracle Cloud), data warehousing principles, and proficiency in data manipulation and visualization tools, including Python and SQL.

Responsibilities:

• Design and implement robust and scalable data architectures, including data warehouses, data lakes, and operational data stores, primarily leveraging Oracle Cloud services.
• Develop and maintain data models (conceptual, logical, and physical) that align with business requirements and ensure data integrity and consistency.
• Define data governance policies and procedures to ensure data quality, security, and compliance.
• Collaborate with data engineers to build and optimize ETL/ELT pipelines for efficient data ingestion, transformation, and loading.
• Develop and execute data migration strategies to Oracle Cloud.
• Utilize strong SQL skills to query, manipulate, and analyze large datasets from various sources.
• Leverage Python and relevant libraries (e.g., Pandas, NumPy) for data cleaning, transformation, and analysis.
• Design and develop interactive and insightful data visualizations using tools like [Specify Visualization Tools - e.g., Tableau, Power BI, Matplotlib, Seaborn, Plotly] to communicate data-driven insights to both technical and non-technical stakeholders.
• Work closely with business analysts and stakeholders to understand their data needs and translate them into effective data models and visualizations.
• Ensure the performance and reliability of data visualization dashboards and reports.
• Stay up-to-date with the latest trends and technologies in data architecture, cloud computing (especially Oracle Cloud), and data visualization.
• Troubleshoot data-related issues and provide timely resolutions.
• Document data architectures, data flows, and data visualization solutions.
• Participate in the evaluation and selection of new data technologies and tools.

Qualifications:

• Bachelor's or Master's degree in Computer Science, Data Science, Information Systems, or a related field.
• Proven experience (typically 5+ years) as a Data Architect, Data Modeler, or similar role. 
• 
  
• Deep understanding of data warehousing concepts, dimensional modeling (e.g., star schema, snowflake schema), and ETL/ELT processes.
• Extensive experience working with relational databases, particularly Oracle, and proficiency in SQL.
• Hands-on experience with Oracle Cloud data services (e.g., Autonomous Data Warehouse, Object Storage, Data Integration).
• Strong programming skills in Python and experience with data manipulation and analysis libraries (e.g., Pandas, NumPy).
• Demonstrated ability to create compelling and effective data visualizations using industry-standard tools (e.g., Tableau, Power BI, Matplotlib, Seaborn, Plotly).
• Excellent analytical and problem-solving skills with the ability to interpret complex data and translate it into actionable insights. 
• Strong communication and presentation skills, with the ability to effectively communicate technical concepts to non-technical audiences. 
• Experience with data governance and data quality principles.
• Familiarity with agile development methodologies.
• Ability to work independently and collaboratively within a team environment.
• 
  

Application Link- https://forms.gle/km7n2WipJhC2Lj2r5

1. GCP - GCS, PubSub, Dataflow or DataProc, Bigquery, BQ optimization, Airflow/Composer, Python(preferred)/Java

2. ETL on GCP Cloud - Build pipelines (Python/Java) + Scripting, Best Practices, Challenges

3. Knowledge of Batch and Streaming data ingestion, build End to Data pipelines on GCP

4. Knowledge of Databases (SQL, NoSQL), On-Premise and On-Cloud, SQL vs No SQL, Types of No-SQL DB (At Least 2 databases)

5. Data Warehouse concepts - Beginner to Intermediate level

6.Data Modeling, GCP Databases, DB Schema(or similar)

7.Hands-on data modelling for OLTP and OLAP systems

8.In-depth knowledge of Conceptual, Logical and Physical data modelling

9.Strong understanding of Indexing, partitioning, data sharding, with practical experience of having done the same

10.Strong understanding of variables impacting database performance for near-real-time reporting and application interaction.

11.Should have working experience on at least one data modelling tool,

preferably DBSchema, Erwin

12Good understanding of GCP databases like AlloyDB, CloudSQL, and

BigQuery.

13.People with functional knowledge of the mutual fund industry will be a plus Should be willing to work from Chennai, office presence is mandatory

Role & Responsibilities:

● Work with business users and other stakeholders to understand business processes.

● Ability to design and implement Dimensional and Fact tables

● Identify and implement data transformation/cleansing requirements

● Develop a highly scalable, reliable, and high-performance data processing pipeline to extract, transform and load data from various systems to the Enterprise Data Warehouse

● Develop conceptual, logical, and physical data models with associated metadata including data lineage and technical data definitions

● Design, develop and maintain ETL workflows and mappings using the appropriate data load technique

● Provide research, high-level design, and estimates for data transformation and data integration from source applications to end-user BI solutions.

● Provide production support of ETL processes to ensure timely completion and availability of data in the data warehouse for reporting use.

● Analyze and resolve problems and provide technical assistance as necessary. Partner with the BI team to evaluate, design, develop BI reports and dashboards according to functional specifications while maintaining data integrity and data quality.

● Work collaboratively with key stakeholders to translate business information needs into well-defined data requirements to implement the BI solutions.

● Leverage transactional information, data from ERP, CRM, HRIS applications to model, extract and transform into reporting & analytics.

● Define and document the use of BI through user experience/use cases, prototypes, test, and deploy BI solutions.

● Develop and support data governance processes, analyze data to identify and articulate trends, patterns, outliers, quality issues, and continuously validate reports, dashboards and suggest improvements.

● Train business end-users, IT analysts, and developers.

We are looking for a skilled Java Developer with hands-on experience in Java, Spring Boot, and Microservices architecture to join our dynamic development team. The ideal candidate will be responsible for designing, developing, and maintaining high-performance, scalable applications that meet the needs of modern enterprise systems.

Key Responsibilities:

💠Design, develop, test, and deploy Java-based applications using Spring Boot and Microservices.

💠Collaborate with product managers, architects, and cross-functional teams to understand requirements and deliver solutions.

💠Build and maintain RESTful APIs for various business functionalities.

💠Participate in code reviews, debugging, and performance tuning.

💠Ensure best practices in code quality, security, and software development lifecycle (SDLC).

💠Maintain and improve existing systems and troubleshoot issues as needed.

💠Implement and manage containerized applications (e.g., using Docker, Kubernetes) where applicable.

💠Integrate third-party APIs and work with database systems (SQL and/or NoSQL).

💠Monitor and maintain application performance and scalability.

Required Skills & Qualifications:

💠Bachelors/Masters degree in Computer Science, Engineering, or related field.

💠Strong proficiency with Spring Boot and the broader Spring Framework.

💠Proven experience in building and deploying Microservices.

💠Knowledge of RESTful web services and API design.

💠Experience with databases like MySQL, PostgreSQL, or MongoDB.

💠Familiarity with CI/CD tools (e.g., Jenkins, GitLab CI) and version control systems like Git.

💠Understanding of containerization tools (Docker, Kubernetes is a plus).

💠Strong problem-solving and communication skills.

Key Responsibility Areas:

• Design, build and deliver enterprise level mobile applications
• Write code with standards and conventions and follow best practices
• Encourage and lead innovation and solid lifecycle processes
• Collaborate with team on work definition, estimation and prioritization
• Lead and grow as a professional software engineer.
• Full ownership of product deliveries and mentoring junior team members.
• Strong client interactions to provide excellent Quality of Service.
• Owning the code base and making sure all code is reviewed and is of very high quality.
• Write and modify coding conventions and standards documents for all development

Required Skills:

• 2-4 years experience in developing Android applications using Java and Kotlin

Technologies/Frameworks – 

• Java, Kotlin
• Maven, Git, Bitbucket
• Knowledge Data Structures
• SQLite, Room Database 

• Must have strong knowledge and experience in Agile based software development methodologies. Knowledge of an Agile tool like Jira.
• Must have a very strong knowledge of integrating various system and APIs (both REST and SOAP)
• Good to have: Experience of Payment Gateway Integration, Third Party SDK integrations
• Domain Preference
• FinTech, Banking, IoT

Only Chennai candidates should apply

In the capacity of a Quality Assurance Manager (Ecommerce backend testing), you will assume a pivotal role in guaranteeing the consistent delivery of top-tier products and services to our valued customers. Your core responsibilities will encompass the formulation and execution of quality assurance policies and protocols, the meticulous conduct of audits, and the comprehensive oversight of our entire quality management system. Your unwavering attention to detail, analytical acumen, and adept leadership skills in motivating and guiding a team will be instrumental in upholding our steadfast commitment to excellence.

Quality Assurance Manager Responsibilities

Develop and implement quality assurance policies and procedures

Plan and conduct quality audits and inspections

Monitor and analyze quality performance and trends using statistical methods and tools

Identify and resolve quality issues and non-conformities

Coordinate and supervise quality testing activities

Train and mentor quality assurance staff and other employees on quality standards and best practices

Prepare and present quality reports and documentation

Collaborate with other managers and departments to ensure quality integration and alignment

Liaise with customers, suppliers, and regulatory authorities on quality matters

Evaluate and recommend quality improvement opportunities and solutions

Quality Assurance Manager Required Skills

Strong knowledge of quality management principles, methodologies, and tools.

Excellent leadership and team management abilities.

Exceptional problem-solving and analytical skills.

Excellent communication and interpersonal skills.

Proficient in using quality management software and tools.

Strong attention to detail and ability to work with complex data.

Ability to prioritize tasks and meet deadlines in a fast-paced environment.

Strong understanding of regulatory requirements and industry standards.

Ability to influence and drive change across the organization.

Continuous improvement mindset and a commitment to delivering exceptional quality.

Required Qualifications

Bachelor’s degree in engineering, quality management, or a related field

Certification in quality assurance or quality management (such as ISO 9000, CQE, CQM, etc.) is preferred

Proven experience as a quality assurance manager or a similar role in a manufacturing or service industry

Strong knowledge of quality assurance methodologies, tools, and standards

Excellent analytical, problem-solving, and decision-making skills

Proficient in MS Office and data analysis software

Outstanding communication, interpersonal, and leadership skills

Attention to detail and customer orientation

Ability to work under pressure and meet deadlines

The Risk team is responsible for overall risk framework and strategy for the organization. The team develops various risk models, arrives at various sector reports from a risk perspective and provides in depth analysis and recommendation around risk profiles of various clients.

In this role, the person is responsible for playing a leadership role in the Risk function to identify, assess, monitor and make timely and measured judgments on all current and potential future risks faced, in order to protect the organization’s interest, assets and reputation of the group along with growing shareholder value and profitability.

Responsibilities

• Manage risk for the retail and wholesale portfolio. Should have managed organization level Risk Policies, Credit Underwriting and Collection functions.
• Manage risk framework for the organization - including updating, establishing new risk management mechanisms, to identify, assess, monitor, measure and control a broad spectrum of risks. Ensure all policies and frameworks are kept updated and deployed to the optimum level.
• Develop continuous monitoring and improvement of the quality of the organization's credit and lending portfolio through credit policy direction and implementation.
• Possess a complete understanding the business. Evaluate, improve, and monitor the business, including assisting in reporting to the Board and Board Committees and providing leadership in the effectiveness of credit risk management controls, systems, and processes across the organization.
• Lead and mentor a team of analysts.

• Possess 7+ years of relevant experience in financial services industry in a risk role.
• Exposure to both wholesale and retail risk in a banking environment will be preferred. Some experience in a business / sales role within the banking / NBFC space will be an added advantage.
• Should have held a position of authority in terms of allocation and appropriating limits.
• Sector understanding in financial institution space and good knowledge of interpreting financial trends.
• High proficiency in Python and SQL/NoSQL.
• Experience with big data and cloud computing e.g., PySpark, data lake is a plus.
• Outstanding written, verbal and interpersonal communication skills.
• Ability to speak at various levels of an organization (CXOs to analysts).
• Have demonstrated resilience – stayed with companies and taking businesses to scale, have preferably not ‘hopped jobs. Strong organizational skills and excellent follow-through.
• Present / articulate / position an idea compellingly and ability to work in a fast-paced dynamic environment.
• Excellent communication and presentation skills.
• Takes personal ownership; Self-starter; Ability to drive projects with minimal guidance and focus on high impact work.
• Learns continuously; Seeks out knowledge, ideas and feedback.

In this role, you will: 

As part of a team focused on the preserving the customer experience across the organization, this Analytic Consultant will be responsible for: 

• Understand business objectives and provide credible challenge to analysis requirements. 
• Verify sound analysis practices and data decisions were leveraged throughout planning and data sourcing phases. 
• Conduct in-depth research within complex data environments to identify data integrity issues and propose solutions to improve analysis accuracy. 
• Applying critical evaluation to challenge assumptions, formulate a defendable hypothesis, and ensuring high quality analysis results. 
• Ensure adherence to data management/ data governance regulations and policies. 
• Performing and testing highly complex data analytics for customer remediation. 
• Designing analysis projects flow and documentation that is structured for consistency, easy to understand, and to be offered to multiple levels of reviewers, partners, and regulatory agents demonstrating research and analysis completed. 
• Investigate and ensure data integrity from multiple sources. 
• Ensure data recommended and used is the best “source of truth”. 
• Applies knowledge of business, customers, and products to synthesize data to 'form a story' and align information to contrast/compare to industry perspective. Data involved typically very large, structured or unstructured, and from multiple sources. 
• Must have a strong attention to detail and be able to meet high quality standards consistently. 
• Other duties as assigned by manager. 
• Willing to assist on high priority work outside of regular business hours or weekend as needed. 

Essential Qualifications:  

• Around 5+ years in similar analytics roles 
• Bachelors, M.A./M.Sc. College Degree or Higher in applied mathematics, statistics, engineering, physics, accounting, finance, economics, econometrics, computer sciences, or business/social and behavioral sciences with a quantitative emphasis. 
• Preferred programming knowledge SQL/SAS  
• Knowledge of PVSI, Non-Lending, Student Loans, Small Business and Personal Lines and Loans is a plus. 
• Strong experience with data integration, database structures and data warehouses. 
• Persuasive written and verbal communication skills. 

Desired Qualifications: 

• Certifications in Data Science, or BI Reporting tools. 
• Ability to prioritize work, meet deadlines, achieve goals and work under pressure in a dynamic and complex environment – Soft Skills. 
• Detail oriented, results driven, and has the ability to navigate in a quickly changing and high demand environment while balancing multiple priorities. 
• Ability to research and report on a variety of issues using problem solving skills. 
• Ability to act with integrity and a high level of professionalism with all levels of team members and management. 
• Ability to make timely and independent judgment decisions while working in a fast-paced and results-driven environment. 
• Ability to learn the business aspects quickly, multitask and prioritize between projects. 
• Exhibits appropriate sense of urgency in managing responsibilities. 
• Ability to accurately process high volumes of work within established deadlines. 
• Available to flex schedule periodically based on business need. 
• Demonstrate strong negotiation, communication & presentation skills. 
• Demonstrates a high degree of reliability, integrity and trustworthiness. 
• Takes ownership of assignments and helps drive assignments of the team. 
• Dedicated, enthusiastic, driven and performance-oriented; possesses a strong work ethic and good team player. 
• Be proactive and get engaged in organizational initiatives.

• Expertise in designing and implementing enterprise scale database (OLTP) and Data warehouse solutions.
• Hands on experience in implementing Azure SQL Database, Azure SQL Date warehouse (Azure Synapse Analytics) and big data processing using Azure Databricks and Azure HD Insight.
• Expert in writing T-SQL programming for complex stored procedures, functions, views and query optimization.
• Should be aware of Database development for both on-premise and SAAS Applications using SQL Server and PostgreSQL.
• Experience in ETL and ELT implementations using Azure Data Factory V2 and SSIS.
• Experience and expertise in building machine learning models using Logistic and linear regression, Decision tree  and Random forest Algorithms.
• PolyBase queries for exporting and importing data into Azure Data Lake.
• Building data models both tabular and multidimensional using SQL Server data tools.
• Writing data preparation, cleaning and processing steps using Python, SCALA, and R.
• Programming experience using python libraries NumPy, Pandas and Matplotlib.
• Implementing NOSQL databases and writing queries using cypher.
• Designing end user visualizations using Power BI, QlikView and Tableau.
• Experience working with all versions of SQL Server 2005/2008/2008R2/2012/2014/2016/2017/2019
• Experience using the expression languages MDX and DAX.
• Experience in migrating on-premise SQL server database to Microsoft Azure.
• Hands on experience in using Azure blob storage, Azure Data Lake Storage Gen1 and Azure Data Lake Storage Gen2.
• Performance tuning complex SQL queries, hands on experience using SQL Extended events.
• Data modeling using Power BI for Adhoc reporting.
• Raw data load automation using T-SQL and SSIS
• Expert in migrating existing on-premise database to SQL Azure.
• Experience in using U-SQL for Azure Data Lake Analytics.
• Hands on experience in generating SSRS reports using MDX.
• Experience in designing predictive models using Python and SQL Server.
• Developing machine learning models using Azure Databricks and SQL Server

• MSSQL, SSIS, Performance Tuning, Data modeling.
• Experience in No SQL tools is must
• Candidate should have exposure to write scripts in Python/Node JS/MongoDB or any other tool
• Maria DB/MYSQL, Mongo DB, Github, Jira
• Understand Requirements from client and on-site team.
• Participate in preparing design and data modelling.
• Comfortable with SQL Stored procedures and queries development.
• Comfortable with SQL Stored procedures and queries development.
• Manage SQL Server through multiple product lifecycle / environments, from development to critical production systems.
• Apply best in industry standard techniques for data modeling to ensure performance, integrate and requirement.
• Ability to analyze independently problems and resolve them on time.