- Job Ref: 3731
- Location: Dublin, Ireland
- Type: Contract
We have an opportunity for a ETL Lead Developer position with our client a leading consultancy company, to join them for a 6 months project.
About the project:
The project goal is to get a much better automated process in place that all works out of one application for automated reconciliations.
Your main responsibilities on this project will be:
- Create/modify ETL (SSIS) packages to ensure correct data extraction
- Perform data validation by writing/modifying complex SQL scripts
- Record detailed results of validation including defects and documentation issues in tracking system
- Review and validate responses to reported bugs
- Analyze provided documentation to ensure scripts accurately test data accordingly
- Interact with business subject matter experts and vendors relating to data migration activities
- Collaborate with project Business Analyst and other project team members as needed
- Provide status on assigned work as requested using established tools
- Attend project related meetings
- Complete other project related tasks as assigned
- Analyze multiple scripts and ETL packages to gain an understanding of data flow in the absence of comprehensive documentation
- SSIS / SQL development experience of a complex ETL process
- Database development experience
- Development experience in SSIS / SQL on the automated reconciliation of a complex ETL process containing large data sets
- Access development experience would be a benefit
- Development experience for Transfer agency/ financial services or something similar previously that would be advantageous
- Experience writing and scripting complex SQL queries
- Experience creating and modifying ETL based solutions in SSIS
- Experience in working on a large data migration effort from a legacy database to a SQL server
- Experience in translating ETL/Transformation rules into SQL scripts.
- If this is something suitable for you do not hesitate to get in touch for more details.
*Only applicants eligible to work in Ireland are considered for this position.