Allwin Ponraj

Data Engineering Manager at Amazon


Years of Experience


symbiosis, anna university, dakshina bharat hindi prachar sabha


amazon, financial times, bally technologies acquired by scientific games in nov2014, cognizant

Reach out to Allwin Ponraj via Email, InMail and SMS drip

by installing Chrome extension

Allwin's contact details


Email (Verified)



Mobile Number



  • img

    2016 - Present


    Engineering Manager - Data & Analytics

    Leading a cross-functional team of 15+ engineers from 6 different job families (Data, Software development, Business intelligence, Front-end, Data science and Support) to build the world's best analytics products and data infrastructure to provide a compelling value proposition for Amazon digital business stakeholders to seamlessly manage business across formats and marketplaces. Scope of my role covers five broad areas: 1) Define overall data vision and deliver end to end data processing architecture of global Books Org for downstream BI & ML use cases. 2) Own analytics road map for DA digital commerce by identifying key insights in pre & post purchase experience & influence business strategy through surfacing unique metrics. 3) Drive product vision, strategy, execution and GTM efforts of self-service customer analytics product (Internal name: Odyssey) to evangelize & harmonise data across Amazon teams. 4) Establish large scale data governance solutioning via data product (Internal name: Trumpet), which simplifies preventing and handling data quality issues at amazon scale. These 2 data products are used by 100+ amazon teams. 5) Grow the organization through effective hiring, coaching and scaling development teams that are self-organizing loosely coupled; yet highly aligned. My role impacts overall Analytics setup for digital business, indirectly contributes to P&L by driving step changes in measuring the customer impact of our services, gauging the effectiveness of our product offerings, and identifying opportunities/gaps to proactively help our partners improve their key performance indicators (KPIs).

  • img

    2015 - 2016

    financial times

    Senior Data Engineer

    • Spearheaded a team of 5+ highly skilled technologists to build the next generation of data warehouse in a tightly governed and better-understood structure. • Influenced business teams to produce open data model which increased flexibility and reduced time to market by 75% and opportunity costs. • Designed DB Objects and ETL pipelines to have optimum performance considering the Redshift DB (MPP) architecture and parameters. This reduced CRM data latency enabling more timely communication leading to improved campaign ROI. Technology : Custom ETL Framework, Amazon Redshift, Amazon S3, BIRST, Chartio, Splunk, Stash(Bit Bucket)

  • img

    2012 - 2015

    bally technologies acquired by scientific games in nov2014

    Senior Software Analyst

    Being the only ETL developer, Accountable for all ETL tasks in the organization. • Authored Single Source of truth datamart model, Proposed new ETL framework and built scalable data pipelines that collects, transforms, loads and curates data from various (Mapics ERP, Agile PLM,Microsoft Navision, Siebel CRM Systems) data sources. Identified the root cause & optimized 50+legacy ETL Refresh Jobs (>100% reduced execution run time) and OLAP database solutions. • Collaborated with multiple cross-functional teams on daily basis to discuss on the BI solutions and provided technical clarification. Automated X+ manual monotonous tasks for Y+business teams. Technology : Microsoft- SSIS, SSRS, SSAS, SQL Server, Oracle Data Integrator (ODI), Oracle 11g,Cognos 10.2

  • img

    2009 - 2012



    • As the ‘Innovation Champion’ in the account, conducted 5+ workshops to unlock team’s creative potential. Lead the application development team from offshore. • Implemented new ETL Informatica/ routines as well-made changes to the existing ETL process to accommodate enhancements. Created new Data maps in Informatica Power Exchange with Copybooks and analyzed Mainframe file data in PWX. • Created new Unix Shell Scripts for reformatting of files and as well for auditing, balancing and controlling ETL Routines. • Designed, developed and validated Oracle Warehouse Builder (OWB) 11g packages and PL/SQL procedures. Self-Motivated Projects: • Developed an Automation tool named ‘ALTERA’ for change tracking and auto precision update for fields in Informatica mappings. This tool helped in analyzing > 2k mappings in few minutes. Saved XX person hours across multiple customer projects and recognized by upper management. • Developed an Automation tool named ‘ULTRA’ for preparing Unit Test Case Template from Informatica mappings. This tool helped in preparing > 5k test cases template in few minutes. Saved XX person hours. • Developed an utility named ‘FAQ-File Access using Query’ for data profiling on the delimited files directly. Technology : Informatica Power Center 8.6.1, Informatica Power Exchange 8.6.1, Oracle 11g


25 Skills


Amazon Elastic MapReduce (EMR)

Amazon Web Services (AWS)



Apache Airflow

Big Data

business intelligence

Business Intelligence (BI)


Data Integration

Data Management

Data Warehouse

Data Warehousing


Extract, Transform, Load (ETL)







Senior Software Engineer


Team Building


  • img

    2010 - 2012


    Postgraduate Diploma in Business Administration

    Human Resources Management and Services

  • img

    2005 - 2009

    anna university

    Bachelor of Engineering (B.E.)

    Electrical and Electronics Engineering

  • img

    1998 - 2002

    dakshina bharat hindi prachar sabha

    Rashtrabhasha Praveen (equivalent to B.A)

Colleagues at amazon

Saroj Yadav

Software Development Manager, AWS Glue Platform


Saron Kebede

Software Engineer


Saman Sarraf

Data Scientist Ii


Sarreddy Mallidi

Software Development engineer 2


Sartaj Sandhu

Software Development Engineer


Show more

Others named Allwin

Allwin S

Associate Architect

 at amazon

Allwin Backya J

Consultant - Application Developer

 at amazon

Allwin Joseph

MES Application Developer

 at amazon

Allwin Raju

Software Engineer

 at amazon

Allwin Ponraj

Engineering Manager - Data & Analytics

 at amazon

Show more

Colleagues at financial times

andy gout

senior web developer


Viktor Chobanov

Software Engineer