Domain Steward (Data governance)

Job Description

We are looking for a senior resource with Analyst skills and knowledge of IT projects, to support delivery of risk mitigation activities and automation in Aviva’s Global Finance Data Office. The successful candidate will bring structure to this new role in a developing team, with excellent communication, organisational and analytical skills. The Candidate will play the primary role of supporting data governance project/change activities. Candidates should be comfortable with ambiguity in a fast-paced and ever-changing environment. Preferred skills include knowledge of Data Governance, Informatica Axon, SQL, AWS. In our team, success is measured by results and we encourage flexible working where possible.

Key Responsibilities

• Engage with stakeholders to drive delivery of the Finance Data Strategy
• Support data governance project/change activities in Aviva’s Finance function.
• Identify opportunities and implement Automations for enhanced performance of the Team

Required profile

• Relevant work experience in at least one of the following: business/project analyst, project/change management and data analytics.
• Proven track record of successful communication of analytical outcomes, including an ability to effectively communicate with both business and technical teams.
• Ability to manage multiple, competing priorities and hold the team and stakeholders to account on progress.
• Contribute, plan and execute end to end data governance framework.
• Basic knowledge of IT systems/projects and the development lifecycle.
• Experience gathering business requirements and reports.
• Advanced experience of MS Excel data processing (VBA Macros).
• Good communication

Additional Information

Degree in a quantitative or scientific field (e.g. Engineering, MBA Finance, Project Management) and/or experience in data governance/quality/privacy
Knowledge of Finance systems/processes
Experience in analysing large data sets using dedicated analytics tools

Designation – Assistant Manager TS

Location – Bangalore

Job Description

We are looking for you!

You are a team player, get-it-done person, intellectually curious, customer focused, self-motivated, responsible individual who can work under pressure with a positive attitude. You have the zeal to think differently, understand that career is a journey and make the choices right. You must have experience in creating visually compelling designs that effectively communicate our message and engage our target audience. Ideal candidates would be someone who is creative, proactive, go getter and motivated to look for ways to add value to job accomplishments.

You have excellent verbal and written communication skills with the ability to craft compelling UI creatives, visually compelling designs that effectively communicate our message and engage our target audience. You are self-motivated with a strong work ethic, positive attitude, and demeanor, enthusiastic when embracing new challenges, able to multitask and prioritize (good time management skills), willingness to learn new technology/methodologies, adaptable and flexible when new products are assigned. You prefer to work independently with less or no supervision. You are process oriented, have a methodical approach and demonstrate quality first approach and preferably who have worked in a result-oriented product marketing team(s). 

Requirements

What youll do

• Solution Design: Collaborate with clients to understand their business requirements and design comprehensive Informatica MDM solutions tailored to their needs.
• Implementation: Lead the implementation of Informatica MDM solutions, including configuration, customization, and integration with existing systems.
• Data Modeling: Design and implement data models to support MDM initiatives, ensuring data integrity, accuracy, and consistency across systems.
• Data Quality Management: Implement Informatica Data Quality (IDQ) processes and workflows to improve data quality and ensure compliance with organizational standards.
• Integration: Integrate Informatica MDM solutions with other enterprise systems, such as CRM, ERP, and BI platforms, to facilitate seamless data exchange and interoperability.
• Customization: Develop custom components, workflows, and extensions to extend the functionality of Informatica MDM and meet specific business requirements.
• Data Governance: Establish data governance policies, standards, and best practices to govern the use, management, and quality of master data within the organization.
• Documentation: Prepare comprehensive documentation, including solution designs, technical specifications, user guides, and training materials, to support the implementation and maintenance of Informatica MDM solutions.
• Testing and Quality Assurance: Conduct thorough testing and quality assurance activities to ensure the reliability, scalability, and performance of Informatica MDM solutions.
• Training and Support: Provide training and support to end-users, administrators, and stakeholders to ensure successful adoption and utilization of Informatica MDM solutions.

What you’ll bring

