Jose Kattakayam Cherian
Senior Data Engineer
Hounslow
Summary
- Possessing 17+ years of IT experience specializing in requirements gathering, analysis, design, construction, and unit testing. Expertise includes system integration testing and providing UAT support for end-to-end solution offerings.
- Proficient in working with Azure Synapse Analytics, Informatica Powercenter, DataStage, QualityStage, Streamsets, and Informatica Data Quality.
- Demonstrated expertise in project management by overseeing client interactions, providing leadership in both technical and application aspects, and ensuring the delivery of top-notch solutions.
- Employed expertise in requirement analysis, solutioning model development, and providing ETL architecture support for module and job development.
- Gained valuable experience working on projects in different countries, such as the USA and Saudi Arabia, fostering teamwork among individuals from various cultures.
- Proficient in Azure DevOps, responsible for creating efficient CI/CD pipelines and releases while effectively managing branches and commits.
- Proficient in utilizing scheduling tools such as Trigger for Azure Synapse analytics, CA Workload for Informatica, and Autosys for DataStage.
- Utilized extensive work experience to develop efficient SQL queries for extracting and loading data from various databases such as Snowflake, Oracle, Teradata, and MS SQL.
- Adapted to and successfully utilized both traditional waterfall and Agile (scrum) methodologies for project delivery.
- Facilitated refinement of requirements, sprint planning and tracking work progress as per the plan.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Senior Data Engineer
Cognizant
Kochi
05.2022 - 05.2023
- Engaged in various vital discussions to gauge project advancement and strategize accordingly. Played an instrumental role in conducting story pointing sessions and sprint planning.
- Evaluated source data, identified the essential tables, and ensured their inclusion in Snowflake data warehouse to address all BI reporting needs.
- Developed ADF and Streamsets pipelines to extract and store data from the on-premise system in ADLS gen 2
- Implemented efficient Snowflake procedures to optimize Data Transformation and Enrichment of data.
- Optimized workflow through the creation of snowflake tasks for procedure scheduling.
- Interacted with QA, Business analysts, developers, and other interacting teams to ensure smooth and quality delivery.
Senior Data Engineer
Cognizant
Kochi
02.2019 - 04.2022
- He participated in critical project meetings and discussions, assisting in progress determination and future planning. Additionally, he played an active role in story pointing and sprint planning.
- Developed V-Model architecture using all entities and ended at customer table in solution design.
- Analyzed source data and determined the necessary tables to fulfill data requirements for Customer Insights.
- Created synapse Integration pipelines that extracted data from the on-premise system, transferring it seamlessly to the ADLS.
- Created Synapse analytics Data flows for data Transformation and Enrichment.
- Created Synapse analytics Notebooks for optimizing join processes.
- Orchestrated data flows and pipelines while creating triggers.
- Interacted regularly with QA, business analysts, developers and other teams to ensure smooth and quality delivery.
Data Engineer
Cognizant
Charlotte, North Carolina
01.2016 - 01.2019
- As a Data Engineer, successfully delivered new enhancements and provided high-level estimates for associated work.
- Interacted with the business to refine stories and contributed to sprint planning for Azure Synapse Analytics enhancements.
- Coordinated with offshore and onshore teams for tracking daily progress of work to ensure timely completion of stories.
- Contributed to coding, unit testing, integration testing, and UAT testing for new enhancement projects and performed code reviews.
- Monitored and analyzed Azure Synapse pipelines, resolving production issues.
- Participated in critical project meetings to evaluate progress and establish future direction.
- Interacted regularly with QA, business analysts, developers, and other interacting teams to ensure smooth and quality delivery
ETL Lead Developer
Cognizant
Kochi
08.2013 - 01.2016
- Collaborated with onsite team to gather Business requirements and transform them to well-designed architecture.
- Developed new applications using SQL language, Informatica ETL tool, and design specifications to meet client requirements.
- Designed ETL process using Informatica Designer to load data into Oracle target data warehouse from multiple source databases and flat files.
- Created workflow tasks including sessions, event wait/raise, assignment, e-mail and command to execute mapping.
- Optimized mapping by utilizing transformation features such as Aggregator, Filter, Joiner, Expression, and Lookups.
- Provided support for a range of activities including System Testing, User Acceptance, Production, Warranty and Post Production.
- Mentored new joiners and conducted project specific trainings as part of responsibilities.
Onsite Test Coordinator
Cognizant
Riyadh
01.2013 - 07.2013
- Managed communication and collaboration among multiple onsite teams.
- Coordinated onsite-offshore QA teams and shared status reports with client and PMO.
- Analyzed requirements, prepared Test Plan and Strategy, and developed Test Cases.
- Solely responsible for integrating and testing Datastage ETL solutions, providing PreProduction/UAT support.
- Managed offshore team of 6 QA testers, providing necessary knowledge transfer and support for them to handle business operations, batch processes, and incident handling.
ETL Developer
Cognizant
Kochi
03.2012 - 12.2012
- Implemented analysis, design, and testing of intricate Teradata SQL queries.
- Responsible for enhancing Informatica ETL job functionality and Unix scripts.
- Contributed to the creation of technical design documents and unit test case documents.
- Collaborated closely with onsite/Client counterparts to gather requirements and determine estimated/actual project completion dates for SQL & ETL design, development.
- Responsible for Delivery and Post Delivery Support.
- Reviewed developed ETL components to ensure coding standards adherence.
Test Analyst
Cognizant
Kochi
12.2009 - 02.2012
- Analyzed and understood BSD and BTRD requirements to prepare Test Plan, Test Strategy, and Test Case documents.
- Created, optimized, reviewed and executed Teradata SQL test queries for validating transformation rules in source to target mappings and verifying data in target tables.
- Performed SQL tuning and debugging of ETL Process.
- Managed Regression, Functional, and System Testing independently.
- Provided pre-production and UAT support.
- Analyzed defects to identify root causes for issues.
- Participated in defect triage calls involving development team and UAT users.
Production Support
Tech Mahindra
Hyderabad
01.2007 - 12.2009
- Managed a 24/7 team during month ends, quarter ends, and deployments.
- Identified root causes and provided short term fixes.
- Coordinated with onsite team to address development and support issues
- Ensured timely and accurate implementation of change requests.
- Accountable for initiating deployment activities with Development and QA teams and coordinating with team members to ensure successful deployments.
- Managed training initiatives, ensuring successful integration of new resources.
Education
Bachelor of Engineering - Computer Science
CSI College of Engineering
04.2006
Skills
Domain : Manufacturing and Logistics, Energy and Utility, Insurance
Technical : Azure Synapse Analytics, Azure data factory, ADLS gen2, Informatica, DataStage, Snowflake, Oracle SQL, MS SQL, Teradata
Certification
Microsoft certified Azure Data Fundamentals
Timeline
Senior Data Engineer
Cognizant
05.2022 - 05.2023
Senior Data Engineer
Cognizant
02.2019 - 04.2022
Data Engineer
Cognizant
01.2016 - 01.2019
ETL Lead Developer
Cognizant
08.2013 - 01.2016
Onsite Test Coordinator
Cognizant
01.2013 - 07.2013
ETL Developer
Cognizant
03.2012 - 12.2012
Test Analyst
Cognizant
12.2009 - 02.2012
Production Support
Tech Mahindra
01.2007 - 12.2009
Bachelor of Engineering - Computer Science
CSI College of Engineering
Similar Profiles
Navya VootlaNavya Vootla
Associate at CognizantAssociate at Cognizant
Maulik ModiMaulik Modi
Sr. Associate at CognizantSr. Associate at Cognizant
Vyshali Santhosh KumarVyshali Santhosh Kumar
Support Engineer at CognizantSupport Engineer at Cognizant
Tejas HireTejas Hire
Associate at CognizantAssociate at Cognizant
TARUNPREET KAURTARUNPREET KAUR
Pharmacist at JUPITER LIFE CAREPharmacist at JUPITER LIFE CARE