Expoint - all jobs in one place

Finding the best job has never been easier

Limitless High-tech career opportunities - Expoint

EY TechOps1-DE-CloudOpsAMS-SQL-GIG 
India, Karnataka, Bengaluru 
661713081

22.09.2024


This role will be responsible for creating Data orchestration with Azure Data Factory Pipelines & Dataflows. The key role is to understand the business requirements and implement the requirements using Azure Data Factory.

Your key responsibilities

  • Working with the client team, perform development and provide L3 support to database integrations and data warehouse using SQL Server, SSIS, Azure, 3rd party tools, etc.
  • Good research, analysis and problem-solving skills
  • Ability to estimate work items in a systemic manner
  • Strong understanding of Software Development Life Cycle (including agile development methodology)
  • Hands on development and maintenance of the SQL based systems and various associated components for data ingestion, transformation and processing.
  • Hands on development and maintenance of integrations with various (including bespoke) Financial (Applications and Management Information Systems), Underwriting and Claims Management Systems and other systems based on business requirements.
  • Ensure data quality and accuracy by implementing business and technical reconciliations via scripts, profiling and data analysis; analyze and create data mappings.
  • Develop and support objects and code for data profiling, extraction, load and updates.
  • Provide and maintain documentation for all developed objects and processes, in strict timelines.
  • Integration testing of deliverables.
  • Develop and run test scripts to ensure the quality of code and integrity.
  • Use source code control repository (using VSTS,GIT) – preferred GIT
  • Following data / integration design patterns and architecture as prescribed by the Architects. Come up with suggestions and recommendations where required.

Skills and attributes for success

  • Minimum of 3 years of ETL development on SQL Integration Projects using SQL Server Integration Services (SSIS) and SQL Server database objects
  • Experience in implementing Type 2 Dimension Data models and data warehouse ETL techniques for historical data
  • Experience in development of complex / enterprise data warehouse implemented over standard RDBMS (using SQL Server Integration Services (SSIS) and SQL Server database objects)
  • Ability to understand/re-write nested complex SQL script
  • Experience of analysis and resolution of data quality and integration issues
  • Experience of Database queries (SQL) and performance tuning
  • Experience in providing and maintaining technical documentation, specifically Data Mapping and Low Level / ETL Design Documentation
  • Experience of working both independently and collaboratively with various teams and global stakeholders (Business Analysts/Architects/Support/Business) in an agile approach while working on projects or data quality issues
  • Experience of upgrading/converting SQL based system to new versions (SQL Code and Objects) – preferable
  • Microsoft Azure - PaaS fundamental knowledge - preferable
  • Experience in Attunity tools (e.g. Compose, replicate) – preferable
  • Insurance Domain Experience – nice to have
  • Experience working on SSAS Cubes (development & design), along with troubleshooting performance and processing issues – nice to have
  • Experience in BIML based development – nice to have
  • Experience in source control using GIT
  • Possess and demonstrate deep knowledge of data warehouse concepts, techniques, various design alternatives, and overall data warehouse strategies.
  • Knowledge of Type 2 Dimension Data model and data warehouse ETL techniques for historical data
  • Excellent communication and interpersonal skills
  • Ability to work in a geographically dispersed team environment.
  • Demonstrable ability to work on multiple activities simultaneously, and work to deadlines.
  • Good written and verbal communication and interpersonal skills.
  • Good understanding of development methodologies, frameworks and best practices.
  • Ability to work outside of regular working hours where necessary to ensure global migrations are successfully tested.

To qualify for the role, you must have

  • Degree in Engineering, IT, Computer Science
  • Cloud Computing – Azure / AWS
  • Relational databases – SQL Server
  • Integration Service - SSIS, Azure ADF
  • Power BI

Ideally, you’ll also have

  • Certification in Azure Data Engineering

Technologies and Tools

  • Azure, AWS
  • SSIS, Azure ADF, SQL Server
  • SSDT, SSMS, Azure Data Studio

What we look for

  • Seeks opportunities to drive Customer Success and business results by collaborating with multiple team members.
  • Identifies opportunities to articulate business value and grow customer relationships in alignment with Customer Success business priorities and stakeholder management principles.
  • Provides and drives actionable feedback across groups about the customer experience and competitor threats.
  • Delivers given feedback, modifies existing intellectual property (IP) or, where applicable, creates new content.
  • Seeks opportunities to drive Customer Success and business results by collaborating with multiple team members.



EY Global Delivery Services (GDS) is a dynamic and truly global delivery network. We work across six locations – Argentina, China, India, the Philippines, Poland and the UK – and with teams from all EY service lines, geographies and sectors, playing a vital role in the delivery of the EY growth strategy. From accountants to coders to advisory consultants, we offer a wide variety of fulfilling career opportunities that span all business disciplines. In GDS, you will collaborate with EY teams on exciting projects and work with well-known brands from across the globe. We’ll introduce you to an ever-expanding ecosystem of people, learning, skills and insights that will stay with you throughout your career.

  • Continuous learning: You’ll develop the mindset and skills to navigate whatever comes next.
  • Success as defined by you: We’ll provide the tools and flexibility, so you can make a meaningful impact, your way.
  • Transformative leadership: We’ll give you the insights, coaching and confidence to be the leader the world needs.
  • Diverse and inclusive culture: You’ll be embraced for who you are and empowered to use your voice to help others find theirs.



EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.