Design and build data structures on MPP platform like Teradata, Hadoop to provide efficient reporting and analytics capability.
Design solutions using new generation In-Memory Columnar databases like HANA Design and build highly scalable data pipelines using new generation tools and technologies like Spark, Kafka to induct data from various systems
Translate complex business requirements into scalable technical solutions meeting data warehousing design standards.
Strong understanding of analytics needs and proactive-ness to build generic solutions to improve the efficiency
Review, enhance, design and develop ETL processes using Informatica
Educate staff members through training and individual support.
Offer support by responding to system problems in a timely manner.
Technical Knowledge and Skills required
In-depth understanding of data structures and algorithms
Experience in designing and building dimensional data models to improve accessibility, efficiency, and quality of data
Database development experience with Relational or MPP/distributed systems such as Oracle/Teradata/Vertica/HANA/Hadoop
Programming experience in building high quality applications, data pipelines and analytics solutions.
Experience in developing Big Data applications using java, Spark, Hive, Oozie, Kafka, and Map Reduce is a huge plus
Should be proficient in writing Advanced SQLs, Expertise in performance tuning of SQLs. Experience with data science and machine learning tools and technologies is a plus
Strong experience in designing and developing solutions using Columnar Databases.
Demonstrate strong understanding of development processes and agile methodologies
Soft Skills Required
Good communication and presentation skills
Highly driven, energetic, flexible, resourceful & ability to multitask
Clarity of thoughts and vision
Ability to ideate and bring solutions to the table
Adherence to timelines, without sacrificing quality of output
Hands on and detail oriented, with a strong ability to co-ordinate across different Geographies and with different stakeholders at Exec and Director levels
Minimum 14+ years of increasingly responsible experience in high impactful and changing environments
Should have worked in a dynamic and fast changing environment
High affinity with AI powered insight tools and engines and application of real time solutions to analytics problems
Strong analytical and communication skills. Should be self-driven, highly motivated and ability to learn quick
Masters degree/Btech from a good institute in a quantitative discipline
Strong exposure to Databases and data structures of cloud based technologies
AWS/Azure architect certification preferred