EY TechOps1-DE-CloudOpsAMS-SQL-GIG 

India, Karnataka, Bengaluru 

661713081

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.