Required Skills

Microsoft SQL Server T-SQL PL/SQL Azure Data Factory Azure Data Studio Azure Analytics Studio O Auth2.0 JWT Python PySpark Spark SQL and Azure Cloud SQL Procedures. Triggers Functions

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 11th Apr 2025

JOB DETAIL

  • Collaborate with internal customers, prospects, and stakeholders to understand and translate business use cases and requirements into data analysis and data mapping.
  • Develop data integration routines that involve moving, cleansing, and transforming large amounts of data between multiple systems.
  • Identify data sources, provide data flow diagrams, and document source-to-target mapping and processes.
  • Work with the Data Architect to recommend optimal data models for data ingestion and collaborate with the BI developer for analytic reports.
  • Provide technical enablement to team members developing database applications on a cloud platform.
  • Lead small teams of 1-2 junior developers in data integration efforts, utilizing ETL design patterns, error handling, and configurations.
  • Design, implement, and maintain database objects (tables, views, indexes, etc.) and database security.
  • Utilize Azure database tools and technologies, including Azure Data Studio and Azure Analytics Studio,to develop, maintain, and optimize database applications and solutions1.
  • Collaborate with data stewards, data owners, and domain experts to adopt best practices in reporting and analysis, ensuring data integrity, test design, validation, and documentation.
  • Optimize batch processing through parallelization and performance tuning to maintain data warehouse performance.
  • Establish processes for governing the identification, collection, and use of educational metadata to ensure accuracy and validity in business intelligence environments.
  • Ensure data quality through audit controls, proactive monitoring, and data cleansing techniques.
  • Troubleshoot performance and reliability issues and investigate anomalous behavior in the Azure environment.
  • Perform scheduled data process integrity checks, deployments, and coordinate releases.
  • Utilize source version control software like GitHub and CICD pipelines.
  • Provide on-call support after hours as needed.

Company Information