Ananth Narayanaperumal Chellathurai
Data engineer
Agasteeswaram P.O
Summary
Results-driven ETL Developer and Data Engineer with over 14 years of experience in data warehousing, specializing in Informatica PowerCenter, DEI, IDMC, Teradata, Oracle, and cloud ecosystems. Expertise in designing and automating processes to enhance efficiency and responsiveness to evolving business needs. Proven leadership in guiding teams and developing critical components of data warehouse applications, including extract programs, ETL processes, data cleansing functions, and load automation. Passionate about leveraging advanced technologies in big data and cloud environments to drive innovation and deliver impactful solutions.
Overview
15
15
years of professional experience
Work History
Data Engineer
NatWest
01.2022 - Current
- The data orchestration federated platform provides tenants a federated environment to implement its ETL solutions using the Informatica DEI tool.
- Role: Data Engineer.
- Tool: Informatica
- Responsibilities:
- Manage the Federated Data orchestration platform by supporting the tenants in the platform to implement their solutions.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Automated routine tasks using Unix scripts, increasing team productivity, and reducing manual errors.
- Provided technical guidance and mentorship to team members, fostering a collaborative learning environment within the organization.
- Coordinate, plan, and installed upgrades to the system software to enhance performance and fix critical issues in the system.
Lead Developer
HCL Technologies
09.2019 - 01.2022
- The COP - ODS Name Matching project is implemented as a regulatory need to perform the name matching of the payee based on the business rules. The payee names are collated from different source systems and then published into the ODS platform, which can be used by the real-time API to perform the name matching while the transaction is performed.
- Role: Lead Developer.
- Tool: Informatica
- Responsibilities:
- Understand the feed spec change, and decide on the best possible approach to implement the same, based on the existing framework.
- Implement the framework to test the data in cross-platform environments as an add-on to the project delivery.
- Perform solution walkthrough to the business to get the development signoff.
- Inspect the solution provided by the solution design team to check if the solution provided can be implemented by the platform and the resources in hand.
Senior Developer
Cognizant technology solutions
11.2013 - 09.2019
- Credit risk management for KBC group of banks is handled by a system (RAY) and this is being done by calculation engine report for individual tenants. The existing platform does not have a common system to calculate and generate the CRISP1 report. The Rainbow program is initiated to build a common system for all the KBC group of banks, to minimize the manual correction and reconciliation time.
- Role: Senior Developer
- Tool: Informatica BDM
- Responsibilities:
- Create reusable components and dynamic mapping for staging load.
- Interpret the pre mapping document, create the technical design document and hand it over to development team.
- Review the components for coding standards and mapping logic before migrating to test environment.
Senior Developer
Cognizant technology solutions
11.2013 - 09.2019
- GIFT is a product adopted by Prudential to serve customers with exciting offers and insurance plans through ALIP (Accenture Life Insurance Platform). The GIFT application requires data integration from the ALIP system to the ODS environment and delivers extracts to downstream as per the existing business logic in the VPAS system.
- Role: Senior Developer.
- Tool: Informatica.
- Responsibilities:
- Analyzing the business logic given based on the VPAS system and delivering the extracts to the downstream system.
- Work with different teams to get the required data to generate the extract, and deliver the code on time.
- Understand the existing reusable components available, and develop the code as per the business logic provided.
- Perform technical walk-throughs as needed to communicate the design/coded solution, and to seek input from team members.
- Validate the unit test case, unit test results, and review the code of the associates before migrating the code to higher environments.
Senior Developer
Cognizant technology solutions
11.2013 - 09.2019
- MassMutual decided to leverage the Teradata FSLDM to standardize and store the retirement service-related information. The data is loaded into the BIF tables from multiple source systems via ETL loads. There are views created on top of the BIF tables, with all the business logic. The ETL job extracts the data out of these views for the consumption of the downstream systems, third-party vendors, as well as other source systems.
- Role: Senior Developer
- Tool: Informatica
- Responsibilities:
- Analyzing business requirements and facilitating sessions with various stakeholders.
- Coordination with stakeholders and other internal teams for testing, deployment to production, maintenance of the code, and fixes.
- Played a significant role in automating developer tasks using UNIX shell scripting.
Developer
Cognizant technology solutions
11.2013 - 09.2019
- RST – Actuarial Transition Application will take feeds of contract, contract level fund information and fund information such as fees and prices combine these values and calculate and reformat them into input files for Actuarial Reserving Software (TAS, MoSes and ArcVal). The project is to read the admin system data coming in the input file, apply the compression and mapping rules and extract the output files from the processed data stored in Teradata. The output files will be fed into ArcVal and the TAS/MoSes system for the reserve calculations.
- Role: Developer
- Tool: Informatica
- Responsibilities:
- Understand the calculation logic based on the sample input/output files provided and arrive at the formula for the fields to be mapped.
- Implement the complex row type in each file as per the requirement.
Developer
Mphasis an Hp Company
12.2010 - 11.2013
- Marks work warehouse is a retail giant in Canada which operates around 420 stores. Marks have chosen PMM as their merchandising system since 2009. It provides database, merchandising, multi-channel order processing, financial, and warehouse management functionality to meet retailers’ requirements.
- Role: Developer
- Tool: Informatica, PMM
- Responsibilities:
- To interact with different teams and get to know the issues and resolve the assigned tickets.
- Run the required job to populate the oracle table as per SAS team request.
- Monitor the daily jobs and investigate the issue if the job gets aborted.
Education
Bachelor of Engineering - ECE
Vel High Tech Engineering College
Avadi, India01.2010
Skills
Database: Oracle, Teradata, MongoDB, Hive
ETL Tool: Informatica power center, BDM
Utilities: Teradata BTEQ, Fload, Mload
undefinedTimeline
Data Engineer
NatWest
01.2022 - Current
Lead Developer
HCL Technologies
09.2019 - 01.2022
Senior Developer
Cognizant technology solutions
11.2013 - 09.2019
Senior Developer
Cognizant technology solutions
11.2013 - 09.2019
Senior Developer
Cognizant technology solutions
11.2013 - 09.2019
Developer
Cognizant technology solutions
11.2013 - 09.2019
Developer
Mphasis an Hp Company
12.2010 - 11.2013
Bachelor of Engineering - ECE
Vel High Tech Engineering College