Senior ETL Developer

TCS has always been in the spotlight for being adept in “the next big technologies”. What we can offer you is a space to explore varied technologies and quench your techie soul.

The customer -  LSEG (London Stock exchange group) is a leading global financial markets infrastructure and data group, also they are dedicated partners with a deep commitment to excellence, delivering value for their customers.  They are leaders in data and analytics, risk, collateral and processing solutions, capital formation and trade execution.  With them you get the level of influence and opportunity that you’d have at a startup, combined with the large-scale impact of working at a global company. 

LSEG is a global organization spanning 70 countries and one rooted in a culture of growth, opportunity, diversity, and innovation, this is a place where everyone can grow, develop, and fulfil your potential with purposeful careers.

Job Description:

Experience: 5-10 Years

Location: Hyderabad

Must Have Skills:

• 5+ Years Data Integration development experience with hands on experience in SAP BODS, SAP DI, HANA.

• 2+ years of SAP HANA experience.

• Experience Developing SAP HANA XS/XSA applications based on the HANA architecture a plus

• Experience with performance tuning and optimization SAP HANA and applications. 

• Experience in python coding.

• Experience with scripting languages such as Python or JavaScript.

• Agile development processes (SCRUM and Kanban).  

• Experience with complex business projects.

• Demonstrated ability to understand business requirements and the implications of those requirements on current and future roadmaps. 

• Detailed understanding of architectural dependencies of technologies in IT environments. 

• Experience with data migrations and coordination in a cross-project management team and business functions. 

• Fundamental understanding of data modeling stages and techniques. 

• Expertise with Data integration tools (including ETL and data replication tools). 

• Data Modelling concepts and tools. 

• Continuous Integration and source control.

• Experience with Jira a plus 

Key Responsibilities and Accountabilities: 

• Design and develop optimal code to maintain exceptional performance in processing large volumes of data across diverse sources.

• Build solutions using native HANA ecosystem and components. 

• Design and develop scalable, reusable ETL code using BODS and Data Intelligence in line with architectural standards and best practices.

• HANA performance analysis and performance optimization. 

• Develop SAP HANA information models (Graphical and SQL based Calculation views) for analyzing data and generating reports. 

• Defining and maintaining robust and scalable ETL to manage data according to formal concepts, principles, and techniques.

• Translate functional specifications into technical requirements.

• Contribute to the development, delivery and maintenance of solutions based on the latest SAP technology.

• Build solutions using SAP BODS/SAP DI ecosystem and components. 

• Experience with scripting languages such as Python or JavaScript.

• Work together with other developers, business analysts and product owners to ensure that new or modified HANA and ETL applications are developed using industry standard best practice design and development practices.

• Design, develop and test data models and ensure that data is correctly loaded into the system.

• Help to manage data as a critical asset across all the organization’s business functions.

Academic Qualifications and Certifications:

• Bachelor’s Degree in MIS, Computer Science, or IT related field or equivalent IT related experience. 

Good-to-have:

• Experience using SAP ETL Tools such as Data Services and Data Intelligence, Python scripts.

• Experience with SAP HANA Database development and technologies such as: Calculation Views, Tables, synonyms, sequence, triggers, table functions and procedures using SQL/PL SQL scripts.

• Experience in data transformation features such as:  Preserving, Hierarchy Flattening, Match Transform, Data Cleansing Generator, Lookup, Fuzzy Lookup, etc. 

• Data provisioning in SAP HANA using various