Arindam Debnath Email & Phone Number

Mountain View, CA, US

As a Senior Data Architect, I drive high-impact results across strategic BI projects. With deep expertise in data architecture and modeling, I design robust data models, create scalable dashboards, and maintain critical data pipelines to support informed decision-making. By developing forward-looking BI processes and solutions, I proactively enhance the BI.

Mountain View, CA, US

Mountain View, CA, US

Katy, Texas, US

Responsible for building and maintaining optimized and highly available data pipelines that facilitate deeper analysis and reporting. Build a data processing frameworks that handle the business’s growing database and leverage data with reporting and scientific tools. Continuously strives to develop new and improved data engineering capabilities.

Katy, Texas, US

Worked as an ETL developer to create solution for complex business requirement. Took active participation in creating Data Model for various projects. Created Datasatge jobs as well as complex SQL queries/procedures whenever required to extract,transform and load huge volume of data into Data Marts. Authored a re-usable ETL design for data processing and.

Mumbai, Maharashtra, IN

• Requirements gathering and analysis and feasible study of requirements. Created Data modeling for the warehouse and the marts.
• Provided technical expertise and created software design proposals for upcoming components.
• Developed data architecture components like reusable extraction and load processes with auto restart features, validation framework, and regression test framework.
• Worked as an onsite coordinator and review daily work done by offshore team
• Worked on numerous enhancement and also provided Level 3 support.
• Tuned ETL processes to optimize load and query performance. Also implemented error handling by loading the reject data into the error files and tables.

Mumbai, Maharashtra, IN

• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translated business rules and functionality requirements into ETL procedures.
• Used Informatica Workflow Manager (Informatica 8.x) to create, Schedule, execute and Monitor Sessions, Batches/Worklets and Workflows.
• Created Pre and Post session commands like created Stored Procedures to drop and recreate the indexes and keys of source and target tables.
• Extensively used Worklets and Mapplets which were reused across different releases.
• Hands on experience in design of Data Warehouse/Data Mart, Star Schema, Snowflake Schema.
• Involved in developing the mappings for moving data from Flat Files to Staging (STG) and then to Data Warehouse (DWH)

Mumbai, Maharashtra, IN

• Requirements gathering and analysis and feasible study of requirements
• Data modeling for the warehouse and the marts
• Run Proof of Concepts to validate the feasibility of the design
• Data Extraction, Transformation and Loading from source systems
• Designing, Coding, Unit testing and review of mappings
• System Testing of the Data Mart and Data Warehouse

Mumbai, Maharashtra, IN

Created a Telecommunication Customer Service Portal using C++ programming language in Unix.Acquiring technical and analytical skills. Also developing Soft Skills

San Antonio, Texas, US

• Developed solutions to increase profitability and reduce cost through resolving technical deficiencies
• Created datastage jobs and implemented numerous best practices and error handling process.
• Worked on Bigdata solutions to take a backup of the production data. Involved in coding shell scripts to import/load source data from/into Hive tables.
• Re-designed and developed a critical ingestion pipeline to process high volume of data.
• Developed Hadoop integrations for data ingestion, data mapping and data processing capabilities using different Big Data tools like Hive, Sqoop, Flume and Scylla.
• Developed Salesforce objects, workflow rules, Triggers, Classes and Apex pages.

B.Tech, Electrical And Electronics

All India Senior School Certificate Examination ( Aissce ), Pure Science