• Bachelor's degree in Computer Science, Information Systems, or related field; Master's degree preferred.
• Minimum of 4 years of experience in implementing and configuring Informatica MDM solutions.
• Proficiency in Informatica MDM Hub, Informatica Data Director, Informatica Data Quality (IDQ), and related Informatica tools and technologies.
• Strong understanding of data modelling principles, data integration concepts, and master data management best practices.
• Hands-on experience with data profiling, cleansing, and transformation using Informatica IDQ.
• Experience with data governance frameworks, data stewardship workflows, and data quality metrics.
• Excellent communication skills and the ability to effectively collaborate with cross-functional teams and stakeholders.
• Proven ability to work independently, manage multiple priorities, and deliver high-quality results within tight deadlines.
• Informatica certification(s) in MDM and/or IDQ is a plus.

Benefits

1. Culture:

• Open Door Policy: Encourages open communication and accessibility to management.
• Open Office Floor Plan: Fosters a collaborative and interactive work environment.
• Flexible Working Hours: Allows employees to have flexibility in their work schedules.
• Employee Referral Bonus: Rewards employees for referring qualified candidates.
• Appraisal Process Twice a Year: Provides regular performance evaluations and feedback.

2. Inclusivity and Diversity:

• Hiring practices that promote diversity: Ensures a diverse and inclusive workforce.
• Mandatory POSH training: Promotes a safe and respectful work environment.

3. Health Insurance and Wellness Benefits:

• GMC and Term Insurance: Offers medical coverage and financial protection.
• Health Insurance: Provides coverage for medical expenses.
• Disability Insurance: Offers financial support in case of disability.

4. Child Care & Parental Leave Benefits:

• Company-sponsored family events: Creates opportunities for emplo4. Child Care & Parental Leave Benefits:yees and their families to bond.
• Generous Parental Leave: Allows parents to take time off after the birth or adoption of a child.
• Family Medical Leave: Offers leave for employees to take care of family members' medical needs.

5. Perks and Time-Off Benefits:

• Company-sponsored outings: Organizes recreational activities for employees.
• Gratuity: Provides a monetary benefit as a token of appreciation.
• Provident Fund: Helps employees save for retirement.
• Generous PTO: Offers more than the industry standard for paid time off.
• Paid sick days: Allows employees to take paid time off when they are unwell.
• Paid holidays: Gives employees paid time off for designated holidays.
• Bereavement Leave: Provides time off for employees to grieve the loss of a loved one.

6. Professional Development Benefits:

• L&D with FLEX- Enterprise Learning Repository: Provides access to a learning repository for professional development.
• Mentorship Program: Offers guidance and support from experienced professionals.
• Job Training: Provides training to enhance job-related skills.
• Professional Certification Reimbursements: Assists employees in obtaining professional certifications.
• Promote from Within: Encourages internal growth and advancement opportunities.

About company

Who we are

Kanerika Inc. is a premier global software products and services firm that specializes in providing innovative solutions and services for data-driven enterprises. Co-founded by Wharton Business School Aluminous, Our focus is to empower businesses to achieve their digital transformation goals and maximize their business impact through the effective use of data. We leverage cutting-edge technologies and industry best practices to deliver custom solutions that help organizations optimize their operations, enhance customer experiences, and drive growth.

Awards and Recognitions

Kanerika has won several awards over the years, including:

• Best Place to Work 2022 by Great Place to Work
• Top 10 Most Recommended RPA Start-Ups in 2022 by RPA Today
• Frost & Sullivan India 2021 Technology Innovation Award for its Compass composable solution architecture
• Kanerika has also been recognized for its commitment to customer privacy and data security, having achieved ISO 27701, SOC2, and GDPR compliances.

Good experience in the Extraction, Transformation, and Loading (ETL) of data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager,

Designer, Workflow Manager, Workflow Monitor, Metadata Manager), Power Connect as ETL tool on Oracle, and SQL Server Databases.

 Knowledge of Data Warehouse/Data mart, ODS, OLTP, and OLAP implementations teamed with

