Develop and optimize ANSI SQL queries for data extraction and transformation.
Handle and process semi-structured data formats such as JSON, XML, and HTML.
Work with distributed querying tools such as Hive, Impala, and other SQL clients (RDBMS, Python, Scala, etc.).
Transform and structure data to meet business and reporting needs .
Utilize ETL tools like Informatica or Talend for tool-based development and frameworks like Spark or MapReduce (Python, Scala, or Java) for code-based development.
Ensure efficient data warehousing and reporting through best practices in database design and performance...