Full Job Description
Tesco Bengaluru: We are a multi-disciplinary team creating a sustainable competitive advantage for Tesco by standardising processes, delivering cost savings, enabling agility, providing cutting-edge technological solutions and empowering our colleagues to do ever more for our customers. With cross-functional expertise in Global Business Services and Retail Technology & Engineering, a wide network of teams and strong governance we reduce complexity thereby offering high quality services for our customers. Tesco Bengaluru, established in 2004 to enable standardisation and build centralised capabilities and competencies, makes the experience better for our millions of customers worldwide and simpler for over 4,40,000 colleagues.
Tesco Technology consists of people from a number of different backgrounds, but having a common purpose to serve our shoppers a little better every day with our retail technological solutions. We shared a common interest in harnessing innovations in technology to enhance their shopping experience at Tesco stores. Whether making products, software or systems, our teams focuses on various aspects from taking strategic ownership of the architecture to delivering technological solutions such as design, testing, deployment, infrastructure, operation and security of the systems to ensure agile, smooth and safe operations. These help us to deliver the maximum business impact. Teams refine their internal processes to best fit their own needs, working to build core capabilities in application and services. We collaborate globally across teams to build end-to-end customer-facing solutions, as well as to share knowledge, experience, tools and techniques.
At Tesco, inclusion means that Everyones Welcome. Everyone is treated fairly and with respect; by valuing individuality and uniqueness we create a sense of belonging.
Diversity and inclusion have always been at the heart of Tesco. It is embedded in our values: we treat people how they want to be treated. We always want our colleagues to feel they can be themselves at work and we are committed to helping them be at their best.
Across the Tesco group we are building an inclusive workplace, a place to actively celebrate the cultures, personalities and preferences of our colleagues who in turn help to build the success of our business and reflect the diversity of the communities we serve.
Job Description
we are Looking for ETL data stage support and development resource who is having minimum of 5 years’ experience in data warehousing on large scale of support should have sound knowledge of oracle database like PL/SQL Sql joining queries etc.. should able to Designed Technical specifications and Mapping docs with Transformation rules Automation of workflow runs batch and nightly runs using scheduler Developed number of complex Data stage jobs sequences and shared containers. Troubleshooting of ETL jobs and addressing production issue and suggest job enhancements. Knowledge of Banking domain is a plus.
Technical requirements.
==========================
ü Total experience : 5years
ü Data stage (ETL ) development & support experience : 3 years
ü Oracle Database Knowledge : 4 years
ü Unix scripting Knowledge : 4 years
Functional skill set.
====================================
ü Excellent Verbal and written communication skills with good presentation skills
ü Should have excellent problem solving abilities
ü Should be a team player
As a ETL Specialist include:
==============================
Sourcing the data from the operational systems
Applying the business transformation rules
Preparing a database-loadable file for the Data Warehouse
Management of the deployment of the data acquisition tool(s)
Contributing the technical metadata to the metadata repository
Work with the source system analysts to understand the windows available for data extraction
Supporting BI solutions by: monitoring and tuning queries and data loads addressing user questions concerning data integrity
Monitoring performance and communicating functional and technical issues & Should be able to translate business requirements into Design Specs
Must to have experience in employing all of the Datastage transformations/techniques
Experience in developing DataStage (11.5) solutions
Experience on Grid architecture and the working of DataStage tool.
Sound knowledge in SQL PL/SQL to manipulate the data.
Able to implement Scripting Language in order to optimize the DataStage Batch
Able to Designs code test debugs document and implement ETL interfaces and UNIX scripts
Should be able to provide guidance and support to less experienced team members for design development testing and implementation
knowledge in Shell Scripting to manipulate the source files as per prescribed requirements.
Program test implement and maintain any data extraction programs necessary to extract the data from the operational systems needed to be moved to the Data Warehouse
Programming the data acquisition tool with the rules to be applied to the data
Ensuring the correct application of the business rules through data query after the data is loaded into the Data Warehouse.
Knowledge of the data sources transformation rules and uses of the data for the area of stewardship
Qualifications
IBM Datastage ETL Oralce SQL/PL/sql Unix scripting AWS DW services
Additional Information
Hiring Manager – Mritunjoy Ganguli
Last date for OJP application- 4th Oct 2021
Important Notice:
On behalf of Tesco Bengaluru, we must caution all job seekers and educational institutions that Tesco Bengaluru does not authorise any third parties to release employment offers or conduct recruitment drives via a third party. Hence, beware of inauthentic and fraudulent job offers or recruitment drives from any individuals or websites purporting to represent Tesco. Further, Tesco Bengaluru does not charge any fee or other emoluments for any reason (including without limitation, visa fees) or seek compensation from educational institutions to participate in recruitment events.
Accordingly, please check the authenticity of any such offers before acting on them and where acted upon, you do so at your own risk. Tesco Bengaluru shall neither be responsible for honouring or making good the promises made by fraudulent third parties, nor for any monetary or any other loss incurred by the aggrieved individual or educational institution.
In the event that you come across any fraudulent activities in the name of Tesco Bengaluru, please feel free report the incident at [email protected]