Snowflake, Python, Airflow Engineer

About Company : Our client is a trusted global innovator of IT and business services. They help clients transform through consulting, industry solutions, business process services, digital & IT modernization and managed services. Our client enables them, as well as society, to move confidently into the digital future. We are committed to our clients? long-term success and combine global reach with local client attention to serve them in over 50 countries around the globe. Job Title: Snowflake, Python, Airflow Engineer Location: Bangalore Experience: 7+ yrs. Job Type : Contract to hire. Notice Period:- Immediate joiners. Mandatory Skills: Bachelor?s degree in Computer Science, Software Engineering, Information Technology, or related field required. ? At least 5+ years of experience in data development and solutions in highly complex data environments with large data volumes. ? At least 5+ years of experience developing complex ETLs with Informatica PowerCenter. ? At least 5+ years of SQL / PLSQL experience with the ability to write ad-hoc and complex queries to perform data analysis. ? At least 5+ years of experience developing complex stored procedures, triggers, MQTs and views on IBM DB2. ? Experience with performance tuning DB2 tables, queries, and stored procedures. ? An understanding of E-R data models (conceptual, logical, and physical). ? Strong understanding of advanced data warehouse concepts (Factless Fact Tables, Temporal \ Bi-Temporal models, etc.). ? Experience with Python a plus. ? Experience with developing data transformations using DBT a plus. ? Experience with Snowflake a plus. ? Experience with Airflow a plus. ? Experience with using Spark (PySpark) for data loading and complex transformations a plus. ? Strong analytical skills, including a thorough understanding of how to interpret customer business requirements and translate them into technical designs and solutions. ? Strong communication skills both verbal and written.