ETL Developer - Full Remote Colaborare PFA/SRL/CIM
Job description
Methodology: We are working only Agile, following a Spotify model but adapted to ING needs (mix teams of business & IT expertise, Agile ceremonies)
Area and application description: The Customer Interactions tribe is responsible for all customer communication ecosystem and business intelligence activities in Retail for ING Bank Romania.
Unica Campaign is the advanced campaign management solution that delivers customer targeting at scale with powerful segmentation capabilities for outbound, multi-channel, multi-wave batch campaign execution and tracking. In this project the focus for the next period will be:
• Decommission legacy DWH developed on MS SQL 2012, migrate campaign data marts to ING solution in IPC.
• The migration will imply development of ETL to bring data to the new DataMart. The files will be moved to a local SFTP server from where they will be loaded using SSIS in Campaign mart.
• Current DataMart is using MS SQL, new one will be an Oracle data base.
Team & way of working: Combined agile teams from two tribes: Data Management & Customer Interactions, delivering data solutions for customer communication & BI purposes. As an ETL developer you will be working in a scrum squad consisting of a product owner, a scrum master, business analysis & technical analysis members, other ETL developers, QA and DevOps.
Technologies & ideal candidate: The new member is responsible for implementing and testing ETL flows according to business requirements, based on the source to target mappings.
We are looking for a new colleague with combined skills of MS SQL and Oracle Database knowledge:
• Experience with MS SQL Server 2005/2008/2012, T-SQL, stored procedures, SQL Server
Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).
• Experience with design and implementation of Oracle Database is a plus.
• Developing, testing and implementation of ETL processes and reporting solutions using MS SQL Server tools.
Soft skills or other relevant information:
• Commitment to the team and the activity and attention to work procedures, events and alerts
• The ability to quickly learn new applications, systems and IT procedures
• Focus on collaboration and customer service
• Experience working in Agile Methodology is preferred
Your Day to Day
• Understand and translate business needs into technology solutions
• Build complete data Integration solutions working in an Agile environment to provide rapid solutions conforming to best practices and to ING ICT Development standards
• Develop automated data flows, using Visual Studio (dtsx)
• Create technical documentation
• Perform code, design and test plan reviews for peers and develop system implementation schedules while working closely with operations/ infrastructure team
• Perform System testing
• Analyze and troubleshoot SQL statements, code and model database objects
• Independently perform problem determination and resolution in the production environment and support production as needed
• Actively propose improvements in implementation, standards and other work practices.
What you bring to the team
• Minimum 2-3 years of experience in:
1. Developing, testing and implementation of ETL processes and reporting solutions using MS SQL Server tools
2. Project life cycle implementation specific to ETL o Full Project life cycle implementation specific to ETL
• Performance tuning in MS SQL Server
• Strong foundation of Data Warehouse concepts
• Experience diagnosing problems and troubleshooting production issues
• Strong analytic and problem-solving abilities
• Strong foundation in System Development Lifecycle principles
• Strong written and verbal communication skills
• Ability to work independently and collaboratively.