Offers “HSBC”

Expires soon HSBC

Project Management/Software Engineer/Data Services

  • Hyderabad (Hyderābād)
  • Bachelor's Degree
  • IT development

Job description

Business Area

Group Data Services

Location

Hyderabad

Job Title

Software Engineer

Job Family

Data Engineering

Job Sub Family

ETL – Data Warehouse

Job Purpose (overall high level summary of the role)

· The ETL Developer is responsible for performing system development work around ETL, which can include both the development of new function and facilities and the on-going systems support of live systems. There are a number of job functions within the role and the job holder may specialize in a single function or alternatively a combination of functions.
· The role involves taking instructions, usually in written or diagrammatic form, and translating them into a code.
· Determine the optimal approach for obtaining data from diverse systems and moving it to the BI.
· Prepare all ETL processes according to business requirements.Responsible for creating functional and/or technical design solutions and ensuring those requirements are documented.
· Diagnose ETL and database related issues, perform root cause analysis and recommend corrective actions to management. Responsible to perform tests and validate the data flow
· Manage current and future needs of the data design and content.
· Consults with users to resolve issues with programs. Contributes to the development of project plans and timelines, provide estimates for planned work.
· Work with a project team to support the design, development, implementation, monitoring, and maintenance of new ETL programs.

Principal Accountabilities: key activities and decision making areas

Typical Targets and Measures

· Develop, design, tune and maintain the ETL process.
· Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process.
· Design and develop ETL solutions using data integration tools for interfacing between source application and the Enterprise Data Warehouse.
· Develops ETL technical specifications, designs, develops, tests, implements, and supports optimal data solutions.
· Documents ETL data mappings, data dictionaries, processes, programs and solutions as per established standards for data governance.
· Integrates ETL development with existing projects to maximize object reuse.
· Creates, executes, and documents unit test plans for ETL and data integration processes and programs.
· Work with the data analysis team to assess and troubleshoot potential data quality issues at key intake points such as validating control totals at intake.
· Perform problem assessment, resolution and documentation in existing ETL packages, mapping and workflows in production
· Troubleshoot data issues and defects to determine root cause.
· Performance tuning of the ETL process and SQL queries, and recommend and implement ETL and query tuning techniques.
· Develop and create transformation queries, views, and stored procedures for ETL processes, and process automations

· Ability to measure and show marked improvement based on a reference data value set
· Performance tuning
· % of work requests completed within SLA
· Requirements clearly identified and documented
· Clearly defined and executed review/approval process

Customers / Stakeholders

· Build trusting relationships with business stakeholders by accurately documenting decisions, conversations and objections.
· Consistently meeting and delivering upon the business needs; demonstrating and being respected for your domain knowledge.
· To undertake those activities assigned by Functional Technical Lead, review and provide appropriate support to pre-project enquiries (e.g. as a result of Change Request, Initial Requests, general enquiries).

· Communication of and adherence to Reference Data Standards Target Operating Model SLA’s

Local Job Requirements (This could include; Job Dimensions, Job Context & Major Challenges)

· Candidates must have outstanding analytical and problem solving skills and a good grasp of the technical side of business intelligence
· Provide effective co-ordination and communication with distributed teams
· Assist and support the implementation of releases
· Identify, interpret and document requirements for new or altered systems, by working closely with various departments
· Prepare detailed specifications that describe input, output, and logical operation
· Prepare/submit Change Requests/GSDs to support the implementation process
· Review design to ensure it meets the criteria and work is of an acceptable quality
· Undertake technical investigations and program design on new and existing applications as required
· Update computer programs to increase operating efficiency or adapt to new requirements
· Review code from offshore Analyst/Developers as part of the quality assurance process
· Produce unit test plans with detailed expected results to fully exercise the code
· Work with Scheduling Software to automate ETL processes such as using Control-M
· Provide support to existing systems


Certifications, Qualifications & Experience (For the Job – not the Job Holder. Minimum requirements of the Job)


· Bachelor Degree or International Equivalent
· Excellent written and verbal communication skills; presentation skills preferred
· Focus on detail and consistency
· Strong prioritization and time management skills
· Experience in Financial domain (Banking).
· Good knowledge and experience on ETL, Data Stage, DB2, Teradata , Oracle, Unix
· Self-motivated, focused, detailed oriented and able to work efficiently to deadlines are essential
· Ability to work with a degree of autonomy while also being able to work in a collaborative team environment
· High degree of personal integrity
· Experienced in Development of UNIX shell scripts for enhancing the ETL job performance.
· Hands-on experience applying modeling techniques to actual business solutions
· Experience in designing, developing and implementing Business Intelligence tools
· Understanding and Experience on Unix/Linux system, file systems, shell scripting
· Strong knowledge of scheduling tools such as Control- M

Desired profile

Qualifications :

NA

Make every future a success.
  • Job directory
  • Business directory