Mohammed I Khan

Mohammed I Khan Email and Phone Number

ETL Developer at Health Care Service Corporation @ Health Care Service Corporation
300 E Randolph St, Chicago,IL 60601,United States
Mohammed I Khan's Location
Greater Chicago Area, United States
About Mohammed I Khan

ETL Developer with over 9 years of experience in designing, developing, and implementing scalable data warehouse solutions. Utilizing the IBM InfoSphere DataStage and other premier ETL tools, I enable the transformation of complex and voluminous datasets into decision-enabling insights.My expertise spans all phases of the Software Development Life Cycle, from requirements gathering and analysis to design, development, testing, and deployment. I have hands-on experience with relational database management systems-RDBMS like Oracle, SQL Server, and Teradata-that ensure data integrity and optimized performance.In addition to designing and developing DataStage jobs, I work extensively with Parallel and Server jobs, XML data handling, and scripting in UNIX for automation and process optimization. I have also used scheduling tools like Zena and Control-M to automate workflows, manage job dependencies, and improve operational efficiency.My responsibilities include implementing data models, managing Slowly Changing Dimensions (SCD), developing and enhancing Parallel jobs, and delivering ETL solutions aligned with business requirements. I actively participate in Agile ceremonies such as daily stand-ups, sprint planning, and retrospectives to ensure alignment with project goals. Additionally, I handle code migration across environments using tools like Serena and GitHub, schedule and automate workflows with Zena and Control-M, and provide production support to resolve issues and maintain system stability. I collaborate with cross-functional teams, including business analysts and data modelers, to address complex challenges and ensure seamless data operations.Certified in Databricks, Microsoft Azure Data Engineering, and Talend, I continuously explore emerging technologies to improve my technical capabilities. I am dedicated to providing the best services, whether by building scalable ETL pipelines, troubleshooting data processes, or optimizing workflows, using innovative solutions to help organizations tap into their data's power.

Mohammed I Khan's Current Company Details
Health Care Service Corporation

Health Care Service Corporation

View
ETL Developer at Health Care Service Corporation
300 E Randolph St, Chicago,IL 60601,United States
Website:
hcsc.com
Employees:
20468
Mohammed I Khan Work Experience Details
  • Health Care Service Corporation
    Etl Developer
    Health Care Service Corporation Apr 2017 - Present
    Chicago
    •Analyzed, designed, developed, implemented and maintained Parallel jobs using IBM info sphere Data stage 8.5 and working with 11.5 to develop jobs, extract, cleanse, transform, integrate and load data into the database and dataset. •Develop and enhance Parallel jobs using various stages like Join, Merge, Lookup, Surrogate key, Funnel, Sort, Transformer, Copy, Remove Duplicate, Filter, Peek and XML.•Involved in complete Data Warehouse Life Cycle from requirements gathering, designing, testing to end user support•Uses Zena scheduling tool to schedule, run jobs and automate the processes.•Active participation in decision making, interacted with the Business Analysts and development team on business process, requirement gathering and estimation.•Migration of code from Dev to Test to Production using Serena code migration and GitHub DevOps.•Responsible for Create, Update, Delete and drop of Tables as per the business requirements.•Involved in DataStage software migration project from 8.5 to 11.5 that migrated DataStage jobs and components successfully.•Writing SQL queries to join and enhancements in the database table.•Works on production issues as required.•Uses Unix for File transfer between the servers, create, update, permissions on files.•Created Multi Instance jobs that can save time and increase efficiency.•Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.•Daily SCRUM Stand-up calls to discuss on project status and any issues/concerns and Sprint grooming and planning sessions.•Documents ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.•Works with Data modeler, creating and updating data models as per the business requirement.•Works with Business on monthly ETL runs (Incremental and History) and data delivery.
    View
  • Unitedhealth Group/Optum
    Etl Developer
    Unitedhealth Group/Optum Oct 2016 - Apr 2017
    Used DataStage 11.3 as an ETL tool for enhancements and new development. Interacted with End users to understand the business requirements and in identifying data sources Analysis of business requirements and providing ETL design. Extracted data from flat files and then transformed according to the requirement and loaded into target sequential file. Extensively worked on different types of stages like Copy, Funnel, Transformer, Merge, Join, Lookup, Sort, Pivot, Remove Duplicates and Containers (Parallel)for developing jobs. Responsible for reading input data, processing and reporting. Created Multi Instance jobs that can save time and increase efficiency Developing DataStage jobs and Executing by running Shell Scripts. Created job sequences for easy maintenance and improved performance Prepared shared containers for reusability. Daily Business meeting to discuss on project status and any issues/concerns. Performed the Unit testing for jobs developed to ensure that it meets the requirements. Writing SQL queries for Data Extracts and loading. Modified shell scripts to run DataStage jobs from UNIX. Removing special characters from input files. Transferring files between UNIX and Windows servers Developing Unix Scripts for verification and validation of input and output files.
  • Boeing
    Etl Datastage Developer
    Boeing Dec 2015 - Oct 2016
    North Charleston, Sc
     Used DataStage 9.1 as an ETL tool to both enhancements and new development. Extensively worked on different types of stages like Sequential file, ODBC, Hashed File, Aggregator, Transformer, Merge, Join, Lookup, Sort and Containers (Server, Parallel) for developing jobs. Analysis and design of ETL processes. Requirement gathering & Providing Estimates for Development. Responsiblefor managing enhancements to existing Data Marts as well as developing new Data Marts to meet new business requirements. Writing sql queries to join or any modifications in the table. Created Multi Instance jobs that can save time and increase efficiency. Weekly Business meeting to discuss on project status and any issues/concerns. Documented test cases and performed Unit testing. Modified shell scripts to run DataStage jobs from UNIX. Monitoring the DataStage jobs on daily basis by running the UNIX shell script. Created job sequences for easy maintenance and improved performance Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance. Created a proactive capability to enhance the management of supplier performance
    View
  • Hillsborough County Public Schools
    Etl Datastage Developer
    Hillsborough County Public Schools Apr 2015 - Sep 2015
    Tampa, Florida
     Used DataStage 8.7 as an ETL tool to extract data from source systems, loaded the data into the DB2 database. Designed and developed DataStage jobs to extract data from multiple sources, applied transformation logic to extracted data, and loaded the data into Data Warehouse Databases. Created PX Jobs using different stages such as, Aggregator, Change Data Capture, Copy, Filter, Funnel, Join, Lookup Merge, Remove Duplicates, Sample, Surrogate Key, Sort, Column Generator, Row Generator, and Peek. Used some UNIX scripts to archive the files to permanent folder and also to run the DS job. Worked in deployment of DS jobs from one environment to other and also in Bug fixing Worked in performance tuning of the job at both DB2 and DataStage level by creating index, partitioning and triggers. Created Parameter Sets and Worked in creating of user defined environment variables, environment variables that improves the job execution Involved in complete phase till the job is deployed to production where we have taken care in UAT, SIT phases in bug fixing. Maintained Data Warehouse by loading dimensions and facts as part of the overall project
    View

Mohammed I Khan Education Details

Frequently Asked Questions about Mohammed I Khan

What company does Mohammed I Khan work for?

Mohammed I Khan works for Health Care Service Corporation

What is Mohammed I Khan's role at the current company?

Mohammed I Khan's current role is ETL Developer at Health Care Service Corporation.

What schools did Mohammed I Khan attend?

Mohammed I Khan attended Keller Graduate School Of Management Of Devry University, Northeastern Illinois University.

Not the Mohammed I Khan you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.