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.