Md Noorain
Data Engineer with experience designing scalable cloud platforms using Snowflake, dbt, and AWS
Talent
KolkataMember since August 17, 2026
SnowflakedbtAirbyteMatillionBoomiETL/ELTS3LambdaGlueAthenaTransfer FamilyAPI GatewaySQSQuickSightCloud9Cursor AIClaude CodeSQLSalesforceSnowpipeSnowflake Stored Procedures
·
Hire this person
Send a job offer directly to this candidate
SnowflakedbtAirbyteMatillionBoomi
About
Data Engineer with experience designing scalable cloud platforms using Snowflake, dbt, and AWS. Adept at accelerating ETL/ELT pipeline development and complex data modeling by integrating AI-driven coding agents (Cursor, Claude Code). Proven track record in building analytics-ready models, automating workflows, and engineering robust data integration solutions.
Experience
Data Engineer at Mitratech (2025-01 – Present)
- AI-Accelerated Analytics Modeling: Developed 50+ dbt models utilizing staging, intermediate, mart, ephemeral, and incremental patterns to support AWS QuickSight dashboards across sales, marketing, customer success, and operational domains; leveraged Cursor AI and Claude Code to fast-track SQL/Jinja macro development.
- Data Quality & Governance Frameworks: Designed and implemented a robust dbt data quality framework using automated tests (unique, not-null, relationships, accepted values), elevating data reliability to over 95% across customer, opportunity, and marketing datasets.
- Multi-Source Cloud Ingestion: Built scalable ingestion pipelines from Salesforce, SharePoint, D&B, ZoomInfo, and flat-files into Snowflake using Airbyte, S3, and Snowpipe; established secure partner file ingestion leveraging AWS Transfer Family and SFTP endpoints.
- Entity Resolution & API Integration: Integrated D&B and ZoomInfo APIs with fuzzy matching techniques, Snowflake Stored Procedures, and Tasks to fully automate customer data enrichment, hierarchy management, and entity resolution workflows.
- CI/CD Automation & Serverless Orchestration: Engineered automated dbt CI/CD processes and AWS QuickSight dataset refreshes using AWS Lambda, API Gateway, Glue, and SQS for failure detection, proactive alerting, and self-healing recovery workflows.
- Performance Tuning & Ad-Hoc Analytics: Reduced Snowflake pipeline execution time from 45 to 18 minutes through complex query tuning; utilized AWS Athena and Cloud9 for development, testing, and validation of large-scale datasets in Amazon S3.
Data Engineer at Tata Consultancy Services (2021-10 – 2025-01)
- Enterprise Data Warehousing: Built and maintained highly scalable ETL pipelines and Snowflake data warehouse solutions to support cross-functional analytics and business reporting.
- Pipeline Orchestration: Developed and optimized Matillion and Dell Boomi jobs for the ingestion, transformation, and scheduling of large-scale enterprise datasets across diverse APIs and file systems.
- Operational Excellence: Optimized complex SQL queries, maintained strict data security standards, and provided reliable production support and incident resolution for business-critical platforms.
Education
B.Tech in Information Technology – RCC Institute of Information Technology, Kolkata
Skills
dbtand AWS



