Md Noorain

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.

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.

B.Tech in Information Technology – RCC Institute of Information Technology, Kolkata