Strong working experience in SQL, Python or Scala.
Deep understanding of Cloud Design Patterns and their implementation.
Experience working with Snowflake as a data warehouse solution.
Experience with Power BI data integration.
Design, develop, and maintain scalable data pipelines and ETL processes.
Work with structured and unstructured data from multiple sources (APIs, databases, flat files, cloud platforms).
Strong understanding of data modelling, warehousing (e.g., Star/Snowflake schema), and relational database systems (PostgreSQL, MySQL, etc.)
Hands-on experience with ETL tools such as Apache Airflow, Talend, Informatica, or similar.
Strong problem-solving skills and a passion for continuous improvement.
Strong communication skills and the ability to collaborate effectively with cross-functional teams.
RESPONSIBILITIES:
Writing and reviewing great quality code.
Understanding the clients business use cases and technical requirements and be able to convert them into technical design which elegantly meets the requirements.
Mapping decisions with requirements and be able to translate the same to developers.
Identifying different solutions and being able to narrow down the best option that meets the clients requirements.
Defining guidelines and benchmarks for NFR considerations during project implementation
Writing and reviewing design documents explaining overall architecture, framework, and high-level design of the application for the developers.
Reviewing architecture and design on various aspects like extensibility, scalability, security, design patterns, user experience, NFRs, etc., and ensure that all relevant best practices are followed.
Developing and designing the overall solution for defined functional and non-functional requirements; and defining technologies, patterns, and frameworks to materialize it.
Understanding and relating technology integration scenarios and applying these learnings in projects.
Resolving issues that are raised during code/review, through exhaustive systematic analysis of the root cause, and being able to justify the decision taken.
Carrying out POCs to make sure that suggested design/technologies meet the requirements.
