Lead Data Engineer (Ab Initio, ETL, Redshift, AWS, Data warehousing)

Required Qualification:

• Experience in preparing Data warehouse design artifacts based on given requirements – Defining Standards, Building Frameworks, and Source-Target Mapping
• Strong analytical and data modeling skills including logical and physical schema design
• Deep understanding of database technology and data use within analytic platforms 
• Strong programming skills with SQL and PySpark,
• Experience with AWS cloud Services including EMR, Redshift/Postgres
• Experience in other Cloud / ETL technologies including Databricks, Snowflakes, Ab Initio
• Good Understanding of other programming languages Python, Java
• Proven experience with large, complex database projects in environments producing high-volume data 
• Demonstrated Problem solving skills; familiarity with various root cause analysis methods; experience in documenting identified problems and determined resolutions.
• Experience in analyzing Performance Issues analysis and Tuning

Preferred Qualifications:

• Master's degree in information technology, Electrical Engineering or similar relevant fields.
• Proven experience (10 years minimum) with Datawarehouse design, build performance tuning and optimization
• Very good knowledge of data warehouse architecture approaches and trends, and high interest to apply and further develop that knowledge, including understanding of Dimensional Modelling and ERD design approaches,
• Experience in developing streaming applications Spark Streaming, Flink, Storm, etc.
• Excellent conceptual abilities compared with very good technical documentation skills, e.g. ability to understand and document complex data flows as part of business / production processes,
• Familiarity with SDLC concepts and processes