Janarthanan Kannan
Data Integration Architect
Berlin
Summary
- Experienced Data Integration Architect with a demonstrated history of working in the information technology and services industry for various clients in different industries for 10 + years.
- Expert in understanding end to end lifecycle of Data including Data Integration, Data Governance & Quality, Business Intelligence, Data Analysis & Visualization, Data Warehouse Development, Support and Implementation.
- Proficient in performing as active, leading role in shaping and enhancing data integration architecture. Capable of identifying, recommending and implementing ETL process and architecture integration improvements.
- Extensive experience working with clients, with cross functional teams & offshore. Reliable business professional with experience in project management, process improvement and financial analysis.
Overview
9
9
years of professional experience
4
4
years of post-secondary education
3
3
Certifications
2
2
Languages
Work History
Collibra Consultant
Cognizant Technology Solutions GmbH
Berlin
10.2021 - Current
- Analyze user requirements and based on findings, design functional specifications for client/server databases and database applications
- Evaluated client needs and expectations, establishing clear goals for each consulting engagement.
- Developed innovative strategies for clients, resulting in increased revenue and business growth.
- Design and Implement Collibra Connect Integrations with various applications and Implement Data Quality checks across their data warehouse
- Perform Prototyping and POC in support of requirements definition or technical design questions
- Develop re-usable medium-complex dashboards, reports and visualizations, re-usable data sets for reporting, and analytic integrations working with customer, internal teams, and analytic/data scientists where required
- Implement enterprise-wide data quality strategy that proactively monitors and profiles quality of data, assigning trust score
- Automate identification of PII elements and implement strong masking controls to mitigate potential element for breaches and maintain compliance with regulatory frameworks
- Rolled out Owl DQ Rules Engine to business users to stop spreadsheets bottlenecks
- Work in Agile environment with strong familiarity with scrum ceremonies
- Define and assimilate requirements to design and architect BI reporting and measurement solution(s)
- Create and support application of BI development best practices and in troubleshooting complex challenges
- Understand KPI definitions and make sure consistency between BI reports.
ETL Consultant
Cognizant Worldwide
London
2 2020 - 09.2021
- Full ownership of building, managing & administering complex ETL solutions on Informatica platform
- Experienced in upgrading informatica products Power Center, Data quality, Test data Manger , Test Data warehouse to latest versions
- Migration from on-premises to cloud servers has proven to be strategic move that has yielded remarkable cost savings. By embracing this transition, achieved staggering 50% reduction in infrastructure costs.
- Implement items which are part of ETL CoE roadmap (Server Consolidation, Proof of Concepts in New tools/features, Automation, Performance Tuning)
- Efficiently collaborate with multiple teams to set up new Informatica Platform [IPC, IDQ, TDM, BDM, EDC, Axon] on both AWS and on premises
- Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center & Informatica IDQ.
ETL Developer
Cognizant Technology Solutions India Private Ltd
Chennai
12.2015 - 01.2020
- Full ownership of building, managing & administering complex ETL solutions on Informatica platform
- Maintenance and support of ETL environments comprising of Informatica
- Manage license inventory of existing ETL tools and databases
- Manage ETL server inventory
- Ensure license guidelines are followed and within compliance
- Involved in creating low-level design document and then as ETL Developer data was integrated from different source servers to Enterprise Data Warehouse (EDW) database after applying business logic.
- Implemented innovative approach to parsing JSON files and loading into target, achieved remarkable feat. Performance has skyrocketed, and now entire process is wrapped up in mere 3 hours. Before , it took grueling 3 days to complete .
Splz Associate Infra Engineer
Mphasis
Chennai
04.2015 - 12.2015
- Achieved successful project outcomes by maintaining accurate documentation and meeting strict deadlines.
- Established strong working relationships with clients through exceptional communication skills, fostering trust and collaboration.
- Leveraged data-driven decision-making to identify opportunities for process enhancements, leading to significant cost savings.
System Administrator
Maples ESM Technologies (MapOptis)
Chennai
4 2014 - 4 2015
- Collaborated with key stakeholders across multiple departments to assess operational needs and develop tailored solutions that met organizational objectives.
- Managed user access rights to maintain high level of information security while ensuring appropriate levels of accessibility for authorized personnel.
Education
Bachelor of Technology in Information Technology -
Hindustan College of Engineering And Technology
Coimbatore, India 05.2008 - 05.2012
Skills
SQL/ PL SQL
Informatica ETL
Informatica IDQ
Collibra DGC
Collibra DQ
Tableau
Power BI
Certification
AWS certified Developer Associate
Personal Information
- Date of Birth: 12/20/90
- Gender: Male
- Nationality: Indian
Timeline
Collibra Consultant
Cognizant Technology Solutions GmbH
10.2021 - Current
ETL Developer
Cognizant Technology Solutions India Private Ltd
12.2015 - 01.2020
Splz Associate Infra Engineer
Mphasis
04.2015 - 12.2015
Bachelor of Technology in Information Technology -
Hindustan College of Engineering And Technology
05.2008 - 05.2012
ETL Consultant
Cognizant Worldwide
2 2020 - 09.2021
System Administrator
Maples ESM Technologies (MapOptis)
4 2014 - 4 2015
Similar Profiles
Kshitij DattaniKshitij Dattani
Azure Architect at Cognizant Technology Solutions GmBHAzure Architect at Cognizant Technology Solutions GmBH
PRAKASH NARAYANA VIGNESH BPRAKASH NARAYANA VIGNESH B
Business Analyst- Technical Lead at Cognizant technology SolutionsBusiness Analyst- Technical Lead at Cognizant technology Solutions
Raja RathinamadasamyRaja Rathinamadasamy
QA Manager at Cognizant Technology SolutionsQA Manager at Cognizant Technology Solutions