Salman Khan Email & Phone Number

Oakland, California, Us

Buffalo, New York, Us

Pittsburgh, Pennsylvania, Us

• Create and optimize Databricks workflows, notebooks, clusters, and Spark SQL jobs in AWS to streamline data processing. (EDW)• Built and managed Delta tables in Databricks, implementing SCD Type 1 and Type 2 logic for historical data management.• Involved in Cloudera CDH to CDP upgradation and Implement rangers’ policies.• Reusable HQL scripts by using python for the loading of data into Hive tables and schedule the job by using cron.Environment: AWS, Glue, Lambda, EMR, Databricks, Pyspark, S3, Step Functions Informatica BDM , Alteryx, FME, Hadoop, Hive, Cloudera, Athena, Cloud Watch, GitHub, Redshift, MS SQL Server, EMR, Airflow, Oracle, Tableau, Rangers, Service Now, JIRA

Worldwide, Oo

• Technical lead for ETL & MDM design, development and data quality process. Design and develop ETL workflows to migrate data from varied data sources including SQL Server, Netezza, Kafka etc. in batch and real-time.Develop checks and balances to ensure integrity of the ingested data.Design and Develop Spark jobs as per requirements for data processing needs.Work with Analysts and Data Scientists to assist them in building scalable data products.Designs systems, alerts, and dashboards to monitor data products in production• Developed Conceptual and physical model on CDH for Budget and actuals• • Analyzing data with Hive and Pig.• Partitioning of tables in HIVE using static and dynamic partition.• Develop, validate and maintain HiveQL queries.• Involved in writing the test cases of data Migration from Hive to Hive and Mainframe to HDFS.• Carried out all the releases through SDLC process.• Designed Hive tables to load data to and from external tables.• Involved in writing MapReduce jobs.• Import and export data in Hbase.• Drive the workshops / Discussion with the clients.• Design the ETL architecture – business model displaying end- to- end dataflow and the DWH/DM models, ensuring data existed with minimal redundancy and good relationship reducing query times for reporting and increasing feasibility of CUBE creation.• Develop ETL sourcing strategy, Data Validation and data reconciliation process.• Develop process flows, Technical Design Document, Deployment Cutover Checklist.• Establish ETL frame work, enterprise naming standards and best practices• Informatica power-center installation, configure and administrator• Co-ordination with delivery team to ensure high quality and timely

Norwalk, Ct, Us

Development of new workflow to extract the data from EDW and provide the XML, Flat Files, CSV to the end customer through FTP by writing script at session level.• Translated Business processes into Informatica mappings.• Managed a team of offshore and onshore resources for the successfully completion of project..• Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Staging /Target EDW tables for maintaining the history• Responsible for migrating from Development to staging and to Production (deployments).• Worked on different tasks in Workflows like sessions, events raise, event wait, decision-mail, command, worklets, Assignment, Timer and scheduling of the workflow• Used Workflow Manager for Creating, Validating, Testing and running the sequential, parallel, and initial and Incremental Load• Deployment of objects.• Monitoring and tracking the applications as per the schedule run.• Mainly involved in Preparation of Low Level Designs (Mapping Documents) by understanding the system CPMS.• Responsible in developing the ETL logics and the data maps for loading the tables.• Designed for populating Tables for one-time load and Incremental loads.• Analyze functional requirements provided by Business Analysts for the code changes.• Create workflows based on Dependencies in Informatica for the code changes.• Unit test the data mappings and workflows.• Validate the data loaded into database.• Provide the status report for all the application monitoring, tracking status.• Execute the Test cases for the code changes.• Provided extensive support in UAT (user acceptance testing) and deployment of mappings.Environment: Informatica Power Center 9.5, Teradata, UNIX, Oracle 11g, Mainframes, Flat Files, XML, VSAM Files, Sequential Files,Sequential Files, Hadoop Ecosystem (Hive, Pig, Map reduce and HDFS.)

Arlington, Va, Us

Working closely with all internal and external business partners (stakeholders) to deliver Datawarehouse solutions• Interacted with SAP Functional / Business Analyst to understand the business requirements Consulting on Interface tools and methodology. Define fact and Dimensions Tables into .• Converting the Main Frame files into flat files by defining the structure and doing performance tuning to run the wf very fast.• Formulating the ETL mappings to implement the business logic. Used transformations like lookup, update strategy, expression, filter, router, aggregate, sequence generator,. Implemented Performance tuning at mapping, session level. Extensively used look up cache and persistent cache to make the performance fast. Use sorter transformation to remove the duplicate record before aggregator.• Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.• Followed the required client security policies and required approvals to move the code from one environment to other.• Developed ETL mappings, transformations using Informatica Power center 8.6• Deployed the Informatica code and worked on code merge between two difference development teams.• Identified the bottlenecks in the sources, targets, mappings, and sessions and resolved the problems.• Created automated scripts to perform data cleansing and data loading.Environment: Windows XP/2008, Mainframe, UNIX, Oracle 10g,. SQL Server 2008, Informatica Power Center 9.1.0, Power Exchange Visi Prise HMS, SAP Business Objects