project scope, Analysis, requirements gathering, data modeling, ETL Design, development,

System testing, Implementation, and production support.

 Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts

and Dimensions

 Used various transformations like Filter, Expression, Sequence Generator, Update Strategy,

Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

 Developed mapping parameters and variables to support SQL override.

 Created applets to use them in different mappings.

 Created sessions, configured workflows to extract data from various sources, transformed data,

and loading into the data warehouse.

 Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

 Modified existing mappings for enhancements of new business requirements.

 Involved in Performance tuning at source, target, mappings, sessions, and system levels.

 Prepared migration document to move the mappings from development to testing and then to

production repositories

 Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex

SQL queries using PL/SQL.

 Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica

/Talend sessions as well as performance tuning of mappings and sessions.

 Experience in all phases of Data warehouse development from requirements gathering for the

data warehouse to develop the code, Unit Testing, and Documenting.

 Extensive experience in writing UNIX shell scripts and automation of the ETL processes using

UNIX shell scripting.

 Experience in using Automation Scheduling tools like Control-M.

 Hands-on experience across all stages of Software Development Life Cycle (SDLC) including

business requirement analysis, data mapping, build, unit testing, systems integration, and user

acceptance testing.

 Build, operate, monitor, and troubleshoot Hadoop infrastructure.

 Develop tools and libraries, and maintain processes for other engineers to access data and write

MapReduce programs.

As the successful candidate, you will be required to:

• Design, develop and maintain data quality assurance framework
• Work in conjunction with BI and Data Engineers to ensure high quality Data Deliverable
• Design and develop testing frameworks to test ETL jobs, BI reports and Dashboards and other data pipelines
• Write SQL scripts to validate data in the data repositories against the data in the source systems
• Write SQL scripts to validate data surfacing in BI assets against the data sources
• Ensure data quality by checking against our ODS and the front-end application
• Track, monitor and document testing results

To be eligible for this role, you should possess the following:

• Demonstrated ability to write complex SQL/TSQL queries to retrieve/modify data
• Ability to work in an Agile environment
• Ability to learn new tools and technologies and adapt to an evolving tech-scape

Envoy Global is an equal opportunity employer and will recruit, hire, train and promote into all job levels the most qualified applicants without regard to race, colour, religion, sex, national origin, age, disability, ancestry, sexual orientation, gender identification, veteran status, pregnancy, or any other protected classification.

Key  Responsibilities :

• Development of proprietary processes and procedures designed to process various data streams around critical databases in the org
• Manage technical resources around data technologies, including relational databases, NO SQL DBs, business intelligence databases, scripting languages, big data tools and technologies, visualization tools.
• Creation of a project plan including timelines and critical milestones to success in support of the project
• Identification of the vital skill sets/staff required to complete the project
• Identification of crucial sources of the data needed to achieve the objective.

Skill Requirement :

• Experience with data pipeline processes and tools
• Well versed in the Data domains (Data Warehousing, Data Governance, MDM, Data Quality, Data Catalog, Analytics, BI, Operational Data Store, Metadata, Unstructured Data, ETL, ESB)
• Experience with an existing ETL tool e.g Informatica and Ab initio etc
• Deep understanding of big data systems like Hadoop, Spark, YARN, Hive, Ranger, Ambari
• Deep knowledge of Qlik ecosystems like  Qlikview, Qliksense, and Nprinting
• Python, or a similar programming language
• Exposure to data science and machine learning
• Comfort working in a fast-paced environment

Soft attributes :

• Independence: Must have the ability to work on his/her own without constant direction or supervision. He/she must be self-motivated and possess a strong work ethic to strive to put forth extra effort continually
• Creativity: Must be able to generate imaginative, innovative solutions that meet the needs of the organization. You must be a strategic thinker/solution seller and should be able to think of integrated solutions (with field force apps, customer apps, CCT solutions etc.). Hence, it would be best to approach each unique situation/challenge in different ways using the same tools.
• Resilience: Must remain effective in high-pressure situations, using both positive and negative outcomes as an incentive to move forward toward fulfilling commitments to achieving personal and team goals.

