Prajith Thottathil
Kochi
Summary
Innovative professional with 14 years of total IT industry experience in software development, known for productivity and efficiency in completing projects, primarily in the Data Engineering space.
Possess strong skills in algorithm design, system architecture, and code optimization. Excel in problem-solving, communication, and teamwork, ensuring successful collaboration on complex projects.
An expert in building data engineering solutions with Informatica Intelligent Cloud Services (IICS CDI/CAI), Alteryx, API, Snowflake, and AWS services like EC2, S3, FSx, and Redshift. An AI/ML enthusiast.
Overview
14
14
years of professional experience
Work History
Tech Lead
Intelliswift Softwares
10.2021 - Current
- Sr. Data Engineer (Technical - 80%, Functional - 20%)
- Tech Lead by designation, managing Data Engineers, Data Analysts, primarily, and a small team for Data Science.
- Company Overview: An international biopharmaceutical company focused on improving patients' lives by identifying, developing, and commercializing meaningful products that address unmet medical needs. The R&D data solutions team provides extensive data services to data engineering, data visualization, analytics, as well as data science deliverables. The team facilitates the development of various capabilities through organizing and analyzing heterogeneous data sources and corresponding data sets. Specifically, the team is responsible for the development and maintenance of R&D insights, which is the central platform that provides accurate, actionable, and oftentimes real-time metrics and insights on R&D business functions and operations.
- Client facing ,working directly with the Manager, Sr. Managers (Data Engineer and BI/ML Engineer), Associate Director, Director of Data Integration & Management, ETL, and Application Developers to deliver high-quality outcomes to our internal and external clients.
- Oversees the Data Integration and Management operations.
- Integrated data from various source systems, like S3, Redshift, Snowflake, Salesforce, Workday, Oracle DB, SQL Server DB, and APIs (REST/SOAP).
- Define technical artifacts, delivery timelines, data architecture, and build strategies supporting robust ETL pipelines for multiple clients/projects.
- Worked with the Informatica Global Support team to get and provide timely feedback on the issues we face during daily operations.
- Define the technical project roadmaps, leveraging enterprise-standard technologies.
- Work with Enterprise Architects to develop and maintain reusable assets.
- Select appropriate technologies and architectures to build robust ETL pipelines.
- Lead a team that prioritizes excellence, reliability, reusability, and predictable delivery.
- Lead the way with best practices, metrics, and service-level objectives (SLO).
- Engage with leaders across the enterprise to define clear and unambiguous deliverables.
- Take an active role in building, mentoring, and growing a high-performing team.
- Leads, and provides ownership and accountability for all Data Integration and Management outcomes.
- Coordinates with peers to align and execute cross-departmental goals and functions.
- Builds and maintains strong relationships with internal and external stakeholders.
- Responsible for building and maintaining resource management, and capacity planning of direct reports.
- Demonstrates strategic thought leadership with company directors and the executive team, with roadmaps and opportunities for growth.
- Focuses on portfolio profitability across the enterprise, and drives strategies to reduce internal costs and increase margins for the organization, leveraging internal tools.
- Identify partnership opportunities.
- Develop new relationships in an effort to grow the business and help the company expand
Team Lead
UST
05.2019 - 10.2021
- Team Lead managing a massive and ambitious ETL engineers
- Company Overview: A major US real estate and logistics company, which is very passionate about technology, wishes to have their data warehouse highly maintained.
- Architect, Team Lead, Design, and Development.
- Maintaining a good relationship with the stakeholders and business partners.
- Converting business requirements into technical deliverables.
- Worked on the code refactoring part.
- Resource mentoring
- Handled aggressive timelines, clients, and demands for large-scale projects.
Team Lead
UST
01.2018 - 04.2019
- Senior ETL Developer, Individual Contributor role.
- Company Overview: An American tax preparation company operating in Canada, the United States, and Australia.
- This project involves migrating the database from DB2 to SQL Server.
- A migration project to revamp the ETL codes against the SQL server within an estimated span of a year.
- Analysis of the specifications provided by the client.
- Maintaining a good relationship with all the major stakeholders.
- Worked on the code refactoring part.
- Building robust ETL pipelines
Informatica Developer
Infosys Limited
03.2017 - 10.2017
- Company Overview: They are the global producer of medical devices and therapies, such as insulin pumps, pacemakers, and diabetes therapies.
- This objective of the project was to building the integrations from various product sensors and integrate to data lake so that it can be consumed by various downstream teams for processing.
- Assisted in building the ETL source-to-target specification documents by understanding the business requirements.
- Developed mappings that perform extraction, transformation, and loading of source data into the derived masters schema using various PowerCenter transformations like source qualifier, aggregator, filter, router, sequence generator, lookup, rank, joiner, expression, stored procedure, SQL, and update strategy to meet business logic in the mappings.
- Reusable transformations and Mapplets are built wherever redundancy is needed.
- Performance tuning is performed at the mapping level, as well as the database level, to increase the data throughput.
- Created post-UNIX scripts to perform operations like removing and touching files.
- Designed and developed various stored procedures to perform various calculations related to measures.
- They are the global producer of medical devices and therapies, such as insulin pumps, pacemakers, and diabetes therapies.
Informatica Developer
Infosys Limited
03.2016 - 02.2017
- Company Overview: Swapmart is a project under Investment Banking portfolio.
- They are a reporting team that sources data from a trading platform called Delta-One and generates position, trades, dividend level information reports etc. on a daily basis and sends it to customers of the bank.
- The development project involves migrating data from another trading platform called Sophis to the Data Mart, so that the same along with the data from our existing source system can be used to generate reports for the Indian regulator.
- This involves requirement gathering, analysis, functional mapping of fields into existing data model structure, design, build, testing, implementation and support.
- It also involves performance tuning and regression testing.
- Runs on Agile methodology using JIRA as a tool.
- Swapmart is a project under Investment Banking portfolio.
Informatica Developer
Infosys Limited
08.2011 - 02.2016
- Company Overview: This project includes developing Data warehouse from different data feeds and other heterogeneous systems.
- Builging a landing layer for the systems like oracle, SQL server and flat files and running through the business logics to fit in Datawarehousing architecture was the main goal.
- Actively involved as an Analyst for preparing design documents and interacted with the data modellers to understand the data model and design the ETL logics.
- Responsible for Business Analysis and Requirements Collection.
- Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
- Parsed high-level design specification to simple ETL coding and mapping standards.
- Created mapping documents to outline data flow from sources to targets.
- Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
- Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
- 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 mapplets to use them in different mappings.
- Developed mappings to load into staging tables and then to Dimensions and Facts.
- Used existing ETL standards to develop these mappings.
- Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer, and scheduling of the workflow.
- Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
- Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
- Extensively used SQL
- Loader to load data from flat files to the database tables in Oracle.
- Modified existing mappings for enhancements of new business requirements.
- Used Debugger to test the mappings and fixed the bugs.
- 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.
- This project includes developing Data warehouse from different data feeds and other heterogeneous systems.
Education
Master of Computer Applications -
Punjab Technical University
Chandigarh11-2013
Bachelor of Computer Applications -
Nehru Arts And Science College
Coimbatore04-2011
Skills
- Data/Application integration
- Cross-functional and Team collaboration
- Risk assessment
- Problem solving
- Strategic thinking
- Client communication
- Coaching and mentoring
- Test-driven development
- Debugging techniques
- Analytical thinking
- Interpersonal communication
- Decision-making
Disclaimer
I hereby declare that the information furnished above is true to the best of my knowledge and belief.
Timeline
Tech Lead
Intelliswift Softwares
10.2021 - Current
Team Lead
UST
05.2019 - 10.2021
Team Lead
UST
01.2018 - 04.2019
Informatica Developer
Infosys Limited
03.2017 - 10.2017
Informatica Developer
Infosys Limited
03.2016 - 02.2017
Informatica Developer
Infosys Limited
08.2011 - 02.2016
Master of Computer Applications -
Punjab Technical University
Bachelor of Computer Applications -
Nehru Arts And Science College