The Job logo

What

Where

Data Architect

ApplyJoin for More Updates

You must Sign In before continuing to the company website to apply.

Smart SummaryPowered by Roshi
As a Data Architect at Accenture, you will lead the design and development of data integration solutions using Microsoft SQL Server Integration Services (SSIS). Your responsibilities include modeling application data structure, ensuring data consistency, and mentoring junior team members. This full-time on-site role is based in Mumbai, India.

Job description 

Summary: As a Data Architect, you will be responsible for defining the data requirements and structure for the application. Your typical day will involve modeling and designing the application data structure, storage, and integration using Microsoft SQL Server Integration Services (SSIS). Roles & Responsibilities: - Lead the design and development of data integration solutions using Microsoft SQL Server Integration Services (SSIS). - Handling team, distributing the work, and ensuring quality deliverables. - Requirement gathering, analysis, design, development, testing & deployment skills of SSIS packages. - Experience on best practice and coding standards on SSIS packages - Collaborate with cross-functional teams to identify and resolve data-related issues, ensuring data consistency and accuracy across the organization. - Develop and maintain data models, data dictionaries, and other documentation to support data integration and analysis activities. - Provide technical guidance and mentorship to junior team members, ensuring adherence to best practices and standards. Professional & Technical Skills: - Minimum 8+ years of IT experience - 6+ years of extensive database experience with a good knowledge of Business Intelligence, Data Warehousing Concepts. - Minimum 6+ years of experience on SQL Server Integration Services 2012 2014 and above - Knowledge on SSIS control flow, Data flows, Transformation, Configuration, and logging. - Experience in multi-site project model, client communication skills. - Knowledge on version control and estimate techniques. - Minimum 3+ years of experience on SQL Server 2016 and above. - Knowledge on Store Procedures, Functions, Dynamic SQL, queries, Locks, Tables, Database creation, Roles, Backup/restore, Deployment, Archival - Azure SQL DB knowledge, no hands on expected but must know the working principles Additional Information: - The candidate should have a minimum of 7.5 years of experience in Microsoft SQL Server Integration Services (SSIS). - The ideal candidate will possess a strong educational background in technology and information architectures, along with a proven track record of delivering impactful data-driven solutions. - This position is based at our Mumbai office.

Set alert for similar jobsData Architect role in Chennai, India
Accenture Logo

Company

Accenture

Job Posted

7 months ago

Job Type

Full-time

WorkMode

On-site

Experience Level

8-12 Years

Category

Software Engineering

Locations

Chennai, Tamil Nadu, India

Qualification

Bachelor or Master

Applicants

Be an early applicant

Related Jobs

KONE Logo

Data Architect

KONE

Chennai, Tamil Nadu, India

Posted: a year ago

Seeking a skilled Data Architect with a passion for data and ability to quickly master complex data enterprise landscapes. You will be responsible for managing the data product backlog, designing data architecture, driving data related innovation, and providing data architecture leadership. The ideal candidate will have professional experience in data architecture development, data product development, and data modelling. Proficiency in agile and lean development methods, excellent problem-solving skills, and proficiency in English language are also required.

UST Logo

Associate Data Architect I

UST

Chennai, Tamil Nadu, India

Posted: a year ago

Job description  Role Proficiency: Leverage expertise in a technology area (e.g. Infromatica Transformation Terradata data warehouse Hadoop Analytics) Responsible for Architecture for a small/mid-size projects.   Outcomes:      Implement either data extract and transformation a data warehouse (ETL Data Extracts Data Load Logic Mapping Work Flows stored procedures data warehouse) data analysis solution data reporting solutions or cloud data tools in any one of the cloud providers(AWS/AZURE/GCP)      Understand business workflows and related data flows. Develop design for data acquisitions and data transformation or data modelling; applying business intelligence on data or design data fetching and dashboards      Design information structure work-and dataflow navigation. Define backup recovery and security specifications      Enforce and maintain naming standards and data dictionary for data models      Provide or guide team to perform estimates      Help team to develop proof of concepts (POC) and solution relevant to customer problems. Able to trouble shoot problems while developing POCs      Architect/Big Data Speciality Certification in (AWS/AZURE/GCP/General for example Coursera or similar learning platform/Any ML)   Measures of Outcomes:      Percentage of billable time spent in a year for developing and implementing data transformation or data storage      Number of best practices documented in any new tool and technology emerging in the market      Number of associates trained on the data service practice   Outputs Expected: Strategy & Planning: Create or contribute short-term tactical solutions to achieve long-term objectives and an overall data management roadmap   Implement methods and procedures for tracking data quality completeness redundancy and improvement   Ensure that data strategies and architectures meet regulatory compliance requirements   Begin engaging external stakeholders including standards organizations regulatory bodies operators and scientific research communities or attend conferences with respect to data in cloud Operational Management : Help Architects to establish governance stewardship and frameworks for managing data across the organization   Provide support in implementing the appropriate tools software applications and systems to support data technology goals   Collaborate with project managers and business teams for all projects involving enterprise data   Analyse data-related issues with systems integration compatibility and multi-platform integration Project Control and Review : Provide advice to teams facing complex technical issues in the course of project delivery   Define and measure project and program specific architectural and technology quality metrics Knowledge Management & Capability Development : Publish and maintain a repository of solutions best practices and standards and other knowledge articles for data management    Conduct and facilitate knowledge sharing and learning sessions across the team    Gain industry standard certifications on technology or area of expertise   Support technical skill building (including hiring and training) for the team based on inputs from project manager /RTE’s    Mentor new members in the team in technical areas   Gain and cultivate domain expertise to provide best and optimized solution to customer (delivery) Requirement gathering and Analysis: Work with customer business owners and other teams to collect analyze and understand the requirements including NFRs/define NFRs    Analyze gaps/ trade-offs based on current system context and industry practices; clarify the requirements by working with the customer   Define the systems and sub-systems that define the programs People Management: Set goals and manage performance of team engineers   Provide career guidance to technical specialists and mentor them Alliance Management: Identify alliance partners based on the understanding of service offerings and client requirements   In collaboration with Architect create a compelling business case around the offerings   Conduct beta testing of the offerings and relevance to program Technology Consulting: In collaboration with Architects II and III analyze the application and technology landscapers process and tolls to arrive at the architecture options best fit for the client program   Analyze Cost Vs Benefits of solution options   Support Architects II and III to create a technology/ architecture roadmap for the client   Define Architecture strategy for the program Innovation and Thought Leadership: Participate in internal and external forums (seminars paper presentation etc)   Understand clients existing business at the program level and explore new avenues to save cost and bring process efficiency    Identify business opportunities to create reusable components/accelerators and reuse existing components and best practices Project Management Support: Assist the PM/Scrum Master/Program Manager to identify technical risks and come-up with mitigation strategies Stakeholder Management: Monitor the concerns of internal stakeholders like Product Managers & RTE’s and external stakeholders like client architects on Architecture aspects. Follow through on commitments to achieve timely resolution of issues    Conduct initiatives to meet client expectations    Work to expand professional network in the client organization at team and program levels New Service Design: Identify potential opportunities for new service offerings based on customer voice/ partner inputs   Conduct beta testing / POC as applicable    Develop collaterals guides for GTM