Leishangthem Dinesh Singh

Results-driven Data Engineer specializing in ETL processes with Informatica, Snowflake, DBT, and Hadoop. Optimizes data workflows and enhances system performance, delivering successful projects. Transforms complex datasets into actionable insights and fosters collaboration across cross-functional teams.

• Intelligence Platform integration, 11/2025 - Present, Bangalore, India, Linux, Snowflake, DBT, IICS, AWS, Trident, Grandcentral, Unity, Gitlab, JIRA, Monte Calo, Troweprice, Engineered an automated data integration pipeline to process Salesforce files utilizing Trident transfer protocols., Orchestrated robust data ingestion workflows leveraging AWS S3 and AWS Step Functions to seamlessly load data into Snowflake staging tables., Designed and implemented complex ETL mappings utilizing Informatica IICS to transform, validate, and load data from Snowflake staging environments to final target tables., Facilitated downstream data consumption and business intelligence analytics by integrating reporting pipelines using Monte Carlo/Alteryx., Handle a team of 10 members., Analyze the data and design the data architecture.
• OMNI transformation (Teradata to Big Data migration), 05/2021 - 10/2024, Bangalore, India, Unix, Hadoop, Teradata, Hive, Informatica 10.4 (powercenter), Bank of America, Bank of America is starting on a multi-year journey to migrate workloads off the Teradata platform to on-premise Cloudera Hadoop Platform and to external cloud with the goal of eliminate costs, reduce vendor risk, increase resiliency, and to better enable the business., It involves migration of various AITs (application Infrastructure Technology) from Teradata to Hadoop platform like hive., Lift and shift Teradata box to Hadoop and minimal re-engineering for faster time to market., Migration focused on replacing Teradata components and touchpoints., ETL migration (no functionality/logic changes)., Re-platforming delivery involves data mapping, migration of Teradata SQLs to HQLs, Informatica related changes, migration of Teradata jobs, testing, deployment, and support during parallel run., Automated TCS tools like TCS Dezypher and BITS are used in this project to analyze DW source and convert Code and for quicker Quality Assurance., Identify the lineage, dependencies required in jobs and the finalize target data mapping & types., Recreate the target data model in Hadoop (raw, stage, target)., Developing Mapping/Workflows involving various ETL processes., Convert Teradata (TD) artifacts to Hadoop artifacts., Design, Optimized and Automate Data ingestion jobs using Informatica PowerCenter., Informatica Mapping Creation, Workflow Creation., Develop ELT jobs on Hadoop platform for data Extraction, Load and Transform onto Hadoop storage using Informatica., Creating data flow for various stages of the ELT (Extract Load Transform) in and out of the Big Data environment., Develop and Optimize HQL Jobs to run in Informatica using Dynamic Partitions, Hive Query optimization etc., Scheduling of the Enterprise job in Autosys., Support SIT, UAT, Prod Parallel runs., Resolves SIT, UAT, Prod parallel, reconciliation issues., Handle a team of 10 members.
• Teradata to Big Data migration, 05/2018 - 04/2021, Bangalore, India, Unix, Informatica 10.1, Hadoop, Teradata, Hive, Postgresql, Informatica 10.2 (BDM), Aviva Canada, As part of Aviva Data-Warehouse Re-platforming Teradata to Big Data Hadoop Migration Program, Aviva Canada is undergoing transformation for its existing application landscape involving systems like Kanetix, General LZ, ABC LZ, RDR, GW Broker Center, GW Claims Center, GW policy Center, Customer 360, Legacy Billing, and interfacing applications., As a part of this migration, Legacy and interfacing applications are being revamped, which will include migration/decommissioning/transformation of existing Informatica applications on premise (Teradata, Oracle, SQL Server) to next generation Informatica Big Data and cloud platform., Realizing the critical value of data to sustain competitiveness Informatica BDM (Big Data Management) has become the framework of choice to process all the data available to the organization., Informatica Big Data Management enables organizations to process large, diverse, and fast changing data sets in Hadoop and cloud platforms so organizations can accelerate time-to-insight into your data which will reduce the overall costs of collecting, processing, and distributing data., This involves Extracting, loading, and transforming raw data from various business intelligence application in Hadoop landscape using Informatica BDM., It also requires building fresh and re-usable components on Informatica BDM which will be used across several project., Scope of the project not only limited to the development of minimum viable product, but also involves in designing of the data flow for various stages of the ELT (Extract Load Transform) in and out of the Big Data environment., Requirement Analysis and Design., Developed High Level design doc and Detailed Level Design Doc., Worked as Technical Lead., Client Interaction., Developing Mapping/Workflows involving various ETL processes., Design, Optimized and Automate Data ingestion jobs using Informatica BDM., Informatica BDM Mapping Creation, Workflow Creation and Application Creation., Develop ELT jobs on Hadoop platform for data Extraction, Load and Transform onto Hadoop storage using Informatica BDM engine is like Sqoop, MapReduce, Spark, Blaze, and Hive., Creating data flow for various stages of the ELT (Extract Load Transform) in and out of the Big Data environment., Develop and Optimize HQL Jobs to run in Informatica BDM using Dynamic Partitions, Hive Query optimization, Bucketing etc., Query optimization using optimization technique like increase number of mappers, eliminate redundant join condition., Scheduling of the Enterprise job in ZENA.
• Myriad Migration: Books migration to SFF (standard file format). DQM – Data Quality Management Powermart Migration to Myriad. Teradata Migration to Hadoop., 03/2013 - 05/2018, Bangalore, India, Unix, Oracle 11g, Informatica 9.6, Hadoop, Teradata, Hive, Postgresql, Informatica 10.2 (BDM), Credit Suisse Group AG, Credit Suisse is a Global financial Services Company headquartered in Zurich., Myriad is a centralized platform that is built to Rationalize Market Risk and Credit Risk infrastructure and business processes., It is a platform which transforms, validates, and enriches data retrieved from various source systems., It stores the data in a standardized format and delivers it to different risk management systems with a lower cost base and reduces operational risk., It is a basically to merge processing of credit and market risk., Main objectives are to make this platform as the single source for credit and market risk so that it can help to curb the duplication of process by sourcing data from various legacy systems and make it a centralized data management system., Requirement Analysis and Design., Developed High Level design doc and Detailed Level Design Doc., Worked as Technical Lead., Client Interaction., Developing Mapping/Workflows involving various ETL processes., Extensive use of oracle procedures, packages., Analysis, Coding, and unit testing., Bug Analysis and Bug fixing., Adherence to standards., Onsite - Offshore Coordination., Performance tuning., Production Support., Status Reporting.
• BFI –Banking, Finance, and Insurance, 12/2011 - 02/2013, Singapore, India, Unix, Oracle 11g, Informatica 8.6/9.5, Credit Suisse Group AG, Credit Suisse is a Global financial Services Company headquartered in Zurich., BFI project is a regulatory project to figure out the collateral risk of banking, finance and insurance of the bank based on the BASEL III accord., It is project to strengthen the transparency of the bank and to deal with financial and economic stress., It involves in findings the gap/trade attributes which will help in proper calculation of BFI number which will help the bank to maintain the correct capital required for BASEL III., RDS is the JAVA application that is used by the Bank to process the trades/positions from the FO/IT and load the positions in the required core tables., The trades are processed using Informatica and finally the positions are loaded using java components., Oracle is the back end., Requirement Analysis and Design., Client Interaction., Developing Mapping/Workflows involving various ETL processes using Informatica for mapping the correct attributes and filling the gaps required for BFI calculation., Extensive use of oracle procedures, packages., Analysis, Coding, and unit testing., Bug Analysis and Bug fixing., Adherence to standards., Onsite - Offshore Coordination., Performance tuning., Production Support.
• CAARS – Merrill Lynch Integration, 01/2008 - 11/2011, Bangalore, India, Unix, Oracle 9i/10g, Netezza, Informatica, Autosys, SQL Server 2005, Bank Of America Corporation (BAC), Bank Of America Corporation is a Financial Banking Services company located in United States., CARRS project involves integration of BAC and Merrill Lynch (ML) data., The web-based application is an OLAP system whose end users vary from BAC clients, Managers, Senior Executives., The module itself is a reporting kind which provides real time access to the customer data in both line of businesses Debt & Equity., It gives a product wise, client wise and marketer wise break up feature., The core thing involved here is integrating the ML data with the existing BAC data bringing in the most enhanced features accessible throughout., Netezza, SQL Server & Oracle databases are being used for housing the data., Requirement Analysis and Design., Client Interaction., Developed High Level design doc and Detailed Level Design Doc for Merrill Lynch Gators and Trade Feeds Migration., Analysis, Coding and unit testing of DEBT and Equity Modules., Developing Mapping/Mapplets/Workflows involving various ETL processes using Informatica for Merrill Lynch Integration., Developing Unix Shell Scripts integrated with Netezza SQL., Conducting and Participating Peer Code review., Bug Analysis and Bug fixing., Adherence to standards., Onsite - Offshore Coordination., Production Support.
• CSAR – Netezza Migration, 10/2006 - 12/2008, Bangalore, India, UNIX, Oracle 9i/10g, Netezza, Informatica, Autosys, SQL Server 2000, Bank Of America Corporation, Comprehensive source for analytics and Reporting (CSAR) is a web-based reporting application that provides a detailed reporting terminology where the end users will be able to view and analyze the market wise, product wise information/data., The end users are individual clients, Managers, Senior Executives., Daily source feeds involving various trades from different line of businesses (LOB) were being brought to the oracle database in a staged manner., The reports are made available across regions involving ASIA, EMEA & US., Oracle DB provides data dating (T + 2), Basically Day before Yesterday data., To enhance the performance of these processes and making the (T + 1) data available for clients, Netezza was being brought in with the source feeds directly populating in NTZ DB., This made a remarkable increase in performance across systems., Developing Mapping/Mapplets/Workflows involving various ETL processes using Informatica for Netezza Migration., Analysis, Coding and unit testing of both Debt and Equity Modules., Improving the performance by fine tuning the scripts in Oracle and Netezza DB., Conducting and Participating Peer code reviews., Bug Analysis and Bug fixing., Developing Detailed Design Document for Equity Module., Adherence to standards.

• Recognized and appreciated for Technical Capability, Flexibility, Productivity, Ability to learn on the job, Teamwork, Communication, Application Knowledge, Problem Solving and Functional.
• Appreciated by Bank of America clients for timely & bug-free delivery.
• Got spot awards for 3 Quarters for exceptional performance.
• Received Special Initiative Award – 'Recognized for your contribution in handling Omni project, your leadership and experience in Teradata to Hadoop migration is definitely appreciated' nominated by TCS - Delivery Manager OMNI program.