Sudharma Meka

Experience

• 

  Sify technologies ltd

  Mar 2007 - Jul 2010

  Software developer
• 

  AXA

  Aug 2010 - May 2011

  Associate Consultant

  Worked as Sr. Software Developer. Design the mappings in Informaica PowerCenter.

• 

  Chevron

  May 2011 - Aug 2013

  ETL Consultant

  Worked as Associate Technology (Lead). Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer. Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment

• 

  Ahold Delhaize

  Aug 2013 - Jul 2016

  ETL Consultant

  • Closely worked with the client and Business Analysts, for understanding the system’s functional and non-functional requirements to design the source to target mapping document• Experience in Informatica IICS• Expertise in Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups• Developed reusable components in informatica Powercenter• Ensuring that code is fit to go into the production.• Investigate, analyze and make recommendations to management regarding modifications• Provide all necessary internal and external technical support• Provide technical support and assist in resolution of development problems as required• Be accountable for the design, development, coordination and maintenance of the code• Worked independently, resolve technical and development issues without detailed direction and worked as part of a team Show less

• 

  Corning Incorporated

  Aug 2016 - Aug 2018

  Senior ETL Consultant

  Worked with the client to plan and execute project, ensured that teams have appropriate product and technical skills. Work closely with the client and Business Analysts, for understanding the system’s functional and non-functional requirements to design the source to target mapping document. Establish a strong focus on internal and external customer service. Reviewing the code developed by the peers and make sure that the coding standards have been followed and maintained.

• 

  ATCO

  Aug 2018 - Jan 2019

  Senior ETL Consultant
• 

  MGM

  Feb 2019 - Sept 2021

  Cloud Engineer Lead

  Responsible for overall delivery of services. Review deliverables & SLAs periodically and ensure meeting them as per SOW. Planning and maintaining work systems, procedures and policies that enable and encourage the optimum performance of resources team. Prepare weekly status reports with accomplishments, planned activities and present client stakeholders. Worked closely with the client and Business Analysts, for understanding the system’s functional and non-functional requirements to design the source to target mapping document. Show less

• 

  The Walt Disney Company

  Oct 2021 - Jul 2023

  Senior Data Engineer/Architect

  Worked with project stakeholders to define scope and objectives, communicating requirements to development teams. Involved in all Business analysis, requirements gathering, design, development, application setup, preparing test scripts, performance improvements, conducting user training, release management and project status reporting. Designed, Developed and Implemented ETL processes using Azure Data Factory, Data Bricks, Data Lake, Azure SQL. Responsible for design, development and delivery of data from operational systems and files into Azure Data Lake Storage gen2. Extract Transform and Load data from different Sources Systems to Azure Data Lake using a combination of Azure Data Factory (ADF v2), Azure Data Lake Analytics by processing the data in Azure Databricks. Created reusable Batch pipelines in Azure Data Factory to extract data in incremental fashion and full load then process the data and create delta table in data lake. Worked on file-based Ingestion to load them into Azure data lake and created raw tables in delta format. Performed transformations like column extract, joining, aggregations as per the functional requirement using Databricks PySpark. Experience with Azure Data Factory control flow transformations such as ForEach Activity, Lookup Activity, Until Activity, Web Activity, Wait Activity, IfCondition Activity. Used Azure Key Vault to encrypt keys and store secrets to Secure key management to protect data. Worked on getting the data from on prem SQL server database to a Raw Zone in Azure Data Lake by using Data bricks and Azure Data Factory. Used file formats on Azure Blobs to store raw data. Develop Azure Databricks notebooks to apply business transformations and perform data cleansing operations. Used spark, python, delta while reading data from files in ADLS to Data frame and writing to destination ADLS location. Prepare weekly status reports with accomplishments. Provide oversight and direction to the team members on day-to-day activities. Show less

• 

  Fox Corporation

  Sept 2023 - now

  Senior Data Engineer Lead/Architect

  •Developed pipelines to Load data from different Sources Systems to Azure Data Lake using a combination of Azure Data Factory (ADF v2), Azure Data Lake Analytics by processing the data in Azure Data bricks.•Involved in all Business analysis, requirements gathering and worked with project stakeholders to define scope and objectives, communicating requirements to development teams.