Development Specialist

RESPONSIBILITIES

Strategy
•    Responsible for the development of Extract Transform and Loading (ETL) routines, for building reports and dashboards.
•    Follow the requirement specifications and work closely with the development lead and peers to deliver the code / programs.
•    Analyse the business requirements, User stories and come up with the development effort and timeline to deliver the product.
•    Review and amend technical design documents, technical specifications and ETL mapping document based on the requirement specifications and user stories.
•    Review and amend data mapping documents and review with development lead and ensure the business derivation rules and transformation logics are accurate. 
•    Participate in Install, upgrade, administration, and troubleshooting of ETL, BI tools and guide infrastructure team on the recommended configuration and settings of the tool in order to best utilize the tools.
•    Create user roles, security filters and build custom data access setup for ETL tools and database.
•    Implement performance tuning techniques for database queries, ETL routines and scripts. 
•    Develop ETL procedures to ensure conformity, compliance with standards and translate business rules and functionality requirements into ETL procedures
•    Create batches jobs using Unix shell scripts.

Business
•    Work closely with development lead and infrastructure teams.
•    Interact with support teams periodically and get input on the various issues and identify the resolution techniques.
•    Provide all the required input and assistance to the business users in performing the data validation and ensure that the data and reporting delivered with accurate numbers. 

Processes
•    Successfully implemented or delivered projects using industry best practices. 
•    Familiar with deployment automation 
•    Actively participate in discussions with development leads, product owner and seek endorsements and approvals wherever necessary w.r.t technology project delivery.

People & Talent
•    Minimum 2 years of experience in the development SQL / PL SQL scripts, ETL programs.
•    Ability to create understand technical design documentation. 
•    Should have excellent technical, analytical, interpersonal and delivery capabilities in the areas of complex data, reporting.
•    Shall be a good team player with excellent written and verbal communications. 
•    Process oriented and experienced in onsite-offshore project delivery, using agile methodology and best practices.
•    Should be able play an Individual Contributor role

Risk Management

•    Assess and evaluate the risks that are related to the project delivery and update the development lead with appropriate remediation and mitigation approach.
•    Review the technical solutions and deliverables with development lead and key technology stakeholders and ensure that the deliverables are adhering to the risk governance rules

Governance
•    Work with Technology Governance and support teams and establish standards for simplifying the existing reports and batch programs
•    Take end to end ownership of managing and administering the ETL, Reports and batches

Regulatory & Business Conduct

•    Display exemplary conduct and live by the Group’s Values and Code of Conduct. 
•    Take personal responsibility for embedding the highest standards of ethics, including regulatory and business conduct, across Standard Chartered Bank. This includes understanding and ensuring compliance with, in letter and spirit, all applicable laws, regulations, guidelines and the Group Code of Conduct.
•    Effectively and collaboratively identify, escalate, mitigate and resolve risk, conduct and compliance matters.
•    Lead to achieve the outcomes set out in the Bank’s Conduct Principles

Our Ideal Candidate
•    SQL
•    Python
•    Spring Batch , Java, Javascript, HTML
•    Informatica
•    RDBMS / Oracle

We're an international bank, nimble enough to act, big enough for impact. For more than 170 years, we've worked to make a positive difference for our clients, communities, and each other. We question the status quo, love a challenge and enjoy finding new opportunities to grow and do better than before. If you're looking for a career with purpose and you want to work for a bank making a difference, we want to hear from you. You can count on us to celebrate your unique talents and we can't wait to see the talents you can bring us.

Our purpose, to drive commerce and prosperity through our unique diversity, together with our brand promise, to be here for good are achieved by how we each live our valued behaviours. When you work with us, you'll see how we value difference and advocate inclusion.

Together we:

• Do the right thing and are assertive, challenge one another, and live with integrity, while putting the client at the heart of what we do
• Never settle, continuously striving to improve and innovate, keeping things simple and learning from doing well, and not so well
• Are better together, we can be ourselves, be inclusive, see more good in others, and work collectively to build for the long term

In line with our Fair Pay Charter, we offer a competitive salary and benefits to support your mental, physical, financial and social wellbeing.

• Core bank funding for retirement savings, medical and life insurance, with flexible and voluntary benefits available in some locations.
• Time-off including annual leave, parental/maternity (20 weeks), sabbatical (12 months maximum) and volunteering leave (3 days), along with minimum global standards for annual and public holiday, which is combined to 30 days minimum.
• Flexible working options based around home and office locations, with flexible working patterns.
• Proactive wellbeing support through Unmind, a market-leading digital wellbeing platform, development courses for resilience and other human skills, global Employee Assistance Programme, sick leave, mental health first-aiders and all sorts of self-help toolkits
• A continuous learning culture to support your growth, with opportunities to reskill and upskill and access to physical, virtual and digital learning.
• Being part of an inclusive and values driven organisation, one that embraces and celebrates our unique diversity, across our teams, business functions and geographies - everyone feels respected and can realise their full potential.