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 infrastructure, anticipating and addressing emerging needs.I excel at translating complex metrics and analytics into accessible insights, empowering teams to extract relevant information effortlessly. In addition, I am committed to fostering a collaborative and inclusive work culture through community contributions

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 loading type-2 dimension/fact table, which resulted in the basis for physical ETL design of numerous applications. Created data pipelines using PySpark and Hive

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)• Created test cases and completed unit, integration and system tests for mappings developed. It involved documenting the test cases and the output for the given input.• Improved the performance of the mappings and workflows.• Documented all test plans and performance statistics • Wrote views, procedures and developed sessions for QA and production support.• Conducted the training sessions for other ETL developers on the best practices as well as performance improvement techniques.• Migrated previously developed projects from Informatica v8.6 to v9.1. Also, created unix script to validate the data between old and upgraded project.

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• Debugging, Performance tuning of the mapping and Error handling.• Provided Level 2 and Level 3 On-call support

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.• Tuned ETL processes to optimize load and query performance. Also implemented error handling by loading the reject data into the error files and tables.• Designed and developed DataStage jobs to track the SLO information for each production cycle which was used to build SLO report• Migrated previously developed projects from Datastage v8.5 to v9.1.

B.Tech, Electrical And Electronics

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