Experienced Data Warehouse Developer with hands-on expertise in Snowflake SQL, data modeling, ingestion, transformation, and optimization of complex queries. Skilled in developing UDFs (User Defined Functions) to extend database functionalities and proficient in ETL tools such as Informatica BDM, with a strong understanding of pushdown optimization. Adept in relational database design and implementation, with additional knowledge of IBM Exadata. Experience with automation testing, unit tests, and integration testing. Familiar with Airflow, Python scripting, and Django. Strong advocate of Agile and Scrum methodologies for effective project delivery and collaboration.

Key Responsibilities:

• Software Development:

  • Proven hands-on experience in software development with a focus on data warehousing solutions.
  • Strong knowledge and experience in data modeling, data ingestion, data transformation, and data consumption patterns to ensure efficient storage and retrieval of information.
  • Develop and optimize complex SQL queries in Snowflake, focusing on performance improvements and scalability.
  • Create efficient User Defined Functions (UDFs) to extend the functionality of Snowflake and other database systems.

• ETL Development:

  • Experience in using ETL tools like Informatica BDM to automate data integration and transformation processes.
  • Apply pushdown optimization techniques to enhance ETL performance, reducing the load on target systems by pushing transformations closer to the source.

• Database Management:

  • Strong understanding and hands-on experience with relational databases, including the design and implementation of efficient schemas and queries.
  • Knowledge of IBM Exadata and how it can be leveraged for large-scale data warehousing solutions.

• Testing and Automation:

  • Develop and maintain unit tests and integration tests to ensure high-quality and reliable software.
  • Automate testing processes and continuously improve the test suite to keep up with changes in data pipelines and systems.

• Cloud and Scripting:

  • Experience with cloud platforms and services, particularly those related to data storage and processing.
  • Good to have knowledge in Airflow for workflow management, Django for web frameworks, and Python scripting for data processing and automation tasks.

• Agile Methodology:

  • Actively participate in Agile development processes, adopting Scrum for iterative development, backlog management, and regular sprint reviews.
  • Collaborate with cross-functional teams (business, QA, development) to ensure project deliverables are met on time and with high quality.

• Communication and Collaboration:

  • Excellent communication and interpersonal skills, with the ability to interact with both technical and business stakeholders.
  • Actively engage in team discussions, providing insights and suggestions for process improvements.

Must Haves:

• Experience:

  • Proven experience in Data Warehousing with expertise in Snowflake SQL, complex query development, and UDF creation.
  • Strong experience with ETL tools like Informatica BDM and pushdown optimization techniques.
  • In-depth knowledge of relational databases and database design, with exposure to IBM Exadata (a plus).
  • Experience with unit testing, integration testing, and test automation in software development.
  • Familiarity with Agile and Scrum development methodologies.

• Technical Skills:

  • Snowflake SQL, UDFs, and performance optimization.
  • ETL tools (Informatica BDM), pushdown optimization.
  • Relational databases, including Oracle, Teradata, and IBM Exadata.
  • Python scripting and Airflow for automation and orchestration.
  • Experience with cloud platforms for data warehousing.

• Soft Skills:

  • Strong analytical, debugging, and problem-solving skills.
  • Effective communication and interpersonal skills for cross-team collaboration.
  • Ability to work independently and in team environments.

• Educational Qualification:

  • BE/B.Tech in Computer Science or a related Engineering discipline.

• Additional Advantage:

  • Cloud certifications (AWS, Azure, or GCP) are a plus.