• Key responsibility is to design & develop a data pipeline for real-time data integration, processing, executing of the model (if required), and exposing output via MQ / API / No-SQL DB for consumption
• Provide technical expertise to design efficient data ingestion solutions to store & process unstructured data, such as Documents, audio, images, weblogs, etc
• Developing API services to provide data as a service
• Prototyping Solutions for complex data processing problems using AWS cloud-native solutions
• Implementing automated Audit & Quality assurance Checks in Data Pipeline
• Document & maintain data lineage from various sources to enable data governance
• Coordination with BIU, IT, and other stakeholders to provide best-in-class data pipeline solutions, exposing data via APIs, loading in down streams, No-SQL Databases, etc

Skills

• Programming experience using Python & SQL
• Extensive working experience in Data Engineering projects, using AWS Kinesys,  AWS S3, DynamoDB, EMR, Lambda, Athena, etc for event processing
• Experience & expertise in implementing complex data pipeline
• Strong Familiarity with AWS Toolset for Storage & Processing. Able to recommend the right tools/solutions available to address specific data processing problems
• Hands-on experience in Unstructured (Audio, Image, Documents, Weblogs, etc) Data processing.
• Good analytical skills with the ability to synthesize data to design and deliver meaningful information
• Know-how on any No-SQL DB (DynamoDB, MongoDB, CosmosDB, etc) will be an advantage.
• Ability to understand business functionality, processes, and flows
• Good combination of technical and interpersonal skills with strong written and verbal communication; detail-oriented with the ability to work independently

Functional knowledge

• Real-time Event Processing
• Data Governance & Quality assurance
• Containerized deployment
• Linux
• Unstructured Data Processing
• AWS Toolsets for Storage & Processing
• Data Security

Roles & Responsibilities

• Designing and delivering a best-in-class, highly scalable data governance platform
• Improving processes and applying best practices
• Contribute in all scrum ceremonies; assuming the role of ‘scum master’ on a rotational basis
•  Development, management and operation of our infrastructure to ensure it is easy to deploy, scalable, secure and fault-tolerant
• Flexible on working hours as per business needs

Responsibilities

• Installing and configuring Informatica components, including high availability; managing server activations and de-activations for all environments; ensuring that all systems and procedures adhere to organizational best practices
• Day to day administration of the Informatica Suite of services (PowerCenter, IDS, Metadata, Glossary and Analyst).
• Informatica capacity planning and on-going monitoring (e.g. CPU, Memory, etc.) to proactively increase capacity as needed.
• Manage backup and security of Data Integration Infrastructure.
• Design, develop, and maintain all data warehouse, data marts, and ETL functions for the organization as a part of an infrastructure team.
• Consult with users, management, vendors, and technicians to assess computing needs and system requirements.
• Develop and interpret organizational goals, policies, and procedures.
• Evaluate the organization's technology use and needs and recommend improvements, such as software upgrades.
• Prepare and review operational reports or project progress reports.
• Assist in the daily operations of the Architecture Team , analyzing workflow, establishing priorities, developing standards, and setting deadlines.
• Work with vendors to manage support SLA’s and influence vendor product roadmap
• Provide leadership and guidance in technical meetings, define standards and assist/provide status updates
• Work with cross functional operations teams such as systems, storage and network to design technology stacks.

Preferred Qualifications

• Minimum 6+ years’ experience as Informatica Engineer and Developer role
• Minimum of 5+ years’ experience in an ETL environment as a developer.
• Minimum of 5+ years of experience in SQL coding and understanding of databases
• Proficiency in Python
• Proficiency in command line troubleshooting
• Proficiency in writing code in Perl/Shell scripting languages
• Understanding of Java and concepts of Object-oriented programming
• Good understanding of systems, networking, and storage
• Strong knowledge of scalability and high availability