Mohammed Khan
Data Modeler | Data Engineer
- Role
- Sr Data Modeler Data Engineer Data Analyst at Dow Jones
- Location
- Fairfax, VA, US
- LinkedIn followers
- 500 followers
About Mohammed Khan
With over 9 years of experience in IT, specializing in database development, ETL…
Experience
Sr Data Modeler Data Engineer Data Analyst
Aug 2022 — Present · Monmouth Junction, NJ, US
Collaborated in the Regulatory Compliance IT team, performing data profiling, analysis, and modeling.Extensively utilized AWS services (EC2, S3, VPC, ELB, Auto Scaling, Route 53, IAM, CloudTrail, CloudWatch, CloudFormation, CloudFront, SNS, RDS).Conducted performance tuning of PL/SQL code and SQL queries, optimizing database performance.Scaled data processing workloads with Kubernetes and optimized workflows for efficiency.Developed and executed ETL processes using AWS Glue, Apache Airflow, and BigQuery, implementing performance tuning and query optimization.Designed Kafka topics and schemas, developed Kafka producers and consumers.Created data models with Erwin and designed database schemas to meet objectives.Blended data using Alteryx and integrated with Tableau for enhanced ETL performance.Developed Python scripts for data parsing and loading into AWS Snowflake Data Warehouse, utilizing Pytest for test cases.Managed data movement into NoSQL databases (MongoDB, DynamoDB) and ensured compatibility.Implemented data governance with Collibra, maintaining a data catalog and documenting data lineage.Developed and optimized prompts for language models and improved LLM performance with prompt engineering.Executed ETL processes with Informatica PowerCenter, Talend, and AWS Glue, transforming data from various sources.Conducted performance tuning and query optimization in BigQuery and utilized Kubernetes auto-scaling for efficient resource management.Built data pipelines for data movement to S3 and Redshift, and developed SSIS packages for SQL Server databases.Worked with REST APIs, Postman, and custom T-SQL procedures for data extraction and transformation.Prepared data for analysis with Tableau and Power BI, designing models and visualizations.Extensive experience with PaaS, IaaS, SaaS models, and implemented security measures within Talend.
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.