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.
Role Name: Data Warehouse Developer – Capital Markets Data Factory
Desired Experience Range: 6 years to 10 Years
Location of Requirement: Hyderabad
Tech Profile/Essential Skills
• Minimum of 3 year’s design, performance tuning, development and experience with data warehouse and ETL technology (Oracle, SQL Server, Snowflake etc.).
• Oracle – SQL, PL/SQL - min 3 years’ experience.
• ETL Tool (any tool) – min 2 years’ experience.
• Data Warehouse (concepts, implementation) – min 2 years’ experience.
• Strong analytical and problem-solving skills.
• Exposure to the whole development life cycle: design, development, testing.
• Strong written and verbal communication skills with other team members, QA teams and internal business stakeholders.
Desirable skills
• Experience of cloud database and ETL technologies such as Snowflake or Matillion.
• Experience with agile development methodologies including Kanban and Scrum and full SDLC experience.
• Experience with source control management systems, continuous integration/deployment environments, and release management.
Detailed Responsibilities:
• Development and maintenance of the data warehouse and related data transformation.
• Work with Business Analysts, Java Developers, End Users, DevOps, BI developers and QA teams when appropriate.
• Deliver technical documents such as Technical Designs, Specifications, Users Guides.
• Design, Development and maintenance of Data Warehouse storage and transformation using Snowflake and Matillion.
• Take shared responsibility for all database support, development and administrative work.
• Provide Data warehouse functionalities (Snowflake).
• Use ETL (Matillion).
• Develop and maintain SQL code on Snowflake.
• Develop and maintain good coding standards.
• Develop and extend database functionality to support current and future business needs.
• Maintain and manage data feeds and work with business users to improve data flow into and out of the Data Warehouse
• Create improvements in existing code and systems to improve efficiencies.
• Provide daily support to business functions.
• Participate in peer-reviews of solution designs and related code.