ETL, Datastage/Consultant Specialist
Pune (Pune Division) IT development
Job description
Job description
Some careers shine brighter than others.
If you’re looking for a career that will help you stand out, join HSBC and fulfil your potential. Whether you want a career that could take you to the top, or simply take you in an exciting new direction, HSBC offers opportunities, support and rewards that will take you further.
HSBC is one of the largest banking and financial services organisations in the world, with operations in 64 countries and territories. We aim to be where the growth is, enabling businesses to thrive and economies to prosper, and, ultimately, helping people to fulfil their hopes and realise their ambitions.
We are currently seeking an experienced professional to join our team in the role of Consultant Specialist.
In this role, you will:
· Communicating effectively with senior stakeholders.
· Work with a team of technologists, ensuring prioritization of tasks and supporting removal of blockers.
· Working on burning the product backlog and oversee product demo’s
· Understanding complex business requirements and new technologies and understand how to influence teams to adopt new practice and embrace automation.
· Managing of risks and issues
Requirements
To be successful in this role, you should meet the following requirements:
· At least 5+ years of experience in any of the ETL tools Prophecy, Datastage 11.5/11.7, Pentaho.. etc.
· At least 2 years of experience in Pyspark development; Should be capable of developing/configuring data pipelines.
· Strong Experience in writing complex SQL queries to perform data analysis on Databases SQL server, Oracle, HIVE etc.
· Possess the following technical skills – SQL, Python, Pyspark, Hive, ETL, Unix, Control-M (or similar scheduling tools)
· GCP Cloud knowledge/experience (in Airflow, Dataproc, Big query) is an additional advantage.Ability to work independently on specialized assignments within the context of project deliverables
· Take ownership of providing solutions and tools that iteratively increase engineering efficiencies.
· Design should help embed standard processes, systems and operational models into the BAU approach for end-to-end execution of Data Pipelines
· Proven problem solving and analytical abilities including the ability to critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details and apply sound business and technical domain knowledge
· Communicate openly and honestly. Advanced oral, written and visual communication and presentation skills - the ability to communicate efficiently at a global level is paramount.
· Ability to deliver materials of the highest quality to management against tight deadlines.
· Ability to work effectively under pressure with competing and rapidly changing priorities
· Finance systems and language
· Data processing and analytics systems
You’ll achieve more when you join HSBC.
www.hsbc.com/careers
HSBC is committed to building a culture where all employees are valued, respected and opinions count. We take pride in providing a workplace that fosters continuous professional development, flexible working and opportunities to grow within an inclusive and diverse environment. Personal data held by the Bank relating to employment applications will be used in accordance with our Privacy Statement, which is available on our website.
Issued by – HSBC Software Development India